Here a sample for a jsp page connecting to a DB:
<html>
<head> <title>Listing the content of a Database</title> </head>
<body>
<p> Content of the dealer database:
<table border=1 cellpadding=0 cellspacing=0>
<tr> <td> Shop </td>
<td> Street </td>
<td> Country </td>
<td> ZIP </td>
<td> City </td>
<td> Phone </td>
<td> Fax </td>
<td> EMAIL </td>
<td> WEB </td>
</tr>
<%
Class.forName("org.gjt.mm.mysql.Driver");
java.sql.Connection connection =
java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/yourDataba
se", "yourUser", "yourPassword");
java.sql.Statement statement = connection.createStatement();
java.sql.ResultSet columns = statement.executeQuery("SELECT * FROM
dealer");
while(columns.next()) {
String shop = columns.getString("dname");
String street = columns.getString("dstreet");
String country = columns.getString("dcountry");
String zip = columns.getString("dplz");
String city = columns.getString("dort");
String phone = columns.getString("dphone");
String fax = columns.getString("dfax");
String email = columns.getString("demail");
String web = columns.getString("dweb");
%>
<tr> <td> <%= shop %> </td>
<td> <%= street %> </td>
<td> <%= country %> </td>
<td> <%= zip %> </td>
<td> <%= city %> </td>
<td> <%= phone %> </td>
<td> <%= fax %> </td>
<td> <%= email %> </td>
<td> <%= web %> </td>
</tr>
<% } %>
</table>
</body>
</html>
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Bert
Sent: Thursday, August 02, 2001 4:20 PM
To: JRun-Talk
Subject: Querying the Db
Is it possible to Query the db with Jsp like Asp for example,
Via the GetQueryString("parametername")
myid = someid
then do your Sql Statment etc.
select * from my table where myid like id?
Bert
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
