1.在pom.xml引入依賴
<!--mybatis-->
<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>
</dependency>
2.配置文件application.properties冠绢，進(jìn)行數(shù)據(jù)庫(kù)配置
#mysql
spring.datasource.url=jdbc:mysql://localhost/test
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
3.編寫model數(shù)據(jù)庫(kù)對(duì)應(yīng)實(shí)體筛璧，以及Mapper接口
public interface UserMapper {
@Insert("insert into user (name) values (#{name})")
void insertUser(@Param("name")String name);
@Select("select * from user where id = #{id}")
User selectUserById(@Param("id") Integer id);
}
4.在主程序中科雳，使用@MapperScan注解進(jìn)行Mapper掃描
@EnableAutoConfiguration
@ComponentScan(basePackages = "com.fong.controller")
@MapperScan(basePackages = "com.fong.mapper")
public class App {
public static void main(String [] args) throws Exception{
SpringApplication.run(App.class,args);
}
}
5.編寫Controller
@RestController
public class UserController {
@Autowired
private UserMapper userMapper;
@RequestMapping("user-detail")
public User selectUserById(Integer id){
return userMapper.selectUserById(id);
}
@RequestMapping("insert-user")
public String insertUser(){
userMapper.insertUser("zansan");
return "success";
}
}
