我是一个新手，才学JDBC没多久，想做一个登录功能，可是我找不到原因，求大神指点指点！！

Question

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();
        }
    }
}

Answer 1

ResultSet rs=ps.executeQuery();
if(rs.next()){System.out.println("登陆成功")}else{System.out.println("登陆失败");}
可以参考我的博客http://blog.csdn.net/ld0807/article/details/53976180或者http://www.banzg.com/archives/104.html