用户管理加登陆

《用户管理加登陆》由会员分享，可在线阅读，更多相关《用户管理加登陆（21页珍藏版）》请在装配图网上搜索。

1、这个小项目只是servlet和jsp。建包的时候看一下每个import后面的包名。希望对你有帮助Jar包mysql的jar包和一个jstl的jar包。数据库表在表文件夹里面。小项目框架如图：这个类是测试类：package cn.rj.ceshi;import java.util.List;import cn.rj.model.Users;import cn.rj.services.UsersServicesManager;public class ceshiall /* * param args */SuppressWarnings(static-access)public static vo

2、id main(String args) / TODO Auto-generated method stuUsersServicesManager usm=new UsersServicesManager();/*获取所有用户 */List userList=usm.getList(0,4);System.out.println(userList.get(0);for(int i=0;iuserList.size();i+)System.out.println( +userList.get(i).getUserid()+t+ +userList.get(i).getUsername()+t+

3、+userList.get(i).getPassword();/*获取1个用户Users user=usm.getUser(1001);if(user=null)System.out.println(用户为null);System.out.println(当前用户信息：username=+user.getUsername()+tpassword=+user.getPassword(); */*添加1个用户Users user=new Users(0,wj, wj);int result=usm.addUsers(user);System.out.println(result为1的话就添加成功,

4、此时 result=+result); */*删除1个用户int result=usm.deleteUser(1005);System.out.println(result为1的话就删除成功,此时 result=+result); */*修改用户信息Users user=new Users(1007, hr, hr);int result=usm.updateUser(user);System.out.println(result为1的话就修改成功,此时 result=+result); */这个类是users类（model）：package cn.rj.model;/* * 实体User类

5、* author jingdi * */public class Users private Integer userid;private String username;private String password;public Integer getUserid() return userid;public void setUserid(Integer userid) this.userid = userid;public String getUsername() return username;public void setUsername(String username) this.

6、username = username;public String getPassword() return password;public void setPassword(String password) this.password = password;public Users(Integer userid, String username, String password) super();this.userid = userid;this.username = username;this.password = password;public Users(String username

7、, String password) this.username = username;this.password = password;Overridepublic String toString() return useridtusername password;public Users() 这个类是增删改查管理的类（service层）：package cn.rj.services;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.Re

8、sultSetMetaData;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;import cn.rj.model.Users;import cn.rj.util.Util;/* * 用户管理接口 * author jingdi *用户相关的增删改查 */public class UsersServicesManager /* * 获取结果集resultSet */public static ResultSet findResultSet(String sql)PreparedStat

9、ement ps=null;ResultSet rs = null;Connection conn =Util.getConnection();try ps = conn.prepareStatement(sql);rs = ps.executeQuery(); catch (SQLException e) / TODO Auto-generated catch blockSystem.out.println(预处理sql语句出现错误);e.printStackTrace();return rs;/* * 链接和预处理sql语句 */public static PreparedStatemen

10、t excuteSql(String sql)PreparedStatement ps=null;Connection conn=Util.getConnection();try ps=conn.prepareStatement(sql); catch (SQLException e) / TODO Auto-generated catch blockSystem.out.println(添加用户的sql语句出现错误);e.printStackTrace();return ps;/* * 查找全部用户 */public static List getList(int currentPage,i

11、nt pageSize)int offset=(currentPage-1)*pageSize;List list=new ArrayList();String sql=select * from users limit ?,?;PreparedStatement ps=excuteSql(sql);try ps.setInt(1, offset);ps.setInt(2, pageSize);ResultSet rs =ps.executeQuery();while(rs.next()Users users=new Users(rs.getInt(userid),rs.getString(u

12、sername), rs.getString(password);list.add(users); catch (SQLException e) System.out.println(结果集里面没有值);/ TODO Auto-generated catch blocke.printStackTrace();return list;/* * 通过userid（关键字）得到用户的信息 */public static Users getUser(int userId)Users u=null;String sql= select userid,username,password from user

13、s where userid=?;PreparedStatement ps=null;ResultSet rs=null;Connection conn=Util.getConnection();try ps=conn.prepareStatement(sql);ps.setInt(1, userId);rs=ps.executeQuery();while(rs.next()u=new Users(userId, rs.getString(username), rs.getString(password); catch (SQLException e1) / TODO Auto-generat

14、ed catch blocke1.printStackTrace();return u;/* * 添加一个用户 */public static int addUsers(Users u)int result=0;String sql=insert into users values (?,?,?);PreparedStatement ps=excuteSql(sql);try ps.setInt(1, u.getUserid();ps.setString(2, u.getUsername();ps.setString(3, u.getPassword();result=ps.executeUp

15、date(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return result;/* * 删除一个用户 */public static int deleteUser(int userid)int result=0;String sql=delete from users where userid=?;PreparedStatement ps=excuteSql(sql);try ps.setInt(1, userid);result=ps.executeUpdate(); cat

16、ch (SQLException e) e.printStackTrace();return result;/* * 修改用户信息 */public static int updateUser(Users user)int result=0;/Users user=getUser(userid);String sql = update users set username=?,password=? where userid=+user.getUserid();PreparedStatement ps=excuteSql(sql);try ps.setString(1, user.getUser

17、name();ps.setString(2, user.getPassword();result=ps.executeUpdate(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return result;/* * 用户登陆验证 */public static int userLoginCheck(int userid,String username,String passowrd) / TODO Auto-generated method stubint result=0;User

18、s user=getUser(userid);if(user!=null)if(user.getUsername().equals(username)if(user.getPassword().equals(passowrd)result=1;return result;/* * 获取数据库用户总数 */public static int getTotalRow(String tableName)int countRow=0;String sql=select count(*) from +tableName.toLowerCase();ResultSet rs=findResultSet(s

19、ql);try while(rs.next()countRow=rs.getInt(1); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return countRow;/* * 得到表的字段 */public static List getFeild(String sql) / TODO Auto-generated method stubList feilds=null;ResultSet rs=findResultSet(sql);ResultSetMetaData rsmd=nul

20、l;try rsmd=rs.getMetaData();int count=rsmd.getColumnCount();feilds=new ArrayList();for(int i=1;i=count;i+)String feild=rsmd.getCatalogName(i);feilds.add(feild); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return feilds;一下6个类是增删改查相关的servlet：第一个（删除用户）：package cn.rj.serv

21、let;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import cn.rj.services.UsersServicesManager;public class DeleteUser extends

22、HttpServlet private static final long serialVersionUID = 1L;public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException this.doPost(request, response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletExcepti

23、on, IOException int userid=Integer.parseInt(request.getParameter(userid);int result=UsersServicesManager.deleteUser(userid);if(result=1)response.setContentType(text/html);request.setCharacterEncoding(utf-8);response.setCharacterEncoding(utf-8);PrintWriter out = response.getWriter();out.println();out

24、.println();out.println( 删除成功界面);out.println( );out.print();out.print();out.print();out.print( 删除成功 返回);out.print();out.print();out.print();out.print();out.println( );out.println();out.flush();out.close();第二个（真正修改）：package cn.rj.servlet;import java.io.IOException;import java.io.PrintWriter;import jav

25、ax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import cn.rj.model.Users;import cn.rj.services.UsersServicesManager;public class RealUpdateUser extends HttpServlet private static final long s

26、erialVersionUID = 1L;public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException this.doPost(request, response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException int userid=Integer.pars

27、eInt(request.getParameter(userid);String username=request.getParameter(username);String password=request.getParameter(password);Users user=new Users(userid, username, password);int result=UsersServicesManager.updateUser(user);if(result=1)response.setContentType(text/html);request.setCharacterEncodin

28、g(utf-8);response.setCharacterEncoding(utf-8);PrintWriter out = response.getWriter();out.println();out.println();out.println( 修改成功界面);out.println( );out.print();out.print();out.print();out.print( 修改成功 返回);out.print();out.print();out.print();out.print();out.println( );out.println();out.flush();out.cl

29、ose();elseif(username.equals(null)|password.equals(null)response.sendRedirect(admin/users/UpdateUser.jsp);第三个（修改）：package cn.rj.servlet;import java.io.IOException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.ser

30、vlet.http.HttpServletResponse;import cn.rj.model.Users;import cn.rj.services.UsersServicesManager;public class UpdateUser extends HttpServlet private static final long serialVersionUID = 1L;public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOExceptio

31、n this.doPost(request, response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException int currentPage=Integer.parseInt(request.getParameter(currentPage);System.out.println(当前是第+currentPage+页);int userid=Integer.parseInt(request.getParameter

32、(userid);Users user=UsersServicesManager.getUser(userid);request.setAttribute(currentPage, currentPage);request.setAttribute(user, user);request.setAttribute(userid, userid);request.getRequestDispatcher(admin/users/UpdateUser.jsp).forward(request, response);第四个（添加用户）；package cn.rj.servlet;import jav

33、a.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import cn.rj.model.Users;import cn.rj.services.UsersServicesManager;public class userAdd

34、extends HttpServlet private static final long serialVersionUID = 1L;public userAdd() System.out.println(准备添加员工);public void destroy() System.out.println(添加员工结束);public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException this.doPost(request, respon

35、se);/* * 添加员工的主要操作 */public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException int i=isInteger(request.getParameter(userid);int userid;if(i=0)userid=0;elseuserid=Integer.parseInt(request.getParameter(userid);String username=request.getParameter(

36、username);String password=request.getParameter(password);if(username.equals(null)|password.equals(null)response.sendRedirect(admin/users/AddUser.jsp);Users user=new Users(userid,username, password);int result=UsersServicesManager.addUsers(user);if(result=1)response.setContentType(text/html);request.

37、setCharacterEncoding(utf-8);response.setCharacterEncoding(utf-8);PrintWriter out = response.getWriter();out.println();out.println();out.println( 添加成功界面);out.println( );out.print();out.print();out.print();out.print( 添加成功 返回登录登录界面);out.print();out.print();out.print();out.print();out.println( );out.pri

38、ntln();out.flush();out.close();elseif(username.equals(null)|password.equals(null)response.sendRedirect(admin/users/AddUser.jsp);public static int isInteger(String str)try System.out.println(Integer.parseInt(str);Integer.parseInt(str);return 1; catch (NumberFormatException e) / TODO Auto-generated ca

39、tch blockreturn 0;public void init() throws ServletException / Put your code hereSystem.out.println(添加员工初始化);第五个（用户登陆验证）：package cn.rj.servlet;import java.io.IOException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import ja

40、vax.servlet.http.HttpServletResponse;import cn.rj.services.UsersServicesManager;public class UserLoginCheck extends HttpServlet private static final long serialVersionUID = 1L;/* * Constructor of the object. */public UserLoginCheck() System.out.println(进入了userLoginCheck);/* * Destruction of the serv

41、let. */public void destroy() System.out.println(登陆结束);/ Put your code herepublic void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException this.doPost(request, response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws

42、ServletException, IOException int userid=Integer.parseInt(request.getParameter(userid);String username=request.getParameter(username);String password=request.getParameter(password);int result=UsersServicesManager.userLoginCheck(userid,username,password);if(result=1)response.sendRedirect(UsersList);e

43、lseresponse.sendRedirect(index.jsp);public void init() throws ServletException / Put your code hereSystem.out.println(进入init()方法);第六个（用户展示）：package cn.rj.servlet;import java.io.IOException;import java.util.List;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.

44、servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import cn.rj.model.Page;import cn.rj.model.Users;import cn.rj.services.UsersServicesManager;public class UsersList extends HttpServlet private static final long serialVersionUID = 1L;public void doGet(HttpServletRequest re

45、quest, HttpServletResponse response)throws ServletException, IOException this.doPost(request, response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException String cPage=request.getParameter(currentPage);String pSize=request.getParameter(pa

46、geSize);/String sql=select * from users;/* * 存放用户信息的页面对象 */Page pageModel=new Page();int currentPage=1;int pageSize=3;Object psSession= request.getSession().getAttribute(pageSize);if(psSession!=null)pageSize=(Integer)psSession;/* * 判断当前页显示多少条数据(删除 了) */if(pSize!=null)pageSize=Integer.parseInt(pSize)

47、;request.getSession().setAttribute(pSize, pSize);/* * 判断当前的页面 */if(cPage!=null)currentPage=Integer.parseInt(cPage);int totalRow=UsersServicesManager.getTotalRow(users);pageModel.setTotalRow(totalRow);pageModel.setCurrentPage(currentPage);pageModel.setPageSize(pageSize);List usersList=UsersServicesMa

48、nager.getList(pageModel.getCurrentPage(),pageSize);pageModel.setList(usersList);request.setAttribute(pageModel, pageModel);request.getRequestDispatcher(admin/users/UsersList.jsp).forward(request, response);这个是链接数据库的类：package cn.rj.util;import java.sql.Connection;import java.sql.DriverManager;import

49、java.sql.SQLException;/* * 链接数据库 * author jingdi *加，连,欲，执，释 */public class Util private static Connection conn;final static String Drivername=com.mysql.jdbc.Driver;final static String user=root;final static String password=root;final static String url=jdbc:mysql:/localhost:3306/mybase;public static

50、Connection getConnection()try Class.forName(Drivername);conn=DriverManager.getConnection(url, user, password); catch (ClassNotFoundException e) System.out.println(加载驱动失败);/ TODO Auto-generated catch blocke.printStackTrace(); catch (SQLException e) System.out.println(链接数据库出现错误);/ TODO Auto-generated catch blocke.printStackTrace();return conn;接下来是需要的3个jsp:AddUser.jsp: base href= 用户注册 !- 用户编号: 用户姓名: