java整合sybase_在JAVA中连接Sybase数据库(例子)

在JAVA中连接Sybase数据库(例子)推荐查看本文HTML版本

package person.fane.test;

/*

* 创建日期 2005-7-15

* created by Fane

*/

import java.sql.*;

/**

* A JDBC test application for Sybase

* @author Fane

* @version 1.0.0

* @since JDK1.4

*/

public class SybaseTest {

private final String sybaseDriverName = "com.sybase.jdbc3.jdbc.SybDriver";

private final String sybaseUrlToConnect ="jdbc:sybase:Tds:192.168.0.201:7543/cpemyy?charset=cp850&jconnect_version=3";

private Connection myConnection = null;

/**

* To load the jdbc driver

*

System.out.println("Now begin to excute.............");

PreparedStatement myPreparedStatement = myConnection.prepareStatement("select area_id, area_name,ip_address,tel,area_type,pc_id from c_area_info");

//myPreparedStatement.setInt(1,2);

ResultSet myResultSet = myPreparedStatement.executeQuery();

StringBuffer myStringBuffer = new StringBuffer();

while(myResultSet.next())

{

myStringBuffer.append(myResultSet.getInt(1)+"  ");

myStringBuffer.append(myResultSet.getString(2)+"  ");

myStringBuffer.append(myResultSet.getString(3)+"  ");

myStringBuffer.append(myResultSet.getString(4)+"  ");

myStringBuffer.append(myResultSet.getInt(5)+"  ");

myStringBuffer.append(myResultSet.getInt(6)+"  \n");

}

System.out.println(new String(myStringBuffer.toString().getBytes("ISO-8859-1"),"GBK"));

}catch(Exception ex)

{

System.out.println(mySybaseTest.getErrorMessage(ex,"Application error,please contact to your Software Designer!").toString());

}

}

}