在线急等String sql = "SELECT * FROM test3 WHERE NAME LIKE '%"+?+"%'";
南瓜三三 2010-11-21 02:56:56 public List<user> findByStr(String str) {
PreparedStatement pstmt = null;
DBUtil dbUtil = null;
ResultSet rs=null;
String sql = "SELECT * FROM test3 WHERE NAME LIKE '%"+?+"%'";
user user = new user();
List<user> list = new ArrayList<user>();
try {
dbUtil = new DBUtil();
pstmt = dbUtil.getCon().prepareStatement(sql);
pstmt.setString(1,str);
rs=pstmt.executeQuery();
while(rs.next()){
int id = rs.getInt("OPERATOR_ID");
String name = rs.getString("NAME");
String password = rs.getString("PASSWORD");
int status = rs.getInt("STATUS");
user.setOperator_id(id);
user.setName(name);
user.setPassword(password);
user.setStatus(status);
list.add(user);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
pstmt.close();
dbUtil.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return list;
}