Mybatis
1.po
类
|
public
class
User {
private
int
id
;
private
String
username
;
private
String
sex
;
private
Date
birthday
;
private
String
address
;
public
int
getId() {
return
id
;
}
public
void
setId(
int
id
) {
this
.
id
=
id
;
}
|
2.povo
类
|
//bean
Vo
类相对于数据库中的视图，封装视图对象
public
class
UserVo {
private
User
user
;
private
List<Integer>
idList
;
public
User getUser() {
return
user
;
}
public
void
setUser(User
user
){
this
.
user
=
user
;
}
public
List<Integer> getIdList() {
return
idList
;
}
public
void
setIdList(List<Integer>
idList
){
this
.
idList
=
idList
;
}
}
|
3.mapper
，
mapper
类和
mapperxml
文件放在统一的包下
|
public
interface
UserMapper {
//1
、根据用户
ID
查询用户信息
public
User findUserById(
int
id
)
throws
Exception;
//3
、添加用户
public
void
insertUser(User
user
)
throws
Exception;
//
综合查询
public
List<User> findUserList(UserVo
vo
);
//
综合查询用户总数
public
int
findUserCount(UserVo
vo
);
//resultMap
入门
public
User findUserRstMap(
int
id
);
}
|
|
<?
xml
version
=
“1.0”
encoding
=
“UTF-8”
?>
<!
DOCTYPE
mapper
PUBLIC
“-//mybatis.org//DTD Mapper 3.0//EN”
“http://mybatis.org/dtd/mybatis-3-mapper.dtd”
>
<
mapper
namespace
=
|
