How to connect oracle zul file and java file

answered 2010-04-23 09:45:58 +0800

YamilBracho
1722 ● 2

Please check that the ojdbc14.jar is in your classpath. Second check this link (http://www.rgagnon.com/javadetails/java-0112.html)

HTH

answered 2010-04-23 16:22:33 +0800

YamilBracho
1722 ● 2

updated 2010-04-23 16:23:16 +0800

OK I think you will need to specify your static class a init class for ypur zul page.Check http://docs.zkoss.org/wiki/Developer_reference_The_ZK_User_Interface_Markup_Language_Processing_Instructions_The_init_Directive
or (a better idea) use a composer for your page

answered 2010-04-25 19:51:56 +0800

SimonPai
1696 ● 1

fatimatall,

Did you put the driver under WEB-INF/lib too? I guess that's the reason you can't find the driver in Servlet.

Regards,
Simon

answered 2012-05-15 10:39:31 +0800

swati123
66

hello,
As i m new to zk studio,I have wriiten the following code and i wanted to display the data in label and text box,Can anyone help me,

<?page title="edit" contentType="text/html;charset=UTF-8"?>
<zk>
<window title="Edit Records" border="normal">
<label style="color:red" value="EDIT" width="250px"/>

<tabbox>
<tabs>
<tab label="Home" closable="true"/>
<tab label="Edit Record" closable="true"/>


</tabs>

</tabbox>

<grid>
<columns>
<column label="Type" width="150px" />
<column label="Content" />
</columns>
<rows>
<row>
<label value="Name" width="150px" />
<textbox value="" width="150px" id="name"/>
</row>
<row>

Phone:
<textbox value="" width="150px" id="phone"/>
</row>
<row>
Address
<vlayout>
<textbox width="250px" value="" id="address"/>
<hlayout>
<label value="Zip code :" />
<textbox value="" width="150px" id="zip"/>
</hlayout>
</vlayout>

</row>
</rows>
</grid>

<button label="Show Records" onClick="show_rec()" />

<zscript language="Java">
{
import java.sql.*;
import javax.sql.*;
import com.mysql.jdbc.Driver.*;
import java.util.*;
import java.lang.*;



public void show_rec()
{

Connection conn = null;
try
{
String userName = "root";
String password = "123456";
String url = "jdbc:mysql://localhost:3306/telephone_directory";
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
conn = DriverManager.getConnection (url,userName,password);



Statement s = conn.createStatement();
s.executeQuery ("SELECT * FROM test WHERE phone="";");
ResultSet rs = s.getResultSet ();
int count = 0;
while (rs.next ())
{

String nameValue = name.getValue();
String phoneValue = phone.getValue();
String addressValue = address.getValue();
String zipValue = zip.getValue();


++count;
}
s.close();
rs.close();
}
catch (Exception e)
{
System.err.println ("ERROR: "+ e.getMessage());
}


finally
{
if (conn != null)
{
try {
conn.close ();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println ("Database connection terminated");
}
}
}
}

</zscript>
</window>
</zk>

thanks,

answered 2012-05-15 15:19:26 +0800

Steva77
1014 ● 3
http://www.research.softe...

updated 2012-05-15 15:21:17 +0800

swati123, please open a new dedicated topic in Help forum and use the tags to better include your code chunks...
BTW, you have to iterate over your ResultSet and put items in a list, in order to iterate over it and render your grid... see the documentation, plenty of examples.

answered 2012-05-17 10:52:18 +0800

swati123
66

hello all,

please rectify my code,i wanted to display the data in grid view. I dont know much about grid.
So please can any one explain me the what row renderer,list model ,gruop model etc. how to write the code about grid view.
please check the following code .

<?page title="new page title" contentType="text/html;charset=UTF-8"?>
<zk>
<window title="Search" border="normal" maximized="false" >
<label value="Enter your Name" /><textbox value="" width="250px" id="name"/>
<label style="color:green" value="OR" width="100px"/>
<label value="Enter your phone no" /><textbox value="" width="250px" id="phone"/>
<button label="Search" onClick="show_rec()" id="btn1"/>
<grid>
<columns>
<column label="Name"/>
<column label="Phone"/>
<column label="Adress"/>
<column label="zip"/>

</columns>
<rows>
<row>

</row>
</rows>
</grid>

<zscript language="JAVA" >
{
import java.sql.*;
import javax.sql.*;
import com.mysql.jdbc.Driver.*;
import java.util.*;
import java.lang.*;



public void show_rec()
{

Connection conn = null;
try
{
String userName = "root";
String password = "123456";
String url = "jdbc:mysql://localhost:3306/telephone_directory";
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
conn = DriverManager.getConnection (url,userName,password);



Statement s = conn.createStatement();
s.executeQuery ("SELECT * FROM test where name='"+name.Value+"' OR phone='"+phone.Value+"'");
ResultSet rs = s.getResultSet ();
int count = 0;
while (rs.next ())
{

String nameValue = ((Textbox)getFellow("nameValue")).getValue();

++count;
}
s.close();
rs.close();
}
catch (Exception e)
{
System.err.println ("ERROR: "+ e.getMessage());
}


finally
{
if (conn != null)
{
try {
conn.close ();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println ("Database connection terminated");
}
}
}
}

</zscript>
</window>
</zk>

answered 2012-05-18 06:58:45 +0800

swati123
66

pls help me for my previous post.I need it urgently.

answered 2012-05-23 09:06:26 +0800

swati123
66

hello all,

Can anyone explain me with simple example how to display the data in a grid from database.?
There are so many big examples in zk sandbox,that they are confusing me???
So ,please explain me using one text box and button,

thanks,

answered 2012-06-04 07:30:38 +0800

swati123
66

hi..

when I am adding a constraint in text field,it is throwing an error.pls rectify my code.I am unable to find out the bug.<?page title="new page title" contentType="text/html;charset=UTF-8"?>
<zk>
<window title="Name And Phone Numbers" border="none" width="600px" height="600px">

<menubar style="float:right;" height="27px">
<menuitem label="Edit Records" href="/edit.zul" />
</menubar>

<grid>
<columns visible="true">
<column label="Name and phone number" style="font-weight:bold,font-size:35px;color:blue" height="25px" width="175px" />
</columns>

</grid>


<grid>
<columns visible="true">
<column label="Type" width="300px" />
<column label="Content" />
</columns>
<rows>
<row>
<label value="Name*" width="150px" />
<textbox value="" width="150px" id="name" constraint="no empty , /*/ : Enter name "/>
</row>
<row spans="2"></row>
<row>

Phone*:
<textbox value="" width="150px" id="phone" maxlength="10" />
</row>
<row>
Address*:
<vlayout>
<textbox width="250px" value="" id="address" />
<hlayout>
<label value="Zip code*:" />
<textbox value="" width="150px" id="zip" maxlength="6" />
</hlayout>
</vlayout>

</row>
</rows>

</grid>

<button label="Submit" width="150px" onClick="submit()"/>

<zscript language="Java">
{
import java.sql.*;
import javax.sql.*;
import com.mysql.jdbc.Driver.*;
import java.util.*;
import java.lang.*;



public void submit()
{
Connection conn = null;
String userName = "root";
String password = "123456";
String url = "jdbc:mysql://localhost:3306/telephone_directory";
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
conn = DriverManager.getConnection (url,userName,password);
System.out.println ("Database connection established");

PreparedStatement ps=conn.prepareStatement("INSERT INTO test VALUES(?,?,?,?);");


{

try
{


ps.setString(1,name.Value);

ps.setString(2,phone.Value);

ps.setString(3,address.Value);

ps.setString(4,zip.Value);

ps.executeUpdate();
name.setValue("");
phone.setValue("");
address.setValue("");
zip.setValue("");

ps.close ();


}
catch (Exception e)
{
System.err.println ("ERROR: "+ e.getMessage());
}


finally
{
if (conn != null)
{
conn.close ();
System.out.println ("Database connection terminated");
}


}

}

}

}







</zscript>
</window>
</zk>

it gives the following error:

INFO: Source is changed: /name.zul
Database connection established
ERROR: Enter name
Database connection terminated