javaweb-SMBMS项目

在这里插入图片描述

1、项目搭建准备

1、搭建一个maven web项目
2、配置Tomcat
3、测试项目能否成功运行
4、导入项目中需要使用的jar包

 <dependencies>
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>servlet-api</artifactId>
      <version>2.5</version>
    </dependency>
    <dependency>
      <groupId>javax.servlet.jsp</groupId>
      <artifactId>javax.servlet.jsp-api</artifactId>
      <version>2.3.3</version>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.25</version>
    </dependency>
  </dependencies>
      <dependency>
      <groupId>javax.servlet.jsp.jstl</groupId>
      <artifactId>jstl-api</artifactId>
      <version>1.2</version>
    </dependency>
    <dependency>
      <groupId>taglibs</groupId>
      <artifactId>standard</artifactId>
      <version>1.1.2</version>

5、创建项目包结构
在这里插入图片描述
idea链接mysql:
在这里插入图片描述
https://blog.csdn.net/qq_22136439/article/details/106429131
https://blog.csdn.net/liuqiker/article/details/102455077
6、编写实体类
ORM映射:表-类映射
7、编写基础公共类
7.1 数据库配置文件

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306?useUnicode=true&characterEncoding=utf-8
username=root
password=root

7.2、编写数据库的公共类

package com.kuang.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 resourceAsStream = BaseDao.class.getClassLoader().getResourceAsStream("db.properties");

       try {
           properties.load(resourceAsStream);
       } 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 {
        //预编译的sql在后面直接执行就可以了
        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,ResultSet resultSet,PreparedStatement preparedStatement ){
        boolean flag=true;
        if(resultSet!=null){
            try {
                resultSet.close();
                //GC回访
                resultSet=null;
            } catch (SQLException e) {
                e.printStackTrace();
                flag=false;
            }
        }
        if(connection!=null){
            try {
                connection.close();
                //GC回访
                connection=null;
            } catch (SQLException e) {
                e.printStackTrace();
                flag=false;
            }
        }
        if(preparedStatement!=null){
            try {
                preparedStatement.close();
                //GC回访
                preparedStatement=null;
            } catch (SQLException e) {
                e.printStackTrace();
                flag=false;
            }
        }
        return flag;
    }
}

7.3、编写字符编码过滤器

package com.kuang.filter;

import javax.servlet.*;
import java.io.IOException;

public class CharacterEncoidngFilter implements Filter {
    public void init(FilterConfig filterConfig) throws ServletException {

    }

    public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
        servletResponse.setContentType("text/html;charset=utf-8");

        servletRequest.setCharacterEncoding("utf-8");
        servletResponse.setCharacterEncoding("utf-8");


        filterChain.doFilter(servletRequest, servletResponse);
    }

    public void destroy() {

    }
}

<!--  字符编码过滤器-->
  <filter>
    <filter-name>CharacterEncoidngFilter</filter-name>
    <filter-class>com.kuang.filter.CharacterEncoidngFilter</filter-class>
  </filter>
  <filter-mapping>
    <filter-name>CharacterEncoidngFilter</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>

8、导入静态资源
在这里插入图片描述

2、登录功能实现

在这里插入图片描述
1、编写前端页面
2、设置首页

<!--  设置欢迎页面-->
  <welcome-file-list>
    <welcome-file>login.jsp</welcome-file>
  </welcome-file-list>

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


public interface UserDao {

    //得到要登录的用户
    public User getLoginUser(Connection connection, String userCode) throws SQLException;

}

4、编写dao接口的实现类

package com.kuang.dao.user;

import com.kuang.dao.BaseDao;
import com.kuang.pojo.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,rs,pstm);
        }

        return user;
    }
}

5、业务层接口

package com.kuang.service.user;

import com.kuang.pojo.User;

public interface UserService {

    //用户登录
    public User login(String userCode, String password);
}

6、业务层实现类

package com.kuang.service.user;

import com.kuang.dao.BaseDao;
import com.kuang.dao.user.UserDao;
import com.kuang.dao.user.UserDaoImpl;
import com.kuang.pojo.User;
import org.junit.Test;

import java.sql.Connection;
import java.sql.SQLException;

public class UserServiceImpl implements UserService {
    //业务层都会调用dao层,所以我们要引入dao层
    private UserDao userDao;

    public UserServiceImpl(){
        userDao=new UserDaoImpl();
    }
    public User login(String userCode, String password) {
        Connection connection=null;
        User user=null;

        try {
            connection= BaseDao.getConnection();
            //通过业务层调用对应的具体的数据库操作
            user=userDao.getLoginUser(connection,userCode);
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            BaseDao.closeResource(connection,null,null);
        }
        return user;
    }

    @Test
    public void test(){
        UserServiceImpl userService=new UserServiceImpl();
        User admin=userService.login("admin","123");
        System.out.println(admin.getUserPassword());
    }
}

7、编写servlet

package com.kuang.servlet.user;

import com.kuang.pojo.User;
import com.kuang.service.user.UserServiceImpl;
import com.kuang.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 {

    //servlet:控制层,调用业务层代码

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        System.out.println("LoginServlet--start...");

        //获取用户名和密码
        String userCode=req.getParameter("userCode");
        String userPassword=req.getParameter("userPassword");

        //和数据库中的密码进行对比,调用业务层:
        UserServiceImpl userService = new UserServiceImpl();
        User user = userService.login(userCode, userPassword);//这里已经把登录的人给查到了

        if(user!=null){
            //查有此人,可以登录
//            将用户的信息放到session中
            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 {
        super.doPost(req, resp);
    }
}

8、注册servlet

<!--  servlet-->
  <servlet>
    <servlet-name>LoginServlet</servlet-name>
    <servlet-class>com.kuang.servlet.user.LoginServlet</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>LoginServlet</servlet-name>
    <url-pattern>/login.do</url-pattern>
  </servlet-mapping>

9、 测试访问,确保以上功能成功!

解决 ${pageContext.request.contextPath }/css/style.css 和 ${error} 的问题:

isELIgnored="false"

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8" isELIgnored="false"%>

登录功能优化

注销功能:
移除session、到登录页面

package com.kuang.servlet.user;

import com.kuang.pojo.User;
import com.kuang.service.user.UserServiceImpl;
import com.kuang.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 {
        //移除用户的session
        req.getSession().removeAttribute(Constants.USER_SESSION);
//        返回登录页面
        resp.sendRedirect("/login.jsp");
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doGet(req, resp);
    }
}


  <servlet>
    <servlet-name>LogoutServlet</servlet-name>
    <servlet-class>com.kuang.servlet.user.LogoutServlet</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>LogoutServlet</servlet-name>
    <url-pattern>/jsp/logout.do</url-pattern>
  </servlet-mapping>

登录拦截器:

package com.kuang.filter;

import com.kuang.pojo.User;
import com.kuang.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 servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
        HttpServletRequest request=(HttpServletRequest) servletRequest;
        HttpServletResponse response=(HttpServletResponse) servletResponse;

        //过滤器,从session中获取用户
        User user=(User)request.getSession().getAttribute(Constants.USER_SESSION);
        if(user==null){
            //已经被移除或者注销,或者未登录
            response.sendRedirect("/error.jsp");
        }else{
            filterChain.doFilter(servletRequest, servletResponse);
        }
    }

    public void destroy() {

    }
}

密码修改

1、导入前端素材
2、写项目建议从底层往上写
在这里插入图片描述

<!--  用户登录过滤器-->
  <filter>
    <filter-name>SysFilter</filter-name>
    <filter-class>com.kuang.filter.SysFilter</filter-class>
  </filter>
<filter-mapping>
  <filter-name>SysFilter</filter-name>
  <url-pattern>/jsp/*</url-pattern>
</filter-mapping>

3、UserDao

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

4、对应的实现类

 //修改当前用户密码
    public int updatePwd(Connection connection, int id, int password) throws SQLException {
        PreparedStatement pstm=null;
        User user=null;
        int execute=0;

        if(connection!=null){
            String sql="update smbms_user set userPassword=? where id=?";
            //注意这种方式
            Object[] params={password,id};


            execute = BaseDao.execute(connection, sql, params, pstm);
            BaseDao.closeResource(null,null,pstm);
        }
        return execute;
    }

5、UserService层

//根据id修改当前用户密码
    public boolean updatePwd(int id, int password);

6、实现类

//根据id修改当前用户密码
    public boolean updatePwd(int id, int password){
        Connection connection=null;
        boolean flag=false;

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

7、servlet层

package com.kuang.servlet.user;

import com.kuang.pojo.User;
import com.kuang.service.user.UserService;
import com.kuang.service.user.UserServiceImpl;
import com.kuang.util.Constants;
import com.mysql.cj.util.StringUtils;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

//实现Servlet复用
public class UserServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //从session中获取id
        Object attribute = req.getSession().getAttribute(Constants.USER_SESSION);

        String newPassword = req.getParameter("newpassword");

        boolean flag=false;
        
        if(attribute!=null && !StringUtils.isNullOrEmpty(newPassword)){
            UserService userService=new UserServiceImpl();
            flag=userService.updatePwd(((User)attribute).getId(),newPassword);

            if(flag){
                req.setAttribute("message","修改密码成功,请退出,使用新密码登录");

                //密码修改成功,移除当前session
                 req.getSession().removeAttribute(Constants.USER_SESSION);

            }else{
                req.setAttribute("message","密码修改失败");
            }
        }else{
            req.setAttribute("message","新密码有问题");
        }

        req.getRequestDispatcher("pwdmodify.jsp").forward(req,resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doGet(req, resp);
    }
}

7、记得实现复用,需要提取出方法

package com.kuang.servlet.user;

import com.kuang.pojo.User;
import com.kuang.service.user.UserService;
import com.kuang.service.user.UserServiceImpl;
import com.kuang.util.Constants;
import com.mysql.cj.util.StringUtils;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

//实现Servlet复用
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){
        //从session中获取id
        Object attribute = req.getSession().getAttribute(Constants.USER_SESSION);

        String newPassword = req.getParameter("newpassword");

        boolean flag=false;

        if(attribute!=null && !StringUtils.isNullOrEmpty(newPassword)){
            UserService userService=new UserServiceImpl();
            flag=userService.updatePwd(((User)attribute).getId(),newPassword);

            if(flag){
                req.setAttribute("message","修改密码成功,请退出,使用新密码登录");

                //密码修改成功,移除当前session
                req.getSession().removeAttribute(Constants.USER_SESSION);

            }else{
                req.setAttribute("message","密码修改失败");
            }
        }else{
            req.setAttribute("message","新密码有问题");
        }

        req.getRequestDispatcher("pwdmodify.jsp").forward(req,resp);
    }
}

8、测试

优化密码修改使用ajax

在这里插入图片描述
在这里插入图片描述
后台代码编写:

package com.kuang.servlet.user;

import com.alibaba.fastjson.JSONArray;
import com.kuang.pojo.User;
import com.kuang.service.user.UserService;
import com.kuang.service.user.UserServiceImpl;
import com.kuang.util.Constants;
import com.mysql.cj.util.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;

//实现Servlet复用
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) throws ServletException, IOException {
        //从session中获取id
        Object attribute = req.getSession().getAttribute(Constants.USER_SESSION);

        String newPassword = req.getParameter("newpassword");

        boolean flag=false;

        if(attribute!=null && !StringUtils.isNullOrEmpty(newPassword)){
            UserService userService=new UserServiceImpl();
            flag=userService.updatePwd(((User)attribute).getId(),newPassword);

            if(flag){
                req.setAttribute("message","修改密码成功,请退出,使用新密码登录");

                //密码修改成功,移除当前session
                req.getSession().removeAttribute(Constants.USER_SESSION);

            }else{
                req.setAttribute("message","密码修改失败");
            }
        }else{
            req.setAttribute("message","新密码有问题");
        }

        req.getRequestDispatcher("pwdmodify.jsp").forward(req,resp);
    }

//    验证旧密码,session中有用户的密码
    public void pwdModify(HttpServletRequest req, HttpServletResponse resp){
        //从session中获取id
        Object o = req.getSession().getAttribute(Constants.USER_SESSION);
        String oldpassword = req.getParameter("oldpassword");

//        万能的map:结果集
        HashMap<String, String> resultMap = new HashMap<String, String>();

        if(o==null){
            //session失效了,session过期了
            resultMap.put("result","sessionerror");
        }else if(StringUtils.isNullOrEmpty(oldpassword)){
            //输入的密码为空
            resultMap.put("result","error");
        }else{
            String userPassword = ((User) o).getUserPassword();//session中的密码
            if(oldpassword.equals(userPassword)){
                resultMap.put("result","true");
            }else{
                resultMap.put("result","false");
            }
        }

        try {
            resp.setContentType("application/json");
//        resp.setContentType("text/html");
            PrintWriter writer = resp.getWriter();
            //JSONArray 阿里巴巴的JSON工具类,转化格式
            /**
             * resultMap=["result","sessionerror","result","error"]
             * 转化为json的格式={key:value}
             */
            writer.write(JSONArray.toJSONString(resultMap));

            writer.flush();
            writer.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

用户管理实现

思路:
在这里插入图片描述
1、导入分页的工具类
2、用户列表导入
在这里插入图片描述

在这里插入图片描述
在这里插入图片描述
注意:增删改查一定要开启事务

tips:

自己总结的一些常用的IDEA快捷键,有需要的拿走:
ctrl+shift+alt:多行操作
psvm:生成main()方法;
fori:生成for循环;
Ctrl+Alt+v:自动补齐返回值类型
ctrl+o:覆写方法
ctrl+i:实现接口中的方法
ctrl+shift+u:大小写转换
CTRL+SHIFT+Z:取消撤销
Alt+Insert:生成构造方法、getter、setter
ctrl+y:删除当前行
Ctrl+Shift+J:将选中的行合并成一行
ctrl+g:定位到某一行
Ctrl+Shitft+向下箭头:将光标所在的代码块向下整体移动
Ctrl+Shift+向上箭头:将光标所在的代码块向上整体移动
Alt+Shift+向下箭头:将行向下移动
Alt+Shift+向上箭头:将行向上移动
Ctrl+F:在当前文件中查找
Ctrl+R:替换字符串
Ctrl+Shift+F:在全局文件中查找字符串
Ctrl+Shift+R:在全局中替换字符串
Ctrl+Shift+Enter:自动补齐{}或者分号;
Shift+Enter:在当前行的下方开始新行
Ctrl+Alt+Enter:在当前行的上方插入新行
Ctrl+Delete:删除光标所在至单词结尾处的所有字符
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值