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

        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

    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

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

View Full Code Here

    public boolean initBeanList(DBCommand cmd)
    {
        DBReader reader = new DBReader();
        try {
            // Open Suppier Reader
            if (!reader.open(cmd, action.getConnection() ))
            {   return error(reader);
            }
            // Move to desired Position
            int first = this.getFirstItemIndex();
            if (first>0 && !reader.skipRows(first))

View Full Code Here

        }


        cmd.where(comp);


        DBReader reader = new DBReader();
        reader.open(cmd, conn);
        List<Employee> lst = reader.getBeanList(Employee.class);
        return lst;
    }


    public List<Department> getDepartments()

View Full Code Here

    {
        DBCommand cmd = db.createCommand();
        cmd.select(T_DEP.getColumns());


        DBReader reader = new DBReader();
        reader.open(cmd, conn);
        return reader.getBeanList(Department.class);
    }


    public Employee createEmmployee()
    {

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(type)
      {
          case BeanList:

View Full Code Here


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

View Full Code Here

        try
        {
            // Open Reader
            System.out.println("Running Query:");
            System.out.println(cmd.getSelect());
            if (reader.open(cmd, conn) == false)
                throw new RuntimeException(reader.getErrorMessage());
            // Print output
            DBRecord record = new DBRecord();
            while (reader.moveNext())
            {

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.