插入：
<insert id=”insertUserLocation” parameterClass=”UserLocation”>
INSERT INTO
user_location
(user_id,
location_id,
start_time,
end_time,
islocal)
VALUES
(#userId#,
#locationId#,
#startTime:TimeStamp#,
#endTime:TimeStamp#,
#islocal#
)
</insert>
查询：
<select id=”selectByUserLocation” parameterClass=”UserLocation” resultClass=”UserLocation”>
SELECT
user_id as userId,
location_id as locationId,
start_time as startTime,
end_time as endTime,
islocal
FROM user_location
WHERE
user_id = #userId# and
start_time = #startTime:TimeStamp# and
end_time = #endTime:TimeStamp# and
location_id = #locationId#
</select>