Java | 仓库管理系统demo

1.系统功能简介

2. 项目搭建

2.1 搭建一个maven web项目

2.2 配置Tomcat

2.3 测试Tomcat

2.4 导入依赖

<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>5.1.47</version>
    </dependency>

    <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>
    </dependency>

    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
    </dependency>

    <!-- https://mvnrepository.com/artifact/com.alibaba/fastjson -->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>fastjson</artifactId>
      <version>1.2.61</version>
    </dependency>

      <!-- https://mvnrepository.com/artifact/com.alibaba/fastjson -->
      <dependency>
          <groupId>com.alibaba</groupId>
          <artifactId>fastjson</artifactId>
          <version>1.2.61</version>
      </dependency>

2.5 创建项目结构

2.6 编写实体类（ORM映射）

2.7 编写基础公共类（BaseDao）

• getConnection方法：获取数据库的链接
• execute方法：编写公共查询方法
• execute方法：编写增删改公共方法（方法重载）
• closeResource方法：释放资源

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

        try {
   
            properties.load(stream);
        } catch (IOException e) {
   
            e.printStackTrace();
        }

        driver = properties.getProperty("driver");
        url = properties.getProperty("url");
        username = properties.getProperty("username");
        password = properties.getProperty("password");
    }

    //getConnection方法：获取数据库的链接
    //返回值：一个数据库的连接对象connection
    public static Connection getConnection() throws SQLException {
   
        Connection connection=null;
        try {
   
            Class.forName(driver);
             connection = DriverManager.getConnection(url, username, password);
        } catch (ClassNotFoundException e) {
   
            e.printStackTrace();
        }
        return  connection;
    }

    //execute方法：编写公共查询方法
    //返回值：查询结果ResultSet
    public static ResultSet execute(Connection connection,PreparedStatement preparedStatement,ResultSet resultSet,String sql,Object[] params) throws SQLException {
   
        preparedStatement = connection.prepareStatement(sql);
        for (int i = 0; i < params.length; i++) {
   
            //注意这里的下标
            preparedStatement.setObject(i+1,params[i]);
        }
        resultSet = preparedStatement.executeQuery();
        return resultSet;
    }

    //execute方法：编写增删改公共方法（方法重载）
    //返回值：数据库中改变的行数 （int）update
    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++) {
   
            preparedStatement.setObject(i+1,params[i]);
        }
        int update = preparedStatement.executeUpdate();
        return update;
    }

    //closeResource方法：释放资源
    //返回值：是否成功 flag
    public static boolean closeResource(Connection connection,PreparedStatement preparedStatement,ResultSet resultSet)
    {
   
        boolean flag=true;
        if(connection!=null){
   
            try {
   
                connection.close();
            } catch (SQLException e) {
   
                e.printStackTrace();
                flag=false;
            }
        }

        if(preparedStatement!=null){
   
            try {
   
                preparedStatement.close();
            } catch (SQLException e) {
   
                e.printStackTrace();
                flag=false;
            }
        }

        if(resultSet!=null){
   
            try {
   
                resultSet.close();
            } catch (SQLException e) {
   
                e.printStackTrace();
                flag=false;
            }
        }

        return flag;
    }

}

数据库配置文件:

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

2.8 编写字符编码过滤器

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

    }

    public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
   

        servletRequest.setCharacterEncoding("utf-8");
        servletResponse.setCharacterEncoding("utf-8");
        filterChain.doFilter(servletRequest,servletResponse);
    }

    public void destroy() {
   

    }
}

映射：

    <!--字符编码过滤器-->
    <filter>
        <filter-name>CharacterEncodingFilter