out/production/StuSystem/com/stusystem/mappings/TeacherDao.xml

微信扫码关注公众号，代码整理好后第一时间通知你。

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> 
<!-- namesapce ,DAO的package路径  -->
<mapper namespace="com.stusystem.dao.TeacherDao"> 
	<!-- 查询出所有的教师信息 -->
	<select id="getTeacher" parameterType="com.stusystem.entity.TeacherBean" resultType="com.stusystem.entity.TeacherBean">
		<if test=" teacherName != null and teacherName != '' "> SELECT * FROM teacher where teacher_name = #{teacherName} limit #{page} , 6 </if>
		<if test=" teacherName == null or teacherName == '' "> SELECT * FROM teacher limit #{page} , 6 </if>
	</select>
	<!-- 查询出所有教师信息可以分为多少页,在前端做分页处理  -->
	<select id="getteapage" parameterType="com.stusystem.entity.TeacherBean" resultType="int">
		<if test=" teacherName != null and teacherName != '' "> select count(*) from `teacher` where teacher_name = #{teacherName} </if>
		<if test=" teacherName == null or teacherName == '' "> select count(*) from `teacher` </if>
	</select>
	<!-- 根据id查询出一条教师信息  -->
	<select id="getTeacherone" parameterType="com.stusystem.entity.TeacherBean" resultType="com.stusystem.entity.TeacherBean" >
		SELECT * FROM teacher WHERE teacher_id=#{teacherId}
	</select>
	
	<select id="getTeacherByName" parameterType="com.stusystem.entity.TeacherBean" resultType="com.stusystem.entity.TeacherBean" >
		SELECT * FROM teacher WHERE teacher_name=#{teacherName}
	</select>
	<!-- 删除一条教师记录  -->
	<delete id="teacherdel" parameterType="com.stusystem.entity.TeacherBean" >
		DELETE FROM `teacher` WHERE (`teacher_id`=#{teacherId})
	</delete>
	<!--修改一条教师记录  -->
	<update id="teacherxiugai" parameterType="com.stusystem.entity.TeacherBean">
		UPDATE teacher SET teacher_name=#{teacherName}, teacher_sex=#{teacherSex}, teacher_system=#{teacherSystem}, teacher_phone=#{teacherPhone}, teacher_email=#{teacherEmail} WHERE (teacher_id=#{teacherId})
	</update>
	<!-- 添加一条教师记录  -->
	<insert id="teacheradd" parameterType="com.stusystem.entity.TeacherBean">
		INSERT INTO `teacher` (`teacher_name`, `teacher_sex`, `teacher_system`, `teacher_phone`, `teacher_email`) VALUES (#{teacherName},#{teacherSex},#{teacherSystem},#{teacherPhone},#{teacherEmail})
	</insert>
</mapper>