不解的是我自己写数据库连接就没有成功过,今天搞了几个小时,调来调去,希望大家能帮下忙,运行出现如下的错误。
org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 10 in the jsp file: /untitled9.jsp
Generated servlet error:
C:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\commerce\org\apache\jsp\untitled9_jsp.java:59: cannot resolve symbol
symbol : method creatStatement (int,int)
location: interface java.sql.Connection
Statement stmt=conn.creatStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
^
1 errororg.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:412)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)程序代码如下(基本照抄),其他配置不知道有没有问题,但案例的系统却能运行成功
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
response.setHeader("Pragma","No-cache");
response.setHeader("Cache-Control","no-cache");
response.setDateHeader("Expires",0);
%>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_shop";
String user="sa";
String password="";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.creatStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from tb_BBS";
ResultSet rs=stmt.executeQuery(sql);
while (rs.next()) {%>
<%=rs.getString(1) %>
<%}%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>>
org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 10 in the jsp file: /untitled9.jsp
Generated servlet error:
C:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\commerce\org\apache\jsp\untitled9_jsp.java:59: cannot resolve symbol
symbol : method creatStatement (int,int)
location: interface java.sql.Connection
Statement stmt=conn.creatStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
^
1 errororg.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:412)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)程序代码如下(基本照抄),其他配置不知道有没有问题,但案例的系统却能运行成功
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
response.setHeader("Pragma","No-cache");
response.setHeader("Cache-Control","no-cache");
response.setDateHeader("Expires",0);
%>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_shop";
String user="sa";
String password="";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.creatStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from tb_BBS";
ResultSet rs=stmt.executeQuery(sql);
while (rs.next()) {%>
<%=rs.getString(1) %>
<%}%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>>
解决方案 »
- 关于AOP登录权限检查的问题,请教大家,比较急。。。
- 100分求助,在线求解:Java 如何读取Lotus中的正文?
- java.net.ProtocolException: Server redirected too many times (20)
- Java(JSP)关于日期的运算等处理方法
- 数据库存储存取问题(急!急!急!急!急!急!急!急!急!急!急!急!急!急!急!)
- 中文乱码问题
- 我知道这个问题很低级,但是我给的分多啊,跪求大哥们帮忙,20分必给
- 请问谁有2004年<开发高手>第8期中,使用java实现在JSP页面上画图的源代码!!
- 关于流量统计的代码,请帮忙找找错误,百思不得其解
- 我听同学说Web板块都是高手,怎么我得问题没有人回答呢?好失望
- 以下程序是动态显示时钟,程序基本上没有问题,但是在IE中为空白,请教各位网友.谢谢!
- 关于servlet中取jsp中的单选框值?
<%@ page import="java.sql.*"%>
<html>
<body>
<%response.setHeader("Pragma", "No-cache");
response.setHeader("Cache-Control", "no-cache");
response.setDateHeader("Expires", 0); %>
<%try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver")
.newInstance();
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String user = "sa";
String password = "";
Connection conn = DriverManager.getConnection(url, user,
password);
Statement stmt = conn.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sql = "select * from jobs";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {%>
<%=rs.getString(1)%>
<%}%>
<%rs.close();
stmt.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
} %>
</body>
</html>/////////////////////////////////////////////////////
你的错误是方法错误。
symbol : method creatStatement (int,int);
应该是:createStatement();
你在运行代码时注意一下你自己的数据库密码。有的就在String password="";的引号中输入,没有就算。