?
（1）单参数查找
?
/**
* 查找
*/
public static Employeer findEmployeerById(int id) {
SqlSession session = null;
Employeer employeer=null;
try {
session = sqlSessionFactory.openSession();
EmployeerMapper employeerMapper=session.getMapper(EmployeerMapper.class);
employeer=employeerMapper.findEmployeerByID(id);
} finally {
session.close();
}
return employeer;
} 对应SQL语句：
?
?
@Select("select* from `t_employeer` where employeer_id =#{id}")
@ResultMap("employeerResultMap")
public Employeer findEmployeerByID(int id);
?
调用：
?
System.out.println(findEmployeerById(10)); System.out.println(findEmployeerById(11));
?
结果：
（2） 添加
?
/**
* 增加
*/
public static void addEmployeer(Employeer employeer){
SqlSession session = null;
try {
session = sqlSessionFactory.openSession();
EmployeerMapper employeerMapper=session.getMapper(EmployeerMapper.class);
employeerMapper.addEmployeer(employeer);
session.commit() ;
} finally {
session.close();
}
} 对应SQL语句：
?
?
@Insert(" insert into `t_employeer`(employeer_name,employeer_age,employeer_department,employeer_worktype) values(#{employeer_name},#{employeer_age},#{employeer_department},#{employeer_worktype})")
public void addEmployeer(Employeer employeer);
?
（3）更改
?
/**
* 更改
*/
public static void updateEmployeer(Employeer employeer){
SqlSession session = null;
try {
session = sqlSessionFactory.openSession();
EmployeerMapper employeerMapper=session.getMapper(EmployeerMapper.class);
employeerMapper.updateEmployeer(employeer);
session.commit() ;
} finally {
session.close();
}
}
对应SQL语句：
?
?
@Update(" update t_employeer set employeer_name = #{employeer_name},employeer_age= #{employeer_age},employeer_department = #{employeer_department} ,employeer_worktype=#{employeer_worktype} where employeer_id = #{employeer_id} ")
public void updateEmployeer(Employeer employeer);
?
（4）删除
?
/**
* 删除
*
*/
public static void deleteEmployeer(int id){
SqlSession session = null;
try {
session = sqlSessionFactory.openSession();
EmployeerMapper employeerMapper=session.getMapper(EmployeerMapper.class);