Urko Lekuona UrkoLekuona
UrkoLekuona
/ TestConnection.java
Last active
August 4, 2020 08:26
Test connection to a Database using Java (Simple main class)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package com.example.jdbc_postgres; | |
| import java.sql.Connection; | |
| import java.sql.DriverManager; | |
| import java.sql.ResultSet; | |
| import java.sql.SQLException; | |
| import java.sql.Statement; | |
| import java.util.Properties; | |
| /** |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"json": [{"variable":"TRDP_PLC_ENERGY_HVAC_M1","system":"HVAC","coach":"M1","element":"HVAC M1","type":"energyConsumed"},{"variable":"TRDP_PLC_ENERGY_HVAC_R1","system":"HVAC","coach":"R1","element":"HVAC R1","type":"energyConsumed"},{"variable":"TRDP_PLC_ENERGY_HVAC_N1","system":"HVAC","coach":"N1","element":"HVAC N1","type":"energyConsumed"},{"variable":"TRDP_PLC_ENERGY_HVAC_N2","system":"HVAC","coach":"N2","element":"HVAC N2","type":"energyConsumed"},{"variable":"TRDP_PLC_ENERGY_HVAC_R2","system":"HVAC","coach":"R2","element":"HVAC R2","type":"energyConsumed"},{"variable":"TRDP_PLC_ENERGY_HVAC_M2","system":"HVAC","coach":"M2","element":"HVAC M2","type":"energyConsumed"},{"variable":"TRDP_PLC_ENERGY_CONV_M1","system":"convectors","coach":"M1","element":"convectors M1","type":"energyConsumed"},{"variable":"TRDP_PLC_ENERGY_CONV_R1","system":"convectors","coach":"R1","element":"convectors R1","type":"energyConsumed"},{"variable":"TRDP_PLC_ENERGY_CONV_N1","system":"convectors","coach":"N1","element":"convectors |