4.9w+
社区成员
public static Vector<String> seek(int operateFlag, String name, String age, String sex) {
String sql = "SELECT * from criminals";
int selectFlag =0;
if(name != null && !name.equals("")) {
sql += "WHERE name LIKE ?";
selectFlag = 1;
if(age != null && !age.equals("")) {
sql += "AND age LIKE ?";
selectFlag = 2;
if(!sex.equals("")) {
sql += "AND sex LIKE ?";
selectFlag =3;
}
}else {
if(!sex.equals("")) {
sql += "AND sex LIKE ?";
selectFlag =4;
}
}
}else {
if(age != null && !age.equals("")) {
sql += "WHERE age LIKE ?";
selectFlag = 5;
if(!sex.equals("")) {
sql += "AND sex LIKE ?";
selectFlag =6;
}
}else {
if(!sex.equals("")) {
sql += "WHERE sex LIKE ?";
selectFlag =7;
}
}
}
Vector <String> infoStringCollection = dataOperate.generalQuery(operateFlag, sql, selectFlag, name, age, sex);
return infoStringCollection;
}
public Vector<String> generalQuery(int operateFlag, String sql, int selectFlag, String name, String age,
String sex) {
Vector <String> infoStringCollection = new Vector <String>();
try {
pstmt = con.prepareStatement(sql);
switch (selectFlag) {
case 0 :
break;
case 1:
pstmt.setString(1, name);
break;
case 2:
pstmt.setString(1, name);
pstmt.setString(2, age);
break;
case 3:
pstmt.setString(1, name);
pstmt.setString(2, age);
pstmt.setString(3, sex);
break;
case 4:
pstmt.setString(1, name);
pstmt.setString(2, sex);
break;
case 5:
pstmt.setString(1, age);
break;
case 6:
pstmt.setString(1, age);
pstmt.setString(1, sex);
break;
case 7:
pstmt.setString(1, sex);
}
ResultSet rs = pstmt.executeQuery();
}catch (SQLException se) {
System.err.println("查询数据库出错");
System.err.println(se);
se.printStackTrace(System.err);
}
return infoStringCollection;
}
if(source == submit) {
Vector <String> infoStringCollection = new Vector <String>();
list.setListData(infoStringCollection);
String name = nameField.getText().trim();
String age = ageField.getText().trim();
String sex = sexChoice.getSelectedItem().toString();
infoStringCollection = Service.seek(operateFlag, name, age, sex);
list.setListData(infoStringCollection);
nameField.setText("");
ageField.setText("");
sexChoice.setSelectedIndex(0);
return;
}