21-上手一个项目SMBMS-项目搭建
21-上手一个项目SMBMS-项目搭建
概述
SMBMS(SuperMarket Bills Management System) 超市订单管理系统,学完javaweb,跟着狂神一起来搭建一个小的项目,从简单入手
建议看视频一起做更容易上手,我这边只是自己学习的笔记,不适用于所有人
分析
超时订单管理系统分为几个功能模块
订单管理
供应商管理
用户管理
登录注销
每个功能背后都对应一张表订单表、供应商表、用户表、角色表(登录注销功能对应)
项目搭建
前端相关静态web资源在这里获取
数据库建表sql在这里获取
几个pojo实体类表
Bill.java
package com.kuang.pojo;
import java.math.BigDecimal;
import java.util.Date;
/**
* 功能描述
*
* @since 2022-09-03
*/
public class Bill {
private Integer id; // 账单id
private String billcode; // 账单编码
private String productName; // 商品名称
private String productDesc; // 商品描述
private String productUnit; // 商品单位
private BigDecimal productCount; // 商品数量
private BigDecimal totalPrice; // 商品总额
private Integer isPayment; // 是否支付(1:未支付 2:已支付)
private Integer createdBy; // 创建者(userId)
private Date creationDate; // 创建时间
private Integer modifyBy; // 更新者(userId)
private Date modifyDate; // 更新时间
private Integer providerId; // 供应商ID
private String provideName; // 数据库中没有,用于返回联表查询的结果
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getBillcode() {
return billcode;
}
public void setBillcode(String billcode) {
this.billcode = billcode;
}
public String getProductName() {
return productName;
}
public void setProductName(String productName) {
this.productName = productName;
}
public String getProductDesc() {
return productDesc;
}
public void setProductDesc(String productDesc) {
this.productDesc = productDesc;
}
public String getProductUnit() {
return productUnit;
}
public void setProductUnit(String productUnit) {
this.productUnit = productUnit;
}
public BigDecimal getProductCount() {
return productCount;
}
public void setProductCount(BigDecimal productCount) {
this.productCount = productCount;
}
public BigDecimal getTotalPrice() {
return totalPrice;
}
public void setTotalPrice(BigDecimal totalPrice) {
this.totalPrice = totalPrice;
}
public Integer getIsPayment() {
return isPayment;
}
public void setIsPayment(Integer isPayment) {
this.isPayment = isPayment;
}
public Integer getCreatedBy() {
return createdBy;
}
public void setCreatedBy(Integer createdBy) {
this.createdBy = createdBy;
}
public Date getCreationDate() {
return creationDate;
}
public void setCreationDate(Date creationDate) {
this.creationDate = creationDate;
}
public Integer getModifyBy() {
return modifyBy;
}
public void setModifyBy(Integer modifyBy) {
this.modifyBy = modifyBy;
}
public Date getModifyDate() {
return modifyDate;
}
public void setModifyDate(Date modifyDate) {
this.modifyDate = modifyDate;
}
public Integer getProviderId() {
return providerId;
}
public void setProviderId(Integer providerId) {
this.providerId = providerId;
}
public String getProvideName() {
return provideName;
}
public void setProvideName(String provideName) {
this.provideName = provideName;
}
}
Provider.java
package com.kuang.pojo;
import java.util.Date;
/**
* 功能描述
*
* @since 2022-09-03
*/
public class Provider {
private Integer id; // 供应商id
private String proCode; // 供应商编码
private String proName; // 供应商名称
private String proDesc; // 供应商描述
private String proContact; // 供应商联系人
private String proPhone; // 供应商联系电话
private String proAddress; // 供应商地址
private Integer proFax; // 传真
private Integer createdBy; // 创建者(userId)
private Date creationDate; // 创建时间
private Date modifyDate; // 更新时间
private Integer modifyBy; // 更新者(userId)
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getProCode() {
return proCode;
}
public void setProCode(String proCode) {
this.proCode = proCode;
}
public String getProName() {
return proName;
}
public void setProName(String proName) {
this.proName = proName;
}
public String getProDesc() {
return proDesc;
}
public void setProDesc(String proDesc) {
this.proDesc = proDesc;
}
public String getProContact() {
return proContact;
}
public void setProContact(String proContact) {
this.proContact = proContact;
}
public String getProPhone() {
return proPhone;
}
public void setProPhone(String proPhone) {
this.proPhone = proPhone;
}
public String getProAddress() {
return proAddress;
}
public void setProAddress(String proAddress) {
this.proAddress = proAddress;
}
public Integer getProFax() {
return proFax;
}
public void setProFax(Integer proFax) {
this.proFax = proFax;
}
public Integer getCreatedBy() {
return createdBy;
}
public void setCreatedBy(Integer createdBy) {
this.createdBy = createdBy;
}
public Date getCreationDate() {
return creationDate;
}
public void setCreationDate(Date creationDate) {
this.creationDate = creationDate;
}
public Date getModifyDate() {
return modifyDate;
}
public void setModifyDate(Date modifyDate) {
this.modifyDate = modifyDate;
}
public Integer getModifyBy() {
return modifyBy;
}
public void setModifyBy(Integer modifyBy) {
this.modifyBy = modifyBy;
}
}
Role.java
package com.kuang.pojo;
import java.util.Date;
/**
* 功能描述
*
* @since 2022-09-03
*/
public class Role {
private Integer id; // 角色id
private String roleCode; // 角色编码
private String roleName; // 角色名称
private Integer createdBy; // 创建者
private Date creationDate;// 创建时间
private Integer modifyBy;// 修改者
private Date modifyDate;// 修改时间
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getRoleCode() {
return roleCode;
}
public void setRoleCode(String roleCode) {
this.roleCode = roleCode;
}
public String getRoleName() {
return roleName;
}
public void setRoleName(String roleName) {
this.roleName = roleName;
}
public Integer getCreatedBy() {
return createdBy;
}
public void setCreatedBy(Integer createdBy) {
this.createdBy = createdBy;
}
public Date getCreationDate() {
return creationDate;
}
public void setCreationDate(Date creationDate) {
this.creationDate = creationDate;
}
public Integer getModifyBy() {
return modifyBy;
}
public void setModifyBy(Integer modifyBy) {
this.modifyBy = modifyBy;
}
public Date getModifyDate() {
return modifyDate;
}
public void setModifyDate(Date modifyDate) {
this.modifyDate = modifyDate;
}
}
User.java
package com.kuang.pojo;
import java.util.Date;
/**
* 功能描述
*
* @since 2022-09-03
*/
public class User {
private Integer id;// '主键ID'
private String userCode;// '用户编码',
private String userName;// '用户名称',
private String userPassword;// '用户密码',
private Integer gender;// '性别(1:女、 2:男)',
private Date birthday;// '出生日期',
private String phone;// '手机',
private String address;// '地址',
private String userRole;// '用户角色(取自角色表-角色id)',
private Integer createdBy;// '创建者(userId)',
private Date creationDate;// '创建时间',
private Integer modifyBy;// '更新者(userId)',
private Date modifyDate;// '更新时间'
private Integer age; // 年纪,数据库中没有,自己计算
private String userRoleName; // 用户角色名称
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUserCode() {
return userCode;
}
public void setUserCode(String userCode) {
this.userCode = userCode;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getUserPassword() {
return userPassword;
}
public void setUserPassword(String userPassword) {
this.userPassword = userPassword;
}
public Integer getGender() {
return gender;
}
public void setGender(Integer gender) {
this.gender = gender;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getUserRole() {
return userRole;
}
public void setUserRole(String userRole) {
this.userRole = userRole;
}
public Integer getCreatedBy() {
return createdBy;
}
public void setCreatedBy(Integer createdBy) {
this.createdBy = createdBy;
}
public Date getCreationDate() {
return creationDate;
}
public void setCreationDate(Date creationDate) {
this.creationDate = creationDate;
}
public Integer getModifyBy() {
return modifyBy;
}
public void setModifyBy(Integer modifyBy) {
this.modifyBy = modifyBy;
}
public Date getModifyDate() {
return modifyDate;
}
public void setModifyDate(Date modifyDate) {
this.modifyDate = modifyDate;
}
public Integer getAge() {
Date date = new Date();
return date.getYear() - birthday.getYear();
}
public String getUserRoleName() {
return userRoleName;
}
public void setUserRoleName(String userRoleName) {
this.userRoleName = userRoleName;
}
}
filter 过滤器文件
CharacterEncodingFilter.java
package com.kuang.filter;
import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import java.io.IOException;
/**
* 功能描述
*
* @since 2022-09-03
*/
public class CharacterEncodingFilter implements Filter {
@Override
public void init(FilterConfig filterConfig) throws ServletException {
Filter.super.init(filterConfig);
}
@Override
public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain)
throws IOException, ServletException {
servletRequest.setCharacterEncoding("utf-8");
servletResponse.setCharacterEncoding("utf-8");
filterChain.doFilter(servletRequest, servletResponse);
}
@Override
public void destroy() {
Filter.super.destroy();
}
}
数据库操作
BaseDao.java
package com.kuang.dao;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;
/**
* 功能描述
*
* @since 2022-09-03
*/
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 inputStream = BaseDao.class.getClassLoader().getResourceAsStream("db.properties");
try {
properties.load(inputStream);
} 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);
} catch (Exception throwables) {
throwables.printStackTrace();
}
return connection;
}
// 数据库查询操作执行
public static ResultSet execute(Connection connection, String sql, Object[] params,
PreparedStatement preparedStatement, ResultSet resultSet) 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;
}
// 数据库更细操作执行
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]);
}
return preparedStatement.executeUpdate();
}
// 释放资源
public static boolean closeResource(Connection connection, PreparedStatement preparedStatement,
ResultSet resultSet) {
boolean flag = true;
if (resultSet != null) {
try {
resultSet.close();
resultSet = null;
} catch (SQLException throwables) {
throwables.printStackTrace();
flag = false;
}
}
if (preparedStatement != null) {
try {
preparedStatement.close();
preparedStatement = null;
} catch (SQLException throwables) {
throwables.printStackTrace();
flag = false;
}
}
if (connection != null) {
try {
connection.close();
connection = null;
} catch (SQLException throwables) {
throwables.printStackTrace();
flag = false;
}
}
return flag;
}
}
db.properties
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://xxx:3306/xxx
username=xxxx
password=xxx
父pom
pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.example</groupId>
<artifactId>SMBMS</artifactId>
<version>1.0-SNAPSHOT</version>
<properties>
<maven.compiler.source>8</maven.compiler.source>
<maven.compiler.target>8</maven.compiler.target>
</properties>
<dependencies>
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.2</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>4.0.1</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</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>taglibs</groupId>
<artifactId>standard</artifactId>
<version>1.1.2</version>
</dependency>
</dependencies>
</project>