Capstone训练营36

今天周五上去分享了，准备的还行  就是太紧张了  发言很急促。贼难受

java  今天最后的课讲了一下 jdbc数据库。

import java.sql.*;


public class TestSQL {
public static void main(String[] args) {
String u = "aaab";
String p = "1234488";
Connection cn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try{
Class.forName("org.gjt.mm.mysql.Driver");
cn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/student","root","123456");
ps = cn.prepareStatement("select * from user where username=? and password=?");
ps.setString(1, u);
ps.setString(2, p);
rs = ps.executeQuery();
// ps =cn.prepareStatement("insert into user(username,password) values(?,?)");
// ps.setString(1, u);
// ps.setString(2, p);
// int rst= ps.executeUpdate();
// System.out.println(rst);
if(rs.next()){
System.out.println("验证成功");
}else{
System.out.println("验证失败");
}
// ResultSet rs = st.executeQuery("select * from grade");
// st.executeUpdate("insert into user(username,password)values('aaa','123')");
while(rs.next()){
System.out.println(rs.getString(3));
}
}catch(Exception e){
System.out.println(e.getMessage());
}
finally{
try{
ps.close();
cn.close();
}catch(Exception e){}
}
}
}