springboot-maven-ssm整合

呵呵！
环境：
硬件：电脑一台
开发工具：idea
框架：spring-springMVC-myBatis，maven，springboot
服务器：tomcat9.0（springboot内置）
jdk1.8
第一步：在idea中新建工程，使用spring initializer模版创建

第二步：配置pom.xml

部分原因写的很清楚了，在此声明，这个合并用的不是templates而是用jsp

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

4.0.0

org.springframework.boot
spring-boot-starter-parent
2.1.8.RELEASE


com.example
springboot-ssm
0.0.1-SNAPSHOT
war
springboot-ssm
Demo project for Spring Boot

<java.version>1.8</java.version>

    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
    <dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>2.1.0</version>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-devtools</artifactId>
        <scope>runtime</scope>
        <optional>true</optional>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.2</version>
        <scope>runtime</scope>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-tomcat</artifactId>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>
    <!--        如果不加这个解析器，则访问页面会变成下载.  使用jsp作为这个模版就必须加入这个，因为springboot对
        jsp不支持-->
    <dependency>
        <groupId>org.apache.tomcat.embed</groupId>
        <artifactId>tomcat-embed-jasper</artifactId>
    </dependency>

    <dependency>
        <groupId>jstl</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
    </dependency>
    <dependency>
        <groupId>taglibs</groupId>
        <artifactId>standard</artifactId>
        <version>1.1.2</version>
    </dependency>
</dependencies>
<build>
    <plugins>
        <plugin>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-maven-plugin</artifactId>
        </plugin>
    </plugins>
</build>

第三步：配置默认配置文件
这是springboot默认读取的配置文件
端口，试图解析器，数据源，以及mybatis的映射文件路径都是在这里边配置，其实都很熟悉了

server config

server.port= 8083
#试图解析
spring.mvc.view.prefix=/WEB-INF/jsp/
spring.mvc.view.suffix=.jsp

mysql

spring.datasource.url= jdbc:mysql://192.168.31.188:3306/user
spring.datasource.username= root
spring.datasource.password= 123465
spring.datasource.driver-class-name= com.mysql.jdbc.Driver
spring.datasource.dbcp2.validation-query= ‘select 1’
spring.datasource.dbcp2.test-on-borrow= true
spring.datasource.dbcp2.test-while-idle= true
spring.datasource.dbcp2.time-between-eviction-runs-millis= 27800
spring.datasource.dbcp2.initial-size= 5
spring.datasource.dbcp2.min-idle= 5
spring.datasource.dbcp2.max-idle= 100
spring.datasource.dbcp2.max-wait-millis= 10000

thymleaf

spring.thymeleaf.cache = false

mybatis

mybatis.mapper-locations= classpath:mapper/*.xml
mybatis.configuration.map-underscore-to-camel-case= true

第四步：编写BaisController，IUserDao和User
目录结构如下：

BasicController.java
package com.example.springbootssm.controller;
import com.example.springbootssm.dao.IUserDao;
import com.example.springbootssm.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.servlet.ModelAndView;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
@Controller
public class BasicController {
@Autowired
private IUserDao iUserDao;
@RequestMapping(value = “/lookUserInfo”)
public String lookUserInfo(Model model){
System.out.println(iUserDao);
List list = iUserDao.getUserAllInfo();
// List list = new ArrayList<>();
// list.add(new User(1,“snkae”,new Date(1),“m”,“Tina 汤”));
// list.add(new User(1,“kuke”,new Date(2),“w”,“盛典元”));
// list.add(new User(1,“bake”,new Date(3),“m”,“Tina 汤”));
model.addAttribute(“list”,list);
return “showUserInfo”;
}
}

IUserDao.java
package com.example.springbootssm.dao;
import com.example.springbootssm.pojo.User;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;
@Mapper
public interface IUserDao {
public List getUserAllInfo();
}

User.java
package com.example.springbootssm.pojo;
import java.util.Date;
public class User {
private Integer id;
private String username;
private Date birthday;
private String sex;
private String address;
public User(){
}
public User(Integer id, String username,Date birthday, String sex, String address){
this.id = id;
this.username = username;
this.birthday = birthday;
this.address = address;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
@Override
public String toString() {
return “User{” +
“id=” + id +
“, username=’” + username + ‘’’ +
“, birthday=” + birthday +
“, address=’” + address + ‘’’ +
‘}’;
}
}

第四步：编写IUserDao.xml配置文件
根据在application.properties中配置的文件路径，所以要在resources目录下创建mapper

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

<select id="getUserAllInfo" resultType="com.example.springbootssm.pojo.User">
    select * from user

第五步：改变目录结构，也就是添加webapp目录以及其下的WEB-INF 步骤是：1->选择文件下的Project Structure  2->分别在Web Resource Directories添加webapp目录 和在Deployment Descriptors下添加WEB-INF添加时注意路径一定要对，是在src/main下  第六步：编写showUserInfo.jsp文件 <%-- Created by IntelliJ IDEA. User: heshang Date: 2019/9/25 Time: 8:09 PM To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

用户信息

id	username	birthday	sex	address
${user.id}	${user.username}	${user.birthday}	${user.sex}	${user.address}

然后就在主函数下启动测试吧！注意webapp下的那个showUserInfo.jsp不是必须的是我测试用的。
注意事项：注意数据库版本，选择合适的数据库驱动，具体版本可在pom.xml
中修改