当前位置: 代码迷 >> Java Web开发 >> 急jsp连接sqlsever时的有关问题
  详细解决方案

急jsp连接sqlsever时的有关问题

热度:68   发布时间:2016-04-17 13:02:19.0
急!jsp连接sqlsever时的问题
在不连接数据库时,jsp能运行,但连接数据库时会出现如下的问题:
HTTP   Status   500   -

type   Exception   report

message

description   The   server   encountered   an   internal   error   ()   that   prevented   it   from   fulfilling   this   request.

exception

org.apache.jasper.JasperException:   Unable   to   compile   class   for   JSP:  

An   error   occurred   at   line:   5   in   the   jsp   file:   /test.jsp
Syntax   error   on   tokens,   delete   these   tokens
2:   <%@   page   import= "java.sql.* "%>  
3:   <html>   <head> </head>
4:   <body>  
5:   <%Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ").newInstance();  
6:   String   url= "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test ";    
7:   String   user= "sa ";  
8:   String   password= "1233651406wh ";  


An   error   occurred   at   line:   5   in   the   jsp   file:   /test.jsp
Syntax   error,   insert   "; "   to   complete   Statement
2:   <%@   page   import= "java.sql.* "%>  
3:   <html>   <head> </head>
4:   <body>  
5:   <%Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ").newInstance();  
6:   String   url= "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test ";    
7:   String   user= "sa ";  
8:   String   password= "1233651406wh ";  


Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:85)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:435)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:298)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:277)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:265)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:564)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:299)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

note   The   full   stack   trace   of   the   root   cause   is   available   in   the   Apache   Tomcat/5.5.23   logs.
请问这是怎么回事,我的测试程序如下
<%@   page   contentType= "text/html;charset=gb2312 "%>  
<%@   page   import= "java.sql.* "%>  
<html>   <head> </head>
<body>  
<%Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ").newInstance();  
String   url= "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test ";    
String   user= "sa ";  
String   password= "1233651406wh ";  
Connection   conn=   DriverManager.getConnection(url,user,password);  
Statement   stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);