<%@ page contentType="text/html; charset=gb2312" language="java" errorPage="" %>
<%@ Page import="java.sql.*"%>
<html>
<head>
<title>无标题文档</title>
</head>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver:XING-AE809AD14D;DataaseName=sql";
String user="sa";String password="";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql="select * from student";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){%>
第一个字节内容为:<%=rs.getString(1)%>
第二个字节内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库连接成功");%>
<%rs.close();
stmt.close();
con.close();
%>
</body>
</html>
显示如图:结果是这样了
Location: /myapp/sjk.jsp
Internal Servlet Error:
org.apache.jasper.compiler.ParseException: D:\Tomcat 6.0\jakarta-tomcat\webapps\myapp\sjk.jsp(0,4) Invalid directive
at org.apache.jasper.compiler.Parser$Directive.accept(Parser.java:186)
at org.apache.jasper.compiler.Parser.parse(Parser.java:1070)
at org.apache.jasper.compiler.Parser.parse(Parser.java:1035)
at org.apache.jasper.compiler.Parser.parse(Parser.java:1031)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:182)
at org.apache.jasper.servlet.JspServlet.doLoadJSP(JspServlet.java:453)
at org.apache.jasper.servlet.JasperLoader12.loadJSP(JasperLoader12.java:146)
at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:424)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:152)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:164)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:309)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:382)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:387)
at org.apache.tomcat.core.Handler.service(Handler.java:263)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:371)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:786)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:732)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:407)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
at java.lang.Thread.run(Thread.java:595)
----------------解决方案--------------------------------------------------------
[IMG]http://127.0.1.1\C:\Documents and Settings\xing\桌面\11A3BE-A0E0-4C47-8B9A-ADE783CAE46A}0.jpg[/IMG]
----------------解决方案--------------------------------------------------------
看错误信息好像是强制转换错误，你到JSp转换成的JAVA代码找找错误
----------------解决方案--------------------------------------------------------
连接数据库有问题吗 ?!
----------------解决方案--------------------------------------------------------
数据库连接测试是成功的
----------------解决方案--------------------------------------------------------
<%@ page contentType="text/html; charset=gb2312" language="java" errorPage="" %>
<%@ Page import="java.sql.*"%>
<html>
<head>
<title>无标题文档</title>
</head>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver:XING-AE809AD14D;DataaseName=sql";
String user="sa";String password="";
Connection conn=DriverManager.getConnection(url,user,password);
con.close();
%>
</body>
</html>
就要这点看看连接时不时对的
可能是你这写错了
应该是conn.close();
别犯这样的错误了以后
----------------解决方案--------------------------------------------------------
哦，对了，检查检查你的用户名和密码
----------------解决方案--------------------------------------------------------
数据库连接没通的结果
----------------解决方案--------------------------------------------------------
晕 你写错了，
String url="jdbc:microsoft:sqlserver:XING-AE809AD14D;DataaseName=sql";
中的DataaseName改变DatabaseName，少了个 b
跟我 上次出的错误差不多，，，也往 这儿发来了，呵，，，
----------------解决方案--------------------------------------------------------
路过
----------------解决方案--------------------------------------------------------