mysql数据库的update语法错误_我的数据库的增加和修改操作报SQL语法错误。

Class.forName("com.mysql.jdbc.Driver");ct=DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=linzhe1996");ps=ct.prepareStatement("updatepersonset...

Class.forName("com.mysql.jdbc.Driver");

ct = DriverManager

.getConnection("jdbc:mysql://localhost/test?user=root&password=linzhe1996");

ps = ct.prepareStatement("update person set name=?,gender=?,age=?,dbo=?,phone=?,email=?,qq=?,adress=? where id='+id'");

ps.setString(1,t_name.getText());

ps.setString(2,t_gender.getText());

ps.setString(3,t_age.getText());

ps.setString(4,t_dbo.getText());

ps.setString(5,t_phone.getText());

ps.setString(6,t_email.getText());

ps.setString(7,t_qq.getText());

ps.setString(8,t_adress.getText());

System.out.println(t_name.getText());

ps.executeUpdate();

//**********************************************************************************

try{

//连接数据库

Class.forName("com.mysql.jdbc.Driver");

ct = DriverManager

.getConnection("jdbc:mysql://localhost/test?user=root&password=linzhe1996");

ps=ct.prepareStatement("insert into person values(?,?,?,?,?,?,?,?,?)");

//从TEXT中获取数据

ps.setString(1,t_id.getText());

ps.setString(2,t_name.getText());

ps.setString(3,t_gender.getSelectedItem().toString());

ps.setString(4,t_age.getText());

ps.setString(5,t_dbo.getText());

ps.setString(6,t_phone.getText());

ps.setString(7,t_email.getText());

ps.setString(8,t_qq.getText());

ps.setString(9,t_adress.getText());

ps.executeUpdate();

展开