es.us.mwm.testcloudfoundry.DBClient.java Source code

Introduction

Here is the source code for es.us.mwm.testcloudfoundry.DBClient.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package es.us.mwm.testcloudfoundry;

import com.fasterxml.jackson.databind.JsonNode;
import com.fasterxml.jackson.databind.ObjectMapper;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
 *
 * @author carlos
 */
public class DBClient {

    private Connection conn;

    private static final Logger log = Logger.getLogger(DBClient.class.getName());

    public DBClient() {
        try {
            JsonNode rootNode = new ObjectMapper().readTree(System.getenv("VCAP_SERVICES"));
            JsonNode innerNode = rootNode.get("cleardb").get(0);
            if (innerNode != null) {
                JsonNode aField = innerNode.get("credentials");
                if (aField != null) {
                    String host = aField.get("hostname").asText();
                    String database = aField.get("name").asText();
                    String username = aField.get("username").asText();
                    String password = aField.get("password").asText();
                    conn = DriverManager.getConnection("jdbc:mysql://" + host + ":3306/" + database, username,
                            password);
                }
            }
        } catch (SQLException ex) {
            log.log(Level.SEVERE, ex.toString(), ex);
        } catch (IOException ex) {
            log.log(Level.SEVERE, ex.toString(), ex);
        }
    }

    @Override
    public void finalize() {
        try {
            conn.close();
        } catch (SQLException ex) {
            log.log(Level.SEVERE, ex.toString(), ex);
        }
    }

    public String getClients() {
        String result = "";
        try {
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM Client");
            result += "<table>";
            result += "<tr><th>IDCLIENT</th><th>NAME</th></tr>";
            while (rs.next()) {
                result += "<tr>";
                result += "<td>" + rs.getInt("idClient") + "</td>";
                result += "<td>" + rs.getString("Address") + "</td>";
                result += "<td>" + rs.getString("Name") + "</td>";
                result += "</tr>";
            }
            result += "</table>";
            rs.close();
            stmt.close();
        } catch (SQLException ex) {
            log.log(Level.SEVERE, ex.toString(), ex);
        }
        return result;
    }
}