jdbcTemplate 改成namedParameterJdbcTemplate

Question

继承NamedParameterJdbcDaoSupportpublic int addOrUpdateStatisticRule() {
        String procedure = "{call sp_getdatabypage(?,?,?)}";// 参数用？替代（包含输出参数）
        @SuppressWarnings("unchecked")
        int cur_id=this.getNamedParameterJdbcTemplate().execute(procedure, new CallableStatementCallback() { // 内部类
                   @Override
                  public Object doInCallableStatement(CallableStatement cs)
                                    throws SQLException, DataAccessException {
                            // 初始化返回值
                          int current_id=3;
                          // 设置输入参数
                         cs.setString(1, "SELECT ddh,zt,chddm, ddje,convert(varchar(12),ydsj,111) as ydrq  from tCPYDD");
                         cs.setInt(2, 10);
                         cs.setInt(3, 4);
                                  
                       // 注册输出参数
                       //cs.registerOutParameter(3, Types.INTEGER);
                       //cs.execute();
                       //current_id=cs.getInt(5); // 获得非结果集的返回值
                     ResultSet rs=cs.executeQuery(); // 获得结果集的返回值
                        while(rs.next()){
                             
                            String ddd =rs.getString(1);
                            System.out.println("订单号："+ddd);
                      }
                     return current_id;
               }
          });
        System.out.println("我显示的是："+cur_id);
         return cur_id;
    }