我的代码是：
<%@ page import= "java.lang.*, java.io.*, java.sql.*, java.util.* "
contentType= "text/html;charset=gb2312 " %>
<html>
<body>
<%
Class.forName( "com.miscrosoft.jdbc.sqlserver.SQLServerDriver ").newInstance();
String url= "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs ";
//pubs 为你的数据库的
String user= "sa ";
String password= "6641249 ";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement;
(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql= "select job_id , job_desc from jobs ";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) { %>
您的第一个字段内容为： <%=rs.getString(1)%> <br>
您的第二个字段内容为： <%=rs.getString(2)%> <br>
<% } %>
<% out.print( "数据库操作成功，恭喜你 "); %>
<%
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
用的是sql server 2000,出现如标题的错误：
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: /sql.jsp(1,4) Invalid directive
org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:39)
org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:409)
org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:90)
org.apache.jasper.compiler.Parser.parseDirective(Parser.java:506)
org.apache.jasper.compiler.Parser.parseElements(Parser.java:1539)
org.apache.jasper.compiler.Parser.parse(Parser.java:126)
org.apache.jasper.compiler.ParserController.doParse(ParserController.java:220)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:101)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:203)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:470)
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)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
哪位帮解决一下？
------解决方案--------------------
Statement stmt=conn.createStatement;
(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
这句奇怪哦，（）应该跟到createStatement后面~
------解决方案--------------------
Statement stmt=conn.createStateme(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
代码迷推荐解决方案：The server encountered an internal error () that prevented it from fulfilling this request.,http://www.daimami.com/search?q=317