java_DB2

最新推荐文章于 2024-09-21 10:38:43 发布
最新推荐文章于 2024-09-21 10:38:43 发布
阅读量605 收藏
点赞数
分类专栏： Oracle/DB2 java 文章标签： java string exception jdbc integer null
Oracle/DB2 同时被 2 个专栏收录
145 篇文章 0 订阅
订阅专栏
java
107 篇文章 1 订阅
订阅专栏 
// ----------------------------------------------------------
// ---                                                    ---
// ---     FILE:    HTM_JAVA.HTML                         ---
// ---     AUTHOR:  G.BIRCHALL                            ---
// ---     DATE:    13/SEP/2006                           ---
// ---     NOTES:   Below is some very basic java code    ---
// ---              that demonstrates the use of simple   ---
// ---              DB2 user-defined functions to run     ---
// ---              SQL within SQL.  There are three      ---
// ---              types of function:                    ---
// ---                                                    ---
// ---               - Scalar functions – that return a   ---
// ---                 single value (different types).    ---
// ---               - Table functions – that return a    ---
// ---                 single column of data (different   ---
// ---                 data types), plus an INTEGER row-  ---
// ---                 number value.                      ---
// ---               - Table functions – that return more ---
// ---                 one column of data (VARCHAR only), ---
// ---                 plus an INTEGER row-number value.  ---
// ---                                                    ---
// ---     USAGE NOTES:                                   ---
// ---     #1  Save this file on your own machine.        ---
// ---     #2  Remove the few lines of HTML code at the   ---
// ---         top and bottom of this file.               ---
// ---     #3  Rename the file "Graeme1java".             ---
// ---     #4  Compile the java code:                     ---
// ---         javac Graeme1java                          ---
// ---     #5  Copy the generated Graeme1.class file to   ---
// ---         the relevant "jar" directory.              ---
// ---     #6  Create the matching DB2 user-defined       ---
// ---         functions (see: HTM_JSQL.HTM).             ---
// ---     #7  You are ready to go.  If they don't work,  ---
// ---         don't ask me, because I don't know much    ---
// ---         about java and DB2.                        ---
// ---                                                    ---
// ---     NOTE: I have defined the tabular functions     ---
// ---     to ignore columns of certain types and all     ---
// ---     columns longer than 254 bytes. Change this     ---
// ---     as you wish. Make sure to change the CREATE    ---
// ---     FUNCTION code to match.                        ---
// ---                                                    ---
// ----------------------------------------------------------

import java.lang.*;
import COM.ibm.db2.app.*;
import java.sql.*;
import java.math.*;
import java.io.*;

public class Graeme1 extends UDF {


  // --------------------------------------------------------
  // ---     SINGLE-DATA-VALUE SCALAR FUNCTIONS           ---
  // ---                                                  ---
  // ---     These functions accept a SQL stmt (query) as ---
  // ---     input.  The query is executed and the first  ---
  // ---     column and row fetched is returned to DB2.   ---
  // ---     All other columns and rows are ignored.      ---
  // ---                                                  ---
  // ---     There is one function per data-type:         ---
  // ---       - SMALLINT                                 ---
  // ---       - INTEGER                                  ---
  // ---       - BIGINT                                   ---
  // ---       - DOUBLE                                   ---
  // ---       - DECIMAL                                  ---
  // ---       - VARCHAR                                  ---
  // ---                                                  ---
  // --------------------------------------------------------


  public void get_Smallint(String inStmt,
                           short  outValue)
  throws Exception {
    try {
      Connection         con = DriverManager.getConnection
                               ("jdbc:default:connection");
      PreparedStatement stmt = con.prepareStatement(inStmt);
      ResultSet           rs = stmt.executeQuery();
      if (rs.next() == true  &&  rs.getString(1) != null) {
        set(2, rs.getShort(1));
      }
      rs.close();
      stmt.close();
      con.close();
    }
    catch (SQLException sqle) {
      setSQLstate("38999");
      setSQLmessage("SQLCODE = " + sqle.getSQLState());
      return;
    }
  }


  public void get_Integer(String inStmt,
                          int    outValue)
  throws Exception {
    try {
      Connection         con = DriverManager.getConnection
                               ("jdbc:default:connection");
      PreparedStatement stmt = con.prepareStatement(inStmt);
      ResultSet           rs = stmt.executeQuery();
      if (rs.next() == true  &&  rs.getString(1) != null) {
        set(2, rs.getInt(1));
      }
      rs.close();
      stmt.close();
      con.close();
    }
    catch (SQLException sqle) {
      setSQLstate("38999");
      setSQLmessage("SQLCODE = " + sqle.getSQLState());
      return;
    }
  }


  public void get_Bigint(String inStmt,
                         long   outValue)
  throws Exception {
    try {
      Connection         con = DriverManager.getConnection
                               ("jdbc:default:connection");
      PreparedStatement stmt = con.prepareStatement(inStmt);
      ResultSet           rs = stmt.executeQuery();
      if (rs.next() == true  &&  rs.getString(1) != null) {
        set(2, rs.getLong(1));
      }
      rs.close();
      stmt.close();
      con.close();
    }
    catch (SQLException sqle) {
      setSQLstate("38999");
      setSQLmessage("SQLCODE = " + sqle.getSQLState());
      return;
    }
  }


  public void get_Double(String inStmt,
                         double outValue)
  throws Exception {
    try {
      Connection         con = DriverManager.getConnection
                               ("jdbc:default:connection");
      PreparedStatement stmt = con.prepareStatement(inStmt);
      ResultSet           rs = stmt.executeQuery();
      if (rs.next() == true  &&  rs.getString(1) != null) {
        set(2, rs.getDouble(1));
      }
      rs.close();
      stmt.close();
      con.close();
    }
    catch (SQLException sqle) {
      setSQLstate("38999");
      setSQLmessage("SQLCODE = " + sqle.getSQLState());
      return;
    }
  }


  public void get_Decimal(String  inStmt,
                          BigDecimal outValue)
  throws Exception {
    try {
      Connection         con = DriverManager.getConnection
                               ("jdbc:default:connection");
      PreparedStatement stmt = con.prepareStatement(inStmt);
      ResultSet           rs = stmt.executeQuery();
      if (rs.next() == true  &&  rs.getString(1) != null) {
        set(2, rs.getBigDecimal(1));
      }
      rs.close();
      stmt.close();
      con.close();
    }
    catch (SQLException sqle) {
      setSQLstate("38999");
      setSQLmessage("SQLCODE = " + sqle.getSQLState());
      return;
    }
  }


  public void get_Varchar(String inStmt,
                          String outValue)
  throws Exception {
    try {
      Connection         con = DriverManager.getConnection
                               ("jdbc:default:connection");
      PreparedStatement stmt = con.prepareStatement(inStmt);
      ResultSet           rs = stmt.executeQuery();
      if (rs.next() == true  &&  rs.getString(1) != null) {
        set(2, rs.getString(1));
      }
      rs.close();
      stmt.close();
      con.close();
    }
    catch (SQLException sqle) {
      setSQLstate("38999");
      setSQLmessage("SQLCODE = " + sqle.getSQLState());
      return;
    }
  }


  // --------------------------------------------------------
  // ---     SINGLE-DATA-COLUMN TABLE FUNCTIONS           ---
  // ---                                                  ---
  // ---     These functions accept a SQL stmt (query) as ---
  // ---     input.  The query is executed and the first  ---
  // ---     column of data (all rows) is returned.  Any  ---
  // ---     other columns are ignored.                   ---
  // ---                                                  ---
  // ---     There is one function per data-type:         ---
  // ---       - SMALLINT                                 ---
  // ---       - INTEGER                                  ---
  // ---       - BIGINT                                   ---
  // ---       - DOUBLE                                   ---
  // ---       - DECIMAL                                  ---
  // ---       - VARCHAR                                  ---
  // ---                                                  ---
  // --------------------------------------------------------


  Connection        con;
  Statement         stmt;
  ResultSet         rs;
  ResultSetMetaData rsmtadta;
  int               rowNum;
  int               i;
  int               outLength;
  short             colNum;
  int               colCount;
  String[] colName  = new String[1100];
  String[] colType  = new String[1100];
  int[]    colSize  = new int[1100];


  public void tab_Smallint(String inStmt,
                           int    outNumber,
                           short  outValue)
  throws Exception {
    switch (getCallType()) {
      case SQLUDF_TF_FIRST:
        break;
      case SQLUDF_TF_OPEN:
        rowNum = 1;
        try {
          con  = DriverManager.getConnection
                 ("jdbc:default:connection");
          stmt = con.createStatement();
          rs   = stmt.executeQuery(inStmt);
        }
        catch(SQLException sqle) {
          setSQLstate("38999");
          setSQLmessage("SQLCODE = " + sqle.getSQLState());
          return;
        }
        break;
      case SQLUDF_TF_FETCH:
        if (rs.next() == true) {
          set(2, rowNum);
          if (rs.getString(1) != null) {
            set(3, rs.getShort(1));
          }
          rowNum++;
        }
        else {
          setSQLstate ("02000");
        }
        break;
      case SQLUDF_TF_CLOSE:
        rs.close();
        stmt.close();
        con.close();
        break;
      case SQLUDF_TF_FINAL:
        break;
    }
  }


  public void tab_Integer(String inStmt,
                          int    outNumber,
                          int    outValue)
  throws Exception {
    switch (getCallType()) {
      case SQLUDF_TF_FIRST:
        break;
      case SQLUDF_TF_OPEN:
        rowNum = 1;
        try {
          con  = DriverManager.getConnection
                 ("jdbc:default:connection");
          stmt = con.createStatement();
          rs   = stmt.executeQuery(inStmt);
        }
        catch(SQLException sqle) {
          setSQLstate("38999");
          setSQLmessage("SQLCODE = " + sqle.getSQLState());
          return;
        }
        break;
      case SQLUDF_TF_FETCH:
        if (rs.next() == true) {
          set(2, rowNum);
          if (rs.getString(1) != null) {
            set(3, rs.getInt(1));
          }
          rowNum++;
        }
        else {
          setSQLstate ("02000");
        }
        break;
      case SQLUDF_TF_CLOSE:
        rs.close();
        stmt.close();
        con.close();
        break;
      case SQLUDF_TF_FINAL:
        break;
    }
  }


  public void tab_Bigint(String inStmt,
                         int    outNumber,
                         long   outValue)
  throws Exception {
    switch (getCallType()) {
      case SQLUDF_TF_FIRST:
        break;
      case SQLUDF_TF_OPEN:
        rowNum = 1;
        try {
          con  = DriverManager.getConnection
                 ("jdbc:default:connection");
          stmt = con.createStatement();
          rs   = stmt.executeQuery(inStmt);
        }
        catch(SQLException sqle) {
          setSQLstate("38999");
          setSQLmessage("SQLCODE = " + sqle.getSQLState());
          return;
        }
        break;
      case SQLUDF_TF_FETCH:
        if (rs.next() == true) {
          set(2, rowNum);
          if (rs.getString(1) != null) {
            set(3, rs.getLong(1));
          }
          rowNum++;
        }
        else {
          setSQLstate ("02000");
        }
        break;
      case SQLUDF_TF_CLOSE:
        rs.close();
        stmt.close();
        con.close();
        break;
      case SQLUDF_TF_FINAL:
        break;
    }
  }


  public void tab_Double(String inStmt,
                         int    outNumber,
                         double outValue)
  throws Exception {
    switch (getCallType()) {
      case SQLUDF_TF_FIRST:
        break;
      case SQLUDF_TF_OPEN:
        rowNum = 1;
        try {
          con  = DriverManager.getConnection
                 ("jdbc:default:connection");
          stmt = con.createStatement();
          rs   = stmt.executeQuery(inStmt);
        }
        catch(SQLException sqle) {
          setSQLstate("38999");
          setSQLmessage("SQLCODE = " + sqle.getSQLState());
          return;
        }
        break;
      case SQLUDF_TF_FETCH:
        if (rs.next() == true) {
          set(2, rowNum);
          if (rs.getString(1) != null) {
            set(3, rs.getDouble(1));
          }
          rowNum++;
        }
        else {
          setSQLstate ("02000");
        }
        break;
      case SQLUDF_TF_CLOSE:
        rs.close();
        stmt.close();
        con.close();
        break;
      case SQLUDF_TF_FINAL:
        break;
    }
  }


  public void tab_Decimal(String     inStmt,
                          int        outNumber,
                          BigDecimal outValue)
  throws Exception {
    switch (getCallType()) {
      case SQLUDF_TF_FIRST:
        break;
      case SQLUDF_TF_OPEN:
        rowNum = 1;
        try {
          con  = DriverManager.getConnection
                 ("jdbc:default:connection");
          stmt = con.createStatement();
          rs   = stmt.executeQuery(inStmt);
        }
        catch(SQLException sqle) {
          setSQLstate("38999");
          setSQLmessage("SQLCODE = " + sqle.getSQLState());
          return;
        }
        break;
      case SQLUDF_TF_FETCH:
        if (rs.next() == true) {
          set(2, rowNum);
          if (rs.getString(1) != null) {
            set(3, rs.getBigDecimal(1));
          }
          rowNum++;
        }
        else {
          setSQLstate ("02000");
        }
        break;
      case SQLUDF_TF_CLOSE:
        rs.close();
        stmt.close();
        con.close();
        break;
      case SQLUDF_TF_FINAL:
        break;
    }
  }


  public void tab_Varchar(String inStmt,
                          int    outNumber,
                          String outValue)
  throws Exception {
    switch (getCallType()) {
      case SQLUDF_TF_FIRST:
        break;
      case SQLUDF_TF_OPEN:
        rowNum = 1;
        try {
          con  = DriverManager.getConnection
                 ("jdbc:default:connection");
          stmt = con.createStatement();
          rs   = stmt.executeQuery(inStmt);
        }
        catch(SQLException sqle) {
          setSQLstate("38999");
          setSQLmessage("SQLCODE = " + sqle.getSQLState());
          return;
        }
        break;
      case SQLUDF_TF_FETCH:
        if (rs.next() == true) {
          set(2, rowNum);
          if (rs.getString(1) != null) {
            set(3, rs.getString(1));
          }
          rowNum++;
        }
        else {
          setSQLstate ("02000");
        }
        break;
      case SQLUDF_TF_CLOSE:
        rs.close();
        stmt.close();
        con.close();
        break;
      case SQLUDF_TF_FINAL:
        break;
    }
  }


  // --------------------------------------------------------
  // ---     MULTI-DATA-COLUMN (VARCHAR) TABLE FUNCTIONS  ---
  // ---                                                  ---
  // ---     These functions accept a SQL stmt (query) as ---
  // ---     input.  The query is executed and the first  ---
  // ---     "n" columns of data (all rows) is returned.  ---
  // ---     Any other columns are ignored.               ---
  // ---                                                  ---
  // ---     All columns are converted to VARCHAR. Those  ---
  // ---     that cannot be converted are set to null.    ---
  // ---                                                  ---
  // ---     The number of columns returned is:           ---
  // ---       - 2                                        ---
  // ---       - 5                                        ---
  // ---       - 10                                       ---
  // ---                                                  ---
  // --------------------------------------------------------


  public void tab_2Varchar(String inStmt,
                           short  numColumns,
                           int    rowNumber,
                           String outValue01,
                           String outValue02)
  throws Exception {
    switch (getCallType()) {
      case SQLUDF_TF_FIRST:
        break;
      case SQLUDF_TF_OPEN:
        try {
          rowNum   = 0;
          con      = DriverManager.getConnection
                     ("jdbc:default:connection");
          stmt     = con.createStatement();
          rs       = stmt.executeQuery(inStmt);
          rsmtadta = rs.getMetaData();
          colCount = rsmtadta.getColumnCount();
          if (colCount > 2) {
            colCount = 2;
          }
          for (i=1; i <= colCount; i++) {
            colType[i] = rsmtadta.getColumnTypeName(i);
            colSize[i] = rsmtadta.getColumnDisplaySize(i);
          }
        }
        catch(SQLException sqle) {
          setSQLstate("38999");
          setSQLmessage("SQLCODE = " + sqle.getSQLState());
          return;
        }
        break;
      case SQLUDF_TF_FETCH:
        rowNum++;
        if (rs.next() == true) {
          int i;
          set(2, (short)colCount);
          set(3, rowNum);
          for (i=1; i<=colCount; i++) {
            if (colType[i].equals("XML")         || 
                colType[i].equals("BLOB")        ||
                colType[i].equals("CLOB")        ||
                colType[i].equals("DBLOB")       ||
                colType[i].equals("GRAPHIC")     ||
                colType[i].equals("VARGRAPHIC")  ||
                colSize[i] > 254                 ||
                rs.getString(i) == null) {
              // DON'T DISPLAY THIS VALUE
              return;
            }
            else {
              // DISPLAY THIS COLUMN VALUE
              set(i+3, rs.getString(i));
            }
          }
        }
        else {
          setSQLstate ("02000");
        }
        break;
      case SQLUDF_TF_CLOSE:
        rs.close();
        stmt.close();
        con.close();
        break;
      case SQLUDF_TF_FINAL:
        break;
    }
  }


  public void tab_5Varchar(String inStmt,
                           short  numColumns,
                           int    rowNumber,
                           String outValue01,
                           String outValue02,
                           String outValue03,
                           String outValue04,
                           String outValue05)
  throws Exception {
    switch (getCallType()) {
      case SQLUDF_TF_FIRST:
        break;
      case SQLUDF_TF_OPEN:
        try {
          rowNum   = 0;
          con      = DriverManager.getConnection
                     ("jdbc:default:connection");
          stmt     = con.createStatement();
          rs       = stmt.executeQuery(inStmt);
          rsmtadta = rs.getMetaData();
          colCount = rsmtadta.getColumnCount();
          if (colCount > 5) {
            colCount = 5;
          }
          for (i=1; i <= colCount; i++) {
            colType[i] = rsmtadta.getColumnTypeName(i);
            colSize[i] = rsmtadta.getColumnDisplaySize(i);
          }
        }
        catch(SQLException sqle) {
          setSQLstate("38999");
          setSQLmessage("SQLCODE = " + sqle.getSQLState());
          return;
        }
        break;
      case SQLUDF_TF_FETCH:
        rowNum++;
        if (rs.next() == true) {
          int i;
          set(2, (short)colCount);
          set(3, rowNum);
          for (i=1; i<=colCount; i++) {
            if (colType[i].equals("XML")         || 
                colType[i].equals("BLOB")        ||
                colType[i].equals("CLOB")        ||
                colType[i].equals("DBLOB")       ||
                colType[i].equals("GRAPHIC")     ||
                colType[i].equals("VARGRAPHIC")  ||
                colSize[i] > 254                 ||
                rs.getString(i) == null) {
              // DON'T DISPLAY THIS VALUE
              return;
            }
            else {
              // DISPLAY THIS COLUMN VALUE
              set(i+3, rs.getString(i));
            }
          }
        }
        else {
          setSQLstate ("02000");
        }
        break;
      case SQLUDF_TF_CLOSE:
        rs.close();
        stmt.close();
        con.close();
        break;
      case SQLUDF_TF_FINAL:
        break;
    }
  }


  public void tab_10Varchar(String inStmt,
                            short  numColumns,
                            int    rowNumber,
                            String outValue01,
                            String outValue02,
                            String outValue03,
                            String outValue04,
                            String outValue05,
                            String outValue06,
                            String outValue07,
                            String outValue08,
                            String outValue09,
                            String outValue10)
  throws Exception {
    switch (getCallType()) {
      case SQLUDF_TF_FIRST:
        break;
      case SQLUDF_TF_OPEN:
        try {
          rowNum   = 0;
          con      = DriverManager.getConnection
                     ("jdbc:default:connection");
          stmt     = con.createStatement();
          rs       = stmt.executeQuery(inStmt);
          rsmtadta = rs.getMetaData();
          colCount = rsmtadta.getColumnCount();
          if (colCount > 10) {
            colCount = 10;
          }
          for (i=1; i <= colCount; i++) {
            colType[i] = rsmtadta.getColumnTypeName(i);
            colSize[i] = rsmtadta.getColumnDisplaySize(i);
          }
        }
        catch(SQLException sqle) {
          setSQLstate("38999");
          setSQLmessage("SQLCODE = " + sqle.getSQLState());
          return;
        }
        break;
      case SQLUDF_TF_FETCH:
        rowNum++;
        if (rs.next() == true) {
          int i;
          set(2, (short)colCount);
          set(3, rowNum);
          for (i=1; i<=colCount; i++) {
            if (colType[i].equals("XML")         || 
                colType[i].equals("BLOB")        ||
                colType[i].equals("CLOB")        ||
                colType[i].equals("DBLOB")       ||
                colType[i].equals("GRAPHIC")     ||
                colType[i].equals("VARGRAPHIC")  ||
                colSize[i] > 254                 ||
                rs.getString(i) == null) {
              // DON'T DISPLAY THIS VALUE
              return;
            }
            else {
              // DISPLAY THIS COLUMN VALUE
              set(i+3, rs.getString(i));
            }
          }
        }
        else {
          setSQLstate ("02000");
        }
        break;
      case SQLUDF_TF_CLOSE:
        rs.close();
        stmt.close();
        con.close();
        break;
      case SQLUDF_TF_FINAL:
        break;
    }
  }


  // --------------------------------------------------------
  // ---     TRANSPOSE QUERY OUTPUT COLUMNS INTO ROWS     ---
  // ---                                                  ---
  // ---     These function accepts a SQL stmt (query) as ---
  // ---     input.  The query is executed and the output ---
  // ---     is transposed such that each column/row item ---
  // ---     becomes a row of output.                     ---
  // ---                                                  ---
  // ---     The output row has the following columns:    ---
  // ---       - row_number (of row fetched).             ---
  // ---       - num_columns (in query result).           ---
  // ---       - column_number (within row).              ---
  // ---       - column_name (if provided).               ---
  // ---       - column_type (source DB2 type).           ---
  // ---       - column_length (of column, not value).    ---
  // ---       - column_value (converted to VARCHAR).     ---
  // ---                                                  ---
  // ---     Two sample functions are provided:           ---
  // ---       - Return data up to 254 bytes long.        ---
  // ---       - Return data up to 4000 bytes long.       ---
  // ---     Columns that are longer than the max length, ---
  // ---     or of type XML, BLOB, CLOB, etc. are simply  ---
  // ---     ignored.  A null value is returned.          ---
  // ---                                                  ---
  // --------------------------------------------------------


  public void writeRow()
  throws Exception {
    set(2, rowNum);
    set(3, (short) colCount);
    set(4, colNum);
    set(5, colName[colNum]);
    set(6, colType[colNum]);
    set(7, colSize[colNum]);
    if (colType[colNum].equals("XML")         || 
        colType[colNum].equals("BLOB")        ||
        colType[colNum].equals("CLOB")        ||
        colType[colNum].equals("DBLOB")       ||
        colType[colNum].equals("GRAPHIC")     ||
        colType[colNum].equals("VARGRAPHIC")  ||
        colSize[colNum] > outLength) {
      // DON'T DISPLAY THIS VALUE
      return;
    }
    else if (rs.getString(colNum) !=  null) {
      // DISPLAY THIS COLUMN VALUE
      set(8, rs.getString(colNum));
    }
  }


  public void tab_Transpose(String inStmt
                           ,int    rowNumber
                           ,short  numColumns
                           ,short  outColNumber
                           ,String outColName
                           ,String outColtype
                           ,int    outColSize
                           ,String outColValue)
  throws Exception {
    switch (getCallType()) {
      case SQLUDF_TF_FIRST:
        break;
      case SQLUDF_TF_OPEN:
        try {
          con      = DriverManager.getConnection
                     ("jdbc:default:connection");
          stmt     = con.createStatement();
          rs       = stmt.executeQuery(inStmt);
          // GET COLUMN NAMES
          rsmtadta = rs.getMetaData();
          colCount = rsmtadta.getColumnCount();
          for (i=1; i <= colCount; i++) {
            colName[i] = rsmtadta.getColumnName(i);
            colType[i] = rsmtadta.getColumnTypeName(i);
            colSize[i] = rsmtadta.getColumnDisplaySize(i);
          }
          rowNum    = 1;
          colNum    = 1;
          outLength = 254;
        }
        catch(SQLException sqle) {
          setSQLstate("38999");
          setSQLmessage("SQLCODE = " + sqle.getSQLState());
          return;
        }
        break;
      case SQLUDF_TF_FETCH:
        if (colNum == 1 && rs.next() == true) {
          writeRow();
          colNum++;
          if (colNum > colCount) {
            colNum = 1; 
            rowNum++;
          }
        }
        else if (colNum > 1 && colNum <= colCount) {
          writeRow();
          colNum++;
          if (colNum > colCount) {
            colNum = 1; 
            rowNum++;
          }
        } 
        else {
          setSQLstate ("02000");
        }
        break;
      case SQLUDF_TF_CLOSE:
        rs.close();
        stmt.close();
        con.close();
        break;
      case SQLUDF_TF_FINAL:
        break;
    }
  }


  public void tab_Transpose_4K(String inStmt
                              ,int    rowNumber
                              ,short  numColumns
                              ,short  outColNumber
                              ,String outColName
                              ,String outColtype
                              ,int    outColSize
                              ,String outColValue)
  throws Exception {
    switch (getCallType()) {
      case SQLUDF_TF_FIRST:
        break;
      case SQLUDF_TF_OPEN:
        try {
          con      = DriverManager.getConnection
                     ("jdbc:default:connection");
          stmt     = con.createStatement();
          rs       = stmt.executeQuery(inStmt);
          // GET COLUMN NAMES
          rsmtadta = rs.getMetaData();
          colCount = rsmtadta.getColumnCount();
          for (i=1; i <= colCount; i++) {
            colName[i] = rsmtadta.getColumnName(i);
            colType[i] = rsmtadta.getColumnTypeName(i);
            colSize[i] = rsmtadta.getColumnDisplaySize(i);
          }
          rowNum    = 1;
          colNum    = 1;
          outLength = 4000;
        }
        catch(SQLException sqle) {
          setSQLstate("38999");
          setSQLmessage("SQLCODE = " + sqle.getSQLState());
          return;
        }
        break;
      case SQLUDF_TF_FETCH:
        if (colNum == 1 && rs.next() == true) {
          writeRow();
          colNum++;
          if (colNum > colCount) {
            colNum = 1; 
            rowNum++;
          }
        }
        else if (colNum > 1 && colNum <= colCount) {
          writeRow();
          colNum++;
          if (colNum > colCount) {
            colNum = 1; 
            rowNum++;
          }
        } 
        else {
          setSQLstate ("02000");
        }
        break;
      case SQLUDF_TF_CLOSE:
        rs.close();
        stmt.close();
        con.close();
        break;
      case SQLUDF_TF_FINAL:
        break;
    }
  }
}


 
junli0310
关注
专栏目录
db2函数调用java_db2触发器调用JAVA程序样例.doc
weixin_30359265的博客
03-03 300
DB2触发器调用JAVA程序步骤1.通过eclipse创逮一个Java Project.如K图所示: ￡ Java - Eclipse PlatformFile Edit Refactor Run Source Navigate Search Project Window HelpNewAlt+Shift+NJava ProjectCloseCtrl+WClose AllCtrl+Shift+WS...
db2存储过程调用java_db2使用Java存储过程实现MD5函数
weixin_39981360的博客
02-12 291
1.数据库版本2.Java脚本importjava.security.MessageDigest;importCOM.ibm.db2.app.UDF;public class MD5UDF extendsUDF {public staticString MD5(String s) {String s1= new String("");char hexDigits[] = { '0', '1', '...
db2 自定义java_DB2基于JAVA的自定义函数(user-defined-function)示例
weixin_28999945的博客
02-23 316
DB2基于JAVA的自定义函数(user-defined-function)示例, 作用是返回两个数的和。测试环境：$ db2levelDB21085I This instance or install (instance name, where applicable: "e105q5a")uses "64" bits and DB2 code release "SQL10055" with l...
db2 自定义java_DB2通过java代码生成自定义uuid()函数
weixin_31975737的博客
02-19 314
一、简单的方法此种方法在快速大量生成时，会有重复SELECT concat (hex (RAND ()), hex (RAND ())) as uuid FROM SYSIBM.SYSDUMMY1; --32位大写select lower(hex(RAND())||hex(RAND())) as uuid from sysibm.sysdummy1;--32位小写二、自定函数，调用java生成uu...
db2存储过程调用java_DB2 使用java存储过程，如何使存储过程中使用Axis
weixin_34746495的博客
02-21 145
DB2 使用java存储过程，class要用Axis调用接口可以吗？，我将要用的jar(activation.jar、ant-1.8.2.jar、axis.jar、commons-discovery-0.2.jar、commons-logging-1.1.3.jar、jaxrpc.jar、log4j-1.2.15.jar、mail-1.4.jar、wsdl4j-1.6.3.jar)都打包到一个ja...
timestamp相减的函数 java_DB2中TIMESTAMP字段的计算
weixin_39743603的博客
03-02 553
以下内容是对《DB2 基础: 日期和时间的使用》的内容进行的摘要与精练。遗憾的是，本文参考的原文已经被IBM DeveloperWorks删掉了，暂时还没找到。1、在SQL中使用DB2中的寄存器获取数据库服务器当前时间戳SELECTcurrentdateFROMsysibm.sysdummy1SELECTcurrenttimeFROMsysibm.sysdummy1SELECTc...
db2 bigint java_DB2 字段类型 — SMALLINT (小整型) INTEGER (整型) BIGINT(大整型) | 学步园...
weixin_36042403的博客
02-28 974
说明：小整型是两个字节的整数，精度为 5 位。小整型的范围从 -32,768 到 32,767。增加字段：ALTER TABLE ADD COLUMN smallint修改字段类型：ALTER TABLE ALTER SET DATA TYPE smallint删除字段：ALTER TABLE DROP 验证字段范围：insert into aaa(ddd) values(-327...
java导出db2_DB2 导出表数据
weixin_39544333的博客
02-16 365
db2 => connect to testdb user db2inst1 using thepasswd以DEL格式导出：db2 => export to /home/backup/mytbl.txt of del select * from mytbl以IXF格式导出：db2 => export to /home/backup/mytbl.ixf of ixf select...
db2java_java 连接 db2
weixin_42511373的博客
02-22 132
classpath中有db2java，文件在dos黑屏下编译，执行可以完成，在eclipse上导入了db2java.zip。一直执行失败，如下Unabletoconnectionjava.sql.SQLException:Nosuitabledriveratjava.sq...classpath中有db2java，文件在dos黑屏下编译，执行可以完成，在eclipse上导入了db2java.zip...
java 查询db2_DB2查询语句
weixin_34034295的博客
02-19 366
VALUE:WITH AA AS(select a499.MERCHANT_ID,a499.TERMINAL_ID,a499.trans_date,count(*) as count_num,SUM(a499.trans_amount) as count_sumfrom DBAT.DTATA499 a499where a499.MERCHANT_ID IS NOT NULL and a499.IN...
squirrel-sql-2.0final-install.zip_db2_java db2_java sql_squirrel
09-23
标题中的“squirrel-sql-2.0final-install.zip_db2_java db2_java sql_squirrel”指的是SQuirrel SQL Client的2.0最终版本，它是一个基于Java开发的数据库管理工具，尤其适用于DB2和Java环境。SQuirrel SQL能够连接...
db_driver.rar_Java DB2 Driver_db2java.jar_informix_java database
09-22
本文将深入探讨标题“db_driver.rar_Java DB2 Driver_db2java.jar_informix_java database”所涉及的知识点，包括Java数据库连接（JDBC）驱动、DB2 Java驱动(db2java.jar)、Informix数据库、Oracle数据库以及Java...
java_connection_db2_driver.zip
07-23
JavaWeb程序连接IBM DB2数据库通常需要依赖特定的驱动程序，这个`java_connection_db2_driver.zip`压缩包就包含了这样的驱动。在这个压缩包中，有两个关键的文件：`db2jcc4.jar`和`db2jcc_license_cu.jar`。 `db2...
db2jcc2_db2jcc4_db2_java_jar
02-08
总之，`db2jcc2_db2jcc4_db2_java_jar`这个压缩包包含的JAR文件是与DB2数据库进行Java编程的关键组件，它们使开发者能够在各种Java环境中安全、高效地访问和操作DB2数据库。正确理解和使用这些驱动，对于构建和维护...
AS400_DB2_SQL.rar_AS400 db2 sql mod_as400 db2 da_as400 sql_db2
09-23
"AS400_DB2_SQL.rar"这个压缩包显然包含了一些关于如何在AS400环境下的DB2中使用SQL进行数据操作和管理的详细资料。 在AS400中，DB2 SQL的使用涵盖了许多方面，例如： 1. **数据查询**：使用SELECT语句从数据库中...
Java企业面试题3
m0_74972727的博客
09-15 901
1. break和continue的作用(智*图) break：用于完全退出一个循环（如 for, while）或一个 switch 语句。当在循环体内遇到break语句时，程序会立即跳出当前循环体，继续执行循环之后的代码。 continue：用于跳过当前循环体中剩余的部分，并开始下一次循环。如果是在 for 循环中使用continue，则会直接进行条件判断以决定是否执行下一轮循环。 2. if分支语句和switch分支语句的异同之处(智*图) 相同点：都是用来根据不同的条件执行不同的代码块。
Arthas sysenv（查看JVM的环境变量）
最新发布
刘大猫
09-21 213
Arthas sysenv（查看JVM的环境变量）
JDK17新增语法特性
2201_76124988的博客
09-20 527
从springboot3.0开始，已经不支持JDK8，转变为JDK17参考资料：官方博客。
faiss安装 （CPU版本）
CSDN_WHB的博客
09-20 180
faiss版本 faiss-v1.7.4。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值