java 连接sybase 数据库12.5无法连通
帮朋友写了一个jsp页面帮他实现一个法院的led大屏幕的显示页面,实现还是很简单的,只是在连接数据库时出现了点问题:无法连接数据库,debug了一下发现报错在
创建conn(url,user,password)连接上,sybase版本是12.5,操做系统是sybase安装的机子是小型机,liunix系统,地址192.16.80.195端口4100数据库名j贴出代码,不给出配置文件和common.PropertiesUnit类,不需要大家调试,请有经验的朋友帮我想想可能的错误情况:
ps:url连接,用户名,数据库密码是我最大的怀疑出错的地方,但是朋友说一定没问题,难道是我的包不对?引入了jconn3.jar;和 jTDS3.jar两个jar包(我也不知道用那个索性都引入了)。
非常感谢达人的指点,小生经验不足。。。
=======
<%@ page contentType="text/html;charset=utf-8"%>
<%@ page import="java.sql.*"%>
<%@ page import="common.PropertiesUnit"%>
<%@ page import="com.sybase.jdbc3.jdbc.SybDriver"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.text.*"%>
<%@ page import="java.util.Calendar"%>
<%
int time =-30;
String tableWidth = "98%";
String textcolour = "white";
String tableBorder = "1";
String bgcolor = "black";
String frame="below";
String scrollAmount="3";
String bordercolor="white";
String rules="all";
String xunhuncishu="10";
String flashtime="180";
String file = "D:\\WEB\\SWH\\sinoPNS\\config.properties";//读取配置文件
PropertiesUnit conf = new PropertiesUnit(file);
try{
//PropertiesUnit conf = new PropertiesUnit(file);
if(conf!=null){
tableWidth = conf.getValue("tableWidth");
textcolour = conf.getValue("textcolour");
tableBorder = conf.getValue("tableBorder");
bgcolor = conf.getValue("bgcolor");
bordercolor=conf.getValue("bordercolor");
rules=conf.getValue("rules");
xunhuncishu=conf.getValue("xunhuncishu");
flashtime=conf.getValue("flashtime");
scrollAmount=conf.getValue("scrollAmount");
frame=conf.getValue("frame");
time =Integer.parseInt( conf.getValue("time"));//预计开庭时间
}
}
catch(Exception ex){
ex.printStackTrace();
System.out.println("无法读取配置文件!!!");
}
%>
<script language="javascript">
setInterval("document.getElementById('time').innerHTML=new Date().toLocaleString()+' 星期'+'日一二三四五六'.charAt(new Date().getDay());",10);
</script>
<html>
<head>
<title>法院信息公告系统</title>
<%
response.setHeader("refresh",flashtime);
%>
</head>
<body bgcolor=<%=bgcolor%> text=<%=textcolour%> >
<table ><tr><td><font color="white" size="6"> 开庭信息</font></td><td width="20%"></td><td><font color="white" size="4" id="time"></font></td></tr></table>
<table border=<%=tableBorder %> width="<%=tableWidth%>" bordercolor=<%=bordercolor %> rules="none" frame="hsides" cellspacing="0">
<tr>
<td align="center" width=20%><font size="5">案号</font></td>
<td align="center" width=40%><font size="5">案由</font></td>
<td align="center" width="10%"><font size="5">承办人</font></td>
<td align="center" width="10%"><font size="5">开庭时间</font></td>
<td align="center" width="10%"><font size="5">开庭地点</font></td>
<td align="center" width="10%"><font size="5">书记员</font></td>
</tr></table>
<MARQUEE scrollAmount=<%=scrollAmount %> direction=up width="100%" height="100%" >
<% //控制循环次数
int m=Integer.parseInt(xunhuncishu);
if(m<=0){m=1;}
for( int i=0;i<m;i++){
%>
<table border=<%=tableBorder %> width="<%=tableWidth%>" bordercolor=<%=bordercolor %> rules=<%=rules%> frame="<%=frame %>"cellspacing="0">
<%
String DBDRIVER = conf.getValue("DBDRIVER");
String DBURL = conf.getValue("DBURL");
String DBUSER = conf.getValue("DBUSER");
String DBPASSWORD = conf.getValue("DBPASSWORD");
//String sql_language = conf.getValue("sql_language");
Connection conn = null ;
System.out.println("开始创建驱动对象...");
Class.forName(DBDRIVER).newInstance(); //.newInstance()
System.out.println("创建驱动对象成功...");
String url =DBURL;//myDB为你的数据库名
%>
<%
try
{
//取当前时间
Date now = new Date();
SimpleDateFormat d = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String nowTime = d.format(now);
Calendar cd = Calendar.getInstance();
cd.setTime(d.parse(nowTime));
cd.add(Calendar.DATE, time);//增加一天
String aheadtime =d.format(cd.getTime());
System.out.println("conn对象开始建立连接...");
//conn= DriverManager.getConnection(url,DBUSER,DBPASSWORD);
conn= DriverManager.getConnection("jdbc:sybase:Tds:192.168.80.195:4100/JUDGE","sa","a741030elwengs");//这里就出错了- -
System.out.println("conn对象建立连接 成功...");
//String sql = "SELECT case_reasion,case_id,case_strattime,case_startplace,case_master,case_writer FROM case_inf where case_strattime "+" >="+"'"+ nowTime+"'"+
// " and '" + nowTime+ " ' >= ' " + aheadtime + " ' order by case_strattime asc ";
String sql = "SELECT case_reasion,case_id,case_strattime,case_startplace,case_master,case_writer FROM case_inf ";
System.out.println("11111111111111111="+sql);
PreparedStatement pstmt = null ;
System.out.println("创建pstmt ...");
pstmt = conn.prepareStatement(sql) ;
System.out.println("创建pstmt 成功...");
ResultSet rs = pstmt.executeQuery() ;
System.out.println("rs读取数据集 成功...");
%>
<%
//int i = 0 ;
while(rs.next())
{
//i++ ;
String case_reasion = rs.getString(1) ;
String case_id = rs.getString(2) ;
String case_strattime = rs.getString(3) ;
String case_startplace = rs.getString(4) ;
String case_master = rs.getString(5) ;
String case_writer = rs.getString(6) ;
%>
<tr>
<td align="center" width=20%><%=case_id %></td>
<td align="center" width=40%><%=case_reasion %></td>
<td align="center" width=10%><%= case_master%></td>
<td align="center" width=10%><%=case_strattime %></td>
<td align="center" width=10%><%= case_startplace%></td>
<td align="center" width=10%><%= case_writer%></td>
</tr>
<%
}
rs.close() ;
pstmt.close() ;
%>
<%
}
catch(Exception e)
{
System.out.println("数据库连接出错...");
%>
<h2>通讯出错!!</h2>
<%
}
finally
{
conn.close() ;
System.out.println("自动释放数据库连接...");
}
%>
<!-- 控制两张表之间的的间隔 -->
<%int lines=8;
String jiange =" ";
for(int j= 0;j<lines;j++)
{
jiange =jiange+"<br>";
} %>
<%=jiange%>
</table>
<%
}
%>
</MARQUEE>
</body>
</html>
================================
!#############################Sybase数据库配置文件##################################################
!sybase数据库注册驱动
DBDRIVER=com.sybase.jdbc3.jdbc.SybDriver
!sybase数据库连接myDB为你的数据库名
DBURL =jdbc:sybase:Tds:192.168.80.195:4100/JUDGE
DBUSER = sa
DBPASSWORD = 123
================================
创建conn(url,user,password)连接上,sybase版本是12.5,操做系统是sybase安装的机子是小型机,liunix系统,地址192.16.80.195端口4100数据库名j贴出代码,不给出配置文件和common.PropertiesUnit类,不需要大家调试,请有经验的朋友帮我想想可能的错误情况:
ps:url连接,用户名,数据库密码是我最大的怀疑出错的地方,但是朋友说一定没问题,难道是我的包不对?引入了jconn3.jar;和 jTDS3.jar两个jar包(我也不知道用那个索性都引入了)。
非常感谢达人的指点,小生经验不足。。。
=======
<%@ page contentType="text/html;charset=utf-8"%>
<%@ page import="java.sql.*"%>
<%@ page import="common.PropertiesUnit"%>
<%@ page import="com.sybase.jdbc3.jdbc.SybDriver"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.text.*"%>
<%@ page import="java.util.Calendar"%>
<%
int time =-30;
String tableWidth = "98%";
String textcolour = "white";
String tableBorder = "1";
String bgcolor = "black";
String frame="below";
String scrollAmount="3";
String bordercolor="white";
String rules="all";
String xunhuncishu="10";
String flashtime="180";
String file = "D:\\WEB\\SWH\\sinoPNS\\config.properties";//读取配置文件
PropertiesUnit conf = new PropertiesUnit(file);
try{
//PropertiesUnit conf = new PropertiesUnit(file);
if(conf!=null){
tableWidth = conf.getValue("tableWidth");
textcolour = conf.getValue("textcolour");
tableBorder = conf.getValue("tableBorder");
bgcolor = conf.getValue("bgcolor");
bordercolor=conf.getValue("bordercolor");
rules=conf.getValue("rules");
xunhuncishu=conf.getValue("xunhuncishu");
flashtime=conf.getValue("flashtime");
scrollAmount=conf.getValue("scrollAmount");
frame=conf.getValue("frame");
time =Integer.parseInt( conf.getValue("time"));//预计开庭时间
}
}
catch(Exception ex){
ex.printStackTrace();
System.out.println("无法读取配置文件!!!");
}
%>
<script language="javascript">
setInterval("document.getElementById('time').innerHTML=new Date().toLocaleString()+' 星期'+'日一二三四五六'.charAt(new Date().getDay());",10);
</script>
<html>
<head>
<title>法院信息公告系统</title>
<%
response.setHeader("refresh",flashtime);
%>
</head>
<body bgcolor=<%=bgcolor%> text=<%=textcolour%> >
<table ><tr><td><font color="white" size="6"> 开庭信息</font></td><td width="20%"></td><td><font color="white" size="4" id="time"></font></td></tr></table>
<table border=<%=tableBorder %> width="<%=tableWidth%>" bordercolor=<%=bordercolor %> rules="none" frame="hsides" cellspacing="0">
<tr>
<td align="center" width=20%><font size="5">案号</font></td>
<td align="center" width=40%><font size="5">案由</font></td>
<td align="center" width="10%"><font size="5">承办人</font></td>
<td align="center" width="10%"><font size="5">开庭时间</font></td>
<td align="center" width="10%"><font size="5">开庭地点</font></td>
<td align="center" width="10%"><font size="5">书记员</font></td>
</tr></table>
<MARQUEE scrollAmount=<%=scrollAmount %> direction=up width="100%" height="100%" >
<% //控制循环次数
int m=Integer.parseInt(xunhuncishu);
if(m<=0){m=1;}
for( int i=0;i<m;i++){
%>
<table border=<%=tableBorder %> width="<%=tableWidth%>" bordercolor=<%=bordercolor %> rules=<%=rules%> frame="<%=frame %>"cellspacing="0">
<%
String DBDRIVER = conf.getValue("DBDRIVER");
String DBURL = conf.getValue("DBURL");
String DBUSER = conf.getValue("DBUSER");
String DBPASSWORD = conf.getValue("DBPASSWORD");
//String sql_language = conf.getValue("sql_language");
Connection conn = null ;
System.out.println("开始创建驱动对象...");
Class.forName(DBDRIVER).newInstance(); //.newInstance()
System.out.println("创建驱动对象成功...");
String url =DBURL;//myDB为你的数据库名
%>
<%
try
{
//取当前时间
Date now = new Date();
SimpleDateFormat d = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String nowTime = d.format(now);
Calendar cd = Calendar.getInstance();
cd.setTime(d.parse(nowTime));
cd.add(Calendar.DATE, time);//增加一天
String aheadtime =d.format(cd.getTime());
System.out.println("conn对象开始建立连接...");
//conn= DriverManager.getConnection(url,DBUSER,DBPASSWORD);
conn= DriverManager.getConnection("jdbc:sybase:Tds:192.168.80.195:4100/JUDGE","sa","a741030elwengs");//这里就出错了- -
System.out.println("conn对象建立连接 成功...");
//String sql = "SELECT case_reasion,case_id,case_strattime,case_startplace,case_master,case_writer FROM case_inf where case_strattime "+" >="+"'"+ nowTime+"'"+
// " and '" + nowTime+ " ' >= ' " + aheadtime + " ' order by case_strattime asc ";
String sql = "SELECT case_reasion,case_id,case_strattime,case_startplace,case_master,case_writer FROM case_inf ";
System.out.println("11111111111111111="+sql);
PreparedStatement pstmt = null ;
System.out.println("创建pstmt ...");
pstmt = conn.prepareStatement(sql) ;
System.out.println("创建pstmt 成功...");
ResultSet rs = pstmt.executeQuery() ;
System.out.println("rs读取数据集 成功...");
%>
<%
//int i = 0 ;
while(rs.next())
{
//i++ ;
String case_reasion = rs.getString(1) ;
String case_id = rs.getString(2) ;
String case_strattime = rs.getString(3) ;
String case_startplace = rs.getString(4) ;
String case_master = rs.getString(5) ;
String case_writer = rs.getString(6) ;
%>
<tr>
<td align="center" width=20%><%=case_id %></td>
<td align="center" width=40%><%=case_reasion %></td>
<td align="center" width=10%><%= case_master%></td>
<td align="center" width=10%><%=case_strattime %></td>
<td align="center" width=10%><%= case_startplace%></td>
<td align="center" width=10%><%= case_writer%></td>
</tr>
<%
}
rs.close() ;
pstmt.close() ;
%>
<%
}
catch(Exception e)
{
System.out.println("数据库连接出错...");
%>
<h2>通讯出错!!</h2>
<%
}
finally
{
conn.close() ;
System.out.println("自动释放数据库连接...");
}
%>
<!-- 控制两张表之间的的间隔 -->
<%int lines=8;
String jiange =" ";
for(int j= 0;j<lines;j++)
{
jiange =jiange+"<br>";
} %>
<%=jiange%>
</table>
<%
}
%>
</MARQUEE>
</body>
</html>
================================
!#############################Sybase数据库配置文件##################################################
!sybase数据库注册驱动
DBDRIVER=com.sybase.jdbc3.jdbc.SybDriver
!sybase数据库连接myDB为你的数据库名
DBURL =jdbc:sybase:Tds:192.168.80.195:4100/JUDGE
DBUSER = sa
DBPASSWORD = 123
================================
...全文
相关推荐
Sybase12.5 数据库创建与导入数据库
Windows环境下Sybase12.5 数据库创建与导入数据库
Sybase12.5 ODBC驱动
解压后 包含两个文件 一个说明文件 一个jar包,jar解压后按照说明操作即可。
sybase12.5.2
sybase数据库安装包,含客户端(openclient,odbc,jdbc,连接工具sybase Central),服务端
Sybase ASE 12.5.4 PC 客户端
Sybase ASE 12.5.4 PC 客户端,12系列最终版本, Sybase ASE 12.5.4 PC 客户端,12系列最终版本,
sybase12.5 odbc.rar
sybase12.5 odbc for windows,这是个较老的SyBase版本的Windows客户端的ODBC驱动。


Web 开发
