在JAVA中连接Sybase数据库的例子

核心提示：以下是程序代码:import java.sql.*;/*** A JDBC test application for Sybase* @author Fane* @version 1.0.0* @since JDK1.4*/public class SybaseTest { PRivate final String s

　　以下是程序代码:

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());

　   }

 }

}