Public class CunkDao {
Private QueryRunner qr=new TxQueryRunner ();
Public int updateFenl (String acct, String empid) {
Try {
String the parm []={empid, acct};
String SQL="update pastest2. Dpfm22_b_neiguan set empid=? Where the acct=?" ;
Int I=(int) qr. Query (SQL, new ScalarHandler (), the parm);
System.out.println(i);
Return the I;
} the catch (Exception e) {
e.printStackTrace();
return 0;
}
}
}
The abnormal quoted:
Java. SQL. SQLException: invalid column index of the Query: update pastest2. Dpfm22_b_neiguan set empid=? Where the acct=? The Parameters: [conventional, 362103010300000220186]
At org.apache.com mons. Dbutils. AbstractQueryRunner. Rethrow (AbstractQueryRunner. Java: 527)
At org.apache.com mons. Dbutils. QueryRunner. Query (QueryRunner. Java: 391)
At org.apache.com mons. Dbutils. QueryRunner. Query (QueryRunner. Java: 252)
At com. Neiguan. Tools. TxQueryRunner. Query (TxQueryRunner. Java: 32)
At com. Neiguan. Dao. CunkDao. UpdateFenl (CunkDao. Java: 152)
At com. Neiguan. Service. CunkService. UpdateFenl (CunkService. Java: 29)
At com. Neiguan. Web. Servlet. FenLServlet. DoPost (FenLServlet. Java: 22)
The at javax.mail. Servlet. HTTP. HttpServlet. Service (HttpServlet. Java: 648)
The at javax.mail. Servlet. HTTP. HttpServlet. Service (HttpServlet. Java: 729)
The at org. Apache. Catalina. Core. ApplicationFilterChain. InternalDoFilter (ApplicationFilterChain. Java: 291)
The at org. Apache. Catalina. Core. ApplicationFilterChain. DoFilter (ApplicationFilterChain. Java: 206)
At org, apache tomcat, websocket server WsFilter. DoFilter (WsFilter. Java: 52)
The at org. Apache. Catalina. Core. ApplicationFilterChain. InternalDoFilter (ApplicationFilterChain. Java: 239)
The at org. Apache. Catalina. Core. ApplicationFilterChain. DoFilter (ApplicationFilterChain. Java: 206)
The at org. Apache. Catalina. Core. StandardWrapperValve. Invoke (StandardWrapperValve. Java: 219)
The at org. Apache. Catalina. Core. StandardContextValve. Invoke (StandardContextValve. Java: 106)
The at org. Apache. Catalina. The authenticator. AuthenticatorBase. Invoke (AuthenticatorBase. Java: 502)
The at org. Apache. Catalina. Core. StandardHostValve. Invoke (StandardHostValve. Java: 142)
The at org. Apache. Catalina. Valves. ErrorReportValve. Invoke (ErrorReportValve. Java: 79)
The at org. Apache. Catalina. Valves. AbstractAccessLogValve. Invoke (AbstractAccessLogValve. Java: 616)
The at org. Apache. Catalina. Core. StandardEngineValve. Invoke (StandardEngineValve. Java: 88)
At org. Apache. Catalina. Connector. CoyoteAdapter. Service (518) CoyoteAdapter. Java:
The at org. Apache. Coyote. Http11. AbstractHttp11Processor. Process (AbstractHttp11Processor. Java: 1091)
The at org. Apache. Coyote. AbstractProtocol $AbstractConnectionHandler. Process (AbstractProtocol. Java: 673)
At org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun AprEndpoint. Java: (2503)
At org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run AprEndpoint. Java: (2492)
The at Java. Util. Concurrent. ThreadPoolExecutor. RunWorker (ThreadPoolExecutor. Java: 1142)
The at Java. Util. Concurrent. ThreadPoolExecutor $Worker. The run (ThreadPoolExecutor. Java: 617)
At org, apache tomcat. Util. Threads. TaskThread $WrappingRunnable. Run (61) TaskThread. Java:
The at Java. Lang. Thread. The run (Thread. Java: 745)
Problem description: database update is successful, but the abnormal, jump straight to the catch (Exception e) {
e.printStackTrace();
return 0;
}
Updated line on principle should return int I=1;
Also on the number of arguments, also to order, really can't find the problem, please god to see
CodePudding user response:
I suspect the qr. Query and other operations in this method