java 连接sybase_最基础的JDBC连接SYBASE方式

package com.citi.hnw.mainframe;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import java.util.List;

import org.apache.log4j.Logger;

public class getCusipList {

private static Logger logger = Logger.getLogger(getCusipList.class);

public static void main(String[] args) throws SQLException{

getCusipList cusip = new getCusipList();

cusip.getList();

}

public void getList() throws SQLException{

Connection con = null;

try{

con = getConnection();

}finally{

closeConnection(con);

}

}

public Connection getConnection(){

Connection con = null;

Statement stmt = null;

ResultSet rs = null;

List list = new ArrayList();

String sql="select distinct Cusip as cusip from HnwFeedPosition";

try{

Class.forName("com.sybase.jdbc2.jdbc.SybDriver");

String connectionUrl="jdbc:sybase:Tds:dbname:port?ServiceName=dbname";

con = DriverManager.getConnection(connectionUrl,"username","password");

System.out.println("Connection detail is : "

+ con.getMetaData().getDatabaseProductName()

+ "," + con.getMetaData().getURL()

+ "," + con.getMetaData().getUserName());

stmt = con.createStatement();

stmt.setFetchSize(500);

rs = stmt.executeQuery(sql);

while(rs.next()){

list.add(rs.getString("cusip"));

System.out.println(list.size());

}

}catch(Exception ex){

ex.printStackTrace();

}

return con;

}

public void closeConnection(Connection con){

if( null != con ){

try {

con.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

public void closeStatement(Statement stmt){

if( null != stmt ){

try {

stmt.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

public void closeResultSet(ResultSet rs){

if( null != rs ){

try {

rs.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

}