初学者学习如何适用jdbc连接sybase数据库 你试试com.sybase.jdbc2.jdbc.SybDriver还有端口号是对的吗 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 不好意思我就时用的com.sybase.jdbc2.jdbc.SybDriver端口时5000,是我的数据库.用户名和密码都是正确的具体代码如下:<%@ page contentType="text/html;charset=gb2312"%><%@ page import="java.util.Properties" %><%@ page import="java.sql.*" %><html><body><%Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();String url= "jdbc:sybase:Tds:localhost:5000/jwgl"; Properties sysProps=System.getProperties(); sysProps.put("use","sa");sysProps.put("password","");Connection conn= DriverManager.getConnection( "jdbc:sybase:Tds:localhost:5000/jwgl?charset=eucgb","sa","jw123456");Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE );String sql="select * from b_mz";ResultSet rs=stmt.executeQuery(sql); while(rs.next()){%> 您的第一个字段内容为:< %=rs.getString(1)% > 您的第二个字段内容为:< %=rs.getString(2)% > < %}% > < %out.print("数据库操作成功,恭喜你");% > <%rs.close();stmt.close(); conn.close(); %> </body></html>您看还有什么错误的疑点没有谢谢 Properties sysProps=System.getProperties(); sysProps.put("use","sa");sysProps.put("password","");和ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE 不要,你看还报什么错! 文件修改如下:<%@ page contentType="text/html;charset=gb2312"%><%@ page import="java.util.Properties" %><%@ page import="java.sql.*" %><html><body><%Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();Connection conn= DriverManager.getConnection( "jdbc:sybase:Tds:localhost:5000/jwgl?charset=eucgb","sa","jw123456");%> %out.print("数据库操作成功,恭喜你");% > <%conn.close(); %> </body></html>错误如下:javax.servlet.ServletException: JZ006: 捕获到 IO 例外:java.net.ConnectException: Connection refused: connect org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758) org.apache.jsp.testmysql_jsp._jspService(testmysql_jsp.java:67) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) 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) filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123)root cause java.sql.SQLException: JZ006: 捕获到 IO 例外:java.net.ConnectException: Connection refused: connect com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:487) com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:723) com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3071) com.sybase.jdbc2.tds.Tds.login(Tds.java:394) com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:218) com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:195) com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:174) com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:126) com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179) java.sql.DriverManager.getConnection(DriverManager.java:512) java.sql.DriverManager.getConnection(DriverManager.java:171) org.apache.jsp.testmysql_jsp._jspService(testmysql_jsp.java:50) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) 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) filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123) 呵呵问题解决了要把localhost改成我机器的ip才行,127.0.0.1也不行.所以虽然问题解决,但是还是不知道为什么,请大家指点]谢谢 和sybase的配置有关. sql.ini中 struts标签set和if的问题 谁有做敏感词过滤的经验,求高手进来 包含多个User类list<User>,对应数据库要怎么设计 求SSH教材 struts2+sitemesh 装饰器action路径问题··· hibernate一对多映射问题 怎样在Red Hat Enterprise Linux 5安装vsftp? 判断一个String类型的变量是否为空的最佳选择是什么? 关于action提交问题。。。。。 高手请回:hibernate-one to many and one-to-one的问题 关于如何引入一个类的问题 springmvc+hibernate整合,jar引了还出错
我就时用的com.sybase.jdbc2.jdbc.SybDriver
端口时5000,是我的数据库.用户名和密码都是正确的
具体代码如下:<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.util.Properties" %>
<%@ page import="java.sql.*" %>
<html>
<body>
<%Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();
String url= "jdbc:sybase:Tds:localhost:5000/jwgl";
Properties sysProps=System.getProperties();
sysProps.put("use","sa");
sysProps.put("password","");
Connection conn= DriverManager.getConnection( "jdbc:sybase:Tds:localhost:5000/jwgl?charset=eucgb","sa","jw123456");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE );
String sql="select * from b_mz";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){%>
您的第一个字段内容为:< %=rs.getString(1)% >
您的第二个字段内容为:< %=rs.getString(2)% >
< %}% >
< %out.print("数据库操作成功,恭喜你");% >
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
您看还有什么错误的疑点没有
谢谢
sysProps.put("use","sa");
sysProps.put("password","");
和
ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE
不要,
你看还报什么错!
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.util.Properties" %>
<%@ page import="java.sql.*" %>
<html>
<body>
<%Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();
Connection conn= DriverManager.getConnection( "jdbc:sybase:Tds:localhost:5000/jwgl?charset=eucgb","sa","jw123456");
%>
%out.print("数据库操作成功,恭喜你");% >
<%conn.close();
%>
</body>
</html>
错误如下:javax.servlet.ServletException: JZ006: 捕获到 IO 例外:java.net.ConnectException: Connection refused: connect
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.testmysql_jsp._jspService(testmysql_jsp.java:67)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
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)
filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123)
root cause java.sql.SQLException: JZ006: 捕获到 IO 例外:java.net.ConnectException: Connection refused: connect
com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:487)
com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:723)
com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3071)
com.sybase.jdbc2.tds.Tds.login(Tds.java:394)
com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:218)
com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:195)
com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:174)
com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:126)
com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
java.sql.DriverManager.getConnection(DriverManager.java:512)
java.sql.DriverManager.getConnection(DriverManager.java:171)
org.apache.jsp.testmysql_jsp._jspService(testmysql_jsp.java:50)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
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)
filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123)
问题解决了
要把localhost改成我机器的ip才行,127.0.0.1也不行.所以虽然问题解决,但是还是不知道为什么,请大家指点]谢谢
sql.ini中