Examples of org.apache.empire.db.DBReader.open()

org.apache.empire.db.DBReader.open()
Opens the reader by executing the given SQL command.
After the reader is open, the reader's position is before the first record.
Use moveNext or iterator() to step through the rows.
Data of the current row can be accessed through the functions on the RecordData interface.

ATTENTION: After using the reader it must be closed using the close() method!
Use
```
try { ... } finally { reader.close(); } 
```
to make sure the reader is closed.

@param cmd the SQL-Command with cmd.getSelect() @param scrollable true if the reader should be scrollable or false if not @param conn a valid JDBC connection.

    try
        {
      // Open Reader
      System.out.println("Running Query:");
      System.out.println(cmd.getSelect());
      reader.open(cmd, conn);
      // Print output
      System.out.println("---------------------------------");
      switch(queryType)
      {
          case Reader:

View Full Code Here

    
    // read a value
    DBCommand cmd = db.createCommand();
    cmd.select(db.DATA.DATA);
    DBReader reader = new DBReader();
    reader.open(cmd, conn);
    while(reader.moveNext()){
      byte[] value = (byte[]) reader.getValue(db.DATA.DATA);
      Assert.assertArrayEquals(new byte[]{1,2,3}, value);
    }
    conn.close();

View Full Code Here

        return new EmpireDBException(e);
    }


    protected DBReader openReader(DBCommand cmd, Connection conn) {
        DBReader r = new DBReader();
        r.open(cmd, conn);
        return r;
    }


}

View Full Code Here

    public boolean initBeanList(DBCommand cmd)
    {
        DBReader reader = new DBReader();
        try {
            // Open Suppier Reader
            reader.open(cmd, action.getConnection());
            // Move to desired Position
            int first = this.getFirstItemIndex();
            if (first>0 && !reader.skipRows(first))
            {   // Page is not valid. Try again from beginning
                reader.close();

View Full Code Here

        
        OracleDataDictionnary dataDictionnary = new OracleDataDictionnary();
        DBReader rd = new DBReader();
        try
        {
            rd.open(sysDBCommand, conn);
            // read all
            log.info("---------------------------------------------------------------------------------");
            log.info("checkDatabase start: " + db.getClass().getName());
            String skipTable = "";
            while (rd.moveNext())

View Full Code Here

    try
        {
      // Open Reader
      System.out.println("Running Query:");
      System.out.println(cmd.getSelect());
      reader.open(cmd, conn);
      // Print output
      System.out.println("---------------------------------");
      switch(queryType)
      {
          case Reader:

View Full Code Here

                    queryCmd.limitRows(skipRows+maxItems);
                }
            }


            // DBReader.open immer nur innerhalb eines try {} finally {} blocks!
            r.open(queryCmd, getConnection(queryCmd));


            // get position from the session
            if (skipRows>0)
            {   // we are not at position 0, "skipping" entries
                r.skipRows(skipRows);

View Full Code Here


    int rowCount = 0;
    DBReader reader = new DBReader();
    try {
      System.err.println(cmd.getSelect());
      reader.open(cmd, conn);
      while (reader.moveNext()) {
        rowCount++;
        System.out.println(reader.getString(EMP.EMPLOYEE_ID) + "\t" + reader.getString(EMP.FIRSTNAME));
      }
    } finally {

View Full Code Here

            System.out.println("1. Query all females currently working in the production department");
            // Set command parameter values
            genderParam.setValue('F'); // set gender to female
            curDepParam.setValue(idProdDep); // set department id to production department
            // Open reader using a prepared statement (due to command parameters!)
            r.open(cmd, conn);
            // print all results
            System.out.println("Females working in the production department are:");
            while (r.moveNext())
                System.out.println("    " + r.getString(T_EMP.C_FULLNAME));
            r.close();

View Full Code Here

            System.out.println("2. Query all males currently working in the development department");
            // Set command parameter values
            genderParam.setValue('M'); // set gender to female
            curDepParam.setValue(idDevDep); // set department id to production department
            // Open reader using a prepared statement (due to command parameters!)
            r.open(cmd, conn);
            // print all results
            System.out.println("Males currently working in the development department are:");
            while (r.moveNext())
                System.out.println("    " + r.getString(T_EMP.C_FULLNAME));

View Full Code Here

0 1 2 3 4 5 6

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.