在过去的几天里,我一直在努力解决这个问题。我有一个SerachUser函数,在其中将所有数据(例如年龄,性别,城市和兴趣)输入每个字符串,并将其检查到select查询命令中。
如果有数据,请打印出来。
很遗憾,搜索无法完全正常进行。例如:我的表用户没有'F'性别。但是,如果我键入“ F”,我仍然会获得数据,而不是显示“ ResultSet in Java中为空”。
下面是我完成的简短代码。try{
conn = DriverManager.getConnection(DB_URL,"shankarv5815","1807985");
st = conn.createStatement();
rs = st.executeQuery("Select loginID, f_name, l_name from users where gender = '" +
searchUser.getGender() + "' and age between '" + min + "' and '" + max + "' and city = '" +
searchUser.getCity() + "' and interest1 = '" + searchUser.getInterest1() +
"' or interest2 = '" + searchUser.getInterest1() + "' or interest3 = '" +
searchUser.getInterest1() + "' and loginID != '" + curUser + "'");
if (rs.next() == false) {
System.out.println("ResultSet in empty in Java");
}
else {
do {
String id = rs.getString(1);
String fName = rs.getString(2);
String lName = rs.getString(3);
System.out.print(id +" ," + fName + ", " + lName);
System.out.println();
} while (rs.next());
}
}
catch(SQLException e){
e.printStackTrace();
}
finally
{
try
{
conn.close();
st.close();
rs.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}