MyBatis的增删改查
第一章:代理Dao方式的CRUD操作
- 代理Dao方式的增删改查
- 创建项目
- UserDao接口代码
1.dao层
import com.qcby.entity.User;
import java.util.List;
public interface UserDao {
/**
* 全部查询
* @return
*/
public List<User> findAll();
/**
* 根据id进行查询
* @param id
*/
public User findById(int id);
/**
* 插入数据
* @param user
* @return
*/
public int insert(User user);
/**
* 删除
* @param id
* @return
*/
public int delete(int id);
/**
* 修改
* @param user
* @return
*/
public int update(User user);
/**
* 获取插入的id
* @param user
* @return
*/
public int insertGetId(User user);
/**
* 通过姓名模糊查询
* @return
*/
public List<User> likeByName(String username);
}
2.mapper层
<?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.qcby.Dao.UserDao">
<select id="findAll" resultType="com.qcby.entity.User">
select * from user
</select>
<select id="findById" resultType="com.qcby.entity.User" parameterType="java.lang.Integer">
select * from user where id = #{id}
</select>
<insert id="insert" parameterType="com.qcby.entity.User">
insert into user(username,birthday,sex,address)
values(#{username},#{birthday},#{sex},#{address})
</insert>
<delete id="delete" parameterType="java.lang.Integer">
delete from user where id = #{id}
</delete>
<update id="update" parameterType="com.qcby.entity.User">
update user set username = #{username},birthday = #{birthday},
sex = #{sex},address = #{address} where id = #{id}
</update>
<!--返回主键 :我们的主键需要设置自动递增 -->
<insert id="insertGetId" parameterType="com.qcby.entity.User">
<selectKey keyProperty="id" resultType="int" order="AFTER">
SELECT LAST_INSERT_ID()
</selectKey>
insert into user(username,birthday,sex,address)
values(