数据库连接问题,
刚学jsp,懂得不多。
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<%Class.forName("org.git.mm.mysql.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/book","wangf","liduanduan");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from book");
while(rs.next()){%>
<%=rs.getSring("name")%>
<%}%>
<% rs.close();
con.close();
%>
我的jdk的设置:
.;e:\jdk\lib\dt.jar;e:\jdk\lib\tools.jar;f:\jdbc\mysql;E:\tomcat\lib\servlet.jar;F:\jdbc\mysql;
mysql的jdbc驱动程序放在:F:\jdbc\mysql\org\gjt\mm\mysql
运行时出现:
Internal Servlet Error:
org.apache.jasper.JasperException: Unable to compile class for JSPNote: sun.tools.javac.Main has been deprecated.
E:\tomcat\work\localhost_8080%2Fwangf\_0002fttj_0002ejspttj_jsp_0.java:62: Ambiguous class: java.beans.Statement and java.sql.Statement
Statement stmt=con.createStatement();
^
E:\tomcat\work\localhost_8080%2Fwangf\_0002fttj_0002ejspttj_jsp_0.java:70: Method getSring(java.lang.String) not found in interface java.sql.ResultSet.
out.print(rs.getSring("name"));
还望指教。