Mybatis增删改查以及Dao的写法

增加：

单条增加xml

DAO

public int insert(WycjwdjlTemp wycjwdjlTemp) {
        return sessionTemplate.insert("addWycjwdjlTemp", wycjwdjlTemp);
    }

XML

<insert id="addWycjwdjlTemp" parameterType="WycjwdjlTemp"  useGeneratedKeys="true" keyProperty="id">
        INSERT INTO wycjwdjl_temp (recordid, lng, lat, gpstime, speed, isabled,direction,remark)
        VALUES (#{recordid},#{lng},#{lat},#{gpstime},#{speed},#{isabled},#{direction},#{remark})
    </insert>

</pre>*************************************************************************************************************************************<pre>

批量增加xml：

DAO：

 public int insert(List<WycjwdjlTemp> wycjwdjlTemps) {
        return sessionTemplate.insert("addWycjwdjlTempBatch", wycjwdjlTemps);
    }

XML

<!--批量增加车辆经纬度记录-->
    <insert id="addWycjwdjlTempBatch" >
        INSERT INTO wycjwdjl_temp (recordid, lng, lat, gpstime, speed, isabled,direction,remark) values
        <foreach item="item" collection="list" separator=",">
            (#{item.recordid},#{item.lng},#{item.lat},#{item.gpstime},#{item.speed},#{item.isabled},#{item.direction},#{item.remark})
        </foreach>
    </insert>

*************************************************************************************************************************************

查询：

</pre><pre name="code" class="html">DAO：

</span>public UserDacheReceipt findUserDacheReceiptByrecordId(long recordId) {
		UserDacheReceipt userDacheReceipt=sessionTemplate.selectOne("findUserDacheReceiptByrecordId",recordId);
		return userDacheReceipt;
	}

DAO list；

public List<UserDacheReceipt> findUserDacheReceiptByrecordId(long recordId) {
		List<UserDacheReceipt> userDacheReceipts=sessionTemplate.selectList("findUserDacheReceiptByrecordId",recordId);
		return userDacheReceipts;
	}

</pre><pre name="code" class="html">XML

 <!-- 根据id查询接单记录 -->
     <select id="findUserDacheReceiptByrecordId" resultType="UserDacheReceipt">
     	SELECT * FROM user_dache_receipt WHERE recordId = #{recordId}
     </select>

*************************************************************************************************************************************

更新：

DAO

public int update(UserDache userDache) {
        return sessionTemplate.update("editDacheUser", userDache);
    }

xml

<!--修改个人信息-->
     <update id="editDacheUser" parameterType="UserDache">
     	UPDATE `user_dache_info` SET  `username`=#{username}, `tel`=#{tel}, `sex`=#{sex} WHERE openid=#{openid};
     </update>

*****************************************************************************************************************************************************

删除

DAO

 public void del(int id) {
        sessionTemplate.delete("delDacheUser", id);
    }

xml

     <delete id="delDacheUser" parameterType="int">
     	DELETE FROM user_dache_info where id=#{id}
     </delete>

*****************************************************************************************************************************************************

批量查询、模糊查询和时间段查询

DAO

<!--通过开始时间、结束时间、用户名或者电话查询用户详情-->

public List<UserDache> findUsers(String starttime,String endtime,String username,String tel) {
        Map<String,String> map=new HashMap<String, String>();
        map.put("startTime",starttime);
        map.put("endTime",endtime);
        map.put("username",username);
        map.put("tel",tel);
        List<UserDache> list = sessionTemplate.selectList("findUsers",map);
        return list;
    }

xml

<pre name="code" class="html"><!--通过开始时间、结束时间、用户名或者电话查询用户详情-->
    <select id="findUsers" parameterType="map"   resultType="UserDache">
        select * from user_dache_info
        <where>

<span style="white-space:pre">	</span>    1 = 1//一定能执行，为了关联后面的ADN，不然会报错
            <if test="starttime!=null and starttime!=''"> AND createTime >= #{startTime} </if>
            <if test="endtime!=null and endtime!=''"> AND createTime <= #{endTime} </if>
            <if test="username!=null and username!=''"> AND username LIKE CONCAT ('%',#{username},'%' ) </if>
            <if test="tel!=null and tel!=''"> AND tel LIKE CONCAT('%',#{tel},'%' ) </if>
        </where>
    </select>