SSM整合案例企业权限管理系统（1）：SSM环境搭建

一、数据库环境搭建

1.sql语句

CREATE TABLE product(
id VARCHAR(32) PRIMARY KEY,
productNum VARCHAR(50) NOT NULL,
productName VARCHAR(50),
cityName VARCHAR(50),
DepartureTime TIMESTAMP,
productPrice DOUBLE,
productDesc VARCHAR(500),
productStatus INT,
UNIQUE KEY(id,productNum)
)
INSERT INTO PRODUCT (id, productnum, productname, cityname, departuretime, productprice,
productdesc, productstatus)
VALUES ('676C5BD1D35E429A8C2E114939C5685A', 'xpt-002', '北京三日游', '北京', 20181010101000, 1200, '不错的旅行', 1);

INSERT INTO PRODUCT (id, productnum, productname, cityname, departuretime, productprice,
productdesc, productstatus)
VALUES ('12B7ABF2A4C544568B0A7C69F36BF8B7', 'xpt-003', '上海五日游', '上海', 20180425143000, 1800, '魔都我来了', 0);
INSERT INTO PRODUCT (id, productnum, productname, cityname, departuretime, productprice,
productdesc, productstatus)
VALUES ('9F71F01CB448476DAFB309AA6DF9497F', 'xpt-001', '北京三日游', '北京', 20181010101000, 1200, '不错的旅行', 1);

2.可视化效果

3.字段说明

二、maven工程搭建

1.首先创建父工程

2.创建父工程的子模块

创建方式和上述完全一致，依次命名为

2.1几大子模块

2.2web模块需要用maven模板项目

2.3最后效果

3.父工程pom.xml导入jar包

<?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>com.xpt</groupId>
    <artifactId>SSM_EnterpriseAuthorityManagement</artifactId>
    <packaging>pom</packaging>
    <version>1.0-SNAPSHOT</version>


    <properties>
        <spring.version>5.0.2.RELEASE</spring.version>
        <slf4j.version>1.6.6</slf4j.version>
        <log4j.version>1.2.12</log4j.version>
        <mysql.version>5.1.6</mysql.version>
        <mybatis.version>3.4.5</mybatis.version>
        <spring.security.version>5.0.1.RELEASE</spring.security.version>
    </properties>

    <dependencies>        <!-- spring -->
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.6.8</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aop</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId