1.Dialect的设置,在pageHelper中会控制数据的sql的是oracle或者mysql
2.插入数据的时候返回id,参见https://blog.csdn.net/weixin_43179996/article/details/85062405
核心就是oracle的数据库,查询需要这么 写useGeneratedKeys、keyProperty、selectKey 都带上,不加selectKey 只有前两部分会报错 :
<insert id="insertLangValue" parameterType="LangValue" useGeneratedKeys="true" keyProperty="id">
<selectKey keyProperty="id" order="BEFORE" resultType="Long">
SELECT LANGUAGE_SEQUENCE.nextval
id from dual
</selectKey>
insert into lang_value
<trim prefix="(" suffix=")" suffixOverrides=",">
id,
<if test="languageKey != null and languageKey != ''