在JAVA中连接Sybase数据库(例子)

最新推荐文章于 2021-02-26 04:36:42 发布

FaneAnn

最新推荐文章于 2021-02-26 04:36:42 发布

阅读量918

点赞数

CC 4.0 BY-SA版权

分类专栏： JAVA 文章标签： sybase 数据库 java exception string application

本文链接：https://blog.youkuaiyun.com/FaneAnn/article/details/466479

JAVA 专栏收录该内容

29 篇文章

订阅专栏

此博客展示了一个用Java编写的连接Sybase数据库的测试程序。程序包含加载JDBC驱动、获取数据库连接等功能，还执行了查询操作并输出结果，同时对可能出现的异常进行了处理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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

   }

}