package?com;

import?java.sql.Statement;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;

public?class?QuerTest?{

	public?static?void?main(String[]?args)?throws?Exception?{
		//連接數據庫的url
		String?url?=?"jdbc:mysql://127.0.0.1:5653/wuzydb";
		//數據庫用戶名
		String?user?=?"root";
		//數據庫密碼
		String?password?=?"1111";
		
		//1、加載驅動
		Class.forName("com.mysql.jdbc.Driver");
		//2、創建數據庫連接對象
		Connection?conn?=?DriverManager.getConnection(url,?user,?password);
		//3、創建Statement對象
		Statement?stmt?=?conn.createStatement();
		//4、獲取ResultSet
		String?sql?=?"select?name,salary,age?from?t_emp";
		ResultSet?rs?=?stmt.executeQuery(sql);
		
		while?(rs.next())?{
			//獲取字段name數據
			String?name?=?rs.getString("name");
			//獲取字段salary
			double?salary?=?rs.getDouble("salary");
			//獲取age數據
			int?age?=?rs.getInt("age");
			
			System.out.println(name+?","?+salary+?","?+age);
		}
		
		//5、關閉數據庫
		rs.next();
		stmt.close();
		conn.close();
	}

}