1、增删改查
1.1、写一个User实体类如下所示:
@Data
public class User {
private Integer id;
private String name;
private Double money;
public User(Integer id, String name, Double money) {
this.id = id;
this.name = name;
this.money = money;
}
public User(Integer id) {
this.id = id;
}
public User() {
}
}
1.2、在mapper文件夹下创建一个UserMapper类
代码如下所示:
@Repository("userMapper")
public interface UserMapper {
/**
* 查询所有
* @return
*/
List<User> getAllUser();
/**
* 删除
* @param id
* @return
*/
int deleteUser(Integer id);
/**
* 新增
* @param user
* @return
*/
int addUser(User user);
/**
* 修改
* @param user
* @return
*/
int updateUser(User user);
/**
* 根据id查询
* @param id
* @return
*/
User selectById(Integer id);
}
在如下图所示创建一个UserMapper.xml映射文件
关键代码如下所示:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="mapper.UserMapper">
<select id="getAllUser" resultType="User">
select * from user
</select>
<delete id="deleteUser">
delete from `user` where id=#{id}
</delete>
<insert id="addUser">
insert into `user` (id,`name`,money)
values (#{id},#{name},#{money})
</insert>
<update id="updateUser">
update user set name=#{name},money=#{money}
where id=#{id}
</update>
<select id="selectById" resultType="domain.User">
select * from user where id=#{id}
</select>
</mapper>
1.3、在service文件夹下创建一个UserService接口和UserServiceImpl类(实现类)
代码如下所示
UserService接口:
public interface UserService {
//查询
List<User> getAllUser();
//删除
int deleteUser(Integer id);
//新增
int addUser(User user);
//修改
int updateUser(User user);
//Id查询
User selectById(Integer id);
}
UserServiceImpl类:
@Service("userService")
public class UserServiceImpl implements UserService{
@Autowired
private UserMapper userMapper;
@Transactional(rollbackFor = Exception.class)
@Override
public List<User> getAllUser() {
return userMapper.getAllUser();
}
@Override
public int deleteUser(Integer id) {
return userMapper.deleteUser(id);
}
@Override
public int addUser(User user) {
return userMapper.addUser(user);
}
@Override
public int updateUser(User user) {
return user