更新女神代碼問題
public?void?updateGoddess(Goddess?g)?throws?SQLException{//更新,數(shù)據(jù)通過對象的形式傳進(jìn)來 Connection?conn=DBUtil.getConnection(); String?sql=""+//編寫sql語句 ????"update?into?goddess?set?user_name=?,sex=?,age=?,birthday=?,email=?,mobile=?,update_user=?,update_date=current_date(),isdel=??where?id=?";//問號為占位符 //prepareStatement方法會將sql語句加載到驅(qū)動程序的執(zhí)行程序中,但不會直接執(zhí)行,預(yù)編譯 PreparedStatement?ptmt=conn.prepareStatement(sql); //傳參給預(yù)編譯符 ptmt.setString(1,?g.getUser_name()); ptmt.setInt(2,?g.getSex()); ptmt.setInt(3,?g.getAge()); ptmt.setDate(4,?new?Date(g.getBirthday().getTime()));//因為在原定義方法中Date是java.util類型的,此處需要轉(zhuǎn)換成java.sql類型的 ptmt.setString(5,?g.getEmail()); ptmt.setString(6,?g.getMobile()); ptmt.setString(7,?g.getUpdate_user()); ptmt.setInt(8,?g.getIsdel()); ptmt.setInt(9,?g.getId()); //當(dāng)調(diào)用execute()才會執(zhí)行 ptmt.execute(); }
測試數(shù)據(jù)時代碼如下
GoddessDao?g=new?GoddessDao(); Goddess?g1=new?Goddess(); ????????g1.setUser_name("小蘭"); ????????g1.setAge(21); ????????g1.setSex(1); ????????g1.setBirthday(new?Date());//定義為今天,用util類型 ????????g1.setEmail("xiaolan@123.com"); ????????g1.setMobile("15071234567"); ????????g1.setUpdate_user("ADMIN");//更新人 ????????g1.setIsdel(1);//是否刪除,否 ???????? ????????g1.setId(4); ????????g.updateGoddess(g1);
最后報錯
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 'into goddess set user_name='小蘭',sex=1,age=21,birthday='2017-06-04',email='xi' at line 1
請問是哪里出了問題,求解答,謝謝~
2017-06-04
update 不需要into