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