* self.StockNameList[8] = new;<br>
* self.StockNameList[8].TextValue.Setvalue('Forte');<br>
* <p>
*/
private void setupStockNameList() {
DBConnectionManager dBConnection = DBConnectionManager.getInstance("DBConnection");
ResultSet qq_rs = null;
PreparedStatement qq_cmd = null;
String qq_SQL = null;
try {
// -- =============== Original SQL ===============
// select StockName from Stock
// on session DBConnection
// -- ============================================
qq_SQL = "select StockName from Stock ";
qq_cmd = dBConnection.getPreparedStatement(qq_SQL);
qq_rs = qq_cmd.executeQuery();
ResultSetHelper qq_rsHelper = new ResultSetHelper(qq_rs);
while (qq_rsHelper.next()) {
TextData temp = qq_rsHelper.getTextData(1);
ListElement row = new ListElement();
row.getTextValue().setValue( temp.getValue() );
this.stockNameList.add(row);
}
}
catch (SQLException qq_error) {
throw new SQLErrorCodeSQLExceptionTranslator(dBConnection.getDataSource()).translate("Running SQL", qq_SQL, qq_error);
}
finally {
dBConnection.cleanup(qq_cmd);
}
}