当前页面: 开发资料首页 → JSP 专题 → 连接sybase数据库问题
连接sybase数据库问题
摘要: 连接sybase数据库问题
编了一个打印sybase数据库一张表的jsp，碰到以下问题连不上数据库
高手看一下是什么问题
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: /shujuku.jsp(1,1) Page directive has invalid attribute: contenttype
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.java:2219)
org.apache.jasper.compiler.Node$Root.accept(Node.java:456)
org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2163)
org.apache.jasper.compiler.Validator.validate(Validator.java:1438)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:214)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:470)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
--------------------------------------------------------------------------------
Page directive has invalid attribute
你的jsp中的Page标签有不合法的属性
贴出来看看
查看org.apache.jasper.JasperException: /shujuku.jsp(1,1) ，都告诉错误给你了，在shujuku.jsp第一行啊。
代码如下：
<%@ page contenttype="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<body>
<% connection con;
statement sql;
resultset rs;
try
{class.forname("com.sybase.jdbc2.jdbc.SybDriver");
}
catch(classnotfoundexception e)
{out.print("类找不到！");
}
try
{con=drivermanager.getconnection("jdbc:sybase:tds:134.201.4.6:4100/nvlocal","sa","nvlocal");
sql=con.creatstatement();
rs=sql.executequery("select * from state");
out.print("<table border>");
out.print("<tr><td colspan=8 align=center>状态</td></tr>");
out.print("<tr>");
out.print("<td width=100>"+"状态");
out.print("</tr>");
while(rs.next())
{out.print("<tr>");
out.print("<td>"+rs.getstring(8)+"</td>");
out.print("</tr>");
}
out.print("</table>");
con.close();
}
catch(sqlexecption el)
{out.print("sql异常！");
}
%>
</body>
<%@ page contentType="text/html; charset=gb2312" %>
↑返回目录
前一篇: 50分求下载的后台源码与前台连接问题
后一篇: 一个servlet如何跳转到另一个servlet