myBatis中传参类型

1、员工实体类，省略set，get方法

private Integer empno; private String ename; private String job; private Integer mgr; private Date hiredate; private Double sal ; private Double comm; private Integer deptno;

部门实体类 private Dept dept;

2、dao接口中的方法；

//查询所有 public List<Emp> findAll(); //根据姓名查找 public Emp  findByName(String ename); //根据工号查找 public Emp  findByNo(Integer empno); //插入 public void insert(Emp emp); //修改 public void update(Emp emp); //删除 public void delete(Integer empno); //查询总数 public Integer findRows(@Param("ename")String name,@Param("deptno")Integer deptno); //查询单页显示的所有 public List<Emp> findAllByPage(@Param("ename")String name,@Param("deptno")Integer deptno,@Param("begin")Integer page,@Param("end")Integer end);

3、根据姓名查找，传入String类型参数

<select id="findByName" parameterType="string" resultType="Emp">  select * from t_emp where ename=#{ename} </select>

4、//根据工号查找 public Emp  findByNo(Integer empno);

<select id="findByNo" parameterType="int" resultType="Emp">  select * from t_emp where empno=#{empno} </select>

5、 //插入 public void insert(Emp emp);

<insert id="insert" parameterType="Emp">  insert into t_emp(empno,ename,job,hiredate,mgr,sal,comm,deptno) values(emono_id.nextval,#{ename,jdbcType=VARCHAR} ,#{job,jdbcType=VARCHAR},#{hiredate},#{mgr},#{sal},#{comm,jdbcType=DOUBLE},#{deptno}) </insert>

6、<select id="findRows" parameterType="string" resultType="java.lang.Integer">  select count(*) from t_emp where 1=1  <if test="ename!=null&amp;&amp;ename.trim()!=''">   and ename=#{ename}  </if>  <if test="deptno!=null">   and deptno=#{deptno}  </if> </select>