Question

java如何检测SQL查询结果为空

Answer 1

public static boolean checkCountExecute(String sql) {
Connection conn = getConnection();
Statement st = null;
ResultSet rs = null;
boolean flag = false;
try {
st = conn.createStatement();
rs = st.executeQuery(sql);
if (rs.next()) {
flag = true;
} else {
flag = false;
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBConnection.tryClose(conn, st, null, null);
}
return flag;
}
判断是否有结果的一个通用方法0.0

Answer 2

pstmt= conn.prepareStatement(sql);
rs=pstmt.executeQuery();
if(!rs.next()){
//SQL查询结果为空
}