private static void LoginAdmin(){
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Connection conn = null;
PreparedStatement ps = null;
try {
conn = DriverManager.getConnection("jdbc:sqlserver://localHost:1433;databaseName=MySchool","sa","sqlpass");
String id = "zl";
String pwd = "1234";
String sql = "select Count(*) as login from Admin where LoginId = ? and LoginPwd = ?";
ps = conn.prepareStatement(sql);
ps.setString(1, id);
ps.setString(2, pwd);
int r = ps.executeQuery(); //这里报不能从结果集转换为int
System.out.println(r == 1 ? "登录成功!" : "登录失败!");
} catch (SQLException e) {
e.printStackTrace();
}finally{
if(ps != null){
ps.close();
}
if(conn != null){
conn.close();
}
}
}