portletsdbmanager.java

java 写的一个新闻发布系统

//
//                                   ____.
//                       __/\ ______|    |__/\.     _______
//            __   .____|    |       \   |    +----+       \
//    _______|  /--|    |    |    -   \  _    |    :    -   \_________
//   \\______: :---|    :    :           |    :    |         \________>
//           |__\---\_____________:______:    :____|____:_____\
//                                      /_____|
//
//                 . . . i n   j a h i a   w e   t r u s t . . .
//
//--------------------------
// PortletsDBManager
//--------------------------
// Jerome Bedat 18.12.2000
//--------------------------

package jahiatemplates.org.jahia.portlets_api;

import java.sql.*;                              // ResultSet
import java.util.*;                             // Vector
import org.jahia.utils.*;                   // JahiaConsole
import org.jahia.registries.*;              // ServicesRegistry
import org.jahia.exceptions.JahiaException; // Jahia Exceptions
import org.jahia.services.database.*;       // DataBase Services


public class PortletsDBManager {

    private static PortletsDBManager    theObject = null;
    private DesktopObj                  theDesktop;
    private PortletObj                  thePortlet;
    private SkinObj                     theSkin;
    private int                         thePortletsCount;
    private int                         theDesktopsCount;



    /**
     * PortletsDBManager
     *
     * @author Jerome Bedat
     *
     */
	private PortletsDBManager()
	{
	    JahiaConsole.println( "PortletsDBManager", "***** Starting the Portlets DataBase Manager *****" );
	} // end constructor


    /**
     * getInstance
     *
     * @author Jerome Bedat
     *
     */
	public static synchronized PortletsDBManager getInstance()
	{
	    if (theObject == null) {
	        theObject = new PortletsDBManager();
	    }
	    return theObject;
	} // end getInstance


    /**
     * load_portlet_skin
     *
     * @author Jerome Bedat
     *
     */
	public SkinObj load_portlet_skin(int theID)
	throws JahiaException
	{
  		Connection dbConn = null;
  		Statement stmt = null;
  		ResultSet rs = null;

	    try {
	        String sqlQuery = "SELECT * FROM jahiatemplates_portet_skin WHERE (skin_id=" + theID + ")";
	        
	        dbConn = ServicesRegistry.getInstance().getDBPoolService().getConnection(87);
	        stmt = dbConn.createStatement();
			  rs = ServicesRegistry.getInstance().getDBPoolService().executeQuery( stmt, sqlQuery );
            theSkin = null;
			while (rs.next()) {
		        theSkin = new SkinObj(rs.getInt("skin_id"),
									  rs.getString("skin_name"),
									  rs.getString("skin_url"));
	        }
	    } catch (SQLException se) {
	        theSkin = null;
	        String errorMsg = "Error in load_portlet_skin : " + se.getMessage();
	        JahiaConsole.println( "JahiaDBManager", errorMsg + " -> BAILING OUT" );
	        throw new JahiaException(   "Cannot load portlet skin data from the database", 
	                                    errorMsg, JahiaException.DATABASE_ERROR, JahiaException.CRITICAL );
	    } finally {
			try {
				ServicesRegistry.getInstance().getDBPoolService().freeConnection(dbConn);
				if ( stmt != null ) stmt.close();
				//if ( rs != null ) rs.close();
			} catch ( SQLException ex ) {
			    JahiaException je = new JahiaException(   "Cannot free resources", 
	                                    "load_portlet_skin : cannot free resources", 
	                                    JahiaException.DATABASE_ERROR, JahiaException.WARNING );
			}
        }
        return theSkin;

    } // end load_portlet_skin


    /**
     * load_desktop_skin
     *
     * @author Jerome Bedat
     *
     */
	public SkinObj load_desktop_skin(int theID)
	throws JahiaException
	{
  		Connection dbConn = null;
  		Statement stmt = null;
  		ResultSet rs = null;

	    try {
	        String sqlQuery = "SELECT * FROM jahiatemplates_desktop_skin WHERE (skin_id=" + theID + ")";
	        
	        dbConn = ServicesRegistry.getInstance().getDBPoolService().getConnection(88);
	        stmt = dbConn.createStatement();
			  rs = ServicesRegistry.getInstance().getDBPoolService().executeQuery( stmt, sqlQuery );
            theSkin = null;
	        while (rs.next()) {
		        theSkin = new SkinObj(rs.getInt("skin_id"),
									  rs.getString("skin_name"),
									  rs.getString("skin_url"));
			}
	    } catch (SQLException se) {
	        theSkin = null;
	        String errorMsg = "Error in load_desktop_skin : " + se.getMessage();
	        JahiaConsole.println( "JahiaDBManager", errorMsg + " -> BAILING OUT" );
	        throw new JahiaException(   "Cannot load desktop skin data from the database", 
	                                    errorMsg, JahiaException.DATABASE_ERROR, JahiaException.CRITICAL );
	    } finally {
			try {
				ServicesRegistry.getInstance().getDBPoolService().freeConnection(dbConn);
				if ( stmt != null ) stmt.close();
				//if ( rs != null ) rs.close();
			} catch ( SQLException ex ) {
			    JahiaException je = new JahiaException(   "Cannot free resources", 
	                                    "load_desktop_skin : cannot free resources", 
	                                    JahiaException.DATABASE_ERROR, JahiaException.WARNING );
			}
        }
        return theSkin;

    } // end load_desktop_skin

}