还是连不了sql2000,高手请进 本帖最后由 scholar999 于 2011-01-23 19:22:57 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 IE运行后就显示以下这段代码:< %@ page contentType="text/html;charset=gb2312"% > < %@ page import="java.sql.*"% > < html > < body > < %Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs"; //pubs为你的数据库的 String user="sa"; String password=""; Connection conn= DriverManager.getConnection(url,user,password); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select * from titles"; ResultSet rs=stmt.executeQuery(sql); while(rs.next()) {% > 您的第一个字段内容为:< %=rs.getString(1)% > 您的第二个字段内容为:< %=rs.getString(2)% > < %}% > < %out.print("数据库操作成功,恭喜你");% > < %rs.close(); stmt.close(); conn.close(); % > < /body > < /html > 你这样的错误信息好像根本就没把页面当做jsp页面对待一样,完全就是纯文本输出来的。我估计你就没通过服务器就直接把它打开了。 我也觉得奇怪,我运行其它jsp程序是可以的,但与数据库有关的就不行。是纯文本输出,请问要怎么解决? 第一行应该是<%@ page contentType="text/html;charset=gb2312" language="java" %> 即 需包含 language="java" 表示是 java的 加了,还是不行,又输出纯文本:< %@ page import="java.sql.*"% > < html > < body > < %Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs"; //pubs为你的数据库的 String user="sa"; String password="a+++"; Connection conn= DriverManager.getConnection(url,user,password); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select * from titles"; ResultSet rs=stmt.executeQuery(sql); while(rs.next()) {% > 您的第一个字段内容为:< %=rs.getString(1)% > 您的第二个字段内容为:< %=rs.getString(2)% > < %}% > < %out.print("数据库操作成功,恭喜你");% > < %rs.close(); stmt.close(); conn.close(); % > < /body > < /html > jdbc4好像就可以,反正不是你那个,你那个是连mysql还差不多 sqlserver的jdbc驱动包是三个msbase.jarmssqlserver.jarmsutil.jar你的这个mysql-connector-java-5.1.7-bin.jar是连接mysql数据库的 这三个包我也下载了,放在Tomcat 6.0\bin 里,但程序也不行 要安装吗?哪里下载? 我下载了,解压后只有三个文件msbase.jar;mssqlserver.jar;msutil.jar我把它们放在Tomcat 6.0\bin 里,但程序也运行不了 最新出错信息:HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /sql.jsp at line 118: Connection conn= DriverManager.getConnection(url,user,password); 9: Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 10: String sql="select * from stu"; 11: ResultSet rs=stmt.executeQuery(sql); 12: while(rs.next()){ %> 13: 您的第一个字段内容为:<%=rs.getString(1)%><br> 14: 您的第二个字段内容为:<%=rs.getString(2)%><br> Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) javax.servlet.http.HttpServlet.service(HttpServlet.java:717)root cause javax.servlet.ServletException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]对象名 'stu' 无效。 org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781) org.apache.jsp.sql_jsp._jspService(sql_jsp.java:97) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) javax.servlet.http.HttpServlet.service(HttpServlet.java:717)root cause java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]对象名 'stu' 无效。 com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source) com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source) com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source) com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source) com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source) com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown Source) org.apache.jsp.sql_jsp._jspService(sql_jsp.java:67) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) javax.servlet.http.HttpServlet.service(HttpServlet.java:717)note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs. JSP用JDBC连接MYSQL问题,请大虾帮忙 shutdown.bat 使用tomcat的时候,为撒关闭不了啊 JSP访问mysql数据库取一条数据时,速度很慢。。求优化方案! 有关ssh 在windows2003中,如何配置JDBC? 一个简单的jsp竟然出错,请各位高手帮我看看是什么错误! 重新启动web服务或重新启动web服务器,为什么jsp不被重新编译?在先等 在SERVLET里如何向下一页面传递参数?至少给你50分! 急!我想写一些Servlet小程序,却........... 高分请教一个架构问题 JSP页面跳转 怎么在IE中直接打开文档(word,pdf等),不弹出下载框
IE运行后就显示以下这段代码:
< %@ page contentType="text/html;charset=gb2312"% > < %@ page import="java.sql.*"% > < html > < body > < %Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs"; //pubs为你的数据库的 String user="sa"; String password=""; Connection conn= DriverManager.getConnection(url,user,password); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select * from titles"; ResultSet rs=stmt.executeQuery(sql); while(rs.next()) {% > 您的第一个字段内容为:< %=rs.getString(1)% > 您的第二个字段内容为:< %=rs.getString(2)% > < %}% > < %out.print("数据库操作成功,恭喜你");% > < %rs.close(); stmt.close(); conn.close(); % > < /body > < /html >
我也觉得奇怪,我运行其它jsp程序是可以的,但与数据库有关的就不行。是纯文本输出,请问要怎么解决?
<%@ page contentType="text/html;charset=gb2312" language="java" %>
即 需包含 language="java" 表示是 java的
加了,还是不行,又输出纯文本:
< %@ page import="java.sql.*"% > < html > < body > < %Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs"; //pubs为你的数据库的 String user="sa"; String password="a+++"; Connection conn= DriverManager.getConnection(url,user,password); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select * from titles"; ResultSet rs=stmt.executeQuery(sql); while(rs.next()) {% > 您的第一个字段内容为:< %=rs.getString(1)% > 您的第二个字段内容为:< %=rs.getString(2)% > < %}% > < %out.print("数据库操作成功,恭喜你");% > < %rs.close(); stmt.close(); conn.close(); % > < /body > < /html >
msbase.jar
mssqlserver.jar
msutil.jar你的这个mysql-connector-java-5.1.7-bin.jar是连接mysql数据库的
这三个包我也下载了,放在Tomcat 6.0\bin 里,但程序也不行
要安装吗?哪里下载? 我下载了,解压后只有三个文件msbase.jar;mssqlserver.jar;msutil.jar
我把它们放在Tomcat 6.0\bin 里,但程序也运行不了
最新出错信息:
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /sql.jsp at line 118: Connection conn= DriverManager.getConnection(url,user,password);
9: Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
10: String sql="select * from stu";
11: ResultSet rs=stmt.executeQuery(sql);
12: while(rs.next()){ %>
13: 您的第一个字段内容为:<%=rs.getString(1)%><br>
14: 您的第二个字段内容为:<%=rs.getString(2)%><br>
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause javax.servlet.ServletException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]对象名 'stu' 无效。
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.sql_jsp._jspService(sql_jsp.java:97)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]对象名 'stu' 无效。
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown Source)
org.apache.jsp.sql_jsp._jspService(sql_jsp.java:67)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.