public List<YahooDailyStockDataDo> listDate(
String stockcode, String stockname, String date, int pageIndex, int limit)
throws SQLException, ClassNotFoundException {
// TODO Auto-generated method stub
StringBuilder sql = new StringBuilder();
sql.append("select t.* from StockDataYahoo t where 1=1 ");
if (stockcode == null || stockcode.equalsIgnoreCase("")) {
// Do Nothing
} else {
sql.append("and t.stockcode like '%" + stockcode + "%'");
}
if (stockname == null || stockname.equalsIgnoreCase("")) {
// Do Nothing
} else {
sql.append("and t.stockname like '%" + stockname + "%'");
}
if (date == null || date.equalsIgnoreCase("")) {
// Do Nothing
} else {
sql.append("and t.date = '" + date + "'");
}
// sql.append(" order by t.updatetime desc");
String pageSQL = SQLFactory.getPageSql(sql.toString(), pageIndex, limit);
Connection connection = null;
Statement sSta = null;
ResultSet resultSet = null;
List<YahooDailyStockDataDo> result = new ArrayList<YahooDailyStockDataDo>();
connection = DBFactory.CreateConnection();
try {
sSta =
connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
resultSet = sSta.executeQuery(pageSQL);
while (resultSet.next()) {
YahooDailyStockDataDo fms = new YahooDailyStockDataDo();
fms.setYahooseq(resultSet.getInt("YAHOOSEQ"));
fms.setStockname(resultSet.getString("STOCKNAME"));
fms.setStockcode(resultSet.getString("STOCKCODE"));
fms.setStockexchangecode(resultSet.getString("STOCKEXCHANGECODE"));
fms.setDate(resultSet.getString("date"));
fms.setOpen(resultSet.getString("open"));
fms.setHigh(resultSet.getString("high"));
fms.setLow(resultSet.getString("low"));
fms.setClose(resultSet.getString("close"));
fms.setVolumn(resultSet.getString("volumn"));
fms.setAdjclose(resultSet.getString("adjclose"));
result.add(fms);
}
} finally {
try {
if (connection != null) {
connection.close();
}
if (sSta != null) {
sSta.close();
}
if (resultSet != null) {
resultSet.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
return result;
}