SMBMS项目

最新推荐文章于 2022-09-21 19:53:54 发布

Topon1

最新推荐文章于 2022-09-21 19:53:54 发布

阅读量466

点赞数

分类专栏：新人3.11 文章标签： maven jar java

本文链接：https://blog.csdn.net/Topon1/article/details/122567375

版权

新人3.11 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

SMBMS项目

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-22SAjHdY-1642507042027)(C:\Users\宁智波带土\AppData\Roaming\Typora\typora-user-images\image-20211214014940679.png)]

数据库：

项目如何搭建：

考虑使不使用Maven？依赖 jar包

项目搭建

搭建一个maven web 项目
配置Tomcat
测试项目能不能动起来
导入项目中会遇到的jar包
创建项目包结构
1. [外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-mbDlyimt-1642507042028)(C:\Users\宁智波带土\AppData\Roaming\Typora\typora-user-images\image-20211214160811054.png)]
编写实体类

ORM映射：表–类映射

编写基础公共类

数据库配置文件

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/student?userUnicode=true&characterEncoding=utf8&useSSL=true
username=root
password=root

编写数据库公共类

package com.yao.Dao;

import javax.xml.transform.Result;
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 Connection getConnection(){
        Connection connection=null;
        try {
            Class.forName("com.mysql.jdbc.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 i = preparedStatement.executeUpdate();
        return i;
    }
    //释放资源
    public static boolean closeResour(Connection connection,PreparedStatement preparedStatement,ResultSet resultSet){
        boolean b=true;
        if(resultSet!=null){
            try {
                resultSet.close();
            }catch (Exception e){
                e.printStackTrace();
                b=false;
            }
        }
        if(preparedStatement!=null){
            try {
                preparedStatement.close();
            }catch (Exception e){
                e.printStackTrace();
                b=false;
            }
        }
        if(connection!=null){
            try {
                connection.close();
            }catch (Exception e){
                e.printStackTrace();
                b=false;
            }
        }
        return b;
    }
}

导入静态资源

登录功能实现

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-hpWZJfMZ-1642507042029)(C:\Users\宁智波带土\AppData\Roaming\Typora\typora-user-images\image-20211215153818992.png)]

编写前端页面

设置首页

<welcome-file-list>
    <welcome-file>login.jsp</welcome-file>
</welcome-file-list>

通过Dao层登录用户登录的接口

public User getLoginUser(Connection connection,String userCode) throws SQLException;

编写dao层的实现类

package com.yao.Dao.user;

import com.yao.Dao.BaseDao;
import com.yao.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 preparedStatement =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,preparedStatement,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.closeResour(null,preparedStatement,rs);

        }
return user;
    }
}

业务层接口，操作dao层

package com.yao.Service.user;

import com.yao.pojo.User;

public interface UserService {
    //用户登录
    public User login(String userCode,String password);

}

业务层实现类

package com.yao.Service.user;

import com.yao.Dao.BaseDao;
import com.yao.Dao.user.UserDao;
import com.yao.Dao.user.UserDaoimpl;
import com.yao.pojo.User;
import org.junit.jupiter.api.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 user=null;
        try {
            connection=BaseDao.getConnection();
            user=userDao.getLoginUser(connection,userCode);
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            BaseDao.closeResour(connection,null,null);

        }
        return user;

    }
    


}

编写servlet

package com.yao.Servlet.user;

import com.yao.Service.user.UserService;
import com.yao.Service.user.UserServiceimpl;
import com.yao.pojo.User;
import com.yao.util.Constant;

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 {
        //获取用户名称和密码
        String username = req.getParameter("userCode");
        String password = req.getParameter("userPassword");
        //和数据库中的密码进行对比，调用业务层
        UserService userService=new UserServiceimpl();
        User user=userService.login(username,password);//这里已经把登陆的人查出来了

        if(user!=null){/*
            查有此人，可以登录
            将用户的信息存放到session中
            */
           req.getSession().setAttribute(Constant.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);
    }
}

注册servlet

测试访问，确保以上功能成功

登录功能优化

注销功能;

思路：移出session，返回登录页面

package com.yao.Servlet.user;

import com.yao.util.Constant;

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(Constant.USER_SESSION);
        resp.sendRedirect("login.jsp");//返回登录页面
    }

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

注册servlet

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

登陆拦截优化

ption, IOException {
doGet(req, resp);
}
}


注册servlet

```xml
<servlet>
    <servlet-name>LogoutServlet</servlet-name>
    <servlet-class>com.yao.Servlet.user.LogoutServlet</servlet-class>
</servlet>
<servlet-mapping>
    <servlet-name>LogoutServlet</servlet-name>
    <url-pattern>/jsp/logout.do</url-pattern>
</servlet-mapping>

登陆拦截优化