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.Driver");
????????//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.getInt("age"));
????????}
????}


}