20145109 《Java程序设计》第九周学习总结

JDBC

1 . DriverManager

Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); 

2 . Connection

Connection conn=DriverManager.getConnection(url,user,password); 

3 . Statement (execute SQL)

Statement stmt=conn.createStatement(); 

String sql="select * from user where userName=? and password=?"; 
PreparedStatement pstmt=Conn.prepareStatement(sql); 

pstmt.setString(1,"admin"); 
pstmt.setString(2,"liubin");

关于安装：