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?{
		//連接數(shù)據(jù)庫的url
		String?url?=?"jdbc:mysql://127.0.0.1:5653/wuzydb";
		//數(shù)據(jù)庫用戶名
		String?user?=?"root";
		//數(shù)據(jù)庫密碼
		String?password?=?"1111";
		
		//1、加載驅(qū)動(dòng)
		Class.forName("com.mysql.jdbc.Driver");
		//2、創(chuàng)建數(shù)據(jù)庫連接對(duì)象
		Connection?conn?=?DriverManager.getConnection(url,?user,?password);
		//3、創(chuàng)建Statement對(duì)象
		Statement?stmt?=?conn.createStatement();
		//4、獲取ResultSet
		String?sql?=?"select?name,salary,age?from?t_emp";
		ResultSet?rs?=?stmt.executeQuery(sql);
		
		while?(rs.next())?{
			//獲取字段name數(shù)據(jù)
			String?name?=?rs.getString("name");
			//獲取字段salary
			double?salary?=?rs.getDouble("salary");
			//獲取age數(shù)據(jù)
			int?age?=?rs.getInt("age");
			
			System.out.println(name+?","?+salary+?","?+age);
		}
		
		//5、關(guān)閉數(shù)據(jù)庫
		rs.next();
		stmt.close();
		conn.close();
	}

}