1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
PreparedStatement ps = null;
List array = new ArrayList();
Bigdecimal bd = null;
Date date = null;
SimpleDateFormat format = new SimpleDateFormat("yyyy/MM/dd");
Date start = format.parse("2006/08/01");
Date end = format.parse("2006/08/31");
ps =
connection.
prepareStatement("select meschiffres, mesdates from matable where mesjours between ? AND ?");
ps.setDate(1, start);
ps.setDate(2, end);
resultSet = ps.executeQuery();
while(resultSet.next()) {
bd = resultSet.getBigDecimal(1);
date = resultSet.getDate(2);
array.add(new Object[]{bd, date});
} |