如何在NetBeans中使用Java代码连接Sybase数据库? [英] How to connect Sybase database using Java code in NetBeans?

问题描述

我想通过用NetBeans编写的Java代码连接远程Sybase.到目前为止，我已经准备了如下代码:

I want to connect remote Sybase from my Java code written in NetBeans. So far I have prepared a code as below:

public static void connect()
{
   String host = "192.168.150.11";
   String url = "jdbc:sybase:Tds:"+host+":4100";
   String username = "sa";
   String password ="";
   SybDriver sybDriver = null;
   Connection conn;

   try 
   {
      sybDriver=(SybDriver)Class.forName("com.sybase.jdbc3.jdbc.SybDriver").newInstance();
      System.out.println("Driver Loaded");
      conn = DriverManager.getConnection(url,username,password);
      Statement stmt = conn.createStatement();
      ResultSet rs = stmt.executeQuery("select * from zxdbl_888..account_0");
      rs.next();
      System.out.println(rs.getString(2));

   } 
   catch (InstantiationException ex) 
   {
      Logger.getLogger(Offline_charge.class.getName()).log(Level.SEVERE, null, ex);
   } 
   catch (IllegalAccessException ex) 
   {
      Logger.getLogger(Offline_charge.class.getName()).log(Level.SEVERE, null, ex);
   } 
   catch (ClassNotFoundException ex) 
   {
      Logger.getLogger(Offline_charge.class.getName()).log(Level.SEVERE, null, ex);
   } 
   catch (SQLException ex) 
   {
      Logger.getLogger(Offline_charge.class.getName()).log(Level.SEVERE, null, ex);
   }
}

我得到的错误是:

java.lang.ClassNotFoundException: com.sybase.jdbc3.jdbc.SybDriver

我已经加载了jconn3.jar库.

推荐答案

通过Java应用程序安装Sybase驱动程序.

Install the Sybase drivers via a Java application.

Sybase:安装jConnect for JDBC

这篇关于如何在NetBeans中使用Java代码连接Sybase数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！