在

Java

中打印出了执行SQL

JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@453762db] will not be managed by Spring

==>  Preparing: insert INTO orderdetail ( id, mainid, ordercode ) values ( ?, ?, ? ) ON DUPLICATE KEY UPDATE mainid = ?, ordercode = ?, goodsname = ?

==> Parameters: 14(Integer), 1(Integer), chanchaw03(String), 1(Integer), chanchaw03(String), null

<==    Updates: 2

Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2bf2b238]

Creating a new SqlSession

SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2f52a9e0] was not registered for synchronization because synchronization is not active

JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@453762db] will not be managed by Spring

==>  Preparing: insert INTO orderdetail ( id, mainid, ordercode ) values ( ?, ?, ? ) ON DUPLICATE KEY UPDATE mainid = ?, ordercode = ?, goodsname = ?

==> Parameters: 14(Integer), 1(Integer), chanchaw01(String), 1(Integer), chanchaw01(String), null

<==    Updates: 2

Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2f52a9e0]

看上面

console

打印的

SQL

语句，

inser into

部分判断到

goodsname

是

null

，所以没有拼接该字段最终形成

insert INTO orderdetail ( id, mainid, ordercode ) values ( ?, ?, ? )

，但是后面的

UPDATE

没有检测到

null

，导致形成了

SQL

：

UPDATE mainid = ?, ordercode = ?, goodsname = ?

最终字段

goodsname

被修改为了

null

，这是什么问题？是我

xml

文件中写的不对？