Spring-boot+Mybatis+Maven+MySql搭建实例

田维常

发布于 2019-11-25 22:44:31

5730

发布于 2019-11-25 22:44:31

前言

最近读了spring-boot开发手册，spring-boot相比于spring-mvc封装了很多常用的依赖，并且内置了tomcat容器，启动生成的jar包即可启动项目，也是目前流行的微服务常用框架。本文主要用到了spring-boot，以及mybatis，数据库用到了mysql。

准备工作

1.首先创建一个表：

CREATE TABLE `t_user` (    `USER_ID` int(11) NOT NULL AUTO_INCREMENT,    `USER_NAME` char(30) NOT NULL,    `USER_PASSWORD` char(10) NOT NULL,    `USER_EMAIL` char(30) NOT NULL,    PRIMARY KEY (`USER_ID`),    KEY `IDX_NAME` (`USER_NAME`)  ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8

插入一些数据：

INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (1, '林炳文', '1234567@', 'ling20081005@126.com');  INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (2, 'evan', '123', 'fff@126.com');  INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (3, 'kaka', 'cadg', 'fwsfg@126.com');  INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (4, 'simle', 'cscs', 'fsaf@126.com');  INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (5, 'arthur', 'csas', 'fsaff@126.com');  INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (6, '小德', 'yuh78', 'fdfas@126.com');  INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (7, '小小', 'cvff', 'fsaf@126.com');  INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (8, '林林之家', 'gvv', 'lin@126.com');  INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (9, '林炳文Evankaka', 'dfsc', 'ling2008@126.com');  INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (10, 'apple', 'uih6', 'ff@qq.com');

创建工程

我习惯于先创建好maven项目，构建目录再导入到编译器中，这样的好处就是搭建好一个脚手架模板，后面改改参数就可以用到各个工程里面。

构建pom.xml

<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.boot</groupId>    <artifactId>testSpringBoot</artifactId>    <version>0.0.1-SNAPSHOT</version>    <name>testSpringBoot</name>    <packaging>jar</packaging>    <parent>        <groupId>org.springframework.boot</groupId>        <artifactId>spring-boot-starter-parent</artifactId>        <version>1.5.9.RELEASE</version>        <relativePath/>    </parent>    <dependencies>        <dependency>            <groupId>org.springframework.boot</groupId>            <artifactId>spring-boot-starter-web</artifactId>        </dependency>                <!-- mybatis依赖 -->        <dependency>            <groupId>org.mybatis.spring.boot</groupId>            <artifactId>mybatis-spring-boot-starter</artifactId>            <version>1.3.1</version>        </dependency>                <!-- 引入thymelaf 则不需要引入web依赖，若不需要thymelaf则需要添加spring-boot-starter-web -->        <dependency>            <groupId>org.springframework.boot</groupId>            <artifactId>spring-boot-starter-thymeleaf</artifactId>        </dependency>                <!-- mysql依赖 -->        <dependency>            <groupId>mysql</groupId>            <artifactId>mysql-connector-java</artifactId>        </dependency>                 <dependency>          <groupId>org.springframework.boot</groupId>          <artifactId>spring-boot-starter-test</artifactId>        </dependency>    </dependencies>    <build>    <plugins>        <!-- 要使生成的jar可运行，需要加入此插件 -->        <plugin>            <groupId>org.springframework.boot</groupId>            <artifactId>spring-boot-maven-plugin</artifactId>        </plugin>    </plugins></build></project>

启动器以及controller

（1）启动器在com.boot(即最外层目录文件)下写一个如下main方法:

package com.boot;
import org.springframework.boot.SpringApplication;import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication public class Application {    public static void main(String[] args) throws Exception {         SpringApplication.run(Application.class, args);     }}

（2）controller 在com.boot.web下创建一个类如下:

package com.boot.web;
import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RestController;@RestControllerpublic class MainController {    @RequestMapping(value = "/")    String home() {    return "Hello World!";    }}

（3）启动项目找到com.boot下的Application以java Application方式启动，然后打开浏览器输入localhost:8080就会出现Hello World!

添加java代码

（1）User.java 对应数据库中表的字段，放在src/main/java下的包com.boot.domain

package com.boot.domain;
public class User {      private Integer userId;      private String userName;      private String userPassword;      private String userEmail;        public Integer getUserId() {          return userId;      }        public void setUserId(Integer userId) {          this.userId = userId;      }        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 String getUserEmail() {          return userEmail;      }        public void setUserEmail(String userEmail) {          this.userEmail = userEmail;      }        @Override      public String toString() {          return "User [userId=" + userId + ", userName=" + userName                  + ", userPassword=" + userPassword + ", userEmail=" + userEmail                  + "]";      }        }

（2）UserDao.java Dao接口类，用来对应mapper文件。放在src/main/java下的包com.lin.dao,内容如下：

package com.boot.dao;
import org.apache.ibatis.annotations.Mapper;
import com.boot.domain.User;@Mapperpublic interface UserDao {      public User selectUserById(Integer userId);    }

（3）UserService.java和UserServiceImpl.java service接口类和实现类，放在src/main/java下的包com.lin.service,内容如下：

UserService.java

package com.boot.service;
import com.boot.domain.User;
public interface UserService {    User selectUserById(Integer userId); }

UserServiceImpl.java

package com.boot.service.impl;
import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;
import com.boot.dao.UserDao;import com.boot.domain.User;import com.boot.service.UserService;@Servicepublic class UserServiceImpl implements UserService{    @Autowired      private UserDao userDao;          @Override    public User selectUserById(Integer userId) {        return userDao.selectUserById(userId);      }
}

（4）mapper文件用来和dao文件对应，放在src/main/resources中的com/boot/mapper目录下

UserMapper.xml

<?xml version="1.0" encoding="UTF-8"?>    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">  <mapper namespace="com.boot.dao.UserDao">  <!--设置domain类和数据库中表的字段一一对应，注意数据库字段和domain类中的字段名称不致，此处一定要！-->      <resultMap id="BaseResultMap" type="com.boot.domain.User">          <id column="USER_ID" property="userId" jdbcType="INTEGER" />          <result column="USER_NAME" property="userName" jdbcType="CHAR" />          <result column="USER_PASSWORD" property="userPassword" jdbcType="CHAR" />          <result column="USER_EMAIL" property="userEmail" jdbcType="CHAR" />      </resultMap>      <!-- 查询单条记录 -->      <select id="selectUserById" parameterType="int" resultMap="BaseResultMap">          SELECT * FROM t_user WHERE USER_ID = #{userId}      </select>  </mapper>

资源配置

下列所有文件均在src/main/resources目录下 （1）spring-boot配置 不少人都Properties资源文件来配置，不过这种文件在eclipse编码的默认设置是ISO-8859-1，需要修改eclipse的设置才能显示中文。因此我比较喜欢用yml文件来配置，一个是结构明显，另外一个不用考虑编码的问题。

application.yml

spring:  thymeleaf:    mode: HTML5    encoding: UTF-8    content-type: text/html    # 开发禁用缓存    cache: false  datasource:    url: jdbc:mysql://localhost:3306/ssmDb?characterEncoding=UTF-8&useSSL=true    username: root    password: password    # 可省略驱动配置, sprin-boot 会由url检测出驱动类型    # driver-class-name: com.mysql.jdbc.Driver    hikari:      connection-timeout: 60000 mybatis:  mapperLocations: classpath:com/boot/mapper/*.xml  typeAliasesPackage: cn.boot.domain# spring-boot默认打印输出info级别以上的，可在此处修改输出级别logging:  level:    root: info

（2）日志打印logback-spring.xml

<?xml version="1.0" encoding="UTF-8"?><configuration>
    <!-- 控制台输出 -->    <appender name="stdout" class="ch.qos.logback.core.ConsoleAppender">        <encoder>            <pattern>%date [%thread] %-5level %logger{80} - %msg%n</pattern>        </encoder>    </appender>
    <!-- 时间滚动输出 level为 INFO 日志 -->    <appender name="file-info" class="ch.qos.logback.core.rolling.RollingFileAppender">        <filter class="ch.qos.logback.classic.filter.LevelFilter">            <level>INFO</level>            <onMatch>ACCEPT</onMatch>            <onMismatch>DENY </onMismatch>        </filter>        <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">            <FileNamePattern>./logs/info.%d{yyyy-MM-dd}.log</FileNamePattern>            <MaxHistory>30</MaxHistory>        </rollingPolicy>        <encoder>            <pattern>%date [%thread] %-5level %logger{80} - %msg%n</pattern>        </encoder>    </appender>
    <!-- 时间滚动输出 level为 DEBUG 日志 -->    <appender name="file-debug" class="ch.qos.logback.core.rolling.RollingFileAppender">        <filter class="ch.qos.logback.classic.filter.LevelFilter">            <level>DEBUG</level>            <onMatch>ACCEPT</onMatch>            <onMismatch>DENY </onMismatch>        </filter>        <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">            <FileNamePattern>./logs/debug.%d{yyyy-MM-dd}.log</FileNamePattern>            <MaxHistory>30</MaxHistory>        </rollingPolicy>        <encoder>            <pattern>%date [%thread] %-5level %logger{80} - %msg%n</pattern>        </encoder>    </appender>
    <!-- 时间滚动输出 level为 ERROR 日志 -->    <appender name="file—error" class="ch.qos.logback.core.rolling.RollingFileAppender">        <filter class="ch.qos.logback.classic.filter.LevelFilter">            <level>ERROR</level>            <onMatch>ACCEPT</onMatch>            <onMismatch>DENY </onMismatch>        </filter>        <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">            <FileNamePattern>./logs/error.%d{yyyy-MM-dd}.log</FileNamePattern>            <MaxHistory>30</MaxHistory>        </rollingPolicy>        <encoder>            <pattern>%date [%thread] %-5level %logger{80} - %msg%n</pattern>        </encoder>    </appender>
    <logger name="org.apache.ibatis" level="INFO"/>    <logger name="java.sql.Connection" level="debug" />    <logger name="java.sql.Statement" level="debug" />    <logger name="java.sql.PreparedStatement" level="debug" />
    <root level="info">        <appender-ref ref="stdout" />        <appender-ref ref="file-info" />    </root></configuration>

本文参与腾讯云自媒体分享计划，分享自微信公众号。

原始发表：2019-11-15，如有侵权请联系 cloudcommunity@tencent.com 删除

spring