java的数据库语句(急在线等)

Question

String baofeiurl = "insert into baofei values ('"+id+"','"+name+"','"+pattern+"','"+kind+"','"+leader+"','"+employee+"','"+part+"','"+indate+"','"+diedate+"','"+reason+"','"+getway+"')";
        String selecturl = "select * from kc where 设备名 = '"+name+"' and 所属部门 = '"+part+"'";        
        
        if(id.equals("")||name.equals("")||pattern.equals("")||kind.equals("")||leader.equals("")||employee.equals("")||part.equals("")||indate.equals("")||diedate.equals("")||reason.equals("")||getway.equals("")) {
            JOptionPane.showMessageDialog(this,"所有信息都必须填写","警告!!", JOptionPane.INFORMATION_MESSAGE);
        } else {
            try {
                stmt.executeUpdate(baofeiurl);
                rs = stmt.executeQuery(selecturl);
                if(rs.next()) {
                    String temp  = rs.getString(3);
                    int sum1 = new Integer(temp).intValue();
                    int sum = sum1 -1;
                    number = Integer.valueOf(sum).toString();
                    System.out.println(number);
            
                  String updateurl = "update kc set 库存数目 = '"+number+"' where 设备名 = '"+name+"'and 所属部门 = '"+part+"'";
                    int i = stmt.executeUpdate(updateurl);
                    //就是上面这句话错了
                    if(i>0) {
                        System.out.println("chenggongg");
                    }
                }
                System.out.println("Don't success");
                dispose();
            } catch(Exception se) {
                se.printStackTrace();
                System.err.println("cule");
            }
        }
        
        
    }   
netbeans5.0报错如下:
init:
deps-jar:
Compiling 1 source file to C:\Documents and Settings\Administrator\桌面\设备管理系统2.0\build\classes
compile-single:
run-single:
19
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 1。
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
        at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3111)
        at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
        at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:288)
        at BaofeiFrame.jButton1ActionPerformed(BaofeiFrame.java:278)
        at BaofeiFrame.access$000(BaofeiFrame.java:14)
        at BaofeiFrame$1.actionPerformed(BaofeiFrame.java:80)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
...................................................
后面还有一大堆

Answer 1

ODBC Microsoft Access Driver!!!!!!!!!!!强....看看..insert into baofei表是否有对应的字段,不可以多或少的

Answer 2

数据库连接类写好?？？我们也看不到你写的连接类，你的stmt 怎么生成的？

Answer 3

String updateurl = "update kc set 库存数目 = '"+number+"' where 设备名 = '"+name+"'and 所属部门 = '"+part+"'";
//加上日志：
System.out.println(updateurl);
//看输出的SQL是否正确
int i = stmt.executeUpdate(updateurl);

Answer 4

太长了,有点晕,应该sql语句出错了,细心检查以下,最好先打印出来看看