2023年7月24日发(作者：)

mybatis-⾃动⽣成mapper接⼝实现类

PUBLIC "-////DTD Config 3.0//EN"

"/dtd/">

select * from Employee where salary=#{} and name like'%${}%' select * from Employee where id=#{id}

select * from Employee where name like '%${value}%' insert into Employee(email,hiredate,name,salary,pwd,grade,department_id) values(#{email},#{hiredate},#{name},#{salary},#{pwd},#{grade},#{department_id})

delete from Employee where id =#{id}

update Employee set department_id=#{department_id},email=#{email},grade=#{grade},hiredate=#{hiredate},name=#{name},pwd=#{pwd},salary=#{salary} ckage ;import ;import ee;import eeCustom;import eeQueryVo;public interface EmployeeMapper { //根据id查询⽤户信息 public Employee findUserById(int id) throws Exception;

//⽤户信息综合查询 public List findEmployeeList(EmployeeQueryVo employeeQueryVo)throws Exception;

// //根据id查询⽤户信息// public Employee findUserById(int id) throws Exception;// //添加⽤户信息// public void insertEmployee(Employee employee) throws Exception;// //删除⽤户信息// public void delectEmployee(int id)throws Exception; //根据⽤户名称查询⽤户列表 public List findUserByName(String name) throws Exception;}

package ;import ption;import tream;import ;import ces;import sion;import sionFactory;import sionFactoryBuilder;import ee;import eeCustom;import eeQueryVo;public class EmployeeMapperTest{

public static void main(String []args) throws Exception{ InputStream inputStream=ourceAsStream(""); InputStream inputStream=ourceAsStream(""); SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream); SqlSession sqlSession=ssion(); // new EmployeeMapperTest().testfindUserById(sqlSessionFactory); EmployeeMapper employeeMapper=per();

EmployeeQueryVo employeeQueryVo=new EmployeeQueryVo();

EmployeeCustom employeeCustom=new EmployeeCustom(); e("韩"); ary(100f); loyeeCustom(employeeCustom);

List list=ployeeList(employeeQueryVo); for(EmployeeCustom a:list){ n(e()); } (); }

public void testfindUserById(SqlSessionFactory sqlSessionFactory) throws Exception { // TODO Auto-generated method stub

SqlSession sqlSession=ssion();

//创建UserMapper对象 EmployeeMapper employeeMapper=per(); //One(arg0, arg1) //调⽤userMapper的⽅法 Employee employee=erById(1);

n(ng()); (); }}