测试浏览器页面时出错,
type Status reportmessage /sqlserver/err.jspdescription The requested resource (/sqlserver/err.jsp) is not available.大家帮忙看看什么问题啊。jsp代码如下:<%@ page import="java.sql.*"import="java.lang.*" errorPage="err.jsp" contentType="text/html;charset=GBK"%>
<%
String driverClassName;
String url;
Connection conn = null;
//加载sqlserver2000驱动
try{
driverClassName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
Class.forName(driverClassName);
}catch(ClassNotFoundException e){
out.println("无法加载驱动程序:<br>"+e.toString());
}
try{
url="jdbc:microsoft sqlserver://host:1433;DatabaseName=zulin";
conn = DriverManager.getConnection(url,"sa","yangguang123");
out.println("<p>成功连接到SQLserver数据库</p>");
}catch(SQLException e){
out.println("连接SqlServer2000时出现错误:<br>"+e.toString());
}
finally{
conn.close();
}
%>
type Status reportmessage /sqlserver/err.jspdescription The requested resource (/sqlserver/err.jsp) is not available.大家帮忙看看什么问题啊。jsp代码如下:<%@ page import="java.sql.*"import="java.lang.*" errorPage="err.jsp" contentType="text/html;charset=GBK"%>
<%
String driverClassName;
String url;
Connection conn = null;
//加载sqlserver2000驱动
try{
driverClassName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
Class.forName(driverClassName);
}catch(ClassNotFoundException e){
out.println("无法加载驱动程序:<br>"+e.toString());
}
try{
url="jdbc:microsoft sqlserver://host:1433;DatabaseName=zulin";
conn = DriverManager.getConnection(url,"sa","yangguang123");
out.println("<p>成功连接到SQLserver数据库</p>");
}catch(SQLException e){
out.println("连接SqlServer2000时出现错误:<br>"+e.toString());
}
finally{
conn.close();
}
%>
解决方案 »
- java通过tuxedo上传下载文件的问题
- 在Myeclipse中,经常莫名其妙出现很多标签配对错误,请教有类似经验的高手
- 一个简单的oracle 表的问题。
- 菜鸟提问(如果不用EJB,tomcat可以运行JAVA EE 程序吗?)
- sos:org.apache.jasper.JasperException: Unable to compile class for JSP
- <html:base/>搞什么用的?
- weblogic服务变成系统服务
- java写soap包问题(100分)
- 有关struts 中的plugIn 技术问题
- 一个问题
- 请教:我是JSP初学者,怎么学啊
- 解惑,,java怎样来实现cs的桌面应用程序??
package JDBC;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class sssss { public static Connection getConnect(){
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=zulin;SelectMethod=cursor;tds=8.0;lastupdatecount=true";
String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String password="";
String user="";
Connection conn = null;
try {
Class.forName(CLASSFORNAME);
conn = DriverManager.getConnection(url, user, password);
} catch (Exception e) {
e.printStackTrace();
System.out.println("一般错误是不体现在前台的,那是不有好的");
} return conn;
}
}
//如果一定要用JSP页面做JDBC链接,可以把稍作修改即可!!没什么两样。学习的时候要选择优秀的实例
2、你的sqlserver文件夹下有err.jsp么
3、你的url是否写正确了
4、import之间的空格要留出来
5、去掉errorPage之后出现的问题是什么啊说话的时候能不能说的具体点啊
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
<%@ page import="java.sql.*"import="java.lang.*" contentType="text/html;charset=GBK"%>
<%
String driverClassName;
String url;
//Connection conn = null;
//加载sqlserver2000驱动
try{
driverClassName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
Class.forName(driverClassName);
}catch(ClassNotFoundException e){
out.println("无法加载驱动程序:<br>"+e.toString());
}
try{
url="jdbc:microsoft:sqlserver://locahost:1433;DatabaseName=zulin";
Connection conn = DriverManager.getConnection(url,"sa","yangguang123");
out.println("<p>成功连接到SQLserver数据库</p>");
}catch(SQLException e){
out.println("连接SqlServer2000时出现错误:<br>"+e.toString());
}
finally{
// conn.close();
;
}
%>