以下是程序代码:

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

     }

 }

}