图书管理系统(ssm框架) —— 01 环境搭建

数据库搭建

books表--存放书籍信息

CREATE DATABASE ssmframework;
USE ssmframework;
CREATE TABLE `books`(
                        `bookID` INT NOT NULL AUTO_INCREMENT COMMENT '书id',
                        `bookName` VARCHAR(100) NOT NULL COMMENT '书名',
                        `bookCounts` INT NOT NULL COMMENT '书籍总数量',
                        `bookBorrow` INT NOT NULL COMMENT '书籍借阅数量'
                        `detail` VARCHAR(200) NOT NULL COMMENT '描述',
                        KEY `bookID`(`bookID`)
)ENGINE=INNODB DEFAULT CHARSET=utf8;

INSERT INTO `books`(`bookID`,`bookName`,`bookCounts`,`bookBorrow`,`detail`)VALUES
(1,'Java',11,1,'从入门到放弃'),
(2,'MySQL',9,4,'从删库到跑路'),
(3,'Linux',7,4,'从进门到进牢')

borrow表--书籍借阅表

USE ssmframework;
CREATE TABLE `borrow`(
                        `userID` VARCHAR(100) NOT NULL  COMMENT '用户id',
                        `userName` VARCHAR(100) NOT NULL COMMENT '用户名',
                        `bookID` INT  NOT NULL COMMENT '用户密码',
                        `bookName` VARCHAR(100) NOT NULL COMMENT '用户权限',
                        `borrowTime` VARCHAR(100) NOT NULL COMMENT '借阅时间',
                        `returnTime` VARCHAR(100) NOT NULL COMMENT '归还时间',
)ENGINE=INNODB DEFAULT CHARSET=utf8;

user表--用户信息表

USE ssmframework;
CREATE TABLE `user`(
                        `userID` VARCHAR(100) NOT NULL  COMMENT '用户id',
                        `userName` VARCHAR(100) NOT NULL COMMENT '用户名',
                        `userPwd` VARCHAR(100) NOT NULL COMMENT '用户密码',
                        `userRoot` VARCHAR(100) NOT NULL COMMENT '用户权限',
                        KEY `userID`(`userID`)
)ENGINE=INNODB DEFAULT CHARSET=utf8;

INSERT INTO `user`(`userID`,`userName`,`userPwd`,`userRoot`)VALUES
('957b5fd0089148d8a52ac975fa39beb6','admin','123456','Administrator')

创建好后表格如图
book表

user表

maven

添加maven依赖

<!-- 添加依赖 : junit 数据库驱动 连接池 servlet jsp mybatis mybatis-spring spring -->
    <dependencies>
        <!-- JUnit -->
        <dependency>
            <groupId>org.junit.jupiter</groupId>
            <artifactId>junit-jupiter-api</artifactId>
            <version>5.8.0-M1</version>
            <scope>test</scope>
        </dependency>
        <!-- 数据库驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.24</version>
        </dependency>
        <!-- 数据库连接池 : c3p0 -->
        <dependency>
            <groupId>com.mchange</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.5.5</version>
        </dependency>

        <!-- Servlet-jsp -->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>4.0.1</version>
        </dependency>
        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>javax.servlet.jsp-api</artifactId>
            <version>2.3.3</version>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>

        <!-- Mybatis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.7</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.6</version>
        </dependency>

        <!-- Spring -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.3.8</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.3.7</version>
        </dependency>
        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-core</artifactId>
            <version>2.9.8</version>
        </dependency>
        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-databind</artifactId>
            <version>2.9.8</version>
        </dependency>
    </dependencies>

解决静态资源过滤问题

<!-- 静态资源导出 -->
    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>

项目结构

配置文件

配置文件放在resources文件夹下

• ApplicationContext.xml(总配置文件，负责整合其余配置文件)
• spring-mapper.xml(负责读取database.properties文件，连接数据库)
• spring-mvc.xml(负责视图解析器，拦截器)
• spring-service.xml(负责service层的业务)
• mybatis-config.xml(负责读取对应mapper.xml的sql语句)
• database.properties(负责存放数据库的用户名密码)