curd

接口

public interface UserMapper {
    /**
     * 登录
     * @param user
     * @return
     */
    public User login(User user);

    /**
     * 查询
     * @return
     */
    public List<User> findAll();

    /**
     * 删除
     * @param id
     * @return
     */
    public int del(Integer id);

    /**
     * 添加
     * @param user
     * @return
     */
    public int add(User user);

    /**
     * 查询根据id回显
     * @param id
     * @return
     */
    public User selectById(Integer id);

    /**
     * 修改(先查询再修改)
     * @param user
     * @return
     */
    public int updateUser(User user);
    }

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.itcast.mapper.UserMapper">
    <resultMap id="BaseResultMap" type="com.itcast.entity.User">
        <!--主键id-->
        <id column="id" property="id" jdbcType="INTEGER"/>
        <result column="username" property="username" jdbcType="VARCHAR"/>
        <result column="password" property="password" jdbcType="VARCHAR"/>
        <result column="userrole" property="userrole" jdbcType="VARCHAR"/>
    </resultMap>

   <sql id="Base_Column_List">
        id,username,password,userrole
   </sql>

	<!--登录-->
    <select id="login" resultType="com.itcast.entity.User">
      select * from user where username=#{username} and password =#{password} and userrole=#{userrole}
    </select>

	<!--查询-->
    <select id="findAll"  resultType="com.itcast.entity.User">
    select * from user
    </select>

	<!--删除-->
    <delete id="del" parameterType="Integer">
        delete from user where id=#{id};
    </delete>

	<!--添加-->
    <insert id="add" >
         insert into user (id,username,password,userrole)values (
		   null,
		   #{username},
		   #{password},
		   #{userrole}
    )
    </insert>
 
	<!--根据id查询，返回结果集-->
    <select id="selectById" resultType="com.itcast.entity.User" parameterType="Integer">
        select * from user where id=#{id}
    </select>

    <!--id为主键省略不写-->
    <!--修改(先查询再改)-->
    <update id="updateUser" parameterType="com.itcast.entity.User">
        update user set username=#{username},password=#{password},userrole=#{userrole} where username=#{username}
    </update>
</mapper>