All pastes #715860 Raw Edit

Anonym

public text v1 · immutable
#715860 ·published 2007-09-26 15:03 UTC
rendered paste body
   public Vector getCalendars (String uid) throws SQLException {
    
    Connection con = null;
    Statement stmt = null;
    ResultSet rs = null;
            //vector which will be returned
            Vector calendarVector = new Vector();
    try {
            synchronized(this) {
                //SQL query to get folderId, folderName, folderOwner and folderRights
                String sqlQuery = "SELECT oxfolder_tree.fuid, oxfolder_tree.fname, oxfolder_tree.owner," +
                        "oxfolder_permissions.odp from oxfolder_permissions, oxfolder_tree WHERE " + 
                        "oxfolder_permissions.entity='"+ uid + "' AND oxfolder_permissions.odp!='0' " + 
                        "AND oxfolder_tree.module='calendar' AND oxfolder_tree.fuid=oxfolder_permissions.pid";
                
                //get database connection
                con = oxdb.getConnection();
                // create statement
                stmt = con.createStatement();
                // get data from database
                rs = stmt.executeQuery(sqlQuery);
                // create Calendar-objects for each result and add it to vector
                while (rs.next()) {
                    calendarVector.addElement(new drfox.logic.Calendar(rs.getInt("fuid"),rs.getString("fname"),
                            rs.getString("owner"),rs.getInt("odp"))); 
                }     
            }
           
            return calendarVector;
           
        } catch (SQLException e) {
            // Andere Exception werfen, wegen Adapterkapselung
          
            // throw new DBInterneZugriffException("Beim Lesen aus der Datenbank ist ein Fehler aufgetreten.");
            System.out.println("Error while reading database!");
			e.printStackTrace();
        } finally {
            //close all connections, statements and resultsets
            this.closeAll(con, stmt, rs);
        }
        return calendarVector;
   }