SpringBoot2.x系列教程28--SpringBoot中整合Mybatis框架实现数据库CRUD操作

packagecom.yyg.boot.config;
importcom.alibaba.druid.pool.DruidDataSource;
importlombok.Data;
importorg.mybatis.spring.annotation.MapperScan;
importorg.springframework.boot.context.properties.ConfigurationProperties;
importorg.springframework.context.annotation.Bean;
importorg.springframework.context.annotation.ComponentScan;
importorg.springframework.context.annotation.Configuration;
importjavax.sql.DataSource;
/*** @Author 一一哥Sun* @Date Created in 2020/3/30* @Description 第二种配置数据源的方式*/@Data@ComponentScan@Configuration@ConfigurationProperties(prefix="spring.datasource")
@MapperScan("com.yyg.boot.mapper")
publicclassDbConfig {
privateStringurl;
privateStringusername;
privateStringpassword;
@BeanpublicDataSourcegetDataSource() {
DruidDataSourcedataSource=newDruidDataSource();
dataSource.setUrl(url);
dataSource.setUsername(username);
dataSource.setPassword(password);
returndataSource;
    }
}

packagecom.yyg.boot.domain;
importlombok.Data;
importlombok.ToString;
/*** @Author 一一哥Sun* @Date Created in 2020/3/30* @Description Description*/@Data@ToStringpublicclassUser {
privateLongid;
privateStringusername;
privateStringbirthday;
privateStringsex;
privateStringaddress;
}

packagecom.yyg.boot.mapper;
importcom.yyg.boot.domain.User;
importorg.apache.ibatis.annotations.*;
/*** @Author 一一哥Sun* @Date Created in 2020/3/31* @Description 在Mybatis的Mapper接口中,增删改查都有对应的注解.@Insert,@Select,@Delete,@Update*/publicinterfaceUserMapper {
@Select("select * from user where id = #{id}")
UserqueryUserById(@Param(value="id") intid);
@Insert("insert into user(username,birthday,sex,address) values(#{username},#{birthday},#{sex},#{address})")
voidinsertUser(Useruser);
@Update("UPDATE user SET sex=#{sex} WHERE username=#{username}")
voidupdateUser(Useruser);
@Delete("DELETE FROM user WHERE id =#{id}")
voiddeleteById(@Param("id") intid);
}

packagecom.yyg.boot.web;
importcom.yyg.boot.domain.User;
importcom.yyg.boot.mapper.UserMapper;
importorg.springframework.beans.factory.annotation.Autowired;
importorg.springframework.web.bind.annotation.*;
/*** @Author 一一哥Sun* @Date Created in 2020/3/31* @Description Description*/@RestController@RequestMapping("/user")
publicclassUserController {
@AutowiredprivateUserMapperuserMapper;
@GetMapping("/{id}")
publicUserfindUserById(@PathVariable("id") Integerid) {
returnuserMapper.queryUserById(id);
    }
@PostMapping("")
publicStringaddUser(@RequestBodyUseruser) {
userMapper.insertUser(user);
return"success";
    }
@PostMapping("/update")
publicStringupdateUser(@RequestBodyUseruser) {
userMapper.updateUser(user);
return"success";
    }
@DeleteMapping("/{id}")
publicStringdelUserById(@PathVariable("id") Integerid) {
userMapper.deleteById(id);
return"success";
    }
}

packagecom.yyg.boot;
importorg.mybatis.spring.annotation.MapperScan;
importorg.springframework.boot.SpringApplication;
importorg.springframework.boot.autoconfigure.SpringBootApplication;
/*** @Author 一一哥Sun* @Date Created in 2020/3/31* @Description Description*/@SpringBootApplication//@MapperScan("com.yyg.boot.mapper")publicclassMybatisApplication {
publicstaticvoidmain(String[] args) {
SpringApplication.run(MybatisApplication.class, args);
    }
}