新手Mybatis：实现数据库中增删改查操作

接口中写增删改的方法

public interface EmployeeMapper {
	public void addEmp(Employee employee); 
	//传入employee对象
	public void updateEmp(Employee employee);
	public void deleteEmp(Employee employee);
}

在映射文件中，为增删改方法写语句

<!--	为添加方法写-->
	<insert id="addEmp" parameterType="com/atguigu/mybatis/dao/EmployeeMapper.java">
		insert into tbl_employee(last_name,email,gender)
		values (#{lastname},#{email},#{gender})
	</insert>

<!--	更新-->
	<update id="updateEmp" parameterType="com/atguigu/mybatis/dao/EmployeeMapper.java">
		update tbl_employee
		set last_name=#{lastname},email=#{email},gender=#{gender}
		where id=#{id}
	</update>

<!--	删除-->
	<update id="updateEmp" parameterType="com/atguigu/mybatis/dao/EmployeeMapper.java">
		delete from tbl_employee where idd=#{id}
-- 		#{id}我们带来的id
	</update>

在测试类中进行测试

public SqlSessionFactory getSqlSessionFactory() throws IOException {
		String resource = "mybatis-config.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		return new SqlSessionFactoryBuilder().build(inputStream);
	}
	
@Test
	public void test3() throws IOException {
		SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
		SqlSession sqlSession = sqlSessionFactory.openSession();
		try{
			EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);

			//1.测试添加
			Employee employee = new Employee(null,"jerry","2321231","1");
			mapper.addEmp(employee);

//			2.测试修改
			mapper.updateEmp(employee);

			//3.测试删除
			mapper.deleteEmp(employee);
			
			//必须手动提交数据
			sqlSession.commit();
		}finally {
			sqlSession.close();
		}
	}