package cn.henu.mapper;
import cn.henu.domain.User;
import java.util.List;
public interface UserMapper {
//插入操作
public void save(User user);
//更新操作
public void update(User user);
//删除操作
public void delete(int id);
//根据id查询
public User findById(int id);
//查询全部
public List<User> findAll();
}
4、写一个映射文件,里面写SQL语句(cn/henu/mapper/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="cn.henu.mapper.UserMapper">
<insert id="save" parameterType="user">
insert into user values (#{id},#{username},#{password},#{birthday})
</insert>
<update id="update" parameterType="user">
update user set username = #{username},password = #{password} where id = #{id}
</update>
<delete id="delete" parameterType="int">
delete from user where id = #{id}
</delete>
<select id="findById" parameterType="int" resultType="user">
select * from user where id = #{id}
</select>
<select id="findAll" resultType="user">
select * from user
</select>
</mapper>
package cn.henu.mapper;
import cn.henu.domain.User;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import java.util.List;
public interface UserMapper {
//插入操作
@Insert("insert into user values (#{id},#{username},#{password},#{birthday})")
public void save(User user);
//更新操作
@Update("update user set username = #{username},password = #{password} where id = #{id}")
public void update(User user);
//删除操作
@Delete("delete from user where id = #{id}")
public void delete(int id);
//根据id查询
@Select("select * from user where id = #{id}")
public User findById(int id);
//查询全部
@Select("select * from user")
public List<User> findAll();
}