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 'now(user_name,sex,age,shengri,email,haoma,createuser,createdate,updateuser,updat' at line 1翻譯：檢查手冊對應于你的MySQL服務器版本的語法使用“現在附近(user_name、性別、年齡、shengri郵件,號碼,createuser,createdate,updateuser,updat”在1號線求大神指點哪個問題package?src_1gongneg; import?java.sql.Connection; import?java.sql.Date; import?java.sql.PreparedStatement; import?java.sql.SQLException; import?src_1.Jdbc_shujuku; import?src_1.Shujukulianjie; public?class?Gongneng?{ public?void?add(Jdbc_shujuku?g){ ???????try?{ ???? ???//數據庫連接 ???? ???Connection?conn=Shujukulianjie.getConnection(); ???? ???//向數據庫中增加數據 ???? ???String?sql=""+?"insert?into?now"+//向表now中插入 ???? ???"(user_name,sex,age,shengri,email,haoma," ???? ???+?"createuser,createdate,updateuser,updatedate,isdel)" ???? ??? ??+"values(" ???? ???//curren_date當前日期； ???? ??? ??+?"?,?,?,?,?,?,?,current_date(),?,current_date(),?)"; ???? ???/*對sql數據庫中數據進行接收和設置Connection類 ???? ????*?中的prepareStatement返回值類型PreparedStatement，參數sql列參數 ???? ????*/ PreparedStatement?ptmt=conn.prepareStatement(sql); ptmt.setString(1,g.getUser_name());//對user_name取值 ptmt.setInt(2,g.getSex()); ptmt.setInt(3,?g.getAge()); /*注意g.getshengri（）類型是java。util， ?*?但setDate類型要求為java.sql類，進行轉換 ?*?new?Date,getTime()方法 ?*/ ptmt.setDate(4,new?Date(g.getShengri().getTime())); ptmt.setString(5,?g.getEmail()); ptmt.setString(6,g.getHaoma()); ptmt.setString(7,?g.getCreateuser()); //ptmt.setDate(8,(Date)?g.getCreatedate()); ptmt.setString(8,g.getUpdateuser()); ptmt.setInt(9,g.getIsdel()); /*返回值為Boolean類型，執行任何SQL語句， ?*?用于返回結果執行語句，必須要求有 ?*/ ptmt.execute(); }?catch?(SQLException?e)?{ //?TODO?Auto-generated?catch?block e.printStackTrace(); } ??? ?? ??? ???} } package?src_1; import?java.util.Date; import?src_1gongneg.Gongneng; public?class?Shixian?{ public?static?void?main(String[]?args)?{ //?TODO?Auto-generated?method?stub Jdbc_shujuku?one=new?Jdbc_shujuku(); one.setUser_name("小姐"); one.setSex(1); one.setAge(12); one.setEmail("[email protected]"); one.setHaoma("17653809"); one.setShengri(new?Date()); //one.setCreatedate(createdate); one.setCreateuser("xja"); one.setUpdateuser("xhis"); one.setIsdel(1); Gongneng?i=new?Gongneng(); i.add(one); } }