sql 文件 ibatis_app.xml配置如下:(注意 这里是用insert 标签而不能用update标签(虽然update标签也能做新增操作)否则在service层中的 int packageid = dao.addPgInfo(bean);始终返回的是1 ;下面配置中的keyProperty的id和 SELECT LAST_INSERT_ID() as id的id
和com.xxx.wms.mp.atomic.bean.PackageBean中的属性一致)
<insert id="addPgInfo" parameterClass="com.xxx.wms.mp.atomic.bean.PackageBean">
<![CDATA[insert into _wms_client_package (client_package_type,app_name,client_package_version,client_package_url,client_package_creat_time,client_package_key,device_type,os_type)
values (#packageType#,#appName#,#packageVersion#,#packageUrl#,now(),#key#,#deviceType#,#osType#)]]>
<selectKey resultClass="int" keyProperty="id">
SELECT LAST_INSERT_ID() as id
</selectKey>
</insert>
dao接口层:
int addPgInfo(PackageBean bean);
dao实现层:
public int addPgInfo(PackageBean bean)
{
return (Integer)super.getSqlMapClientTemplate().insert("addPgInfo", bean);
}