how String array variable can access from .zs file to zul page.

answered 2009-03-24 06:13:13 +0800

sandeepkharat1
36 ● 2

this is .zul file.i have created many windows in it .i want to update listbox "zk" after onclick() event on a "s_submit" button.i adjusted this thing by putting button & listbox in one window;but which is not my need. kindly guide for different window .

<?page title="ZkPool User Interface" contentType="text/html;charset=UTF-8"?>
<zk>

<window id="masterpage" title="Zk User Interface 1.0" border="normal" closable="true" minimizable="true" maximizable="true" width="100%" height="100%" use="org.zkoss.ZKPool.poolWeb.LoginUI">
<borderlayout>

<north size="6%" splittable="FALSE" border="normal">
<toolbar>
<button id="masterButton" label="MASTER"/>
<button id="editButton" label="EDIT"/>
<button id="logoutButton" label="LOGOUT!"/>
</toolbar>
</north>
<west size="30%" splittable="true" border="normal">
<borderlayout>
<north splittable="true" flex="true" border="normal">


<tabbox>
<tabs>
<tab label="ADD" closable="false"/>
<tab label="SEARCH" closable="false"/>
</tabs>
<tabpanels>
<tabpanel>
<grid>
<rows>
<row>Master Name: <textbox id="masternameTextBox"/></row>
<row>

<button id="clearButton" label="Clear"/>
</row>
</rows>
</grid>
</tabpanel>
<tabpanel>The second panel
<grid>
<rows>
<row>Object Name: <textbox id="objname"/></row>
<row>Type: <textbox id="passtext" type="text" value="property"/></row>

<row>

<button id="s_submittButton" label="Submitt" />
<button id="ResetButton" label="Reset" />

</row>
</rows>
</grid>
</tabpanel>
</tabpanels>
</tabbox>





</north>
<center flex="true" border="normal">



</center>

</borderlayout>
</west>
<center>
<window id="propertydb" title="Properties" contentStyle="overflow:auto" minimizable="true" maximizable="true" closable="true" border="normal" height="100%" use="org.zkoss.ZKPool.poolWeb.LoginUI">
<listbox id="zk">

</listbox>
<button id="submittButton" label="Submitt" onClick="propertydb.submit()" />
</window>
</center>
<south>
</south>

</borderlayout>

</window>

</zk>

----------------------------------------------------------
this is loginUI.java file.
package org.zkoss.ZKPool.poolWeb;
import org.zkoss.zul.Window;
import org.zkoss.zul.Listbox;
import org.zkoss.zul.Listitem;
import java.sql.*;
import java.io.*;
import org.postgresql.Driver;
import org.zkoss.zk.ui.Sessions;

public class LoginUI extends Window {
String []var = new String[]{"abc","def","ghi"};
private static final String DRIVER = "org.postgresql.Driver";
//private static final String DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
private static final String JDBC = "jdbc:postgresql://";
//private static final String ODBC = "jdbc:odbc:bg12";
private String dbServerIp = "127.0.0.1";
private int dbServerPort = 5432;
//private String dbName = "zk";
private String dbName = "postgres";
private String uName = "postgres";
private String uPwd = "1";
Connection conn;
String [] sandy=new String[10];

public void submit()
{

try
{

Class.forName(DRIVER);
System.out.println("DRVER OK");
//conn =DriverManager.getConnection(ODBC);
conn =DriverManager.getConnection("jdbc:postgresql://localhost:5432/zk","postgres", "1");



PreparedStatement pstmt;
pstmt = conn.prepareStatement("select uPwd from uList where uId= ?");
pstmt.setString(1, "sandeep");
ResultSet rs = pstmt.executeQuery();
int i=0;
System.out.println("\n\ni am in jdb.zs\n\n\n\n ");
Listbox lb = (Listbox) getFellow("zk");

while (rs.next())
{
i++;
sandy = rs.getString(1);
System.out.println("---->"+sandy);



Listitem li = new Listitem();


li.setLabel(sandy);
lb.appendChild(li);



}

conn.close();
}catch (Exception e){
System.out.println(e);

}
//return sandy;
}

}