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
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);
}
}
启动项目 测试
文章题目:springboot+mybaits操作数据库
当前链接:http://myzitong.com/article/jdhpsh.html