关于java中sql插入语句的参数疑问
先看一下源码:
public String lb=jLabel2.getText();
public String lb1=jLabel3.getText();
public String lb2=jLabel4.getText();
public String lb3=jLabel5.getText();
public String lb4=jLabel6.getText();
public String tx=jTextField1.getText();
public String tx1=jTextField2.getText();
public String tx2=jTextField3.getText();
public String tx3=jTextField4.getText();
public String tx4=jTextField5.getText();
void jButton1_actionPerformed(ActionEvent e) {
String fh=choice1.getSelectedItem();
String url="jdbc:odbc:xuetijin03010438";
String sql="Insert Into "+fh+"("+lb+","+lb1+","+lb2+","+lb3+","+lb4+") Values ("+tx+","+tx1+","+tx2+","+tx3+","+tx4+")";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url);
PreparedStatement ps=con.prepareStatement(sql);
ps.executeUpdate();
con.close();
} catch(Exception se)
{
jLabel12.setText("操作失败,信息是否完整或已存在");
System.out.println(se);
}
}
运行时总是能捕捉到错误,调试后我把错误归结到插入语句中的参数问题.请专家诊断!~~~~~~