Show table PostgreSQL

<?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>	
		
			<zscript><![CDATA[
            import org.zkoss.zul.*;
            int[] orderArray = new int[26];
            for (int j=0; j<26; j++){
                orderArray = 390 + j;
            }
        ]]></zscript>
		
			<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>
	
	 <zscript><![CDATA[
	                   
     import java.sql.*;
     
     void submit() {
         //load driver and get a database connetion
         Class.forName("com.mysql.jdbc.Driver");
         Connection conn = DriverManager.getConnection(
             "jdbc:mysql://localhost/test?user=postgres&password=nino1n");
         PreparedStatement stmt = null;
         try {
             stmt = conn.prepareStatement("INSERT INTO user values(?, ?)");
  
             //insert what end user entered into database table
             stmt.setString(1, id.value);
             stmt.setString(2, s_date.value);
             stmt.setString(3, e_date.value);
             stmt.setString(4, s_hour.value);
             stmt.setString(5, e_hour.value);
             stmt.setString(6, in_raw.value);
             stmt.setString(7, ex_presen.value);
             stmt.setString(8, ex_flow.value);
             stmt.setString(9, raste.value);
  
             //execute the statement
             stmt.executeUpdate();
         } finally { //cleanup
             if (stmt != null) {
                 try {
                     stmt.close();
                 } catch (SQLException ex) {
                     log.error(ex); //log and ignore
                 }
             }
             if (conn != null) {
                 try {
                     conn.close();
                 } catch (SQLException ex) {
                     log.error(ex); //log and ignore
                 }
             }
         }
     }
     ]]>
     </zscript>

	
</zk>

- 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;