此代码中的问题 [英] problem in this code

问题描述

你好.
我想从mysql数据库更新数据，并使用文本字段输入数据并在数据库中更新它，但它给了我我错过了)或;但是我检查的时间不止一次，找不到任何东西.

这是代码:

hello .
i want to update data from mysql database and use a textfields for enter data and update it in database but it give that i miss ) or ; but i check more than time and can''nt find anything .

here is the code:

String dataSource ="testDb";
      String U="jdbc:odbc:"+dataSource;
      try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            java.sql.Connection con=java.sql.DriverManager.getConnection(U,"","");


     java.sql.PreparedStatement s=con.prepareStatement("update student SET Name= ''"+jTextField2.getText()+"'',Grade= ''"+jTextField3.getText()+" '',Telephone= ''"+jTextField6.getText()+" '',Nationality= ''"+jTextField9.getText()+" '',Nationality1= ''"+jTextField10.getText()+" '',Address= ''"+jTextField4.getText() +" '',Major= ''"+jTextField7.getText()+"  '',High_School_Major= ''"+jTextField8.getText()+ ",GPA= ''"+jTextField5.getText()+" ''WHERE idstudent=  ''"+jTextField1.getText()"  ''");
  ResultSet r=s.executeQuery();
 r.next();



 }

                  catch(Exception e)
      {
System.out.println(e);

      }



    }                                        

推荐答案

在,GPA=之前，您错过了''；在"+jTextField1.getText()之后，您错过了 + 用" ''")
完成签名
所以:

Before ,GPA= you miss '' and after "+jTextField1.getText() you miss the + sign to complete with " ''")

so:

java.sql.PreparedStatement s=con.prepareStatement("update student SET Name= '" + jTextField2.getText() + 
	"', Grade= '" + jTextField3.getText() + 
	"',Telephone= '" + jTextField6.getText() + 
	"',Nationality= '" + jTextField9.getText() +
	"',Nationality1= '" + jTextField10.getText() + 
	"',Address= '" + jTextField4.getText() +
	"',Major= '" + jTextField7.getText() + 
	"',High_School_Major= '" + jTextField8.getText() + 
	"',GPA= '" + jTextField5.getText() + 
	"' WHERE idstudent= '" + jTextField1.getText() + "'");pre>

这篇关于此代码中的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！