在SQL Server数据库中,采用自增长的字段作为主键,在插入一条记录时有时需要同时得到自增长的id。一般的方式是先执行insert语句,然后根据该insert的数据唯一特征(唯一键)检索到该数据,得到id。这个方法首先不方便,其次对于该数据没有唯一特征的情况甚至都不可行。ibatis提供了简单的解决办法。
表结构为:
[code]CREATE TABLE [TaskDeliveryURL] (
[urlId] [int] IDENTITY (1, 1) NOT NULL ,
[urlName] [nvarchar] (511) ,
[urlLink] [nvarchar] (511) ,
PRIMARY KEY CLUSTERED ([urlId]) ON [PRIMARY]
)[/code]
model为:
[code]package com.ccg.ciic.proxy.domain;
public class TaskDeliveryUrl {
private String urlName;
private String urlLink;
private long urlId;
public long getUrlId() {
return urlId;
}
public void setUrlId(long urlId) {
this.urlId = urlId;
}
public String getUrlLink() {
return urlLink;
}
public void setUrlLink(String urlLink) {
this.urlLink = urlLink;
}
public String getUrlName() {
return urlName;
}
public void setUrlName(String urlName) {
this.urlName = urlName;
}
}[/code]
ibatis的映射文件为:
[code]<sqlMap>
<insert id="insert" parameterClass="com.ccg.ciic.proxy.domain.TaskDeliveryUrl">
insert into TaskDeliveryURL(urlName, urlLink) values(#urlName#,#urlLink#)
<selectKey resultClass="long" keyProperty="urlId" >
SELECT @@IDENTITY AS urlId
</selectKey>
</insert>
</sqlMap>[/code]
这样在将一个TaskDeliveryUrl对象的urlName和urlLink属性注入到映射文件,执行insert操作后,自生成的urlId同时被注入到该TaskDeliveryUrl对象的urlId属性中。
表结构为:
[code]CREATE TABLE [TaskDeliveryURL] (
[urlId] [int] IDENTITY (1, 1) NOT NULL ,
[urlName] [nvarchar] (511) ,
[urlLink] [nvarchar] (511) ,
PRIMARY KEY CLUSTERED ([urlId]) ON [PRIMARY]
)[/code]
model为:
[code]package com.ccg.ciic.proxy.domain;
public class TaskDeliveryUrl {
private String urlName;
private String urlLink;
private long urlId;
public long getUrlId() {
return urlId;
}
public void setUrlId(long urlId) {
this.urlId = urlId;
}
public String getUrlLink() {
return urlLink;
}
public void setUrlLink(String urlLink) {
this.urlLink = urlLink;
}
public String getUrlName() {
return urlName;
}
public void setUrlName(String urlName) {
this.urlName = urlName;
}
}[/code]
ibatis的映射文件为:
[code]<sqlMap>
<insert id="insert" parameterClass="com.ccg.ciic.proxy.domain.TaskDeliveryUrl">
insert into TaskDeliveryURL(urlName, urlLink) values(#urlName#,#urlLink#)
<selectKey resultClass="long" keyProperty="urlId" >
SELECT @@IDENTITY AS urlId
</selectKey>
</insert>
</sqlMap>[/code]
这样在将一个TaskDeliveryUrl对象的urlName和urlLink属性注入到映射文件,执行insert操作后,自生成的urlId同时被注入到该TaskDeliveryUrl对象的urlId属性中。