maven web 数据库 增删改查

双表查询sql语句  xml文件中书写

条件查询

<select id="selectByCond" resultType="com.ufox.pojo.Emp">
    select d.dept_id,d.dept_name,e.emp_id,e.emp_pass,e.emp_name,e.emp_num,e.emp_date
    from Emp e,dept d
    where d.dept_id=e.dept_id

    <if test="param1!=null and param1!='' ">
        and emp_name like concat ('%',#{param1},'%')
    </if>

    <if test="param2!=null and param2!='' ">
        and dept_name like concat ('%',#{param2},'%')
    </if>
    order by emp_id desc
</select>

批量删除

<delete id="delBatch">
    delete from Emp
    <where>
        <foreach collection="list" open="emp_id in(" close=")" item="emp_id" separator=",">
            #{emp_id}
        </foreach>
    </where>
</delete>