web课程设计.docx

1、web课程设计WEB技术课程设计报告题目：_用户信息管理系统_学 院 计算机与信息工程学院班 级 _商务1101_ 学 号 _ 1112200108_ _ 姓 名 _ 张怀平_ _ _ 2013年 6 月一、任务书本系统是由我个人自己完成。系统设计目标如下:表1设计目标用户管理基本功能分为前台客户使用部分、后台管理员使用部分。前台基本功能，包括客户注册、客户登录、客户基本资料修改，密码修改，客户信息查看等功能。后台基本功能，包括用户查询、添加用户、用户资料修改、删除用户等功能。开发环境Mysql，Tomcat，MyEclipse，windows运行环境Windows，Tomcat，Mysql二

2、、设计报告1、功能分析1.1 功能概况该系统主要分为前台系统和后台系统。前台系统功能包括用户注册，用户登陆，用户信息查看，用户密码修改等功能。后台只有管理员才可以登陆，主要功能有系统用户的添加，系统用户信息的修改，系统用户信息的查询，系统用户删除等。管理员默认的的账户是yishaoku，密码是123。如果想改变可以在数据库中的t_manager中进行修改。普通用户系统中已经存在一些。如：账户：azhang，姓名：张怀平，密码：yishaoku等。系统功能流程图如下:图11.2 系统角色设计该用户管理系统的角色主要由两类，普通用户角色和管理员角色。其中普通用户又可以分为未注册用户，和已经注册用户

3、。两类用户各自的权限如下:用户:图2管理员:图31.3 主要业务流程设计 1.3.1 用户注册 图4 1.3.2 用户登陆 图5 1.3.3 用户修改密码图6 1.3.4 管理员添加用户 图7 1.3.5 管理员修改用户信息 图8 1.3.6 管理员删除用户图92、数据库表设计本系统主要是模拟用户的信息管理，主要涉及两张表，普通用户信息表t_user，管理员信息表t_manager。普通用户信息表如下: 表2字段名数据类型长度含义备注user_idvarchar11用户账号主码user_namevarchar50用户姓名非空passwordvarchar50用户密码非空contact_telv

4、archar20联系电话非空emailvarchar50电子邮箱非空create_datedatetime无申请日期非空普通用户信息表t_user的ER图如下: 图10管理员信息表如下: 表3字段名数据类型长度含义备注namevarchar50用户账号主码passwordvarchar50用户姓名非空管理员信息表ER图如下:图113、功能实现普通用户信息表和管理员信息的表通过两个JavaBean来封装，代码如下：普通用户：package com.bjsxt.drp.business.usermgr.model;import java.util.Date;public class User pr

5、ivate String userId; private String userName; private String password; private String contactTel; private String email; private Date createDate; public String getContactTel() return contactTel; public void setContactTel(String contactTel) this.contactTel = contactTel; public Date getCreateDate() ret

6、urn createDate; public void setCreateDate(Date createDate) this.createDate = createDate; public String getEmail() return email; public void setEmail(String email) this.email = email; public String getPassword() return password; public void setPassword(String password) this.password = password; publi

7、c String getUserId() return userId; public void setUserId(String userId) this.userId = userId; public String getUserName() return userName; public void setUserName(String userName) this.userName = userName; 管理员如下：package com.bjsxt.drp.business.usermgr.model;public class Manager private String name;

8、private String password; public String getName() return name; public void setName(String name) this.name = name; public String getPassword() return password; public void setPassword(String password) this.password = password; 整个系统对数据库的操作是一个重要的环节，因为对数据库的操作是一个耗资源的操作，所以连接数据库和操作数据库的代码要合理设计，本系统对数据库操作代码如下：

9、package com.bjsxt.drp.business.util;import java.sql.*;public class DB public static Connection getConn() Connection conn = null; try Class.forName(com.mysql.jdbc.Driver); conn = DriverManager.getConnection(jdbc:mysql:/localhost:3306/db_user?user=root&password=yishaoku); catch (ClassNotFoundException

10、 e) e.printStackTrace(); catch (SQLException e) e.printStackTrace(); return conn; public static void closeConn(Connection conn) try if(conn != null) conn.close(); conn = null; catch (SQLException e) e.printStackTrace(); public static void closeStmt(Statement stmt) try if(stmt != null) stmt.close();

11、stmt = null; catch (SQLException e) e.printStackTrace(); public static void closeRs(ResultSet rs) try if(rs != null) rs.close(); rs = null; catch (SQLException e) e.printStackTrace(); 上面的代码是连接数据库服务器，查询服务，修改服务和关闭数据库连接的代码。接下来介绍该系统具体实现对用户表的CRUD(增删改查)的操作。代码如下:具体操作用户信息表的代码:package com.bjsxt.drp.business.

12、usermgr.dao;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.sql.Timestamp;import java.util.ArrayList;import java.util.List;import com.bjsxt.drp.business.usermgr.model.User;import com.bjsxt.drp.b

13、usiness.util.DB;public class UserDao4MySqlImpl implements UserDao public void addUser(Connection conn, User user) String sql = insert into t_user(user_id, user_name, password, contact_tel, email, create_date) + values(?, ?, ?, ?, ?, ?); PreparedStatement pstmt = null; try pstmt = conn.prepareStateme

14、nt(sql); pstmt.setString(1, user.getUserId(); pstmt.setString(2, user.getUserName(); pstmt.setString(3, user.getPassword(); pstmt.setString(4, user.getContactTel(); pstmt.setString(5, user.getEmail(); pstmt.setTimestamp(6, new Timestamp(user.getCreateDate().getTime(); pstmt.executeUpdate(); catch (S

15、QLException e) e.printStackTrace(); finally DB.closeStmt(pstmt); public void deleteUsers(Connection conn, String userIdList) StringBuffer sbfSql = new StringBuffer(); for (int i = 0; i userIdList.length; i+) sbfSql.append().append(userIdListi).append().append(,); String sql = delete from t_user wher

16、e user_id in ( + sbfSql.substring(0, sbfSql.length() - 1) + ); Statement stmt = null; try stmt = conn.createStatement(); stmt.executeUpdate(sql); catch (SQLException e) e.printStackTrace(); finally DB.closeStmt(stmt); DB.closeConn(conn); public List findAllUserList() String sql = select * from t_use

17、r order by user_id ; Connection conn = null; Statement stmt = null; ResultSet rs = null; List userList = new ArrayList(); try conn = DB.getConn(); stmt = conn.createStatement(); rs = stmt.executeQuery(sql); while (rs.next() User user = new User(); user.setUserId(rs.getString(user_id); user.setUserNa

18、me(rs.getString(user_name); user.setPassword(rs.getString(password); user.setContactTel(rs.getString(contact_tel); user.setEmail(rs.getString(email); user.setCreateDate(rs.getTimestamp(create_date); userList.add(user); catch (SQLException e) e.printStackTrace(); finally DB.closeRs(rs); DB.closeStmt(

19、stmt); DB.closeConn(conn); return userList; public User findUserById(String userId) String sql = select * from t_user where user_id=?; User user = null; Connection conn = null; PreparedStatement pstmt = null; ResultSet rs = null; try conn = DB.getConn(); pstmt = conn.prepareStatement(sql); pstmt.set

20、String(1, userId); rs = pstmt.executeQuery(); if (rs.next() user = new User(); user.setUserId(rs.getString(user_id); user.setUserName(rs.getString(user_name); user.setPassword(rs.getString(password); user.setContactTel(rs.getString(contact_tel); user.setEmail(rs.getString(email); user.setCreateDate(

21、rs.getTimestamp(create_date); catch (SQLException e) e.printStackTrace(); finally DB.closeRs(rs); DB.closeStmt(pstmt); DB.closeConn(conn); return user; public User userSearch(String userId,String password) String sql = select * from t_user where user_id=? and password=?; User user = null; Connection

22、 conn = null; PreparedStatement pstmt = null; ResultSet rs = null; try conn = DB.getConn(); pstmt = conn.prepareStatement(sql); pstmt.setString(1, userId); pstmt.setString(2, password); rs = pstmt.executeQuery(); if (rs.next() user = new User(); user.setUserId(rs.getString(user_id); user.setUserName

23、(rs.getString(user_name); user.setPassword(rs.getString(password); user.setContactTel(rs.getString(contact_tel); user.setEmail(rs.getString(email); user.setCreateDate(rs.getTimestamp(create_date); catch (SQLException e) e.printStackTrace(); finally DB.closeRs(rs); DB.closeStmt(pstmt); DB.closeConn(c

24、onn); return user; public void modifyUser(Connection conn, User user) String sql = update t_user set user_name=?, password=?, contact_tel=?, email=? where user_id=?; PreparedStatement pstmt = null; try pstmt = conn.prepareStatement(sql); pstmt.setString(1, user.getUserName(); pstmt.setString(2, user

25、.getPassword(); pstmt.setString(3, user.getContactTel(); pstmt.setString(4, user.getEmail(); pstmt.setString(5, user.getUserId(); pstmt.executeUpdate(); catch (SQLException e) e.printStackTrace(); finally DB.closeStmt(pstmt); 操作管理员的代码:package com.bjsxt.drp.business.usermgr.dao;import java.sql.Connec

26、tion;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import com.bjsxt.drp.business.usermgr.model.Manager;import com.bjsxt.drp.business.util.DB;public class ManagerDao4MySqlImpl implements ManagerDao public Manager findManager(String name, String password) Str

27、ing sql = select * from t_manager where name=? and password=?; Manager manager = null; Connection conn = null; PreparedStatement pstmt = null; ResultSet rs = null; try conn = DB.getConn(); pstmt = conn.prepareStatement(sql); pstmt.setString(1, name); pstmt.setString(2, password); rs = pstmt.executeQuery(); if (rs.next() manager = new Manager(); manager.setName(rs.getString(name); manager.setPassword(rs.getString(password); catch (SQLException e) e.printStackTrace(); finally DB.closeRs(rs); DB.closeStmt(pstmt);