import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class Mysqltest1 {

public static void main(String[] args) {

// TODO Auto-generated method stub

//java連接數(shù)據(jù)庫 步驟

try{

//1、加載驅動

Class.forName("com.mysql.jdbc.Driver");

//2、獲得連接

String url="jdbc:mysql://localhost:3306/mysqldb";//10.25.44.2

String username="root";

String password="lin123";

Connection con=DriverManager.getConnection(url,username,password);

System.out.println(con);

//3、獲得執(zhí)行sql 語句平臺

Statement st=con.createStatement();

? ? ? ? ? // 4、執(zhí)行sql語句? 獲得結果集? ResultSet

ResultSet rs=st.executeQuery("select * from dept where deptno=10");

//5、處理結果集

while(rs.next()){

System.out.println(rs.getInt("deptno")+","+rs.getString("dname")+","+rs.getString("loc"));

}

//6、關閉連接

rs.close();

st.close();

con.close();

}catch(Exception e){

e.printStackTrace();

}

}

}