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ù)庫(kù) 步驟
try{
//1祠够、加載驅(qū)動(dòng)
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 語(yǔ)句平臺(tái)
Statement st=con.createStatement();
? ? ? ? ? // 4蠢壹、執(zhí)行sql語(yǔ)句? 獲得結(jié)果集? ResultSet
ResultSet rs=st.executeQuery("select * from dept where deptno=10");
//5荒揣、處理結(jié)果集
while(rs.next()){
System.out.println(rs.getInt("deptno")+","+rs.getString("dname")+","+rs.getString("loc"));
}
//6尉间、關(guān)閉連接
rs.close();
st.close();
con.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
