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翻譯：檢查手冊(cè)對(duì)應(yīng)于你的MySQL服務(wù)器版本的語(yǔ)法使用“現(xiàn)在附近(user_name、性別、年齡、shengri郵件,號(hào)碼,createuser,createdate,updateuser,updat”在1號(hào)線求大神指點(diǎn)哪個(gè)問(wèn)題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?{ ???? ???//數(shù)據(jù)庫(kù)連接 ???? ???Connection?conn=Shujukulianjie.getConnection(); ???? ???//向數(shù)據(jù)庫(kù)中增加數(shù)據(jù) ???? ???String?sql=""+?"insert?into?now"+//向表now中插入 ???? ???"(user_name,sex,age,shengri,email,haoma," ???? ???+?"createuser,createdate,updateuser,updatedate,isdel)" ???? ??? ??+"values(" ???? ???//curren_date當(dāng)前日期； ???? ??? ??+?"?,?,?,?,?,?,?,current_date(),?,current_date(),?)"; ???? ???/*對(duì)sql數(shù)據(jù)庫(kù)中數(shù)據(jù)進(jìn)行接收和設(shè)置Connection類 ???? ????*?中的prepareStatement返回值類型PreparedStatement，參數(shù)sql列參數(shù) ???? ????*/ PreparedStatement?ptmt=conn.prepareStatement(sql); ptmt.setString(1,g.getUser_name());//對(duì)user_name取值 ptmt.setInt(2,g.getSex()); ptmt.setInt(3,?g.getAge()); /*注意g.getshengri（）類型是java。util， ?*?但setDate類型要求為java.sql類，進(jìn)行轉(zhuǎn)換 ?*?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類型，執(zhí)行任何SQL語(yǔ)句， ?*?用于返回結(jié)果執(zhí)行語(yǔ)句，必須要求有 ?*/ 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("xiap@imooc.com"); 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); } }