(一)查询界面
<%@include file="/common/sub_header.jsp"%>
<%@ page language="java" import="java.util.*,java.sql.*,com.biyeseng.db.*"
pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<link rel="stylesheet" type="text/css" href="css/common.css" />
<link rel="stylesheet" type="text/css" href="css/main.css" />
<script type="text/javascript" src="js/libs/modernizr.min.js">
</script>
</head>
<body>
<jsp:include page="/top.jsp"></jsp:include>
<jsp:include page="/left.jsp"></jsp:include>
<!--/sidebar-->
<div class="main-wrap">
<div class="crumb-wrap">
<div class="crumb-list">
<span class="crumb-name">用户管理</span>
</div>
</div>
<div class="search-wrap">
<div class="search-content">
<form action="<%=path%>/userinfo/list.jsp" method="post">
<table class="search-tab">
<tr>
<th width="150">
请输入用户名称:
</th>
<td>
<input class="common-text" placeholder="关键字" name="queryName"
value="" id="" type="text">
</td>
<td>
<input class="btn btn-primary btn2" name="sub" value="查询"
type="submit">
</td>
</tr>
</table>
</form>
</div>
</div>
<div class="result-wrap">
<form name="myform" id="myform" method="post">
<div class="result-title">
<div class="result-list">
<a href="<%=path%>/userinfo/addUserinfo.jsp"><i
class="icon-font"></i>新增用户</a>
</div>
</div>
<div class="result-content">
<table class="result-tab" width="100%">
<tr>
<th>
ID
</th>
<th>
用户名
</th>
<th>
密码
</th>
<th>
年龄
</th>
<th>
电话
</th>
<th>
卡余额
</th>
<th>
操作
</th>
</tr>
<%
DBManager dbm = new DBManager();
Connection conn = dbm.getConnection();
String queryName = request.getParameter("queryName");
String sql = "select * from userinfo";
//如果查询内容为空
if (queryName != null) {
sql = "select * from userinfo where name like '%" + queryName
+ "%'";
}
PreparedStatement pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
String id = rs.getString("id");
%>
<tr>
<td>
<%=id%>
</td>
<td title="">
<%=rs.getString("name")%>
</td>
<td title="">
<%=rs.getString("pwd")%>
</td>
<td title="">
<%=rs.getString("age")%>
</td>
<td title="">
<%=rs.getString("tel")%>
</td>
<td title="">
<%=rs.getString("jine")%>
</td>
<td>
<a class="link-update"
href="<%=path%>/userinfo/modUserinfo.jsp?id=<%=id%>">修改</a>
<a class="link-update"
href="<%=path%>/userinfo/chong.jsp?id=<%=id%>">充值</a>
<a class="link-del"
href="<%=path%>/DelUserinfoAction?id=<%=id%>">删除</a>
</td>
</tr>
<%
}
if (rs != null)
rs.close();
if (pstmt != null)
pstmt.close();
if (conn != null)
conn.close();
%>
</table>
<div class="list-page">
</div>
</div>
</form>
</div>
</div>
<!--/main-->
</div>
</body>
</html>
注：显示所有信息和显示查询信息的核心代码
<%
DBManager dbm = new DBManager();
Connection conn = dbm.getConnection();
String queryName = request.getParameter("queryName");
String sql = "select * from userinfo";
//如果查询内容为空
if (queryName != null) {
sql = "select * from userinfo where name like '%" + queryName
+ "%'";
}
PreparedStatement pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
String id = rs.getString("id");
%>效果演示：
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
