论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2006-05-18 21:48 |只看该作者 |倒序浏览

我在测试以下代码时报错：test1.jsp

源代码：
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"

.newInstance();
String url="jdbc:microsoft:sqlserver://134.121.6.21:1433;DatabaseName=fgfd";
String user="ererer";
String password="ererer";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select top 5 usertel,username from bbeeuser";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {% >
您的第一个字段内容为：< %=rs.getString(1)% >
您的第二个字段内容为：< %=rs.getString(2)% >
<%}% >
<%out.print("数据库操作成功，恭喜你"

;% >
<%rs.close();
stmt.close();
conn.close();
%>
</body >
</html >

报错：

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: /test1.jsp
Generated servlet error:
Syntax error on tokens, Expression expected instead

An error occurred at line: 5 in the jsp file: /test1.jsp
Generated servlet error:
Syntax error on token(s), misplaced construct(s)

An error occurred at line: 5 in the jsp file: /test1.jsp
Generated servlet error:
Syntax error on tokens, delete these tokens

An error occurred at line: 5 in the jsp file: /test1.jsp
Generated servlet error:
Syntax error on tokens, Expression expected instead

An error occurred at line: 5 in the jsp file: /test1.jsp
Generated servlet error:
Syntax error on tokens, delete these tokens

Generated servlet error:
Syntax error, insert "}" to complete Block

org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:32

org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:409)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:28

org.apache.jasper.compiler.Compiler.compile(Compiler.java:267)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:255)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:556)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:293)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.11 logs.

--------------------------------------------------------------------------------

Apache Tomcat/5.5.11

文库|博客

caojiqun

小富即安

论坛徽章:: 0

2楼 [报告]

发表于 2006-05-18 22:32 |只看该作者

帖子里的代码最好用 ...
复制代码
否则出现一些笑脸看不明白！

源代码：
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://134.121.6.21:1433;DatabaseName=fgfd";
String user="ererer";
String password="ererer";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select top 5 usertel,username from bbeeuser";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
%>
您的第一个字段内容为：<%=rs.getString(1)%>
您的第二个字段内容为：<%=rs.getString(2)%>
<%
}
%>
<%
out.print("数据库操作成功，恭喜你");
rs.close();
stmt.close();
conn.close();
%>
</body >
</html >

复制代码

至少差两个括号，为什么不先仔细检查一下！

[ 本帖最后由 caojiqun 于 2006-5-18 22:34 编辑 ]

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

返回列表

Chinaunix › 论坛 › 程序设计 › Java › jsp连接数据库报错，请指教？

jsp连接数据库报错，请指教？ [复制链接]

浏览过的版块