to db-forespørgsler
hvorfor er det ikke muligt at have to db-forespørgsler på den samme side? Mit forslag ser således ud:<%@ page language="java" import="java.sql.* java.util.* java.io.* java.util.Date.* javax.*" %>
<jsp:useBean name="db" id="db" class="DbHandler" scope="session"/>
<html>
<head>
<basefont face="Arial">
</head>
<body>
<table border="1" cellspacing="5" cellpadding="5">
<tr>
<td><b>Variable</b></td>
<td><b>Value</b></td>
</tr>
<tr>
<td>Request protocol</td>
<td>
<%
String protocol = request.getProtocol();
out.println(request.getProtocol());
%>
</td>
</tr>
<tr>
<td>Hostname</td>
<td>
<%
String hostname = request.getServerName();
out.println(request.getServerName());
%>
</td>
</tr>
<tr>
<td>Port</td>
<td>
<%
int serverport = request.getServerPort();
//out.println(String.charAt(request.getServerPort()));
%>
</td>
</tr>
<tr>
<td>Remote username</td>
<td>
<%
// username if using HTTP authentication
// null if no authentication
String remoteusername = request.getRemoteUser();
out.println(request.getRemoteUser());
%>
</td>
</tr>
<tr>
<td>Remote address</td>
<td>
<%
// get IP address of client
String ipaddress = request.getRemoteAddr();
out.println(request.getRemoteAddr());
%>
</td>
</tr>
<tr>
<td>Client browser</td>
<td>
<%
// client browser identification
String browser = request.getHeader("User-Agent");
out.println(request.getHeader("User-Agent"));
%>
</td>
</tr>
<tr>
<td>Datp</td>
<td>
</td>
</tr>
</table>
<%
db.open("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:test","","");
int rowsAffected = db.doUpdate("insert into test (protocol,hostname,remoteusername,ipaddress,browser) values('" + protocol + "','" + hostname + "','" + remoteusername + "','" + ipaddress + "','" + browser + "')");
if(rowsAffected == 1)
{
ResultSet rs = db.doQuery("select max (id) from test");
while(rs.next()){
String id = rs.getString(id);
%>
velkommen besøgende nummer:
<% id %>
---> til mit enorme site
<%
}
else
{
%>
<h1>Sorry, men dit indlæg blev ikke opdateret... prøv igen... </h1>
<%
}
db.close();
%>
</BODY>
</HTML>
