Examples of org.apache.geronimo.monitoring.console.util.DBManager

Package org.apache.geronimo.monitoring.console.util

Examples of org.apache.geronimo.monitoring.console.util.DBManager

org.apache.geronimo.monitoring.console.util.DBManager

            return "<font color=\"red\"><strong><li>Failed to create a connection to server.</li></strong></font>";
        }
    }


    private String alterServerState(String server_id, boolean b) {
        Connection conn = (new DBManager()).getConnection();
        String message = "";
        String name = "";
        try {
            PreparedStatement pStmt = conn
                    .prepareStatement("SELECT * FROM servers WHERE server_id="
                            + server_id);
            ResultSet rs = pStmt.executeQuery();
            if (rs.next()) {
                name = rs.getString("name");
            }
            rs.close();
            conn.close();
            conn = (new DBManager()).getConnection();
            Statement stmt = conn.createStatement();
            if (!b) {
                stmt
                        .executeUpdate("UPDATE SERVERS SET ENABLED = 0 WHERE SERVER_ID="
                                + server_id);

View Full Code Here


    private void updateView(ActionRequest actionRequest,
            ActionResponse actionResponse) {
        String view_id = actionRequest.getParameter("view_id");
        actionResponse.setRenderParameter("view_id", view_id);
        DBManager DBase = new DBManager();
        Connection con = DBase.getConnection();
        String name = actionRequest.getParameter("name");
        String description = actionRequest.getParameter("description");
        String[] graphsArray = actionRequest.getParameterValues("graph_ids");
        if (graphsArray == null) {
            graphsArray = new String[0];

View Full Code Here

        }
    }


    private void addView(ActionRequest actionRequest,
            ActionResponse actionResponse) {
        DBManager DBase = new DBManager();
        Connection con = DBase.getConnection();
        String name = actionRequest.getParameter("name");
        String description = actionRequest.getParameter("description");
        String[] graphsArray = actionRequest.getParameterValues("graph_ids");
        if (graphsArray == null) {
            graphsArray = new String[0];

View Full Code Here


    private void updateServer(ActionRequest actionRequest,
            ActionResponse actionResponse) {
        String server_id = actionRequest.getParameter("server_id");
        actionResponse.setRenderParameter("server_id", server_id);
        DBManager DBase = new DBManager();
        Connection con = DBase.getConnection();
        String name = actionRequest.getParameter("name");
        String ip = actionRequest.getParameter("ip");
        String password = actionRequest.getParameter("password");
        String username = actionRequest.getParameter("username");
        String snapshot = actionRequest.getParameter("snapshot");

View Full Code Here

        }
    }


    private void addServer(ActionRequest actionRequest,
            ActionResponse actionResponse) {
        DBManager DBase = new DBManager();
        Connection con = DBase.getConnection();
        String name = actionRequest.getParameter("name");
        String ip = actionRequest.getParameter("ip");
        int protocol = Integer.parseInt(actionRequest.getParameter("protocol"));
        int port = Integer.parseInt(actionRequest.getParameter("port"));
        String password = actionRequest.getParameter("password");

View Full Code Here


    private void deleteServer(ActionRequest actionRequest,
            ActionResponse actionResponse) {
        String server_id = actionRequest.getParameter("server_id");
        actionResponse.setRenderParameter("server_id", server_id);
        DBManager DBase = new DBManager();
        Connection con = DBase.getConnection();


        try {
            PreparedStatement pStmt = con
                    .prepareStatement("DELETE FROM graphs WHERE server_id="
                            + server_id);

View Full Code Here


    private void deleteView(ActionRequest actionRequest,
            ActionResponse actionResponse) {
        String view_id = actionRequest.getParameter("view_id");
        actionResponse.setRenderParameter("view_id", view_id);
        DBManager DBase = new DBManager();
        Connection con = DBase.getConnection();


        try {
            PreparedStatement pStmt = con
                    .prepareStatement("DELETE FROM views WHERE view_id="
                            + view_id);

View Full Code Here

        }
    }


    private void addGraph(ActionRequest actionRequest,
            ActionResponse actionResponse) {
        DBManager DBase = new DBManager();
        Connection con = DBase.getConnection();
        String name = actionRequest.getParameter("name");
        String description = actionRequest.getParameter("description");
        String server_id = actionRequest.getParameter("server_id");
        String xlabel = actionRequest.getParameter("xlabel");
        String ylabel = actionRequest.getParameter("ylabel");

View Full Code Here

        }
    }


    private void updateGraph(ActionRequest actionRequest,
            ActionResponse actionResponse) {
        DBManager DBase = new DBManager();
        Connection con = DBase.getConnection();
        String graph_id = actionRequest.getParameter("graph_id");
        actionResponse.setRenderParameter("graph_id", graph_id);


        String name = actionRequest.getParameter("name");
        String description = actionRequest.getParameter("description");

View Full Code Here


    private void deleteGraph(ActionRequest actionRequest,
            ActionResponse actionResponse) {
        String graph_id = actionRequest.getParameter("graph_id");
        actionResponse.setRenderParameter("graph_id", graph_id);
        DBManager DBase = new DBManager();
        Connection con = DBase.getConnection();


        try {
            // remove the graph
            PreparedStatement pStmt = con
                    .prepareStatement("DELETE FROM graphs WHERE graph_id="

View Full Code Here

0 1 2 3 4 5

TOP

Related Classes of org.apache.geronimo.monitoring.console.util.DBManager

org.apache.geronimo.monitoring.console.GraphsBuilder

org.apache.geronimo.monitoring.console.MonitoringPortlet

java.sql.PreparedStatement

javax.naming.Context

java.sql.DatabaseMetaData

javax.sql.DataSource

java.sql.ResultSet

javax.naming.InitialContext

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.