清高手指点,我是java新手,自己建立个工程,实现增删改查,但是修改就是不好用,具体是我的代码应该没问题了,但sql语句有问题,当我修改完时点击放进数据库里吧,但是数据库里的数据不变,应该是是sql语句出错了,代码如下:
已经找一天了没找原因:
<statement id="updateGuolv" resultClass="int" parameterClass="guolv">
update fj_guolv t
<dynamic prepend="set"> <isNotEmpty prepend="," property="oldword">
t.oldword = #oldword#
</isNotEmpty>
<isNotEmpty prepend="," property="newword">
t.newword = #newword#
</isNotEmpty>
</dynamic>
where id = #id#
</statement>
<statement id="updateGuolvHtmlUrl" resultClass="int" parameterClass="guolv">
<![CDATA[update fj_guolv t set t.id=#id# where t.id = #id#]]>
</statement>
已经找一天了没找原因:
<statement id="updateGuolv" resultClass="int" parameterClass="guolv">
update fj_guolv t
<dynamic prepend="set"> <isNotEmpty prepend="," property="oldword">
t.oldword = #oldword#
</isNotEmpty>
<isNotEmpty prepend="," property="newword">
t.newword = #newword#
</isNotEmpty>
</dynamic>
where id = #id#
</statement>
<statement id="updateGuolvHtmlUrl" resultClass="int" parameterClass="guolv">
<![CDATA[update fj_guolv t set t.id=#id# where t.id = #id#]]>
</statement>
<![CDATA[update fj_guolv t set t.id=#id# where t.id = #id#]]>
</statement>这个ID应该在对象里换个名称吧,要不怎么区分后边的id呢,我认为就相当于
update fj_guolv t set t.id=1 where t.id = 1;