<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.wskj.ssm.dao.CategoryMapper" >
<resultMap id="BaseResultMap" type="com.wskj.ssm.pojo.Category" >
<!--
WARNING - @mbggenerated
This element is automatically generated by MyBatis Generator, do not modify.
This element was generated on Mon Mar 06 19:37:25 CST 2017.
-->
<id column="cateId" property="cateid" jdbcType="INTEGER" />
<result column="cateName" property="catename" jdbcType="VARCHAR" />
<result column="cateDesc" property="catedesc" jdbcType="VARCHAR" />
</resultMap>
<insert id="insertCategory">
insert into Category(catename,catedesc) values(#{catename},#{catedesc})
</insert>
<!-- <select id="getAllCategory" resultType="Category" parameterType="Category">
select *,(@rownum:=@rownum+1) i from (SELECT @rownum:=0) r, category
<where>
<if test="catename!=null">
and catename like concat ('%',#{catename},'%')
</if>
</where>
</select> -->
<delete id="deleteCategoryById" parameterType="java.lang.Integer">
delete from Category where cateId=#{cateId}
</delete>
<select id="getCategoryById" parameterType="java.lang.Integer" resultType="Category">
select * from category where cateid=#{cateId}
</select>
<update id="updateCategoryById" parameterType="java.util.Map">
update Category set catename=#{category.catename},catedesc=#{category.catedesc} where cateid=#{cateId}
</update>
<select id="getCategoryCount" parameterType="java.lang.String" resultType="long">
select count(*) from Category
<where>
<if test="_parameter!=null">
and catename like concat ('%',#{_parameter},'%')
</if>
</where>
</select>
<select id="getCategoryWithPaging" parameterType="java.util.Map" resultType="Category">
select *,(@rownum:=@rownum+1) i from (SELECT @rownum:=0) r, category
<where>
<if test="catename!=null">
and catename like concat ('%',#{catename},'%')
</if>
</where>
limit #{skip},#{take}
</select>
</mapper>
上面两个红色的地方就是需要注意的地方
对于String而说发现不能将参数设为bean里的名称,如果传入类型为String类型,则参数需统一修改为[_parameter],修改后的sql语句如下(不管你的参数是什么,都要改成"_parameter")
对于controller而说分页的地方
public String cateList(Model model,String catename,@RequestParam(defaultValue="1", required=false) Integer pageIndex, @RequestParam(defaultValue=ResourceKeys.DEFAULT_PAGE_SIZE) Integer pageSize){
//List<Category> list =categoryService.getAllCategory(catename);
PageUtil<Category> pageModel =categoryService.getCategoryWithPaging(catename,pageIndex,pageSize);
model.addAttribute("cateList",pageModel);
return "houtai/back/goodscategory/list";
}
这样就可以实现了!