springboot+mybaits操作数据库

spring boot 访问 MySQL
方式三：spring boot + mybaits

创新互联公司专业为企业提供河南网站建设、河南做网站、河南网站设计、河南网站制作等企业网站建设、网页设计与制作、河南企业网站模板建站服务，10年河南做网站经验，不只是建网站，更提供有价值的思路和整体网络服务。

pom 文件引入 依赖

        org.mybatis.spring.boot
        mybatis-spring-boot-starter
        2.0.1




        mysql
        mysql-connector-java

配置mybaits

mybatis

# 对应实体类的包名
mybatis.typeAliasesPackage=com.example.demo.model
# mapper.xml文件所在位置
mybatis.mapperLocations=classpath:**/mapper/*.xml

加入 entity mapper service controller 文件
entity

public class User {

        @Id
        @GeneratedValue(strategy= GenerationType.IDENTITY)
        private Long id;

        private String name;

        private int age;

        private String sex;

        public Long getId() {
                return id;
        }

        public void setId(Long id) {
                this.id = id;
        }

        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 getSex() {
                return sex;
        }

        public void setSex(String sex) {
                this.sex = sex;
        }
}

mapper

@Mapper
public interface UserMapper  {

        User findUserById(Long id);

        int add(User user);

        int update(User user);
}

xml

        
                
                
        
        
                SELECT * FROM user where id = #{id}
        

        
        insert  into user (name,age,sex) values (#{name},#{age},#{sex})
        

        
                update user set name = #{name} ,age = #{age} ,sex = #{sex} where id = ${id}
        

service

@Service
public class MybatisUserService {

        @Autowired
        UserMapper userDao;

        public int add(User user){
            return   userDao.add(user);
        }

        public int update(User user){
                return   userDao.update(user);
        }

        public User getById(long id){
                return   userDao.findUserById(id);
        }
}

controller

@RestController
@RequestMapping("/mybatisUser")
public class MybatisUserController {

        @Autowired
        MybatisUserService userService;

        @RequestMapping(value = "/add",method = RequestMethod.POST)
        public Object addUser(@RequestBody User user){

                return userService.add(user);
        }

        @RequestMapping(value = "/update",method = RequestMethod.PUT)
        public Object updateUser(@RequestBody User user){

                return userService.update(user);
        }

        @RequestMapping(value = "/find",method = RequestMethod.GET)
        public Object updateUser(long id){
                return userService.getById(id);
        }

}

主类上加扫描 mapper 路径

@SpringBootApplication
@MapperScan("com.example.demo.dao.mybatis")
public class DemoApplication {

        public static void main(String[] args) {
                SpringApplication.run(DemoApplication.class, args);
        }

}

启动项目 测试