原 JAVA懒开发：对象虚拟化，全程无实体

<select id="getUserRolePage" parameterType="com.lazy.develop.model.UserRolQuery" 
	resultType="com.lazy.develop.model.UserRolePage">
	SELECT
		u.id,
		u.login_name AS loginName,
		u.`password`,
		u.create_time AS createTime,
		r.role_name AS roleName
	FROM
		`user` u
	JOIN role r ON u.`level` = r.id
	<where>
		<if test="startTime != null">
			u.create_time &gt;= #{startTime,jdbcType=TIMESTAMP}
		</if>
		<if test="endTime != null">
			AND u.create_time &lt;= #{endTime,jdbcType=TIMESTAMP}
		</if>
		<if test="level != null">
			AND u.level &gt; #{level,jdbcType=BIGINT}
		</if>
	</where>
</select>

<select id="getUserRolePage" parameterType="com.lazy.develop.model.Record" 
	resultType="com.lazy.develop.model.Record">
	SELECT
		u.id,
		u.login_name AS loginName,
		u.`password`,
		u.create_time AS createTime,
		r.role_name AS roleName
	FROM
		`user` u
	JOIN role r ON u.`level` = r.id
	<where>
		<if test="startTime !='' and startTime != null">
			u.create_time &gt;= #{startTime,jdbcType=TIMESTAMP}
		</if>
		<if test="endTime !='' and endTime != null">
			AND u.create_time &lt;= #{endTime,jdbcType=TIMESTAMP}
		</if>
		<if test="level !='' and level != null">
			AND u.level &gt; #{level,jdbcType=BIGINT}
		</if>
	</where>
</select>

@RequestMapping(value="/getById", method = RequestMethod.GET)
public Object getUserRolePage(@ModelAttribute UserRolQuery userRolQuery){
	List<UserRolePage> user = userServiceImpl.getUserRolePage(userRolQuery);
	return user;
}

@RequestMapping(value="/getUserRolePage", method = RequestMethod.GET)
public Object getUserRolePage(HttpServletRequest request){
	Record Record=new Record(request);
	List<Record> user = userServiceImpl.getUserRolePage(Record);
	return user;
}

@RequestMapping(value="/getUserRolePage", method = RequestMethod.GET)
public Object getUserRolePage(HttpServletRequest request){
	Record record=new Record(request);
	//record.put("name", "name"); //和普通的map使用一样
	//String name=record.getString("name");
	//Integer id=record.getInteger("id");
	//Long id2=record.getLong("id");
	//Object obj=record.get("user"); //目前就写了这几个，大家可以根据自己的需求改哈
	
	List<Record> user = userServiceImpl.getUserRolePage(record);
	return user;
}