8. 整合SSM

环境要求

IDEA
MySQL 5.5
Tomcat 9
Maven 3.5.2

要求：

需要熟练掌握MySQL数据库，Spring，JavaWeb及Mybatis知识，简单的前端知识；

数据库环境

创建一个存放书籍数据的数据库表

create database `ssmbuild`;

use `ssmbuild`;

drop table books;

create table `books`(

	`bookID` int(10) not null auto_increment comment '书id',

	`bookName` varchar(100) not null comment '书名',

	`bookCount` int(11) not null comment '数量',

	`detail` varchar(200) not null comment '描述',

	key `bookID` (`bookID`)

)engine=innodb default charset=utf8;

insert into `books`(`bookID`,`bookName`,`bookCount`,`detail`)

values

(1,'Java',1,'从入门到放弃'),

(2,'MySQL',10,'从删库到跑路'),

(3,'Linux',5,'从进门到进牢');

基本环境搭建

新建一个Maven项目。ssmbuild，添加web的支持

导入相关pom依赖

<!--依赖：junit 数据库驱动 连接池 servlet jsp mybatis mybatis-spring spring -->

<dependencies>

    <!--junit-->

    <dependency>

        <groupId>junit</groupId>

        <artifactId>junit</artifactId>

        <version>4.12</version>

    </dependency>

    <!--数据库驱动-->

    <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->

    <dependency>

        <groupId>mysql</groupId>

        <artifactId>mysql-connector-java</artifactId>

        <version>5.1.47</version>

    </dependency>

    <!--数据库连接池-->

    <!-- https://mvnrepository.com/artifact/com.mchange/c3p0 -->

    <dependency>

        <groupId>com.mchange</groupId>

        <artifactId>c3p0</artifactId>

        <version>0.9.5.2</version>

    </dependency>

    <!--servlet jsp-->

    <!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api -->

    <dependency>

        <groupId>javax.servlet</groupId>

        <artifactId>javax.servlet-api</artifactId>

        <version>3.1.0</version>

    </dependency>

    <!-- https://mvnrepository.com/artifact/javax.servlet.jsp/javax.servlet.jsp-api -->

    <dependency>

        <groupId>javax.servlet.jsp</groupId>

        <artifactId>javax.servlet.jsp-api</artifactId>

        <version>2.3.1</version>

    </dependency>

    <!-- https://mvnrepository.com/artifact/javax.servlet/jstl -->

    <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.2</version>

    </dependency>

    <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->

    <dependency>

        <groupId>org.mybatis</groupId>

        <artifactId>mybatis-spring</artifactId>

        <version>2.0.2</version>

    </dependency>

    <!--spring-->

    <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->

    <dependency>

        <groupId>org.springframework</groupId>

        <artifactId>spring-jdbc</artifactId>

        <version>5.1.9.RELEASE</version>

    </dependency>

    <!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->

    <dependency>

        <groupId>org.springframework</groupId>

        <artifactId>spring-webmvc</artifactId>

        <version>5.1.9.RELEASE</version>

    </dependency>

<!--lombok-->

        <!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->

        <dependency>

            <groupId>org.projectlombok</groupId>

            <artifactId>lombok</artifactId>

            <version>1.16.10</version>

        </dependency>

</dependencies>

Mavan资源过滤设置（静态资源导出问题）

<build>

    <resources>

        <resource>

            <directory>src/main/java</directory>

            <includes>

                <include>**/*.properties</include>

                <include>**/*.xml</include>

            </includes>

            <filtering>false</filtering>

        </resource>

        <resource>

            <directory>src/main/resources</directory>

            <includes>

                <include>**/*.properties</include>

                <include>**/*.xml</include>

            </includes>

            <filtering>false</filtering>

        </resource>

    </resources>

</build>

建立基本接口和配置框架

com.kuang.pojo
com.kuang.dao
com.kuang.service
com.kuang.controller

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE configuration

        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"

        "http://mybatis.org/dtd/mybatis-3-config.dtd">

<!--核心配置文件-->

<configuration>

</configuration>

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

       xsi:schemaLocation="http://www.springframework.org/schema/beans

        https://www.springframework.org/schema/beans/spring-beans.xsd">

</beans>

巴特西

SpringMVC-08-整合SSM之基本环境搭建

8. 整合SSM

最新文章

热门文章