Java連接SybaseASE數(shù)據(jù)庫的一個簡單例子

1、Java 連接 Sybase ASE 數(shù)據(jù)庫的一個簡單例子Java 連接 Sybase ASE 數(shù)據(jù)庫的一個簡單例子 2013-01-08 演示在用 java 連接 Sybase ASE 數(shù)據(jù)庫。用了 一個簡單的 java 程序作試驗。 第一步： 獲得 jdbc for sybase 驅(qū)動程序 下載 JDBC 驅(qū)動： 也可到 CSDN 下載： 有 jConnect6.05 和 jConnect5.5 兩種。jConnect6.05 中包含 jconn3.jar 包， jConnect5.5 中包含 jconn2.jar 包。建議最新 的 Sybase 驅(qū)動 jconn3.jar 。不過我的這個

2、例子很簡單， 兩者 都可以用。下載： jconn3.jar ，下載： jconn2.jar 第二步：設(shè) 置環(huán)境變量 CLASSPATH 將下載下來的 jconn2.jar 或 jconn3.jar 放到目錄 D:sybaseSharedlib 下。將環(huán)境變量 CLASSPATH 設(shè)置為： D:sybaseSharedlibjconn2.jarset CLASSPATH=.;d:sybasesharedlibjconn2.jar;（注意：第一個“ . 這”個，代表當前目錄。 ）第三步：編寫一段簡單的 java 程序。下面的這段程序用 jconn2.jar 連接 Sybase ASE15.0.3

3、數(shù)據(jù)庫并提取 master 數(shù)據(jù)庫中的用戶表的 ID 和 name 兩列 信息。 Sybase ASE 數(shù)據(jù)庫的 ip 地址為： 192.168.0.168 ， 端口： 5000 。登錄 sa 的密碼為： sybase 執(zhí)行： selectid,name,crdate from dbo.sysobjects where type=U這條語句返回當前數(shù)據(jù)庫(這在 url 中指定！)中的用戶表的 id 和 name 列。 import java.sql.*;import java.util.*;public class Conn2ASE public static void main(String

4、 args) try Class.forName(com.sybase.jdbc2.jdbc.SybDriver).newIn stance();String url = jdbc:sybase:Tds:192.168.0.168:5000/master;/ 數(shù)據(jù)庫名Properties sysProps =System.getProperties();sysProps.put(user, sa); /設(shè)置數(shù)據(jù)庫訪問用戶名sysProps.put(password, sybase); / 密碼 Connection conn =DriverManager.getConnection(url,

5、sysProps);Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);String sql = select id,name,crdate from dbo.sysobjects where type=U; / 表ResultSet rs = stmt.executeQuery(sql);while (rs.next() System.out.println(oject_id:+rs.getString(1)+,oject_nam e:+rs.get

6、String(2); / 取得第二列的值 catch (Exception e) System.out.println(e.getMessage();將上面這段代碼保存到：d:sybaseshareddemoConn2ASE.java 下載： Conn2ASE.java 第四步：編譯 java 源文件為 class 文件 javac.exe Conn2ASE.javaC:Documents and SettingsAdministrator>cd /d d:sybaseshareddemoD:sybaseShareddemo>setShareddemo>D:sybaseWor

7、kSpaceJDK1.5.0_15binj avac.exe Conn2ASE.jav aD:sybaseShareddemo>dir 驅(qū)動器 D 中的卷沒有標簽。 卷的序列號是 24C3-2A76 D:sybaseShareddemo 的目錄 2010-09-1517:08<DIR> .2010-09-1517:08 <DIR> .2010-09-1517:081,683 Conn2ASE.class2010-09-1517:021,107 Conn2ASE.java2 個文件2,790 字節(jié)2 個目錄18,468,270,080 可用字節(jié)第五步：執(zhí)行 java

8、 程序連接 Sybase ASE 數(shù)據(jù)庫， 并顯示查詢結(jié) 果java Conn2ASED:sybaseShareddemo>javaConn2ASE oject_id:960003420,oject_name:spt_values oject_id:992003534,oject_name:spt_monitor oject_id:1040003705,oject_name:spt_limit_types oject_id:1088003876,oject_name:syblicenseslog oject_id:1120003990,oject_name:spt_ijdbc_table

9、_types oject_id:1152004104,oject_name:spt_ijdbc_mda oject_id:1200004275,oject_name:spt_ijdbc_conversion oject_id:1232004389,oject_name:ijdbc_function_escapes oject_id:1440005130,oject_name:monTables oject_id:1472005244,oject_name:monTableParameters oject_id:1504005358,oject_name:monTableColumns ojec

10、t_id:1536005472,oject_name:monState oject_id:1568005586,oject_name:monEngine oject_id:1600005700,oject_name:monDataCache oject_id:1632005814,oject_name:monProcedureCache oject_id:1664005928,oject_name:monProcedureCacheMe moryUsage oject_id:1696006042,oject_name:monProcedureCacheMo duleUsage oject_id

11、:1728006156,oject_name:monOpenDatabases oject_id:1760006270,oject_name:monSysWorkerThread oject_id:1792006384,oject_name:monNetworkIO oject_id:1824006498,oject_name:monErrorLog oject_id:1856006612,oject_name:monLocks oject_id:1888006726,oject_name:monDeadLock oject_id:1920006840,oject_name:monWaitCl

12、assInfo oject_id:1952006954,oject_name:monWaitEventInfo oject_id:1984007068,oject_name:monCachedObject oject_id:2016007182,oject_name:monCachePool oject_id:2048007296,oject_name:monOpenObjectActivity oject_id:2080007410,oject_name:monIOQueue oject_id:2112007524,oject_name:monDeviceIO oject_id:214400

13、7638,oject_name:monSysWaits oject_id:28524104,oject_name:monProcess oject_id:60524218,oject_name:monProcessLookup oject_id:92524332,oject_name:monProcessActivity oject_id:124524446,oject_name:monProcessWorkerThrea d oject_id:156524560,oject_name:monProcessNetIO oject_id:188524674,oject_name:monProce

14、ssObject oject_id:220524788,oject_name:monProcessWaits oject_id:252524902,oject_name:monProcessStatement oject_id:284525016,oject_name:monSysStatement oject_id:316525130,oject_name:monProcessSQLText oject_id:348525244,oject_name:monSysSQLText oject_id:380525358,oject_name:monCachedProcedures oject_i

15、d:412525472,oject_name:monProcessProcedures oject_id:444525586,oject_name:monSysPlanText oject_id:476525700,oject_name:monOpenPartitionActivity oject_id:508525814,oject_name:monLicense oject_id:540525928,oject_name:monStatementCache oject_id:572526042,oject_name:monCachedStatement oject_id:604526156

16、,oject_name:monPCIBridge oject_id:636526270,oject_name:monPCISlots oject_id:668526384,oject_name:monPCIEngine oject_id:700526498,oject_name:monSQLRepActivity oject_id:732526612,oject_name:monSQLRepMisses oject_id:764526726,oject_name:spt_jdbc_table_types oject_id:796526840,oject_name:spt_mda oject_id:844527011,oject_name:spt_jtext oject_id:908527239,oject_name:spt_jdbc_conversion oject_id:940527353,oject_name:jdbc_function_escapes oject_id:1100527