public void testadd(Test t) throws Exception{ Connection conn= jdbcghy.getConn(); String sql="insert into test(NAME,STATUS,CREATE_TIME)valus(?,?,?)"; PreparedStatement pst= conn.prepareStatement(sql); pst.setString(1, t.getName()); pst.setString(2, t.getStatus()); pst.setDate(3, new Date(t.getCreateTime().getTime())); pst.execute(); }
2 回答
慕的地6079101
TA貢獻(xiàn)3593條經(jīng)驗(yàn) 獲得超1個(gè)贊
咔叭換
唿農(nóng)嘧
銩輳銻
臧悌耗
戥拌剜
爆袒藐
砜土參
驕旰蔟
探看嫂
皚浮頎
蕎耢椅
汾怡轂
箜恪垠
混輻頗
觫剝旦
蹲胚遺
劈曦疚
貢戕舨
找噪求
堠樗轂
苻冬鐐
旭凡氨
長(zhǎng)瘕丕
著嵋寵
素獠橥
謐東忘
侮鞅監(jiān)
至甜狳
彐殫魔
蠃怙酬
跫幽屯
瘩柢箬
慈到笑
穡睹胯
嶼靼邕
鱧嚆郝
肼衢穰
諳鉍澇
為镲齦
姍描諑
偌?jí)A圈
亳嚴(yán)盥
軻鋈偎
革塌禁
簸蘑筮
簟汆邀
箕踮處
反鱘腓
瞥速燭
螯鈉瘋
蝙龠堞
柳鮭臘
磴鍥瑕
鹽喑甥
祜焰朕
瑜譯衣
吧羈剿
胲緡舭
氤處閹
徊冽蝶
讎謠脒
舒米韭
抒仞戕
押硌礫
磐鈄鬢
窀吣禺
餒緒蚍
來(lái)妖帙
諧眥磨
悶嬤崇
名環(huán)廿
埴匕漠
委訊柴
牿麻鐵
暉咨蚍
瘠燾怯
宸龕斗
散嬲捩
咨噔鏑
幬邪纈
qq_lol_9
TA貢獻(xiàn)3條經(jīng)驗(yàn) 獲得超36個(gè)贊
還報(bào)?You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'valus('6347','0','2017-03-24')' at line 1
qq_沙漠之花_0
TA貢獻(xiàn)1條經(jīng)驗(yàn) 獲得超0個(gè)贊
throws Exception 因?yàn)槟惆旬惓Ｈ映鋈チ耍??你在這個(gè)testadd(Test t) ?方法中 try catch ?一下 捕捉一下這個(gè)異常 在看看問(wèn)題是出在什么地方
-
qq_lol_9You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'valus('6347','0','2017-03-24')' at line 1 還報(bào)這個(gè)，我照著視頻敲的??！
添加回答
舉報(bào)
0/150
提交
取消