这是此问题的mysql / java解决方案。
创建表语句：
CREATE TABLE `date_table` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `date` date NOT NULL, PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
Java代码：
public static void main(String[] args) throws ClassNotFoundException, SQLException { Database db = new Database("root", "root01", "test-db", "10.10.5.11"); db.connect(); int start_year = 2013; int end_year = 2100; for (int year = start_year; year < end_year; year++) { for (int month = 1; month <= 12; month++) { int days_in_month = 0; switch (month) { case 1: { //January days_in_month = 31; break; } case 2: { //February if (year % 4 == 0) { days_in_month = 29; } else { days_in_month = 28; } break; } case 3: { //March days_in_month = 31; break; } case 4: { //April days_in_month = 30; break; } case 5: { //May days_in_month = 31; break; } case 6: { //June days_in_month = 30; break; } case 7: { //July days_in_month = 31; break; } case 8: { //August days_in_month = 31; break; } case 9: { //September days_in_month = 30; break; } case 10: { //October days_in_month = 31; break; } case 11: { //November days_in_month = 30; break; } case 12: { //December days_in_month = 31; break; } } for (int day = 1; day <= days_in_month; day++) { db.executeInsert("INSERT INTO date_table (date) VALUES ('" + year + "-" + month + "-" + day + "');"); } } System.out.println("YEAR: " + year + " FINISHED"); } }我使用此sql获取日期列表：
SELECt * FROM date_table WHERe YEAR(date) = 2014 AND MonTH(date) = 2;
希望有人使用它:)
