目录:
springboot增删改查
实现方式
首先,请确保您已经集成了Spring Boot和MyBatis框架,并且配置了数据源。接下来,您可以按照以下步骤进行实现增删改查功能:
1.创建数据表对应的实体类,例如:
public class User {
private Long id;
private String name;
private Integer age;
// 省略getter和setter方法
}
2.根据实体类创建对应的Mapper接口,例如:
@Mapper
public interface UserMapper {
List<User> findAll();
User findById(Long id);
void save(User user);
void update(User user);
void delete(Long id);
}
3. 在Mapper接口中定义对应的SQL语句,例如:
<select id="findAll" resultType="com.example.user.entity.User">
select * from user
</select>
<select id="findById" parameterType="Long" resultType="com.example.user.entity.User">
select * from user where id = #{id}
</select>
<insert id="save" parameterType="com.example.user.entity.User">
insert into user(name, age) values(#{name}, #{age})
</insert>
<update id="update" parameterType="com.example.user.entity.User">
update user set name = #{name}, age = #{age} where id = #{id}
</update>
<delete id="delete" parameterType="Long">
delete from user where id = #{id}
</delete>
4. 在Service层中注入Mapper,并进行相应的业务处理,例如:
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public List<User> findAll() {
return userMapper.findAll();
}
@Override
public User findById(Long id) {
return userMapper.findById(id);
}
@Override
public void save(User user) {
userMapper.save(user);
}
@Override
public void update(User user) {
userMapper.update(user);
}
@Override
public void delete(Long id) {
userMapper.delete(id);
}
}
5. 最后,在Controller层中进行相应的请求处理,例如:
@RestController
@RequestMapping("/users")
public class UserController {
@Autowired
private UserService userService;
@GetMapping("/{id}")
public User findById(@PathVariable("id") Long id) {
return userService.findById(id);
}
@GetMapping
public List<User> findAll() {
return userService.findAll();
}
@PostMapping
public void save(@RequestBody User user) {
userService.save(user);
}
@PutMapping
public void update(@RequestBody User user) {
userService.update(user);
}
@DeleteMapping("/{id}")
public void delete(@PathVariable("id") Long id) {
userService.delete(id);
}
}
以上代码仅供参考,具体实现细节和样式可以根据需求自行调整。