读书人

jsp与SQL连接有关问题烦啊

发布时间: 2013-09-11 18:34:25 作者: rapoo

jsp与SQL连接问题,烦啊,高手指点
代码如下,可是一直报错

<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.util.*"%>
<%@page import="java.sql.*"%>
<%
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();

Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://SqlServer2000:1433;DatabaseName="pubs";User="sa";Password="");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from jobs";
ResultSet rs=stmt.executeQuery(sql);
rs.next();
out.println(rs.getString(1));
out.println("Ok");
}catch(Exception e)
{
out.println(e.getMessage());
out.println("err");
}
%>

数据库名、用户名、密码都正确,lib下也加载了msbase.jar/mssqlserver.jar/msutil.jar包.
总是有以下错误:
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: 8 in the jsp file: /index.jsp
Syntax error, insert ")" to complete MethodInvocation
5: try{
6: Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
7:
8: Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://SqlServer2000:1433;DatabaseName="guan";User="sa";Password="");
9: Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
10: String sql="select * from guanrong";
11: ResultSet rs=stmt.executeQuery(sql);


An error occurred at line: 8 in the jsp file: /index.jsp
Syntax error, insert ";" to complete LocalVariableDeclarationStatement
5: try{
6: Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
7:
8: Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://SqlServer2000:1433;DatabaseName="guan";User="sa";Password="");
9: Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
10: String sql="select * from guanrong";
11: ResultSet rs=stmt.executeQuery(sql);


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)



[解决办法]
DriverManager.getConnection


("jdbc:microsoft:sqlserver://SqlServer2000:1433;DatabaseName="guan";User="sa";Password="");
参数与参数之间应该用,号分隔而不是用;号分隔
[解决办法]
("jdbc:microsoft:sqlserver://SqlServer2000:1433;DatabaseName="guan";User="sa";Password="");
参数与参数之间应该用,号分隔而不是用;号分隔
注意"号前后对应
我的异常网推荐解决方案:The server encountered an internal error () that prevented it from fulfilling this request.,http://www.myexception.cn/java-web/317.html
我的异常网推荐解决方案:org.apache.jasper.JasperException: Unable to compile class,http://www.myexception.cn/j2ee/2308.html

读书人网 >JavaScript

热点推荐