在JAVA中连接Sybase数据库
2024年03月06日
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
*
*/
public SybaseTest()
{
try
{
Class.forName(sybaseDriverName);
}catch(ClassNotFoundException ex)
{
System.out.println(getErrorMessage(ex,"The Driver loaded error,please contact to your Software Designer!").toString());
}
}
public StringBuffer getErrorMessage(Exception ex,String alarmMessage)
{
StringBuffer errorStringBuffer=new StringBuffer();
errorStringBuffer.append(alarmMessage);
errorStringBuffer.append(ex.getMessage());
return errorStringBuffer;
}
/**
*getConnection method
* return Connection
*/
public Connection getConnection()
{
try
{
this.myConnection=DriverManager.getConnection(sybaseUrlToConnect,"sa","");
}catch(Exception ex)
{
System.out.println(getErrorMessage(ex,"Can not get connection,please contact to your Software Designer!").toString());
}
return this.myConnection;
}
/**
* param args
*/
public static void main(String[]args){
SybaseTest mySybaseTest=new SybaseTest();
try
{
Connection myConnection=mySybaseTest.getConnection();
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());
}
}
}