public static void main(String[] args)
throws SQLException, ClassNotFoundException, JSONException {
PostgresDb db = new PostgresDb();
// db.setUrl("jdbc:postgresql://localhost:5432/powaaim");
try {
Class.forName("org.postgresql.Driver");
c = DriverManager.getConnection(db.getUrl(), db.getUser(), db.getPass());
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
st = c.createStatement();
rs = st.executeQuery("SELECT id, name, externalshopid from shop where name='David_3'");
System.out.println("id" + " " + "name" + " " + "externalshopid");
c.close();
obj = new JSONObject();
while (rs.next()) {
int id = rs.getInt("id");
String externaId = rs.getString("externalshopid");
String name = rs.getString("name");
// System.out.println(id+ " " + " "+ name + " " +" "+ externaId);
System.out.println();
obj.put("id", id);
obj.put("name", name);
obj.put("externalshopid", externaId);
System.out.print(obj);
}
}
public static void createConnectionPool() {
Context context;
try {
context = new InitialContext();
Class.forName("org.firebirdsql.jdbc.FBDriver");
ds = (DataSource) context.lookup("java:comp/env/jdbc/PanelTrackDB");
Connection c = ds.getConnection();
} catch (NamingException e) {
// TODO Auto-generated catch block
errorLogger.error("An Error Occured:", e);
e.printStackTrace();
} catch (ClassNotFoundException e) {
errorLogger.error("An Error Occured:", e);
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
errorLogger.error("An Error Occured:", e);
// TODO Auto-generated catch block
e.printStackTrace();
}
}