May 27th, 2002, 12:34 AM
|
 |
Is a Psycho
|
|
Join Date: Dec 2000
Location: In your computer
Posts: 231
Time spent in forums: < 1 sec
Reputation Power: 8
|
|
|
JSP and mm.MySQL
Hi,
Does anyone know why I would be getting this error:
Code:
Internal Servlet Error:
org.apache.jasper.JasperException: Unable to compile class for JSPNote: sun.tools.javac.Main has been deprecated.
C:\Dev\tomcat\work\localhost_8080\_0002findex_0002ejspindex_jsp_4.java:71: Ambiguous class: java.beans.Statement and java.sql.Statement
Statement stmt = myConn.createStatement();
^
1 error, 1 warning
When trying the following code:
Code:
<html>
<head></head>
<%@ page language="java" import="java.sql.*" %>
<body>
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Connection myConn = DriverManager.getConnection("jdbc:mysql://localhost/mysite?user=root&password=");
//myConn = DriverManager.getConnection("jdbc:mysql://localhost/mysite", "root", "");
Statement stmt = myConn.createStatement();
String strQuery = "select * from page_content where page_id=1";
ResultSet rsResults = stmt.executeQuery(strQuery);
if (rsResults != null) {
while (rsResults.next()) {
String strHeader = rsResults.getString("header");
String strContent = rsResults.getString("content");
%>
<h2><%= strHeader %></h2>
<p><%= strContent %></p>
<%
}
}
%>
</body>
</html>
__________________
deepspring
- "Netscape 4 users are like lemmings... You can't help but laugh when one falls off a cliff"
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
