数据库id设置为自增,新增后需要返回新增的id信息。
Mapper文件(MySQL数据库):
<insert id="addNewsInfo" parameterType="com.bonc.wechat.entity.news.News">
<![CDATA[
INSERT INTO wx_news
(
]]>
<if test="title!=null"> title,</if>
<if test="content!=null">content,</if>
<if test="type!=null"> type,</if>
<if test="which!=null">which,</if>
<if test="issueder!=null"> issueder,</if>
<if test="time!=null">time,</if>
<![CDATA[
id)VALUES (
]]>
<if test="title!=null"> #{title},</if>
<if test="content!=null"> #{content},</if>
<if test="type!=null"> #{type},</if>
<if test="which!=null"> #{which},</if>
<if test="issueder!=null"> #{issueder},</if>
<if test="time!=null"> #{time},</if>
<![CDATA[
root.id.NEXTVAL)
]]>
<!-- 获取当前主键 -->
<selectKey resultType="java.lang.Long" keyProperty="id" >
SELECT root.id.CURRVAL AS id FROM DUAL
</selectKey>
</insert>
service层:
/**
* 根据新闻实体新增新闻对象。
* @param news
* @return
*/
public int addNewsInfo(News news){
int code;
try {
nd.addNewsInfo(news);
} catch (Exception e) {
e.printStackTrace();
}
code = news.getId(); //返回新增的id
return code;
}