1.15、测试insert与insertAllColumn

1.insert:
insert方法插入数据时,底层做非空判断,如果哪个成员变量的值为空就不会放到sql语句中。

• 数据库中的字段:

• 插入是的字段,没有插入email

• 日志中sql语句中也没有email

package com.wzy.text;
import com.wzy.mapper.EmployeeMapper;
import com.wzy.pojo.EmployeeBean;
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 {
    ApplicationContext applicationContext =
            new ClassPathXmlApplicationContext("applicationContext.xml");
    EmployeeMapper employeeMapper =
            applicationContext.getBean("employeeMapper",EmployeeMapper.class);
    EmployeeBean employeeBean = new EmployeeBean(null,"MP1","55522qqw@163.com",1,25);
    @Test
    public void test1() throws SQLException {
        Integer insert = employeeMapper.insert(employeeBean);
        System.out.println(insert);
    }
}

2.insertAllColumn
同样没有传入email