下面一个一个来分析
?
（1）插入测试
函数 ：
?
/**
* 增加
*/
public static void addEmployeer(Employeer employeer){
SqlSession session = null;
try {
session = sqlSessionFactory.openSession();
//返回值是记录条数
int resultCount = session.insert("com.mucfc.model.EmployeerMapper.addEmployeer", employeer );
System.out.printf("当前插入的employeer_id :%d 当前插入数据库中条数:%d " , employeer.getEmployeer_id() ,resultCount); //获取插入对象的id
System.out.println("");
session.commit() ;
} finally {
session.close();
}
}
调用
?
?
//插入
addEmployeer(employeer1);
addEmployeer(employeer2);
addEmployeer(employeer3);
addEmployeer(employeer4);
?
数据库中结果：
（2）查找测试，接上面插入测试：
函数：
?
/**
* 查找
*/
public static void findEmployeerById(int id) {
SqlSession session = null;
try {
session = sqlSessionFactory.openSession();
Employeer employeer = (Employeer) session.selectOne(
"com.mucfc.model.EmployeerMapper.findEmployeerByID", 1);
if (employeer == null)
System.out.println("null");
else
System.out.println(employeer);
} finally {
session.close();
}
}
调用：
?
?
//查找 findEmployeerById(1);结果
?
（3）删除测试，接上面
其中函数：
?
/**
* 删除
*
*/
public static void deleteEmployeer(int id){
SqlSession session = null;
try {
session = sqlSessionFactory.openSession();
//返回值是记录条数
int resultCount=session.delete("com.mucfc.model.EmployeerMapper.deleteEmployeer",id);
System.out