下面是IBatis将用户插入数据库的例子:
MySQL定义
CREATE TABLEuser
(id
bigint(20) NOT NULL AUTO_INCREMENT,name
char(80) NOT NULL,age
int(11) DEFAULT NULL,
PRIMARY KEY (id
),
UNIQUE KEYid
(id
)
)User定义
public class User {
private Long id;
private String name;
private int age;
...
}定义UserMapper
[code="java"]
insert into author(name,age) values(#{name},#{age})
[/code]增加一个用户的程序片段
[code] ApplicationContext aContext = new FileSystemXmlApplicationContext("WebRoot/WEB-INF/applicationContext.xml");
UserMapper userMapper = aContext.getBean(UserMapper.class);
User user = new User();
user.setName("张三");
user.setAge(18);
userMapper.insert(user);[/code]
问题:如何才能得到加入记录"张三"的ID值? 能在插入时直接回填ID吗?