Java Mailing List Archive

http://www.junlu.com/

Home » Home (12/2007) » JSP Interest »

Re: Directive

Mikil

2003-12-01

Replies:

Thank you to all of you for the prompt reply and apologies for the belated
response from me.

I just started from fresh i.e. re-intsalled redhat 9 OS and all other
relevant tools. I still get the same error.

Below are the codes that I am using to connect to the mysql db through JSP.


<html>
<head>
<title>Database Access</title>
</head>
<%@(protected).*" %>
<body>

<%

Class.forName("com.mysql.jdbc.Driver").newInstance();

// java.sql.Connection conn;

Connection conn =
DriverManager.getConnection("jdbc:mysql://localhost:8080/test?user=blah&pass
word=blah");

Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,
java.sql.ResultSet.CONCUR_READ_ONLY);

ResultSet rs = stmt.executeQuery("SELECT * FROM User_Login");

// ResultSet rs = stmt.setFetchSize(Integer.MIN_VALUE);

while (rs.next())
{
String userID = rs.getString("user_id");
String userName = rs.getString("user_name");
String userPassword = rs.getString("user_pwd");

out.print("<tr>");
out.print("<td>" + userID + "</td>");
out.print("<td>" + userName + "</td>");
out.print("<td>" + userPassword + "</td>");
}

conn.close();
%>
</table>
</body>
</html>

Hope this helps to you to help him.

Rgds & thanks

Mikil

----- Original Message -----
From: "Kumar.K.R" <kumar.kopalle@(protected)>
To: <JSP-INTEREST@(protected)>
Sent: Sunday, November 30, 2003 10:50 PM
Subject: Directive


> Hi,
>
> I want a simple but good definition of a Directive in jsp.
>
> Thanx and Regards,
>
> KR Kumar
>
> ===========================================================================
> To unsubscribe: mailto listserv@(protected)".
> For digest: mailto listserv@(protected)".
>
> Some relevant archives, FAQs and Forums on JSPs can be found at:
>
> http://java.sun.com/products/jsp
> http://archives.java.sun.com/jsp-interest.html
> http://forums.java.sun.com
> http://www.jspinsider.com
>

===========================================================================
To unsubscribe: mailto listserv@(protected)".
For digest: mailto listserv@(protected)".

Some relevant archives, FAQs and Forums on JSPs can be found at:

http://java.sun.com/products/jsp
http://archives.java.sun.com/jsp-interest.html
http://forums.java.sun.com
http://www.jspinsider.com


©2008 junlu.com - Jax Systems, LLC, U.S.A.