企业信息管理系统（4）_用户查询
生活随笔
收集整理的這篇文章主要介紹了
企业信息管理系统（4）_用户查询
小編覺(jué)得挺不錯(cuò)的,現(xiàn)在分享給大家,幫大家做個(gè)參考.
本系列博客匯總在這里：企業(yè)信息管理系統(tǒng)匯總
目錄
- 用戶查詢
- 一、src 下建包建類
- 二、tab.jsp 頁(yè)面設(shè)置
- 三、附件
- 附件一
- 附件二
用戶查詢
數(shù)據(jù)庫(kù)的各個(gè)字段構(gòu)成一個(gè)實(shí)體。
一、src 下建包建類
源碼見(jiàn)附件一
二、tab.jsp 頁(yè)面設(shè)置
源碼見(jiàn)附件二
三、附件
附件一
package com.wyx.ces.model;import java.math.BigDecimal; import java.util.Date;public class CSUsr {// 數(shù)據(jù)庫(kù)中的字段多個(gè)單詞使用"_"來(lái)分隔，在java代碼中使用駝峰模式private Integer userId;private String username;private String password;private Integer gender;private Date birthday;private String address;private BigDecimal sal;public Integer getUserId(){return userId;}public void setUserId(Integer userId){this.userId = userId;}public String getUsername(){return username;}public void setUsername(String username){this.username = username;}public String getPassword(){return password;}public void setPassword(String password){this.password = password;}public Integer getGender(){return gender;}public void setGender(Integer gender){this.gender = gender;}public Date getBirthday(){return birthday;}public void setBirthday(Date birthday){this.birthday = birthday;}public String getAddress(){return address;}public void setAddress(String address){this.address = address;}public BigDecimal getSal(){return sal;}public void setSal(BigDecimal sal){this.sal = sal;}@Overridepublic String toString(){return "CSUsr [address=" + address + ", birthday=" + birthday+ ", gender=" + gender + ", password=" + password + ", sal="+ sal + ", userId=" + userId + ", username=" + username + "]";}}附件二
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@page import="java.util.*" %> <%@page import="java.sql.*" %> <%@page import="com.wyx.ces.*" %> <%@page import="com.wyx.ces.model.*" %> <%@page import="java.math.BigDecimal"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html><head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Insert title here</title> <style type="text/css">a {text-decoration: none; }body {font-size:12px; color: #033D61; }.tableb {border-collapse: collapse;width: 100%; }.tableb th {border: 1px solid #33A9D0;height: 20px;text-align: center; }.tableb td {border: 1px solid #33A9D0;height: 10px;text-align: center;padding: 0px; } th {background-color: #E7F2FA; } </style></head><body> <%String sql = "select * from cs_user";PreparedStatement pstmt = DBUtil.getPstmt(sql);List<CSUsr> userList = new ArrayList<CSUsr>();ResultSet rs = null;try{rs = pstmt.executeQuery();//定義存儲(chǔ)user的集合while(rs.next()){//獲得查詢上來(lái)的每一條數(shù)據(jù)Integer userId = rs.getInt("user_id");String username = rs.getString("username");String password = rs.getString("password");Integer gender = rs.getInt("gender");java.util.Date birthday = rs.getDate("birthday");String address = rs.getString("address");BigDecimal sal = rs.getBigDecimal("sal");//封裝成user對(duì)象CSUsr user = new CSUsr();user.setUserId(userId);user.setUsername(username);user.setPassword(password);user.setGender(gender);user.setBirthday(birthday);user.setAddress(address);user.setSal(sal);userList.add(user);}}catch(Exception ex){ex.printStackTrace();}finally{DBUtil.closeResQuery(rs);}pageContext.setAttribute("userList", userList); %> <table style="background-color: #5DBAD9;width: 100%;height: 25px;"><tr><td style="padding-right: 30px; text-align: right;"><a href="/ces/tab/toAdd.jsp"><img src="/ces/tab/images/22.gif"/>添加</a></td></tr> </table> <table class="style1 tableb"><tr><th>用戶名</th><th>密碼</th><th>性別</th><th>生日</th><th>住址</th><th>工資</th><th>操作</th></tr><%for(CSUsr user : userList){%><tr><td><%=user.getUsername() %></td><td><%=user.getPassword() %></td><td><%Integer gender = user.getGender();if(gender == 1){out.print("男");}else{out.print("女");}%></td><td><%=user.getBirthday() %></td><td><%=user.getAddress() %></td><td><%=user.getSal()%></td><td><a href="/ces/tab/toUpdate.jsp?userId=<%=user.getUserId() %>"><img src="/ces/tab/images/edt.gif"/>編輯</a><a href="/ces/tab/delete.jsp?userId=<%=user.getUserId() %>"><img src="/ces/tab/images/del.gif"/>刪除</a></td></tr><%}%> </table> </body> </html>如有錯(cuò)誤，歡迎指正！
總結(jié)
以上是生活随笔為你收集整理的企业信息管理系统（4）_用户查询的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。
- 上一篇： 淘宝/天猫盗图投诉之提交盗图申诉材料时，
- 下一篇： Unable to connect to