package com.entity;
import java.io.Serializable;
public class User implements Serializable{
/*
`uid` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
`userId` varchar(64) DEFAULT NULL COMMENT '用户名',
`password` varchar(64) DEFAULT NULL COMMENT '密码',
`userName` varchar(64) DEFAULT NULL COMMENT '真实姓名',
`birthday` varchar(64) DEFAULT NULL COMMENT '出生日期',
`identityCode` varchar(64) DEFAULT NULL COMMENT '身份证号码',
`email` varchar(64) DEFAULT NULL COMMENT '邮件地址',
`mobile` varchar(64) DEFAULT NULL COMMENT '手机号',
`address` varchar(64) DEFAULT NULL COMMENT '地址',
`uadmin` varchar(64) DEFAULT NULL COMMENT '用户等级',
/**
*
*/
private static final long serialVersionUID = 1L;
private int uid;
private String userId;
private String password;
private String userName;
private String birthday;
private String identityCode;
private String email;
private String mobile;
private String address;
private int uadmin;
public User(int uid, String userId, String password, String userName,
String birthday, String identityCode, String email, String mobile,
String address, int uadmin) {
super();
this.uid = uid;
this.userId = userId;
this.password = password;
this.userName = userName;
this.birthday = birthday;
this.identityCode = identityCode;
this.email = email;
this.mobile = mobile;
this.address = address;
this.uadmin = uadmin;
}
public User() {
super();
}
public int getUid() {
return uid;
}
public void setUid(int uid) {
this.uid = uid;
}
public String getUserId() {
return userId;
}
public void setUserId(String userId) {
this.userId = userId;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getBirthday() {
return birthday;
}
public void setBirthday(String birthday) {
this.birthday = birthday;
}
public String getIdentityCode() {
return identityCode;
}
public void setIdentityCode(String identityCode) {
this.identityCode = identityCode;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getMobile() {
return mobile;
}
public void setMobile(String mobile) {
this.mobile = mobile;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public int getUadmin() {
return uadmin;
}
public void setUadmin(int uadmin) {
this.uadmin = uadmin;
}
public static long getSerialversionuid() {
return serialVersionUID;
}
@Override
public String toString() {
return "User [uid=" + uid + ", userId=" + userId + ", password="
+ password + ", userName=" + userName + ", birthday="
+ birthday + ", identityCode=" + identityCode + ", email="
+ email + ", mobile=" + mobile + ", address=" + address
+ ", uadmin=" + uadmin + "]";
}
}
---------------------dao------------------------
public List<User> queryUser(int page, int pageSize) throws SQLException {
List<User> users = new ArrayList<User>();
User u = null;
try {
conn = BaseDao.myBase();
st = conn.prepareStatement("SELECT * FROM users limit ?,?");
int begin=(page-1)*pageSize;
st.setInt(1, begin);
st.setInt(2, pageSize);
ResultSet rs = st.executeQuery();
while (rs.next()) {
u = new User();
u.setUid(rs.getInt(1));
u.setUserId(rs.getString(2));
u.setPassword(rs.getString(3));
u.setUserName(rs.getString(4));
u.setBirthday(rs.getString(5));
u.setIdentityCode(rs.getString(6));
u.setEmail(rs.getString(7));
u.setMobile(rs.getString(8));
u.setAddress(rs.getString(9));
u.setUadmin(rs.getInt(10));
users.add(u);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
BaseDao.myClose(conn, st, rs);
}
return users;
}
public int getCount() {
conn = BaseDao.myBase();
int count = 0;
try {
st = conn.prepareStatement("SELECT COUNT(1) FROM users");
rs = st.executeQuery();
if (rs.next()) {
count = rs.getInt(1);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
BaseDao.myClose(conn, st, rs);
}
return count;
}
-------------------------------BaseDao------------------------------------
package com.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.jdbc.Driver;
public class BaseDao {
//四大参数
private static final String DRIVER="com.mysql.jdbc.Driver";
private static final String URL="jdbc:mysql://localhost/db_shoping?useUnicode=true&characterEncoding=UTF-8";
private static final String USERNAME="root";
private static final String PWD="123456";
//获取链接
public static Connection myBase(){
Connection conn=null;
try {
Class.forName(DRIVER);
conn=DriverManager.getConnection(URL, USERNAME, PWD);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
//关闭数据库
public static void myClose(Connection conn,PreparedStatement ps,ResultSet rs ){
try {
if(conn!=null){conn.close();}
if(ps!=null){ps.close();}
if(rs!=null){rs.close();}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//增删改的调用方法
public static int chengeBase(String sql,Object[] obj ){
int row=0;
Connection conn=myBase();
PreparedStatement ps=null;
try {
int num=1;
ps=conn.prepareStatement(sql);
for(Object ob:obj){
ps.setObject(num, ob);
num++;
}
row=ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
myClose(conn, ps, null);
}
return row;
}
}
-------------------------------------UserBiz (user分页)--------------------------------------
package com.biz;
import java.sql.SQLException;
import com.util.PageBean;
public class UserBiz {
import com.dao.UserDao;
public PageBean queryUserPageBean(int page,int pageSize) throws SQLException{
UserDao dao=new UserDao();
PageBean pg=new PageBean();
pg.setCurrentPage(page);
pg.setPageSize(pageSize);
pg.setTotalNumber(dao.getCount());
pg.setList(dao.queryUser(page, pageSize));
return pg;
}
}
--------------------------PageBean --------------------------------
package com.util;
import java.util.List;
public class PageBean {
private int currentPage;//当前页
private int pageSize;//一页显示的条数
private int totalNumber;//总条数
private int allPage;//总页数
private List list;
public PageBean(int currentPage, int pageSize, int totalNumber,
int allPage, List list) {
super();
this.currentPage = currentPage;
this.pageSize = pageSize;
this.totalNumber = totalNumber;
this.allPage = allPage;
this.list = list;
}
public PageBean() {
super();
}
public int getCurrentPage() {
return currentPage;
}
public void setCurrentPage(int currentPage) {
this.currentPage = currentPage;
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
public int getTotalNumber() {
return totalNumber;
}
public void setTotalNumber(int totalNumber) {
this.totalNumber = totalNumber;
allPage=totalNumber%pageSize==0?totalNumber/pageSize:totalNumber/pageSize+1;
}
public int getAllPage() {
return allPage;
}
public void setAllPage(int allPage) {
this.allPage = allPage;
}
public List getList() {
return list;
}
public void setList(List list) {
this.list = list;
}
@Override
public String toString() {
return "PageBean [currentPage=" + currentPage + ", pageSize="
+ pageSize + ", totalNumber=" + totalNumber + ", allPage="
+ allPage + ", list=" + list + "]";
}
----------------------------------------
<%@page import="java.text.SimpleDateFormat"%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>后台管理 - 易买网</title>
<link type="text/css" rel="stylesheet" href="../css/style.css" />
<script type="text/javascript" src="../scripts/jquery-1.8.3.min.js"></script>
<script type="text/javascript" src="../scripts/function.js"></script>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<script>
function delp(uid) {
var mymessage = confirm("你确认要删除吗?");
if (mymessage == true) {
if(${user.uid}==uid){
alert("无法自删除");
}else{
location = '../../AggredateUser?caozuo=deluser&uid='+uid;
}
} else {
return false;
}
}
</script>
</head>
<body>
<div id="header" class="wrap">
<div id="logo">
<img src="../images/logo.gif" />
</div>
<div class="help">
<a href="../index.html">返回前台页面</a>
</div>
<div class="navbar">
<ul class="clearfix">
<li><a href="index.html">首页</a></li>
<li class="current"><a href="user.html">用户</a></li>
<li><a href="product.html">商品</a></li>
<li><a href="order.html">订单</a></li>
<li><a href="guestbook.html">留言</a></li>
<li><a href="news.html">新闻</a></li>
</ul>
</div>
</div>
<div id="childNav">
</div>
<div id="position" class="wrap">
您现在的位置:<a href="index.html">易买网</a> > 管理后台
</div>
<div id="main" class="wrap">
<div id="menu-mng" class="lefter">
<div class="box">
<dl>
<dt>用户管理</dt>
<dd>
<a href="user.html">用户管理</a>
</dd>
<dt>商品信息</dt>
<dd>
<em><a href="productClass-add.html">新增</a></em><a
href="productClass.html">分类管理</a>
</dd>
<dd>
<em><a href="product-add.html">新增</a></em><a href="product.html">商品管理</a>
</dd>
<dt>订单管理</dt>
<dd>
<a href="order.html">订单管理</a>
</dd>
<dt>留言管理</dt>
<dd>
<a href="guestbook.html">留言管理</a>
</dd>
<dt>新闻管理</dt>
<dd>
<em><a href="news-add.html">新增</a></em><a href="news.html">新闻管理</a>
</dd>
</dl>
</div>
</div>
<div class="main">
<h2>用户管理</h2>
<div class="manage">
<table class="list">
<tr>
<th>用户名</th>
<th>真实姓名</th>
<th>Email</th>
<th>手机</th>
<th>操作</th>
</tr>
<c:forEach items="${userpagebean.list}" var="user">
<tr>
<td class="first w4 c">${user.userId}</td>
<td class="w1 c">${user.userName}</td>
<td>${user.email}</td>
<td class="w4 c">${user.mobile}</td>
<td class="w1 c"><a
href="../../AggredateUser?caozuo=queryusersbyid&uid=${user.uid}">修改</a>
<a href="javascript:delp(${user.uid})">删除</a></td>
</tr><!--javascript:delp(${user.uid}) -->
</c:forEach>
</table>
</div>
</div>
<div class="clear"></div>
<div class="pager">
<ul class="clearfix">
【 总页数:${userpagebean.allPage}/当前页:${userpagebean.currentPage} 】
<li><a href="../../ListUser?page=1">首页</a></li>
<li id="pg"><a href="../../ListUser?page=${userpagebean.currentPage+1}">下一页</a></li>
<li id="pg"><a href="../../ListUser?page=${userpagebean.currentPage-1}">上一页</a></li>
<li><a href="../../ListUser?page=${userpagebean.allPage}">尾页</a></li>
</ul>
</div>
</div>
<div id="footer">Copyright ©</div>
</body>
</html>
}
-------------------------------------------------------
package com.web;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.biz.UserBiz;
import com.dao.UserDao;
import com.util.PageBean;
public class ListUser extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = 1L;
private static final String PageBean = null;
/**
* Constructor of the object.
*/
public ListUser() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
String page=request.getParameter("page");
if( page==null){page="1";}
PrintWriter out = response.getWriter();
UserBiz bz=new UserBiz();
PageBean userpagebean = null;
try {
userpagebean = bz.queryUserPageBean(Integer.valueOf(page), 4);
UserDao userd=new UserDao();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if(userpagebean!=null){
request.getSession().setAttribute("userpagebean", userpagebean);
response.sendRedirect("onlineshopping/manage/user.jsp");
}else{
response.sendRedirect("err.jsp");
}
out.flush();
out.close();
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}