• Spring jdbc call oralce procedure or function


    1. spring jdbc call oralce procedure:
    final String callFunctionSql = "{call SP_Test(?,?,?)}";  
            
            List<SqlParameter> params = new ArrayList<SqlParameter>();  
            params.add(new SqlParameter(Types.INTEGER));  
            params.add(new SqlReturnResultSet("result",  
                    new ResultSetExtractor<Integer>() {  
                @Override  
                public Integer extractData(ResultSet rs) throws SQLException,DataAccessException {  
                    while(rs.next()) {  
                        return rs.getInt(1);  
                    }  
                   return 0;  
            }})); 
            
            Map<String,Object> map =  getJdbcTemplate().call(new CallableStatementCreator()
            {
    
                @Override
                public CallableStatement createCallableStatement(Connection conn) throws SQLException
                {
                    CallableStatement cstmt = conn.prepareCall(callFunctionSql);  
                    cstmt.setInt(1, 2);
                    cstmt.setInt(2, 16);
                    cstmt.setInt(3, 10);
                    return cstmt;  
                }
                
            }, params);
            
    

    2.Spring jdbc call oracle function

    String i = getJdbcTemplate().execute("{?=call FN_UPDATE_BUSINESS_UNIT(?,?,?)}", new CallableStatementCallback<String>() {
                    public String doInCallableStatement(CallableStatement cs) throws SQLException, DataAccessException {
                        cs.registerOutParameter(1, java.sql.Types.VARCHAR);
                        cs.setInt(2, 2);
                        cs.setInt(3, 16);
                        cs.setInt(4, 8);
                        cs.execute();
                        return cs.getString(1);
                    }
                });



  • 相关阅读:
    WebXml.com.cn 中国股票行情数据 WEB 服务(支持深圳和上海股市的全部基金、债券和股票),数据即时更新
    新浪股票接口AndroidSDK
    Java Applet使用
    Java反射机制
    Java中HashMap排序
    C#委托和事件
    Java操作XML
    迭代器模式
    C# 天气预报
    ptypes中string类的空间分配
  • 原文地址:https://www.cnblogs.com/xue88ming/p/7183010.html
Copyright © 2020-2023  润新知