第一步:点左上角 File-New-Maven Project
然后在pom文件中添加相关依赖,
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<java.version>1.8</java.version>
</properties>
<dependencies>
<!-- 添加支持web的模块 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
<version>2.0.5.RELEASE</version>
</dependency>
<!-- 核心模块,包括自动配置支持,日志 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
<version>2.0.5.RELEASE</version>
</dependency>
<!-- 测试模块, 包括 Junit -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<version>2.0.5.RELEASE</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.39</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<configuration>
<fork>true</fork>
</configuration>
</plugin>
<!-- 解决没有web.xml导致报错的 web.xml is missing and <failOnMissingWebXml> is set to true -->
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-war-plugin</artifactId>
<configuration>
<failOnMissingWebXml>false</failOnMissingWebXml>
</configuration>
</plugin>
</plugins>
</build>
第二步:新建Application类
package com.baidu;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;
//括号里的是解决现在没有连接数据库启动报错,等会整合完mybatis就要把括号删掉,只需保留@SpringBootApplication
@SpringBootApplication(exclude = {DataSourceAutoConfiguration.class})
public class Application {
public static void main(String[] args) {
SpringApplication.run(Application.class, args);
System.out.println("web Spring Boot start!");
}
}
新建目录,以及测试controller
第三步:在Application类启动main方法;在浏览器访问地址localhost:8080/test,访问成功!
下面整合mybatis,新建所需的类;
(1)在application.properties添加配置;
mybatis.mapper-locations=classpath:mapper/*.xml
mybatis.type-aliases-package=com.baidu.entity
spring.datasource.driverClassName = com.mysql.jdbc.Driver
spring.datasource.url = jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8
spring.datasource.username = root
spring.datasource.password = root
(2)实体类UserEntity
package com.baidu.entity;
public class UserEntity {
private String name;
private int age;
private String gender;
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 getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
@Override
public String toString() {
return "UserEntity [name=" + name + ", age=" + age + ", gender=" + gender + "]";
}
}
(3)mapper
package com.baidu.mapper;
import org.apache.ibatis.annotations.Mapper;
import com.baidu.entity.UserEntity;
@Mapper
public interface TestMapper {
void insertUser(UserEntity user);
UserEntity findUserByName(String name);
}
(3)Service
package com.baidu.service;
import com.baidu.entity.UserEntity;
public interface TestService {
void insertUser(UserEntity user);
UserEntity findUserByName(String name);
}
package com.baidu.service.impl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.baidu.entity.UserEntity;
import com.baidu.mapper.TestMapper;
import com.baidu.service.TestService;
@Service
public class TestServiceImpl implements TestService {
@Autowired
private TestMapper testMapper;
public void insertUser(UserEntity user) {
testMapper.insertUser(user);
}
public UserEntity findUserByName(String name) {
return testMapper.findUserByName(name);
}
}
(4)mapper.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.baidu.mapper.TestMapper">
<select id="findUserByName" parameterType="String" resultType="com.baidu.entity.UserEntity">
select * from test where name=#{name}
</select>
<insert id="insertUser" parameterType="com.baidu.entity.UserEntity">
INSERT INTO test VALUES (#{name}, ${age}, #{gender});
</insert>
</mapper>
(5)新建测试类 Junit
package com.baidu.test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;
import org.junit.Test;
import com.baidu.entity.UserEntity;
import com.baidu.service.TestService;
@RunWith(SpringRunner.class)
@SpringBootTest
public class MysqlTest {
@Autowired
private TestService testService;
@Test
public void insertUser() {
UserEntity user = new UserEntity();
user.setAge(44);
user.setGender("女");
user.setName("菜虚鲲");
testService.insertUser(user);
}
@Test
public void findUserByName() {
System.out.println(testService.findUserByName("菜虚鲲"));
}
}
大功告成!