新手做报表，谢谢帮助

swb554983186

2015-09-18 17:09:42 加载模块：/UI2/system/service/report ...
2015-09-18 17:09:42 加载模块：/UI2/system/service/report
java.sql.SQLException: 索引中丢失  IN 或 OUT 参数:: 6
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
    at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1681)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3280)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at HotLineReport.monthReprot(HotLineReport.java:127)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at com.justep.system.action.Engine.invokeActions(Native Method)
    at com.justep.system.action.Engine.invokeActions(Unknown Source)
    at com.justep.business.server.BusinessServer.doAction(Unknown Source)
    at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
    at com.justep.business.server.BusinessServer.excute(Unknown Source)
    at com.justep.business.server.BusinessServer.excute(Unknown Source)
    at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
    at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:745)
@@@@@@@@@@@@@@@@@@@

jishuang

HotLineReport.monthReprot(HotLineReport.java:127)

自己写的sql有问题
这个错误是sql报出来的错误

swb554983186

这个我也知道，我是想知道具体因为什么，避免以后再报
        public static Table monthReprot(String beginDate,String endDate){
                //本月受理               
                String SQL1 = "select count(M.TRANS_FLAG) from MA_HOT_LINE M where M.TRANS_FLAG>=1 and  HOT_LINE_TIME  between  to_date('2015-01-01','yyyy-mm-dd') and to_date('2015-01-31','yyyy-mm-dd')";
             int   monthTotalCount =  HotLineReport.monthTotal(SQL1).getColumnCount();
               
                //已办件
                String SQL2 = "select count(M.TRANS_FLAG) from MA_HOT_LINE M where M.TRANS_FLAG>=11 and  HOT_LINE_TIME  between  to_date('2015-01-01','yyyy-mm-dd') and to_date('2015-01-31','yyyy-mm-dd')";
                int  monthOverTotalCount = HotLineReport.monthOverTotal(SQL2).getColumnCount();

                //数据插入
                String sql="insert into MA_HOT_MONTH(FID,YER,MONTH_S,HOT_LINE_NUMBER,HOT_LINE_TAKEN,HOT_LINE_SCALE," +
                                "HOT_LINE_DISPOSE,HOT_LINE_ZHENGBAN,HOT_LINE_ALL,HOT_LINE_YIBAN,HOT_LINE_YIBANZHANBI," +
                                "HOT_LLINE_ZHENGBANLEIJISHU,HOT_LINE_ZHENGBANZHANBI) " +
                                "values(?,?,?,?,?,?,?,?,?,?,?,?,?)";
         try{
                Connection conn = ModelUtils.getConnectionInTransaction("/szrx/hotLineReport/data");
                PreparedStatement  pstmt = conn.prepareStatement(sql);
               
                   /* pstmt.setString(1,UUID.randomUUID().toString());
                    pstmt.setString(2, "YER");
                        pstmt.setString(3, MONTH_S);
                        pstmt.setString(4, HOT_LINE_NUMBER);
                        pstmt.setString(5, HOT_LINE_TAKEN);
                        pstmt.setString(6, HOT_LINE_SCALE);
                        pstmt.setString(7, HOT_LINE_DISPOSE);
                        pstmt.setString(8, HOT_LINE_ZHENGBAN);
                        pstmt.setString(9, HOT_LINE_ALL);
                        pstmt.setString(10, HOT_LINE_YIBAN);
                        pstmt.setString(11, HOT_LINE_YIBANZHANBI);
                        pstmt.setString(12, HOT_LLINE_ZHENGBANLEIJISHU);
                        pstmt.setString(13, HOT_LINE_ZHENGBANZHANBI);*/
                        pstmt.executeUpdate();
         }catch(Exception e){
                 e.printStackTrace();
         }
                //查询出逐月统计表的数据
                        String querysql = "select MA_HOT_MONTH.MONTH_S as MONTH_S," +
                                        "MA_HOT_MONTH.HOT_LINE_NUMBER as NUMBER_S," +
                                        "MA_HOT_MONTH.HOT_LINE_TAKEN as TAKEN_S," +
                                        "MA_HOT_MONTH.HOT_LINE_SCALE as SCALE_S," +
                                        "MA_HOT_MONTH.HOT_LINE_DISPOSE as DISPOSE_S," +
                                        "MA_HOT_MONTH.HOT_LINE_ZHENGBAN as ZHENGBAN_S," +
                                        "MA_HOT_MONTH.HOT_LINE_ALL as ALL_S," +
                                        "MA_HOT_MONTH.HOT_LINE_YIBAN as YIBAN_S," +
                                        "MA_HOT_MONTH.HOT_LINE_YIBANZHANBI as NUMBER_SS," +
                                        "MA_HOT_MONTH.HOT_LLINE_ZHENGBANLEIJISHU as NUMBER_SSS," +
                                    "MA_HOT_MONTH.HOT_LINE_ZHENGBANZHANBI as CODE_S from MA_HOT_MONTH ";
                                                            
                HashMap<String,String> sqlMap = new HashMap<String,String>();
                sqlMap.put(DatabaseProduct.ORACLE.name(),querysql);

                return SQL.select(sqlMap, null, "/szrx/hotLineReport/data");       
        }

jishuang

http://bbs.wex5.com/forum.php?mo ... 8&pid=165174058