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;
}
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;
}
解决方案 »
- Java中的get和set方法究竟是什么意思?
- hiberhate是否支持跨数据库查询?
- file
- 如何在两个树之间传递节点
- weblogic jstl 使用出错
- 请教?在tomcat admin中配置的datasource存放在什么文件中.
- 能用web service 处理cookie吗?
- 请帮我看看这个利用JDBC查询数据库,并创建XML文档的程序吧!先谢谢了!
- J2EE强问,如何在JBOSS中配置jrep socketType="ssl",用以建立JBOSS服务端和客户的加密通信
- 关于分布式事务
- 求javaee api chm 最新中文
- 有没有人知道关于JSF(javaserver faces)好的网站?
报错 在线等答案
或者你也可以
String sql = "SELECT * FROM test3 WHERE NAME LIKE ?";pstmt.setString(1,"%"+str+"%");
....
pstmt.setString(1,"%"+str+"%");
<tr>
<td>帐号</td><td>姓名</td><td>密码</td><td>状态</td><td>删除</td><td>修改</td>
</tr>
<c:forEach var="list" items="${users}" varStatus="st"> <tr bgcolor="lightblue"> <td>${list.operator_id}</td><td>${list.name}</td><td>${list.password}</td><td>${list.status}</td><td>删除</td><td>修改</td></tr>
</c:forEach>
</table>
在线急等
foreach 出了什么问题啊
???????????在线急等
恩,赞成这个