一.整合Junit
DROP TABLE IF EXISTS `s_user`;
CREATE TABLE `s_user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_name` varchar(100) DEFAULT NULL COMMENT '用户名',
`password` varchar(100) DEFAULT NULL COMMENT '密码',
`name` varchar(100) DEFAULT NULL COMMENT '姓名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
INSERT INTO `user` VALUES ('1', 'zhangsan', '123456', '张三');
INSERT INTO `user` VALUES ('2', 'lisi', '123456', '李四');
INSERT INTO `user` VALUES ('3', 'wangwu', '123456', '王五');
INSERT INTO `user` VALUES ('4', 'zhangwei', '123456', '张伟');
INSERT INTO `user` VALUES ('5', 'lina', '123456', '李娜');
INSERT INTO `user` VALUES ('6', 'lilei', '123456', '李磊');
1.加依赖
<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>it.playmaker</groupId>
<artifactId>SpringBoot-play</artifactId>
<version>0.0.1-SNAPSHOT</version>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.0.6.RELEASE</version>
</parent>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>
</dependency>
<!—配置测试启动器—>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
2.加入Spring-Boot配置文件
#DB Configuration:
spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/xxxx?characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=xxxxx
#JPA Configuration:
spring.jpa.database=mysql
spring.jpa.show-sql=true
spring.jpa.generate-ddl=true #是否自动生成ddl
spring.jpa.hibernate.ddl-auto=update #生成ddl的方式
spring.jpa.hibernate.naming_strategy=org.hibernate.cfg.ImprovedNamingStrategy #选择的命名策略
3.实体类
@Entity
@Table(name="s_user")//对应表
public class User {
@Id
@Column(name="id")
@GeneratedValue(strategy=GenerationType.IDENTITY)//自增长
private Long id;
@Column(name="user_name")//在windows系统下mysql不区分大小写。在Linux系统下,区分大小写
private String user_name;
@Column(name="password")
private String password;
@Column(name="name")
private String name;
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getUser_name() {
return user_name;
}
public void setUser_name(String user_name) {
this.user_name = user_name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
@Override
public String toString() {
return "User [id=" + id + ", user_name=" + user_name + ", password=" + password + ", name=" + name + "]";
}
}
4.编写Mapper类
@Mapper
public interface IUserMapper {
@Select("select * from s_user")
public List<User> findAll();
}
5.用户业务逻辑
public interface IUserService {
//查询所有用户
List<User> findAll();
}
6.用户业务逻辑实现类
@Service("userService")
public class UserServiceImpl implements IUserService {
@Autowired
private IUserMapper userMapper;
public List<User> findAll() {
return userMapper.findAll();
}
}
7.引导类
@SpringBootApplication
public class Application {
public static void main(String[] args) {
SpringApplication.run(Application.class, args);
}
}
8.创建一个测试类
@RunWith(SpringRunner.class)
@SpringBootTest
@Import(Application.class)//属性:用于指定引导类
public class SpringBootJunitTest {
@Autowired
private IUserService userService;
public void testFindAll() {
List<User> list=userService.findAll();
System.out.println(list);
}
}
二.读取Spring Boot核心配置文件内容
@RunWith(SpringRunner.class)
@SpringBootTest
@Import(Application.class)//属性:用于指定引导类
public class SpringBootJunitTest {
//@Autowired 字段类型注入
@Resource
private Environment env;
@Test
public void testReadSpringBootConfig() {
System.out.println(env.getProperty("spring.datasource.url"));
}
}