玩转SSM框架之增删改查

package com; import com.pojo.Employee; import com.utils.MybatisUtils; import org.apache.ibatis.session.SqlSession; import java.util.List; public class Test { public void testMethods(){ //1根据id查询员工信息 SqlSession sqlSession = MybatisUtils.getSession(); // Employee employee =sqlSession.selectOne("com.mapper.EmployeeMapper.findById",1); // System.out.println(employee.toString()); //2新增员工 // Employee employee = new Employee(6,"赵六1",46,"员工"); // int i = sqlSession.insert("com.mapper.EmployeeMapper.addEmployee",employee); // if(i>0){ // System.out.println("添加成功"); // }else{ // System.out.println("添加失败"); // } //3删除员工，id=6 // int i = sqlSession.delete("com.mapper.EmployeeMapper.deleteById",6); // if(i>0){ // System.out.println("删除成功"); // }else{ // System.out.println("删除失败"); // } //4更新员工，id=5,年龄和职位 // Employee employee = new Employee(5,"",60,"员工"); // int i = sqlSession.update("com.mapper.EmployeeMapper.updateById",employee); // if(i>0){ // System.out.println("更新成功"); // }else{ // System.out.println("更新失败"); // } //5 查询所有 List<Employee> list = sqlSession.selectList("com.mapper.EmployeeMapper.findAll"); for(Employee e:list){ System.out.println(e.toString()); } sqlSession.commit(); //注意此句，增删改 sqlSession.close(); } public static void main(String args[]){ new Test().testMethods(); } }