@Autowired
    @Qualifier("jdbcTemplate")
    private JdbcTemplate jdbcTemplate;
　　@SuppressWarnings("unchecked")
    public Integer GetSerNo() {   
          Integer param2Value =  jdbcTemplate.execute(   
             new CallableStatementCreator() {   
                public CallableStatement createCallableStatement(Connection con) throws SQLException {   
                   String storedProc = "{call getSNo(?,?)}";// 调用的sql   
                   CallableStatement cs = con.prepareCall(storedProc);   
                   cs.setString(1, sno);// 设置输入参数的值   
                   cs.registerOutParameter(2, java.sql.Types.INTEGER);
                   return cs;   
                }   
             }, new CallableStatementCallback() {   
                 public Object doInCallableStatement(CallableStatement cs) throws SQLException, DataAccessException {   
                   cs.execute();   
                   return cs.getInt(2);// 获取输出参数的值   
             }   
          }); 
          return param2Value;
        }