to diablero,
воть
| Код |
public List getAccountsListByUserID( int clientID ) {
ArrayList<BankAccount> accounts = new ArrayList<BankAccount>();
BankAccount account = null;
try {
connection = pool.getConnection();
sql = "SELECT DISTINCT S.Account AS account, F.Ccy AS code " +
"FROM AccountS AS S INNER JOIN FinInstr AS F ON S.ISO = F.FI_Code " +
"WHERE ( S.Client = ? ) AND ( S.Open_Close > 0 )";
pstmt = connection.prepareStatement( sql );
pstmt.setInt( 1, clientID );
rs = pstmt.executeQuery();
while( rs.next() ) {
account = new BankAccount();
account.setNumber( rs.getString("account") );
account.setCode( rs.getString("code") );
accounts.add( account );
}
sql = "SELECT DISTINCT V.Account AS account, F.Ccy AS code " +
"FROM AccountV AS V INNER JOIN FinInstr AS F ON V.ISO = F.FI_Code " +
"WHERE ( V.Client = ? ) AND ( V.Open_Close > 0 )";
pstmt = connection.prepareStatement( sql );
pstmt.setInt( 1, clientID );
rs = pstmt.executeQuery();
while( rs.next() ) {
account = new BankAccount();
account.setNumber( rs.getString("account") );
account.setCode( rs.getString("code") );
accounts.add( account );
}
} catch (SQLException ex) {
ex.printStackTrace();
} finally {
try {
pstmt.close();
connection.close();
} catch(SQLException ex) {
ex.printStackTrace();
}
}
return accounts;
}
|
|