public class OsEntity {
private String Filesystem;
private String Used;
private String Mounted;
...get() and set()
}
filesystem | used | mounted |
---|---|---|
test.txt | 50 | /file |
test2.txt | 60 | /file1 |
test3.txt | 50 | /file2 |
test4.txt | 80 | /file3 |
<select id="getUserById" parameterType="int" resultType="cn.truedei.entity.OsEntity">
select filesystem Filesystem,used Used where mounted = #{Mounted}
</select>
<resultMap id="osEntityMap" type="cn.truedei.entity.OsEntity">
<!--用<id></id>标签映射主键字段 property(被映射的):实体类中的,column(映射的):数据表中的-->
<id property="Mounted" column="mounted"/>
<!--用<result>映射非主键字段,-->
<result property="Filesystem" column="filesystem"/>
<result property="Used" column="used"/>
</resultMap>