3. 操作users表的CRUD
3.1 XML的实现
1). 定义sql映射xml文件:
<!-- 增 -->
<insert id="insertUser" parameterType="com.atguigu.ibatis.bean.User">
insert into users(name, age) values(#{name}, #{age});
</insert>
<!-- 删 -->
<delete id="deleteUser" parameterType="int">
delete from users where id=#{id}
</delete>
<!-- 改 -->
<update id="updateUser" parameterType="com.atguigu.ibatis.bean.User">
update users set name=#{name},age=#{age} where id=#{id}
</update>
<!-- 查 -->
<select id="selectUser" parameterType="int" resultType="com.atguigu.ibatis.bean.User">
select * from users where id=#{id}
</select>
<select id="selectAllUsers" resultType="com.atguigu.ibatis.bean.User">
select * from users
</select>
2). 在config.xml中注册这个映射文件
<mapper resource=" com/atguigu/ibatis/bean/userMapper.xml"/>
3). 在dao中调用:
public User getUserById(int id) {
SqlSession session = sessionFactory.openSession();
User user = session.selectOne(URI+".selectUser", id);
return user;
}
3.2 注解的实现
1). 定义sql映射的接口
public interface UserMapper {
@Insert("insert into users(name, age) values(#{name}, #{age})")
public int insertUser(User user);
@Delete("delete from users where id=#{id}")
public int deleteUserById(int id);
@Update("update users set name=#{name},age=#{age} where id=#{id}")
public int updateUser(User user);
@Select("select * from users where id=#{id}")
public User getUserById(int id);
@Select("select * from users")
public List<User> getAllUser();
}
2). 在config中注册这个映射接口
<mapper class="com.atguigu.ibatis.crud.ano.UserMapper"/>
3). 在dao类中调用
public User getUserById(int id) {
SqlSession session = sessionFactory.openSession();
UserMapper mapper = session.getMapper(UserMapper.class);
User user = mapper.getUserById(id);
return user;
}