1. 编写接口类:
- UserMapper.java
public interface UserMapper {
//查询所有用户
List<User> getUserList();
//根据ID查询用户
User getUserById(int id);
//插入用户
int addUser(User user);
//修改用户
int updateUser(User user);
//删除用户
int deleteUser(int id);
}
2. 编写mapper映射的xml文件,也就是sql语句:
- 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="com.wwj.dao.UserMapper">
<select id="getUserList" resultType="com.wwj.pojo.User">
select * from user
</select>