1.20、updateById 修改列

修改全列

package com.wzy.text;
import com.wzy.mapper.EmployeeMapper;
import com.wzy.pojo.Employee;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import java.sql.SQLException;
public class TestS {
    ApplicationContext applicationContext =
            new ClassPathXmlApplicationContext("applicationContext.xml");
    EmployeeMapper employeeMapper =
            applicationContext.getBean("employeeMapper",EmployeeMapper.class);
    @Test
    public void test4() throws SQLException {
        //修改全列
        Employee employeeBean = new Employee();
        employeeBean.setId(5);
        employeeBean.setLastName("我");
        employeeBean.setEmail("555@qq.com");
        employeeBean.setGender(1);
        employeeBean.setAge(25);
        Integer result = employeeMapper.updateById(employeeBean);
        System.out.println(result);
        //获取被修改数据的，id
        Integer id = employeeBean.getId();
        System.out.println(id);
    }
}

修改某些列：

package com.wzy;
import com.wzy.mapper.EmployeesMapper;
import com.wzy.pojo.Employees;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.SQLException;
public class TestS {
    //1.读取配置文件
    private ApplicationContext applicationContext =
            new ClassPathXmlApplicationContext("applicationContext.xml");
    //2、反射得到接口对象
    private EmployeesMapper employeesMapper =
            applicationContext.getBean("employeesMapper", EmployeesMapper.class);
    private Employees employees = new Employees();
    @Test
    public void  test2() throws SQLException {
        //3、设置部分列
        employees.setId(6);
        employees.setLastName("成龙");
        employees.setEmail("chenglong@163.com");
        employees.setGender(1);
        //employees.setAge(null);
        Integer result = employeesMapper.updateById(employees);
        System.out.println(result);//1
        //4、获取修改列的id
        Integer id = employees.getId();
        System.out.println(id);//5
    }
}