<[EMAIL PROTECTED] contentType="text/html" import="java.sql.*,java.util.*,org.apache.commons.beanutils.*" %>
<[EMAIL PROTECTED] pageEncoding="UTF-8"%>
<[EMAIL PROTECTED] uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<[EMAIL PROTECTED]
uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"
http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Sample JSTL</title>
</head>
<body>
<sql:setDataSource var="dataSrc" url="" driver="com.mysql.jdbc.Driver" user="root" password="passit"/>
<sql:query var="users" dataSource="${dataSrc}">
SELECT * FROM master
</sql:query>
<c:out default="bunty" value="${users.rows}" />
<display:table name="${users.rows}" id="user" pagesize="10" >
<display:column property="email" title="Email" />
<display:column property="name" title="Name" />
<display:column property="company" title="Company"/>
<display:column property="contact" title="Contact" />
<display:column property="category" title="Category"/>
<display:column property="edate" title="Date"/>
<display:column property="desg" title="Desg"/>
<display:column property="others" title="Others"/>
</display:table>
</body>
</html>
Ok here we go.
Example with JSTL tags <sql>
put this line in front of <html> tag:
<[EMAIL PROTECTED] uri=" http://java.sun.com/jsp/jstl/sql " prefix="sql"%>
You also need to include in NetBeans 5.5. JSTL 1.1 library in your project to can
use those tags.
in <body> tags put this code:
<sql:setDataSource var="dataSrc"
url="" driver=" com.mysql.jdbc.Driver "
user="root" password=""/>
<sql:query var="users" dataSource="${dataSrc}">
SELECT * FROM master
</sql:query>
<display:table name="${users.rows}" id="user" pagesize="10" >
<display:column property="email" title="Email" />
<display:column property="name" title="Name" />
<display:column property="company" title="Company"/>
<display:column property="contact" title="Contact" />
<display:column property="category" title="Category"/>
<display:column property="edate" title="Date"/>
<display:column property="desg" title="Desg"/>
<display:column property="others" title="Others"/>
</display:table>
and then try it it should work.
Let me know if it works!
On 7/6/06, Bunty India < [EMAIL PROTECTED]> wrote:PLease provide me any working code that is using DisplayTag with Database
On 7/6/06, SourceForge.net <[EMAIL PROTECTED] > wrote:
Read and respond to this message at:
https://sourceforge.net/forum/message.php?msg_id=3809916
By: boske3
This code that you gave is little confuised.
As i can se you have problem with your ResultSet.
I use more simple JSTL tag for that.Are you familiar in that tags?
Problem with Result Set is that you have more then one column you must put it
in some kind of list or vector and then to display it.
"When i add
<display:table name="rows1" />
it display nothing found to display. "
you got this message when you table is empty.
Check your table is it full or not?
______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit:
https://sourceforge.net/forum/unmonitor.php?forum_id=249318
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
displaytag-user mailing list
displaytag-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/displaytag-user--
=======================
Knowledge Is Power Share It
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
displaytag-user mailing list
displaytag-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/displaytag-user
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
displaytag-user mailing list
displaytag-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/displaytag-user
--
=======================
Knowledge Is Power Share It
Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ displaytag-user mailing list displaytag-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/displaytag-user
