Java web项目 停车管理系统实现用户查询功能
查询页面
1.代码:
2.核心代码:
3.代码分析:
<%@include file="/common/sub_header.jsp"%>
<%@ page language=“java” import=“java.util.,java.sql.,com.biyeseng.db.*”
pageEncoding=“UTF-8”%>
<link rel="stylesheet" type="text/css" href="css/common.css" /> *//外部css文件的链接 路径为css/common.css*
<link rel="stylesheet" type="text/css" href="css/main.css" />*//外部css文件链接 路径为css/main.css*
<script type="text/javascript" src="js/libs/modernizr.min.js">*//外部java文件链接 路径为js/libs/modernizr.min.js*
//*包含页面top.jsp* //*包含页面left.jsp*
<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"> *//宽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"; //从user info表中查询
*//如果查询内容为空*
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>
4.结果:
文章代码借鉴 不能转载 谢谢