暑假项目排错笔记

1.

String sql = "update produce set contract=?,jobnumbering=?,groupnumbering=?,planvolume=?,starttime=?,endtime=?,operator=? where numbering= ?";
        boolean res = false;
        try {
            System.out.println("update22xia");
            pstmt = con.prepareStatement(sql);
            //pstmt.setString(1,user.getNumbering());
            pstmt.setString(1,user.getContract());
            pstmt.setString(2,user.getJobnumbering());
            pstmt.setString(3,user.getGroupnumbering());
            pstmt.setString(4,user.getPlanvolume());
            pstmt.setString(5,user.getStarttime());
            pstmt.setString(6,user.getEndtime());
            pstmt.setString(7,user.getOperator());
            pstmt.setString(8,user.getNumbering());//

            res = (pstmt.executeUpdate()==1);

一直报错No value specified for parameter 9，是调用numbering的值，所以可以不把numbering设在前面，可以删除numbering，然后把

 pstmt.setString(8,user.getNumbering());//放在最好jiu欧克了