Question

下面的sql语句怎么写才能让 pstmt.executeQuery();返回一个int类型，判断数据库里是否有这条记录

String sql = "select count(0) from administrator whre name = ?;
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, Name);

int count = pstmt.executeQuery();

if(count>0){
out.print(“该用户已经被注册”);
}

Answer 1

int i=0;
String sql = "select * from administrator whre name = ?;
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, Name);
ResultSet re = pstmt .executeQuery();
while(re.next()){
i++;
}
if(i>0){
out.print(“该用户已经被注册”);

}