package com.qcby.dao;
import com.qcby.entity.User;
import java.util.List;
public interface UserDao {
/**
* 查询所有用户
*/
public List<User> findAll();
/**
* 通过id查询一条数据
* @param id
* @return
*/
public User findById(int id);
/**
* 增加数据
* @param user
* @return
*/
public int insert(User user);
/**
* 更新数据
* @param user
*/
public int update(User user);
/**
* 删除数据
* @param user
*/
public int delete(int id);
}
UserDao.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.qcby.dao.UserDao">
<!--通过id查询 SQL语句使用#{占位符的名称,名称可以任意},仅限于基本数据类型和String类型-->
<select id="findAll" resultType="com.qcby.entity.User">
select * from user
</select>
<!-- 根据ID查询一条数据-->
<select id="findById" parameterType="int" resultType="com.qcby.entity.User">
select * from user where id = #{id}
</select>
<insert id="insert" parameterType="com.qcby.entity.User">
/*查询ID
keyProperty:封装数据到属性
order:数据添加后的操作
resulType:数据类型
*/
<selectKey order="AFTER" resultType="int" keyProperty="id">
select last_insert_id();
</selectKey>
insert into user(username,birthday,sex,address) values(#{username},#{birthday},#{sex},#{address})
</insert>
<update id="update" parameterType="com.qcby.entity.User">
update user set username = #{username},birthday = #{birthday},sex = #{sex},address = #{address} where id = #{id}
</update>
<delete id="delete" parameterType="int">
delete from user where id = #{id}
</delete>
<select id="findByUserName" parameterType="String" resultType="com.qcby.entity.User">
select * from user where username like #{username}
</select>
<!--<select id="findByUserName" parameterType="String" resultType="com.qcby.entity.User">
select * from user where username like '%${value}%'
</select>-->
<select id="findCount" resultType="int">
select count(* )from user
</select>
</mapper>