mysql mapper中增刪查改

標籤：value   inf   資料   insert   tty   開始   style   update   add   

 

//1.增
public int insert(Port port) ;

//2.刪

public int deleteM(String id);
//3.改
public int update(Port port);

//1.增

<insert id="insert" parameterType="com.cn.eport.pojo.Port" resultType="integer">

INSERT INTO bas_port (
id,
country_id,
region_id,
NAME,
is_lock,
add_by,
add_time,
update_by,
update_time
)
VALUES
　　 (
#{id},#{country_id},#{region_id},#{name},#{is_lock},#{add_by},#{add_time},#{update_by},#{update_time})

</insert>

//2.刪

<delete id="deleteM" resultType="integer" >
DELETE
FROM
pro_mainfest
WHERE
id = #{id}
</delete>

 

 

//3.改
<update id="update" parameterType="com.cn.eport.pojo.Port" resultType="integer">

UPDATE bas_port
SET id = #{id},country_id=#{country_id},
region_id = #{region_id},name=#{name},is_lock=#{is_lock},
add_by = #{add_by},add_time=#{add_time},update_by=#{update_by},update_by=#{update_by}
WHERE
id = #{id}

</update>

 

//4.mysql資料庫分頁查詢

limit x,y      x開始行數   y總行數      集合意義(x, x+y)

mysql mapper中增刪查改