jsp访问sqlserver2000数据库问题

来源:百度知道 编辑:UC知道 时间:2024/09/19 15:33:41
用它访问数据库时,出现了如下错误:
type Exception report

message

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

exception

org.apache.jasper.JasperException: /data.jsp(1,1) Page directive has invalid attribute: contenType
org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:39)
org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:409)
org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:200)
org.apache.jasper.compiler.JspUtil.checkAttributes(JspUtil.java:304)
org.apache.jasper.compiler.Validator$DirectiveVisitor.visit(Validator.java:100)
org.apache.jasper.compiler.Node$PageDirective.accept(Node.java:549)
org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2163)
org.apache.jasper.compiler.Node$Visitor.visitBody(Node.java:2213)
org.apache.jasper.compiler.Node$Visitor.visit(Node

没有注册驱动
Class.forName(...);

给你一个我做过的例子的一部分
public static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
public static final String URL="jdbc:sqlserver://localhost:1433;databaseName=company";
public static final String DBNAME="sa";
public static final String DBPASS="";

/**
* 得到数据库连接
* @return
*/
public Connection getConn(){
Connection conn=null;
try {
Class.forName(DRIVER); //注册驱动
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

try {
conn=DriverManager.getConnection(URL,DBNAME,DBPASS);//连接数据
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

return conn;
}

Connection con;
Statement sql;
ResultSet rs;
t