javaEE案例一 员工管理系统

package com.itheima.test; import com.itheima.pojo.Employee; import com.itheima.utils.MyBatisUtils; import org.apache.ibatis.session.SqlSession; import org.junit.Test; public class MyBatisTest { //查询 @Test public void findByIdTest(){ //获取sqlSession SqlSession session = MyBatisUtils.getSession(); //执行sql Employee employee = session.selectOne("com.itheima.mapper.EmployeeMapper.findEmployeeById",1); System.out.println(employee); //释放资源 session.commit(); session.close(); } //新增 @Test public void saveTest(){ Employee employee = new Employee(); employee.setId(1); employee.setAge(55); employee.setName("赵大牛"); employee.setPosition("经理"); //获取sqlSession SqlSession session = MyBatisUtils.getSession(); //执行sql session.update("com.itheima.mapper.EmployeeMapper.save",employee); //释放资源 session.commit(); session.close(); } //修改 @Test public void updateEmployeeByIdTest(){ Employee employee = new Employee(); employee.setId(2); employee.setAge(30); employee.setName("李一"); employee.setPosition("保安"); //获取sqlSession SqlSession session = MyBatisUtils.getSession(); //执行sql session.update("com.itheima.mapper.EmployeeMapper.updateEmployeeById",employee); //释放资源 session.commit(); session.close(); } //删除 @Test public void deleteEmployeeByIdTest(){ //获取sqlSession SqlSession session = MyBatisUtils.getSession(); //执行sql session.update("com.itheima.mapper.EmployeeMapper.deleteEmployeeById",4); //释放资源 session.commit(); session.close(); } }