求助,菜鸟一枚,在使用mybatis执行insert操作返回主键ID的时候,可以正常插入,但是无法返回主键IDmapper
<insert id="insertUrl" parameterType="UploadFile">
<selectKey keyProperty="id" resultType="java.lang.String" order="BEFORE">
select sys_right_seq.NEXTVAL as id from dual
</selectKey>
insert into file_Info (
id,
url
)values (
#{id},
#{url}
)
</insert>实体类
/*ID*/
private String id;
/*文件路径*/
private String url; public String getId() {
return id;
} public void setId(String id) {
this.id = id;
} public String getUrl() {
return url;
} public void setUrl(String url) {
this.url = url;
}DAOpublic int insertUrl(UploadFile uploadFile);实现
@Override
public int insertUrl(UploadFile uploadFile) throws ServiceException {
return uploadFileDao.insertUrl(uploadFile);
}
<insert id="insertUrl" parameterType="UploadFile">
<selectKey keyProperty="id" resultType="java.lang.String" order="BEFORE">
select sys_right_seq.NEXTVAL as id from dual
</selectKey>
insert into file_Info (
id,
url
)values (
#{id},
#{url}
)
</insert>实体类
/*ID*/
private String id;
/*文件路径*/
private String url; public String getId() {
return id;
} public void setId(String id) {
this.id = id;
} public String getUrl() {
return url;
} public void setUrl(String url) {
this.url = url;
}DAOpublic int insertUrl(UploadFile uploadFile);实现
@Override
public int insertUrl(UploadFile uploadFile) throws ServiceException {
return uploadFileDao.insertUrl(uploadFile);
}
解决方案 »
- BigDecimal的一个问题,求解疑。
- [求助]关于xfire eclipse
- quartz执行不正常,结贴率100%,在线等
- 刚发现Hibernate未有效利用mysql的查询缓存!急!!!
- 求对于跨多源数据库库访问查询问题的思路?
- hibernate:你如何优雅地避开冗余?
- 谁有displaytag中文手册或教程?
- xml文件解析、修改的两个问题。请帮帮忙
- 初次到CSDN,以后请多关照!
- LinkedList对象的removeLast()方法是什么意思????
- eclipse自带的export导出的jar包与通过maven打出的jar包存在差异
- log4j2 自定义layout 出错 error contains an invalid element or attribute
参考
insert into user2(id, username, birthday, sex, address) values( USER_SEQUENCE.Nextval, #{username}, #{birthday}, #{sex}, #{address})
<selectKey resultType="java.lang.Integer" keyProperty="id" order="AFTER">
select USER_SEQUENCE.CURRVAL as id FROM dual
</selectKey>
</insert> 你试一下这种,插入的时候写序列号,插入完在查出当前的序列号