文字列とdateitme型との比較について

Connection con = null;

PreparedStatement pStmt = null;

Resultset rs = null;

String sql = "SELECT id,name,count(*) FROM テーブル名 WHERE 日付=? ORDER BY id";



Class.forName("my.sql.Driver");

con = DriverManager.getConnection();

pStmt = con.prepareStatement(sql);

pStmt.setData(1,new java.sql.Date());

rs = pStmt.executeQuery();

while(rs.next()){

//処理

}

"SELECT id,name,count(*)
FROM テーブル名
WHERE
STR_TO_DATE('" + this.fromDay + "." + this.fromMonth + "." +
this.fromYear + " 00.00','%d.%m.%Y %H.%i') < "+
+ 日付（datetime型） + " AND "+
+ 日付（datetime型） + 
" < STR_TO_DATE('" + this.toDay + "." + this.toMonth + "." +
this.toYear + " 00.00','%d.%m.%Y %H.%i') " +
" ORDER BY id";