Results 1 to 6 of 6
Thread: Show data from PostgreSQL
- 05-16-2011, 06:53 PM #1
Member
- Join Date
- May 2011
- Posts
- 3
- Rep Power
- 0
Show data from PostgreSQL
Hi there ..
Im new in java ... i want to show some data from a data base that it was create en postgresql.
Im using a framework that is called ZK i made my model of my page with this framework.
Now i create a class to connect Postgre with Java ... but now i don't now what to do! i have to create another class to show the data???
Please any helps is good links or maybe examples!!
Another question how can i do to prove my code if the connection i made is working???
This my code of connection
Java Code:package conexion; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import java.util.UUID; public class EventoDAO { private String url = "jdbc:postgresql://localhost:5432/usuarios"; private String user = "postgres"; private String pwd = "nino1n"; public EventoDAO() { try { Class.forName("org.postgresql.Driver"); } catch (ClassNotFoundException e) { e.printStackTrace(); } } @SuppressWarnings({ "rawtypes", "unchecked" }) public List findAll(){ Statement stmt = null; Connection conn = null; List allEvents = new ArrayList(); try { // get connection conn = DriverManager.getConnection(url, user, pwd); stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("select * from usua"); // fetch all events from database Evento evt; while (rs.next()) { evt = new Evento(); evt.setId(rs.getString(1)); evt.setCharge(rs.getString(2)); evt.setMail(rs.getInt(3)); evt.setMobile(rs.getString(4)); evt.setPassword(rs.getString(5)); allEvents.add(evt); } } catch (SQLException e) { e.printStackTrace(); }finally{ try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } return allEvents; } public boolean insert(Evento evt){ Connection conn = null; Statement stmt = null; boolean result = false; try { // get connection conn = DriverManager.getConnection(url, user, pwd); stmt = conn.createStatement(); if (stmt.executeUpdate("insert into usua(id,charge,mail,mobile,password) " + "values ('" + UUID.randomUUID().toString() + "','" + evt.getCharge() + "'," + evt.getMail() + "','" + evt.getMobile()+ "','" + evt.getPassword() + "')") > 0); result = true; } catch (SQLException e) { e.printStackTrace(); }finally{ try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } return result; } }
This is my code of ZK Framework were i want to show the data of the table
XML Code:<?page title="Previous Executed Jobs" contentType="text/html;charset=UTF-8"?> <zk> <style> body { background-image: url('images/fondos.jpg'); } </style> <window> <include src="vprincipal.zul"/> </window> <window title="Previus Jobs Executed" border = "normal"> <grid mold="paging" pageSize="10" > <columns> <column label="Execution ID"/> <column label="Start Date"/> <column label="End Date"/> <column label="Start Hour"/> <column label="End Hour"/> <column label="Ingest Rawdata" width="100px"/> <column label="Export Presence" width="120px"/> <column label="Export Flows" width="100px"/> <column label= "Rasterizat" width="100px"/> </columns> <rows> <row forEach="${orderArray}"> <label value="submit()" id="id"/> <label value="submit()" id="s_date"/> <label value="submit()" id="e_date"/> <label value="submit()" id="s_hour"/> <label value="submit()" id="e_hour"/> <label value="submit()" id="in_raw"/> <label value="submit()" id="ex_presen"/> <label value="submit()" id="ex_flow"/> <label value="submit()" id="raste"/> </row> <row> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> </row> <row> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> </row> <row> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> </row> <row> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> </row> <row> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> </row> <row> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> </row> <row> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> <label value="" /> </row> </rows> </grid> <div align="center"> <button label=" Process " onClick="" width="90px"/> </div> </window>
Java Code:-- Table: pre_ -- DROP TABLE pre_; CREATE TABLE pre_ ( id name, s_date date, e_date date, s_hour interval, e_hour interval, in_raw numeric, ex_presen numeric, ex_flow numeric, raste numeric ) WITH (OIDS=FALSE); ALTER TABLE pre_ OWNER TO postgres;
Thanks! for the help!!!!!
:(
- 05-17-2011, 08:59 PM #2
The data is stored in the ResultSet that's created after executing a query. You can display it any way you like - as text, make graphs, console output, whatever. How would you like to display the data?
- 05-18-2011, 07:14 PM #3
Member
- Join Date
- May 2011
- Posts
- 3
- Rep Power
- 0
first of implement how do i know if my connection of my java class is working with my DB Postgres fine.
- 05-18-2011, 07:32 PM #4
How do you know if the DB connection is working? Well, if you get no exceptions and if the result set actually contains records, then it's working.
- 05-18-2011, 07:41 PM #5
Member
- Join Date
- May 2011
- Posts
- 3
- Rep Power
- 0
Java Code:package pre_eventos; import org.zkoss.zk.ui.Component; @SuppressWarnings("unused") public class EventoPre { private String id; private String s_date; private String e_date; private String s_hour; private String e_hour; private String in_raw; private String ex_presen; private String ex_flow; private String raste; public EventoPre(){} public EventoPre(String id,String s_date,String e_date,String s_hour, String e_hour, String in_raw, String ex_presen, String ex_flow, String raste ){ this.id = id; this.s_date = s_date; this.e_date = e_date; this.s_hour = s_hour; this.e_hour = e_hour; this.in_raw = in_raw; this.ex_presen = ex_presen; this.ex_flow = ex_flow; this.raste = raste; } public String getId() { return id; } public void setId(String id) { this.id = id; } public String gets_date() { return s_date; } public void sets_date(String s_date){ this.s_date = s_date; } public String gete_date() { return e_date; } public void sete_date(String e_date) { this.e_date = e_date; } public String gets_hour() { return s_hour; } public void sets_hour(String s_hour) { this.s_hour = s_hour; } public String gete_hour () { return e_hour; } public void sete_hour(String e_hour) { this.e_hour = e_hour; } public String getin_raw() { return in_raw; } public void setin_raw(String in_raw) { this.in_raw = in_raw; } public String getex_presen() { return ex_presen; } public void seten_presen(String ex_presen) { this.ex_presen = ex_presen; } public String getex_flow() { return ex_flow; } public void setex_flow(String ex_flow) { this.ex_flow = ex_flow; } public String getrasastete() { return raste; } public void setraste(String raste) { this.raste = raste; }
Java Code:package pre_eventos; import org.zkoss.zk.ui.util.GenericForwardComposer; import org.zkoss.zkplus.databind.AnnotateDataBinder; import org.zkoss.zul.Listbox; import java.util.List; import conexion.Evento; import conexion.EventoDAO; public class PreControlador extends GenericForwardComposer { private static final long serialVersionUID = 1L; protected AnnotateDataBinder binder; ConexionPre ConePre = new ConexionPre(); EventoPre current = new EventoPre(); Listbox box; public EventoPre getCurrent() { return current; } public void setCurrent(EventoPre current) { this.current = current; } } }
Last edited by kike_skate; 05-18-2011 at 07:43 PM.
- 05-18-2011, 09:06 PM #6What do u thinkg is missing ??? .
Two extra question marks don't make up for that.
db
Similar Threads
-
insert data to PostgreSQL database using Jsp and Servlets
By athi in forum JDBCReplies: 2Last Post: 03-29-2011, 01:08 PM -
how to show web browser in mobile app or is it possible to show it in textArea
By Basit781 in forum CLDC and MIDPReplies: 3Last Post: 05-27-2010, 11:54 AM -
How to show class initialize data in JSP ?
By tking88 in forum New To JavaReplies: 0Last Post: 03-07-2010, 10:17 AM -
Data from a model class won't show up in the table
By ayampanggang in forum AWT / SwingReplies: 3Last Post: 11-27-2008, 09:20 PM -
netbeans 6.0 not show commpunent or show blank page
By fahimaamir in forum NetBeansReplies: 1Last Post: 01-26-2008, 07:20 AM
Bookmarks