mapper mysql 分页_Mybatis+mysql动态分页查询数据案例——配置映射文件(HouseDaoMapper.xml)...

select * form district where id=#{district_id}

select * from users where id=#{user_id}

select * from street where id=#{street_id}

select * from types where id=#{type_id}

ID, USER_ID, TYPE_ID, TITLE, DESCRIPTION, PRICE, PUBDATE, FLOORAGE, CONTACT, STREET_ID

select

from house

where ID = #{id,jdbcType=INTEGER}

delete from house

where ID = #{id,jdbcType=INTEGER}

insert into house

(

USER_ID, TYPE_ID, TITLE,

DESCRIPTION, PRICE, PUBDATE,

FLOORAGE, CONTACT, STREET_ID

)

values

(

#{users.id,jdbcType=INTEGER},

#{types.id,jdbcType=INTEGER}, #{title,jdbcType=VARCHAR},

#{description,jdbcType=VARCHAR}, #{price,jdbcType=REAL},

#{pubdate,jdbcType=DATE}, #{floorage,jdbcType=INTEGER},

#{contact,jdbcType=VARCHAR}, #{street.id,jdbcType=INTEGER}

)

update house set

USER_ID = #{users.id,jdbcType=INTEGER},

TYPE_ID = #{types.id,jdbcType=INTEGER},

TITLE = #{title,jdbcType=VARCHAR},

DESCRIPTION = #{description,jdbcType=VARCHAR},

PRICE= #{price,jdbcType=REAL},

PUBDATE = #{pubdate,jdbcType=DATE},

FLOORAGE = #{floorage,jdbcType=INTEGER},

CONTACT= #{contact,jdbcType=VARCHAR},

STREET_ID = #{street.id,jdbcType=INTEGER}

where ID = #{id,jdbcType=INTEGER}

select count(0) from house h

and h.price > #{priceBegin}

and h.price #{priceEnd}

and h.street_id = #{street.id}

and h.type_id = #{types.id}

and h.floorage > #{floorageBegin}

and h.floorage #{floorageEnd}

select * from house h

and h.price > #{priceBegin}

and h.price #{priceEnd}

and h.street_id = #{street.id}

and h.type_id = #{types.id}

and h.floorage > #{floorageBegin}

and h.floorage #{floorageEnd}

limit #{stratRow},#{endRow}

select * from house

select * from house limit #{startRow},#{endRow}

分享到：

2017-03-18 22:52

浏览 138

评论