packagecom.swift;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;public classLoginJDBC$PreparedStatement2 {public static voidmain(String[] args) {
User userSwift=new User("zhangsan","123456");if(login(userSwift)) {
System.out.println("账号密码正确,登陆成功");
}else{
System.out.println("登陆失败");
}
}private static booleanlogin(User userSwift) {
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;try{//1、装载驱动
Class.forName("com.mysql.jdbc.Driver");
}catch(ClassNotFoundException e) {
e.printStackTrace();
}try{//2、链接数据库,使用com.mysql.jdbc.Connection包会出错
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/sw_database?user=root&password=root");//3、创建连接语句
ps=conn.prepareStatement("select * from sw_user where username=? and password=?");
ps.setString(1, userSwift.getUsername());
ps.setString(2, userSwift.getPassword());//4、执行SQL语句获得结果集
rs=ps.executeQuery();if(rs.next()) {return true;
}
}catch(SQLException e) {
e.printStackTrace();
}finally{//关闭结果集
try{if(rs!=null) {
rs.close();
}
}catch(SQLException e) {//TODO Auto-generated catch block
e.printStackTrace();
}//关闭连接语句
try{if(ps!=null) {
ps.close();
}
}catch(SQLException e) {//TODO Auto-generated catch block
e.printStackTrace();
}//关闭数据库连接
try{if(conn!=null) {
conn.close();
}
}catch(SQLException e) {//TODO Auto-generated catch block
e.printStackTrace();
}
}return false;
}
}