<
mapper
namespace
=
"com.jxj.dao.UserDao"
>
<
resultMap
id
=
"userResultMap"
type
=
"User"
>
<!--
主键字段
property: 实体类属性名.
column: 库中表的列名
javaType: 数据类型.
-->
<
id
property
=
"userId"
column
=
"id"
javaType
=
"int"
></
id
>
<!-- 非主键字段 -->
<
result
property
=
"userSex"
column
=
"sex"
javaType
=
"string"
></
result
>
<
result
property
=
"userAddress"
column
=
"address"
javaType
=
"string"
></
result
>
<
result
property
=
"userBirthday"
column
=
"birthday"
javaType
=
"date"
></
result
>
<
result
property
=
"username"
column
=
"username"
javaType
=
"string"
></
result
>
</
resultMap
>
<
select
id
=
"queryAll"
resultMap
=
"userResultMap"
>
select * from user
</
select
>