springboot项目（一）创建springboot+mybatis
1、如何快速的创建是springboot+mybatis呢？首先点击create new project
2、选择Spring Initializr后直接点击next，如下图
3、如下图：红框中可以根据自己的需求进行改动。下面第二幅图是我进行修改部分，group和artifact可以理解为maven的坐标。改完之后点击next。
4、然后左边选择sql，右边选择mysql driver和mybatis然后点击下一步。最后finish，项目就算创建完成了。注意：project location是可以选择你创建项目的路径。
5、创建完后的项目如下图的：
maven文件内容为：
<?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>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.0.3.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>cn.cy</groupId>
<artifactId>springboot_project</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>springboot_project</name>
<description>Demo project for Spring Boot</description>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.0</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.35</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
6、先简单的配置一下配置文件application.properties（该文件可以改后缀为yml文件）：
后缀为yml的配置为：
spring:
datasource:
url: jdbc:mysql://127.0.0.1:3306/test_db
username: root
password: root
driver-class-name: com.mysql.jdbc.Driver
后缀为properties的配置为：
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test_db
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
因个人习惯用yml为后缀的，所以后面的截图也是yml格式。
1、在mysql中简单的创建一个表：
CREATE TABLE `boot_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(60) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`psw` varchar(30) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2、创建model：
public class SysUser {
private int id;
private String name;
private int age;
private String psw;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public String getPsw() {
return psw;
}
public void setPsw(String psw) {
this.psw = psw;
}
@Override
public String toString() {
return "SysUser{" +
"id=" + id +
", name='" + name + '\'' +
", age=" + age +
", psw='" + psw + '\'' +
'}';
}
}
创建dao：
import cn.cy.model.SysUser;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
@Mapper
public interface SysUserDaoInter {
@Insert("insert into boot_user(id, name, age, psw) values(#{id}, #{name}, #{age}, #{psw})")
int addSysUser(SysUser sysUser);
}
创建service：
import cn.cy.dao.SysUserDaoInter;
import cn.cy.model.SysUser;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
/**
* Created by 30721 on 2019/7/6.
*/
@Service
public class SysUserService {
@Resource
private SysUserDaoInter sysUserDaoInter;
public boolean addSysUser(SysUser sysUser) {
return sysUserDaoInter.addSysUser(sysUser)>0?true:false;
}
}
3、测试class：
import cn.cy.model.SysUser;
import cn.cy.service.SysUserService;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;
import javax.annotation.Resource;
@RunWith(SpringRunner.class)
@SpringBootTest
public class SpringbootProjectApplicationTests {
@Resource
private SysUserService sysUserService;
@Test
public void add() {
SysUser sysUser = new SysUser();
sysUser.setAge(12);
sysUser.setId(1);
sysUser.setName("zhangsan");
sysUser.setPsw("qwer");
sysUserService.addSysUser(sysUser);
}
}
输出结果如下图：
4、数据库的结果如下图。
项目创建成功并能成功运行。
