版本：Orcale 11g
代碼如下：
@Insert("<script>"
+ "INSERT INTO "
+ "\"menu\""
+ "("
+ "\"menu_uid\","
+ "\"create_time\","
+ "\"create_user\","
+ "\"last_update_time\","
+ "\"last_update_user\","
+ "\"name\","
+ "\"level\","
+ "\"url\","
+ "\"first_menu_id\","
+ "\"menu_explain\""
+ ")"
+ " VALUES"
+ "("
+ "#{menu_uid},"
+ "TO_DATE(#{create_time},'yyyy-mm-dd hh24:mi:ss'),"
+ "#{create_user},"
+ "TO_DATE(#{create_time},'yyyy-mm-dd hh24:mi:ss'),"
+ "#{last_update_user},"
+ "#{name},"
+ "#{level},"
+ "#{url},"
+ "#{first_menu_id},"
+ "#{menu_explain}"
+ ")"
+ "</script>")
//保存選單資訊
int saveMenu(MenuBean menuBean, String create_time);
控制臺如下：
描述：專案配置了sql列印，上面select陳述句列印出來了攜帶的引數，insert陳述句并沒有列印出來。控制層和Service實作層都成功攜帶了引數。資料庫也沒有成功插入資料。 求解。
補充：引數攜帶如下圖（確認過了資料庫欄位是否非空等問題）
uj5u.com熱心網友回復：
有沒有報錯呢？另外insert陳述句執行完是要commit提交的，用這個陳述句插入會不會自動提交？
uj5u.com熱心網友回復：
沒有報錯，控制臺的資訊全部都放在上面了
uj5u.com熱心網友回復：
顯式提交一下試試， 即加一個commituj5u.com熱心網友回復：
還是不行轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/10028.html
標籤：開發