- 添加依赖
pom.xml文件中添加一下依赖;
<!--mysql依赖 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!--mybatis依赖 -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>
</dependency>
<!--好像不引入测试依赖pom.xml会报错 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
- 配置application.properties文件
useSSL=false是在JDBC版本与MySQL版本不兼容时需要加上的,true或false都试一下,看可不可用
https://blog.csdn.net/UIYOOOO/article/details/80301411
#连接mysql
spring.datasource.url=jdbc:mysql://localhost:3306/test?useSSL=false
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
- 创建entity实体类
@Data等于@Setter+@Getter
package com.gxl.gree.entity;
import lombok.Data;
@Data
public class User {
private Integer id;
private String username;
private String password;
}
- 创建DAO层的mapper类
@Mapper 可不写,直接在启动类上加:
@MapperScan(basePackages={“com.gxl.gree.mapper”})
package com.gxl.gree.mapper;
import java.util.List;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import com.gxl.gree.entity.User;
//@Mapper
public interface UserMapper {
@Select("SELECT * FROM USER WHERE USERNAME = #{username}")
List<User> findByName(@Param("username") String username);
@Insert("INSERT INTO USER(USERNAME, PASSWORD) VALUES(#{username}, #{password})")
int insert(@Param("username") String username, @Param("password") String password);
}
- 创建Service类
package com.gxl.gree.service;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.gxl.gree.entity.User;
import com.gxl.gree.mapper.UserMapper;
@Service
public class UserService implements UserMapper {
@Autowired
private UserMapper userMapper;
@Override
public List<User> findByName(String username) {
// TODO Auto-generated method stub
List<User> user = userMapper.findByName(username);
return user;
}
@Override
public int insert(String username, String password) {
// TODO Auto-generated method stub
int resultNum = userMapper.insert(username, password);
return resultNum;
}
}
- 调用Controller
@RequestMapping("/userChart")
public String userChart(){
int resultNum = userService.insert("taxianwoshuai", "qwe123");
List<User> userlist = userService.findByName("taxianwoshuai");
log.info("新增"+resultNum+"条数据: "+userlist);
return "新增"+resultNum+"条数据: "+userlist;
}
注:整合Mybatis过程中,SpringBoot2.0版本后的写法和1.5的不一致