在使用mybatis insert时,使用id自增有时需要返回最新插入的id;
SELECT LAST_INSERT_ID() AS ID insert into t_employee (ID, EmployeeName, Position, Salary, Tel, DepartmentID ) values (#{id,jdbcType=INTEGER}, #{employeename,jdbcType=VARCHAR}, #{position,jdbcType=VARCHAR}, #{salary,jdbcType=DOUBLE}, #{tel,jdbcType=VARCHAR}, #{departmentid,jdbcType=INTEGER} )测试:
package com.lls.test;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import com.lls.mapper.EmployeeMapper;
import com.lls.model.Employee;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = { “classpath:config/spring-mybatis.xml” })
public class MyBatisInsert {undefined
private static final Logger LOGGER = LoggerFactory.getLogger(MyBatisInsert.class);
@Autowired
private EmployeeMapper employeeMapper;
@Test
public void testAutoCreate() {undefined
/*
- id 自增;添加时可以设置id,也可以不设置id
- selectkey 返回最近插入的id;
*/
Employee employee = new Employee();
employee.setDepartmentid(1);
employee.setEmployeename(“xiaoA”);
employee.setPosition(“manager”);
employee.setSalary(13000d);
int result = employeeMapper.insert(employee);
int id = employee.getId();
LOGGER.info("last insert id : " + id);
}
}
————————————————
版权声明:本文为CSDN博主「积极流年」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/lanlianhua_luffy/article/details/73196508