02_MyBatis_crud操作

user-mapper.xml

<mapper namespace="com.zhushen.entity.UserMapper">
  <select id="selectUser" resultType="com.zhushen.entity.User">
    select * from user where userId = #{id}
  </select>

  <select id="selectAll" resultType="com.zhushen.entity.User">
    select * from user
  </select>

  <insert id="addUser" parameterType="com.zhushen.entity.User">
    insert into user(userId,userName,passWord) values(#{userId},#{userName},#{passWord})
  </insert>

  <update id="updateUser" parameterType="com.zhushen.entity.User">
    update user set userName=#{username},passWord=#{passWord} where userID=#{userID}
  </update>

  <delete id="deleteUser">
    delete from user where userId = #{id}
  </delete>
</mapper>

UserDAO

public class UserDAO {
    public static List<User> getAll() throws IOException{
        SqlSession session=MyBatisUtil.getSession();
        List<User> userlist=session.selectList("com.zhushen.entity.UserMapper.selectAll");
        return userlist;
    }
    public static User getByID(int id) throws IOException{
        SqlSession session=MyBatisUtil.getSession();
        User user=session.selectOne("com.zhushen.entity.UserMapper.selectUser", id);
        session.close();
        return user;
    }
    public static int add(User user) throws IOException{
        SqlSession session=MyBatisUtil.getSession();
        int result=session.insert("com.zhushen.entity.UserMapper.addUser", user);
        session.commit();
        session.close();
        return result;
    }

    public static int update(User user) throws IOException{
        SqlSession session=MyBatisUtil.getSession();
        int result=session.insert("com.zhushen.entity.UserMapper.updateUser", user);
        session.commit();
        session.close();
        return result;
    }

    public static int delete(int id) throws IOException{
        SqlSession session=MyBatisUtil.getSession();
        int result=session.delete("com.zhushen.entity.UserMapper.deleteUser", id);
        session.commit();
        session.close();
        return result;
    }
}