GIF动态图演示

百度百度网盘提取项目 带数据库！[链接]:https://pan.baidu.com/s/13F2rxszZRLGDt9pr6ixYUg提取码：关注私信我发送！

一、项目搭建准备工作

• 1.搭建一个maven web项目
• 2.配置Tomcat
• 3.测试项目是否能够跑起来
• 4.导入项目中遇到的jar包
• 5.创建项目结构
  

6.编写实体类

ORM映射：表类映射

7.编写基础公共类

1.数据库配置文件

db.properties文件代码

driver=com.mysql.jdbc.Driverurl=jdbc:mysql://localhost:3306?useUnicode=true&characterEncoding=utf-8username=rootpassword=111111

2.编写数据库的公共类

java代码

package com.syj.dao;import java.io.IOException;import java.io.InputStream;import java.sql.*;import java.util.Properties;//操作数据库的公共类public class BaseDao {    private static String driver;    private static String url;    private static String username;    private static String password;    //静态代码块，类加载的时候就初始化了    static {        Properties properties = new Properties();        //通过类加载器读取对应的资源        InputStream is = BaseDao.class.getClassLoader().getResourceAsStream("db.properties");        try {            properties.load(is);        } catch (IOException e) {            e.printStackTrace();        }        driver = properties.getProperty("driver");        url = properties.getProperty("url");        username = properties.getProperty("username");        password = properties.getProperty("password");    }    //获取数据库的链接    public static Connection getConnection(){        Connection connection = null;        try {            Class.forName(driver);            connection = DriverManager.getConnection(url, username, password);        } catch (Exception e) {            e.printStackTrace();        }        return  connection;    }    //编写查询公共类    public static ResultSet execute( Connection connection,String sql,Object[] params,ResultSet resultSet, PreparedStatement preparedStatement ) throws SQLException {       preparedStatement = connection.prepareStatement(sql);        for (int i = 0; i < params.length; i++) {            //setObject,占位符从1开始，但是我们的数组是从0开始！            preparedStatement.setObject(i+1,params[i]);        }        resultSet = preparedStatement.executeQuery();        return resultSet;    }    //编写增删改查公共方法    public static int execute( Connection connection,String sql,Object[] params, PreparedStatement preparedStatement ) throws SQLException {        preparedStatement = connection.prepareStatement(sql);        for (int i = 0; i < params.length; i++) {            //setObject,占位符从1开始，但是我们的数组是从0开始！            preparedStatement.setObject(i+1,params[i]);        }        int updateRows = preparedStatement.executeUpdate();        return updateRows;    }    public static boolean closeResource(Connection connection,PreparedStatement preparedStatement,ResultSet resultSet){        boolean flag = true;        if(resultSet != null){            try {                resultSet.close();                //GC回收                resultSet = null;            } catch (SQLException e) {                e.printStackTrace();                flag = false;            }        }        if(preparedStatement != null){            try {                preparedStatement.close();                //GC回收                preparedStatement = null;            } catch (SQLException e) {                e.printStackTrace();                flag = false;            }        }        if(connection != null){            try {                connection.close();                //GC回收                connection = null;            } catch (SQLException e) {                e.printStackTrace();                flag = false;            }        }        return flag;    }}

3.编写字符编码过滤器

8.导入静态资源

二、登录功能实现

1.编写前端页面

2.设置欢迎界面

xml代码

            login.jsp    

3.编写dao层登录用户的接口

java dao层接口代码

package com.syj.dao.user;import com.syj.entity.User;import java.sql.Connection;import java.sql.SQLException;public interface UserDao {    //得到登录的用户    public User getLoginUser(Connection connection,String userCode) throws SQLException;}

4.编写dao接口的实现类

java dao接口的实现类代码

package com.syj.dao.user;import com.syj.dao.BaseDao;import com.syj.entity.User;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class UserDaoImpl implements UserDao{    //得到要登录的用户    public User getLoginUser(Connection connection, String userCode) throws SQLException {        PreparedStatement pstm = null;        ResultSet rs = null;        User user = null;        if(connection != null){            String sql = "select * from smbms_user where userCode=?";            Object[] params = {userCode};            rs = BaseDao.execute(connection,pstm,rs,sql,params);            if(rs.next()){                user = new User();                user.setId(rs.getInt("id"));                user.setUserCode(rs.getString("userCode"));                user.setUserName(rs.getString("userName"));                user.setUserPassword(rs.getString("userPassword"));                user.setGender(rs.getInt("gender"));                user.setBirthday(rs.getDate("birthday"));                user.setPhone(rs.getString("phone"));                user.setAddress(rs.getString("address"));                user.setUserRole(rs.getInt("userRole"));                user.setCreatedBy(rs.getInt("createdBy"));                user.setCreationDate(rs.getTimestamp("creationDate"));                user.setModifyBy(rs.getInt("modifyBy"));                user.setModifyDate(rs.getTimestamp("modifyDate"));            }            BaseDao.closeResource(null,pstm,rs);        }        return user;    }}

5.业务层接口

java service接口代码

package com.syj.service.user;import com.syj.entity.User;public interface UserService {        //用户登录    public User login(String userCode,String password);}

6.业务层实现类

java serviceImpl实现类代码

package com.syj.service.user;import com.syj.dao.BaseDao;import com.syj.dao.user.UserDao;import com.syj.dao.user.UserDaoImpl;import com.syj.entity.User;import java.sql.Connection;import java.sql.SQLException;public class UserServiceImpl implements UserService{    private UserDao userDao;    public UserServiceImpl(){        userDao = new UserDaoImpl();    }    public User login(String userCode, String password) {        Connection connection = null;        User user = null;        connection = BaseDao.getConnection();        try {            user = userDao.getLoginUser(connection,userCode);        } catch (SQLException e) {            e.printStackTrace();        }finally {            BaseDao.closeResource(connection,null,null);        }        return user;    }}

7.编写Servlet

java 代码

package com.syj.servlet;import com.syj.entity.User;import com.syj.service.user.UserService;import com.syj.service.user.UserServiceImpl;import com.syj.util.Constants;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import java.io.IOException;public class LoginServlet extends HttpServlet {        @Override    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {        String userCode = req.getParameter("userCode");        String userPassword = req.getParameter("userPassword");        UserService userService = new UserServiceImpl();        User user = userService.login(userCode, userPassword);        if(user != null){            req.getSession().setAttribute(Constants.USER_SESSION,user);            resp.sendRedirect("jsp/frame.jsp");        }else{            req.setAttribute("error","用户名或者密码不正确");            req.getRequestDispatcher("login.jsp").forward(req,resp);        }    }    @Override    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {        doGet(req, resp);    }}

8.注册servlet

xml代码

        LoginServlet        com.syj.servlet.LoginServlet                LoginServlet        /login.do    

9.测试访问确保以上功能成功

三、登陆功能优化

注销功能：

思路：移除Session,返回登录界面
java servlet代码

package com.syj.servlet;import com.syj.util.Constants;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import java.io.IOException;public class LogoutServlet extends HttpServlet {    @Override    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {      req.getSession().removeAttribute(Constants.USER_SESSION);      resp.sendRedirect("/login.jsp");    }    @Override    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {        doGet(req, resp);    }}

xml 代码

            LogoutServlet        com.syj.servlet.LogoutServlet                LogoutServlet        /jsp/logout.do    

四、登录拦截优化

编写一个过滤器并注册

java 代码

package com.syj.filter;import com.syj.entity.User;import com.syj.util.Constants;import javax.servlet.*;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import java.io.IOException;public class SysFilter implements Filter {    public void init(FilterConfig filterConfig) throws ServletException {    }    public void doFilter(ServletRequest req, ServletResponse resp, FilterChain chain) throws IOException, ServletException {        HttpServletRequest request = (HttpServletRequest) req;        HttpServletResponse response = (HttpServletResponse) resp;        User user = (User) request.getSession().getAttribute(Constants.USER_SESSION);        if(user==null){            response.sendRedirect("/smbms/error.jsp");        }else{            chain.doFilter(req,resp);        }    }    public void destroy() {    }}

xml 代码

               SysFilter        com.syj.filter.SysFilter                SysFilter        /jsp/*    

测试，登录，注销，权限，以上功能都要保证执行成功

五、密码修改

1.导入前端素材

pwdmodify.jsp

密码修改

2.写项目，建议从底层向上写

3.UserDao接口

//修改用户密码    public int updatePwd(Connection connection,int id,int password) throws SQLException;

4.UserDao接口实现类

//修改用户密码    public int updatePwd(Connection connection, int id, int password) throws SQLException {        PreparedStatement pstm = null;        int execute = 0;        if(connection != null){            String sql = "update smbms_user set userPassword = ? where id = ?";            Object[] params = {password,id};            execute = BaseDao.execute(connection,pstm,sql,params);            BaseDao.closeResource(null,pstm,null);        }        return execute;    }

5.UserService层

  //根据用户Id修改密码    public boolean updatePwd(int id,int pwd);

6.UserService实现类

public boolean updatePwd(int id, int pwd) {        Connection connection = null;        boolean flag = false;        //修改密码        try {            connection = BaseDao.getConnection();            if(userDao.updatePwd(connection,id,pwd) > 0){                flag = true;            }        } catch (SQLException e) {            e.printStackTrace();        }finally {            BaseDao.closeResource(connection,null,null);        }        return false;    }

7. servlet控制器层

记得实现复用，需要提取方法

 @Overridepackage com.mario.servlet;import com.mario.entity.User;import com.mario.service.user.UserService;import com.mario.service.user.UserServiceImpl;import com.mario.util.Constants;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import java.io.IOException;public class UserServlet extends HttpServlet {    @Override    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {        String method = req.getParameter("method");        if(method.equals("savepwd") && method != null){            this.updatePwd(req,resp);        }    }    @Override    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {        doGet(req, resp);    }    public void updatePwd(HttpServletRequest req, HttpServletResponse resp){        Object obj = req.getSession().getAttribute(Constants.USER_SESSION);        String newpassword = req.getParameter("newpassword");        System.out.println(newpassword);        boolean flag = false;        if(obj != null && newpassword != null){            UserService userService = new UserServiceImpl();            flag = userService.updatePwd(((User) obj).getId(), newpassword);            if(flag){                req.setAttribute("message","修改密码成功");                req.getSession().removeAttribute(Constants.USER_SESSION);            }else{                req.setAttribute("message","密码修改失败");            }        }else{            req.setAttribute("message","新密码有问题");        }        try {            req.getRequestDispatcher("pwdmodify.jsp").forward(req,resp);        } catch (ServletException e) {            e.printStackTrace();        } catch (IOException e) {            e.printStackTrace();        }    }}

8. 测试

优化密码修改使用Ajax

1.阿里巴巴的fastjson

pom.xml

      com.alibaba      fastjson      1.2.61    

2.后台修改的代码

package com.mario.servlet;import com.alibaba.fastjson.JSONArray;import com.mario.entity.User;import com.mario.service.user.UserService;import com.mario.service.user.UserServiceImpl;import com.mario.util.Constants;import com.mysql.jdbc.StringUtils;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import java.io.IOException;import java.io.PrintWriter;import java.util.HashMap;import java.util.Map;public class UserServlet extends HttpServlet {    @Override    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {        String method = req.getParameter("method");        if(method.equals("savepwd") && method != null){            this.updatePwd(req,resp);        }else if(method.equals("pwdmodify") && method != null){            this.pwdModify(req,resp);        }    }    @Override    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {        doGet(req, resp);    }    //修改密码    public void updatePwd(HttpServletRequest req, HttpServletResponse resp){        Object obj = req.getSession().getAttribute(Constants.USER_SESSION);        String newpassword = req.getParameter("newpassword");        System.out.println(newpassword);        boolean flag = false;        if(obj != null && newpassword != null){            UserService userService = new UserServiceImpl();            flag = userService.updatePwd(((User) obj).getId(), newpassword);            if(flag){                req.setAttribute("message","修改密码成功");                req.getSession().removeAttribute(Constants.USER_SESSION);            }else{                req.setAttribute("message","密码修改失败");            }        }else{            req.setAttribute("message","新密码有问题");        }        try {            req.getRequestDispatcher("pwdmodify.jsp").forward(req,resp);        } catch (ServletException e) {            e.printStackTrace();        } catch (IOException e) {            e.printStackTrace();        }    }    //验证旧密码,session中有用户的密码    public void pwdModify(HttpServletRequest req, HttpServletResponse resp){        Object obj = req.getSession().getAttribute(Constants.USER_SESSION);        String oldpassword = req.getParameter("oldpassword");        Map resultMap = new HashMap();        if(obj==null){            resultMap.put("result","sessionerror");        }else if(StringUtils.isNullOrEmpty(oldpassword)){            resultMap.put("result","error");        }else{            String userPassword = ((User) obj).getUserPassword();            if(oldpassword.equals(userPassword)){                resultMap.put("result","true");            }else{                resultMap.put("result","false");            }        }        try {            resp.setContentType("application/json");            PrintWriter writer = resp.getWriter();            writer.write(JSONArray.toJSONString(resultMap));            writer.flush();            writer.close();        } catch (IOException e) {            e.printStackTrace();        }    }}

3.测试

六、用户管理实现

1.获取用户数量

1.UserDao

 //查询用户总数    public int getUserCount(Connection connection,String username,int userRole) throws SQLException;

2.UserDaoImpl

    public int getUserCount(Connection connection, String username, int userRole) throws SQLException {        PreparedStatement pstm = null;        ResultSet rs = null;        int count = 0;        if(connection != null){            StringBuilder sql = new StringBuilder();            sql.append("select count(1) as count from smbms_user u,smbms_role r where u.userRole = r.id");            ArrayList