67,538
社区成员
发帖
与我相关
我的任务
分享我的jsp页面连数据库时报错，高手帮忙解决下。
<%@ page language="java" contentType="text/html; charset=gb2312" %>
<%@ page import="java.lang.*, java.io.*, java.sql.*, java.util.*" %>
<html>
<body>
<%
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=xpdatabase";
String userName = "xpchild";
String userPwd = "xpchild";
try {
Class.forName(driverName).newInstance();
Connection conn = DriverManager.getConnection(dbURL, userName, userPwd);
Statement stmt = conn.createStatement();
String sql="select * from echo_message";
ResultSet rs=stmt.executeQuery (sql);
while(rs.next())
{
out.println(rs.getString(1));
out.println(rs.getString(2));
}
out.println("Connection Successful!");
}
catch (Exception e) {
e.printStackTrace();
}
%>
</body>
</html>
这是一个简单的jsp页面，但有浏览器打开时会报错。
<%@ page import="java.lang.*, java.io.*, java.sql.*, java.util.*" %>
<html>
<body>
<%
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=xpdatabase";
String userName = "xpchild";
String userPwd = "xpchild";
try {
Class.forName(driverName).newInstance();
Connection conn = DriverManager.getConnection(dbURL, userName, userPwd);
Statement stmt = conn.createStatement();
String sql="select * from echo_message";
ResultSet rs=stmt.executeQuery (sql);
while(rs.next())
{
out.println(rs.getString(1));
out.println(rs.getString(2));
}
out.println("Connection Successful!");
}
catch (Exception e) {
e.printStackTrace();
}
%>
</body>
</html>
这是一个简单的jsp页面，但有浏览器打开时会报错。
...全文
请发表友善的回复…
发表回复
xpchild 2008-07-20
- 打赏
- 举报
应该是驱动没有加载成功
xpchildd 2008-07-20
- 打赏
- 举报
先前是有这个报错，但现在不知道怎么没有了，我想试试连数据库 sql server 2000,在myeclipse界面下，用的是tomcat服务器
java.security.AccessControlException: access denied (java.lang.RuntimePermis
java.security.AccessControlException: access denied (java.lang.RuntimePermis
xpchildd 2008-07-20
- 打赏
- 举报
高手帮我看一下，
2008-7-20 10:00:48 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet jsp threw exception
java.lang.NoClassDefFoundError: com/microsoft/util/UtilLocalMessages
at com.microsoft.jdbc.base.BaseExceptions.<init>(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.setupExceptionHandling(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:60)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
2008-7-20 10:00:48 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet jsp threw exception
java.lang.NoClassDefFoundError: com/microsoft/util/UtilLocalMessages
at com.microsoft.jdbc.base.BaseExceptions.<init>(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.setupExceptionHandling(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:60)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
