Question

[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 2。

public void actionPerformed(ActionEvent e)
{
if(e.getSource()==btn1)
{
Connection conn;
Statement sql;
ResultSet rs;
String s1=id.getText().toString().trim();
String s2=address.getText().toString().trim();
String s3=direct.getText().toString().trim();
String s4=kind.getText().toString().trim();
String s5=value.getText().toString().trim();
int sum=0;
if(s1.equals(""))
{JOptionPane.showMessageDialog(null,"客户编号不能为空!");}
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ee)
{ System.out.println(""+ee);
}
try { conn=DriverManager.getConnection("jdbc:odbc:excise");
sql=conn.createStatement();
rs=sql.executeQuery("SELECT * FROM Addel where 客户编号='"+s1+"'");
while(rs.next())
{
sum++;
}
if(sum==1)
{
JOptionPane.showMessageDialog(null,"客户编号已经存在，请使用其他编号!");
}
else
{
sql.executeUpdate("INSERT INTO Addel values("+s1+","+s2+","+s3+","+s4+","+s5+")");
setVisible(false);
JOptionPane.showMessageDialog(null,"你已经成功添加客户信息！");
}
conn.close();
}
catch(SQLException ex)
{ System.out.println(ex);
}
}
添加新客户时提示如题,有时是期待1..什么情况?
另个表删除时提示删除成功,但Access表里数据没删,是数据库调用问题么?

Answer 1

Addel这个表一共有多少个字段?超过5个的话sql.executeUpdate("INSERT INTO Addel values("+s1+","+s2+","+s3+","+s4+","+s5+")");这句应该把需要更新的字段名一一列出来,标准写法应该是这样的:
sql.executeUpdate("INSERT INTO Addel (field1,field2,field3,field4,field5)values("+s1+","+s2+","+s3+","+s4+","+s5+")");

Answer 2

是参数传递的错误，尤其是查询的时候，用到where xx=xxxx的时候，这个xxxx没有正确获得值