package?com.imooc.db;

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

public?class?DBUtil?{
		private?static?final?String?URL="jdbc:mysql://127.0.0.1:3306/imooc";
		private?static?final?String?USER="root";
		private?static?final?String?PASSWORD="root";
		
		public?static?void?main(String[]?args)throws?Exception?{
		
		//1.加載驅(qū)動(dòng)程序
		Class.forName("com.mysql.jdbc.Diver");
		//2.獲得數(shù)據(jù)庫(kù)的連接
		Connection?conn=DriverManager.getConnection(URL,?USER,?PASSWORD);
		//3.通過(guò)數(shù)據(jù)庫(kù)的連接操縱數(shù)據(jù)庫(kù)，實(shí)現(xiàn)增刪查改
		Statement?stmt?=?conn.createStatement();
		ResultSet?rs=stmt.executeQuery("select?user_name,age?from?imooc_goddess");
		
		while(rs.next()){
			System.out.println(rs.getString("user_name")+","+rs.getString("age"));
		}
	}
}