自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+
  • 博客(1)
  • 资源 (2)
  • 收藏
  • 关注

原创 poi生成excel————从数据库中查询导出生成excel

package com.security.util; import java.io.File; import java.io.FileOutputStream; import java.io.IOException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.List;

2015-09-15 16:42:52 297

日历转换——java

下载代码可以使用 public class Lunar { private int year; private int month; private int day; private boolean leap; private Calendar clendar; final static String chineseNumber[] = { "一", "二", "三", "四", "五", "六", "七", "八", "九", "十", "十一", "十二" }; static SimpleDateFormat chineseDateFormat = new SimpleDateFormat( "yyyy年MM月dd日"); final static long[] lunarInfo = new long[] { 0x04bd8, 0x04ae0, 0x0a570, 0x054d5, 0x0d260, 0x0d950, 0x16554, 0x056a0, 0x09ad0, 0x055d2, 0x04ae0, 0x0a5b6, 0x0a4d0, 0x0d250, 0x1d255, 0x0b540, 0x0d6a0, 0x0ada2, 0x095b0, 0x14977, 0x04970, 0x0a4b0, 0x0b4b5, 0x06a50, 0x06d40, 0x1ab54, 0x02b60, 0x09570, 0x052f2, 0x04970, 0x06566, 0x0d4a0, 0x0ea50, 0x06e95, 0x05ad0, 0x02b60, 0x186e3, 0x092e0,

2015-06-26

阳历转阴历_java

日历转换,阳历转阴历 下载文件可以使用 package com.action.entity; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Calendar; import java.util.Date; import java.util.GregorianCalendar; public class Lunar { private int year; private int month; private int day; private boolean leap; private Calendar clendar; final static String chineseNumber[] = { "一", "二", "三", "四", "五", "六", "七", "八", "九", "十", "十一", "十二" }; static SimpleDateFormat chineseDateFormat = new SimpleDateFormat( "yyyy年MM月dd日"); final static long[] lunarInfo = new long[] { 0x04bd8, 0x04ae0, 0x0a570, 0x054d5, 0x0d260, 0x0d950, 0x16554, 0x056a0, 0x09ad0, 0x055d2, 0x04ae0, 0x0a5b6, 0x0a4d0, 0x0d250, 0x1d255, 0x0b540, 0x0d6a0, 0x0ada2, 0x095b0, 0x14977, 0x04970, 0x0a4b0, 0x0b4b5, 0x06a50, 0x06d40, 0x1ab54, 0x02b60, 0x09570, 0x052f2, 0x04970, 0x06566, 0x0d4a0, 0x0ea50, 0x06e95, 0x05ad0, 0x02b60, 0x186e3, 0x092e0, 0x1c8d7, 0x0c950, 0x0d4a0, 0x1d8a6, 0x0b550, 0x056a0, 0x1a5b4, 0x025d0, 0x092d0, 0x0d2b2, 0x0a950, 0x0b557, 0x06ca0, 0x0b550, 0x15355, 0x04da0, 0x0a5d0, 0x14573, 0x052d0, 0x0a9a8, 0x0e950, 0x06aa0, 0x0aea6, 0x0ab50, 0x04b60, 0x0aae4, 0x0a570, 0x05260, 0x0f263, 0x0d950, 0x05b57, 0x056a0, 0x096d0, 0x04dd5, 0x04ad0, 0x0a4d0, 0x0d4d4, 0x0d250, 0x0d558, 0x0b540, 0x0b5a0, 0x195a6, 0x095b0, 0x049b0, 0x0a974, 0x0a4b0, 0x0b27a, 0x06a50, 0x06d40, 0x0af46, 0x0ab60, 0x09570, 0x04af5, 0x04970, 0x064b0, 0x074a3, 0x0ea50, 0x06b58, 0x055c0, 0x0ab60, 0x096d5, 0x092e0, 0x0c960, 0x0d954, 0x0d4a0, 0x0da50, 0x07552, 0x056a0, 0x0abb7, 0x025d0, 0x092d0, 0x0cab5, 0x0a950, 0x0b4a0, 0x0baa4, 0x0ad50, 0x055d9, 0x04ba0, 0x0a5b0, 0x15176, 0x052b0, 0x0a930, 0x07954, 0x06aa0, 0x0ad50, 0x05b52, 0x04b60, 0x0a6e6, 0x0a4e0, 0x0d260, 0x0ea65, 0x0d530, 0x05aa0, 0x076a3, 0x096d0, 0x04bd7, 0x04ad0, 0x0a4d0, 0x1d0b6, 0x0d250, 0x0d520, 0x0dd45, 0x0b5a0, 0x056d0, 0x055b2, 0x049b0, 0x0a577, 0x0a4b0, 0x0aa50, 0x1b255, 0x06d20, 0x0ada0 }; // Array lIntLunarDay is stored in the monthly day information in every year from 1901 to 2100 of the lunar calendar, // The lunar calendar can only be 29 or 30 days every month, express with 12(or 13) pieces of binary bit in one year, // it is 30 days for 1 form in the corresponding location , otherwise it is 29 days private static final int [] iLunarMonthDaysTable = { 0x4ae0 , 0xa570 , 0x5268 , 0xd260 , 0xd950 , 0x6aa8 , 0x56a0 , 0x9ad0 , 0x4ae8 , 0x4ae0 , // 1910 0xa4d8 , 0xa4d0 , 0xd250 , 0xd548 , 0xb550 , 0x56a0 , 0x96d0 , 0x95b0 , 0x49b8 , 0x49b0 , // 1920 0xa4b0 , 0xb258 , 0x6a50 , 0x6d40 , 0xada8 , 0x2b60 , 0x9570 , 0x4978 , 0x4970 , 0x64b0 , // 1930 0xd4a0 , 0xea50 , 0x6d48 , 0x5ad0 , 0x2b60 , 0x9370 , 0x92e0 , 0xc968 , 0xc950 , 0xd4a0 , // 1940 0xda50 , 0xb550 , 0x56a0 , 0xaad8 , 0x25d0 , 0x92d0 , 0xc958 , 0xa950 , 0xb4a8 , 0x6ca0 , // 1950 0xb550 , 0x55a8 , 0x4da0 , 0xa5b0 , 0x52b8 , 0x52b0 , 0xa950 , 0xe950 , 0x6aa0 , 0xad50 , // 1960 0xab50 , 0x4b60 , 0xa570 , 0xa570 , 0x5260 , 0xe930 , 0xd950 , 0x5aa8 , 0x56a0 , 0x96d0 , // 1970 0x4ae8 , 0x4ad0 , 0xa4d0 , 0xd268 , 0xd250 , 0xd528 , 0xb540 , 0xb6a0 , 0x96d0 , 0x95b0 , // 1980 0x49b0 , 0xa4b8 , 0xa4b0 , 0xb258 , 0x6a50 , 0x6d40 , 0xada0 , 0xab60 , 0x9370 , 0x4978 , // 1990 0x4970 , 0x64b0 , 0x6a50 , 0xea50 , 0x6b28 , 0x5ac0 , 0xab60 , 0x9368 , 0x92e0 , 0xc960 , // 2000 0xd4a8 , 0xd4a0 , 0xda50 , 0x5aa8 , 0x56a0 , 0xaad8 , 0x25d0 , 0x92d0 , 0xc958 , 0xa950 , // 2010 0xb4a0 , 0xb550 , 0xb550 , 0x55a8 , 0x4ba0 , 0xa5b0 , 0x52b8 , 0x52b0 , 0xa930 , 0x74a8 , // 2020 0x6aa0 , 0xad50 , 0x4da8 , 0x4b60 , 0x9570 , 0xa4e0 , 0xd260 , 0xe930 , 0xd530 , 0x5aa0 , // 2030 0x6b50 , 0x96d0 , 0x4ae8 , 0x4ad0 , 0xa4d0 , 0xd258 , 0xd250 , 0xd520 , 0xdaa0 , 0xb5a0 , // 2040 0x56d0 , 0x4ad8 , 0x49b0 , 0xa4b8 , 0xa4b0 , 0xaa50 , 0xb528 , 0x6d20 , 0xada0 , 0x55b0 // 2050 } ; // Array iLunarLeapMonthTable preserves the lunar calendar leap month from // 1901 to 2050, // if it is 0 express not to have , every byte was stored for two years private static final char[] iLunarLeapMonthTable = { 0x00, 0x50, 0x04, 0x00, 0x20, // 1910 0x60, 0x05, 0x00, 0x20, 0x70, // 1920 0x05, 0x00, 0x40, 0x02, 0x06, // 1930 0x00, 0x50, 0x03, 0x07, 0x00, // 1940 0x60, 0x04, 0x00, 0x20, 0x70, // 1950 0x05, 0x00, 0x30, 0x80, 0x06, // 1960 0x00, 0x40, 0x03, 0x07, 0x00, // 1970 0x50, 0x04, 0x08, 0x00, 0x60, // 1980 0x04, 0x0a, 0x00, 0x60, 0x05, // 1990 0x00, 0x30, 0x80, 0x05, 0x00, // 2000 0x40, 0x02, 0x07, 0x00, 0x50, // 2010 0x04, 0x09, 0x00, 0x60, 0x04, // 2020 0x00, 0x20, 0x60, 0x05, 0x00, // 2030 0x30, 0xb0, 0x06, 0x00, 0x50, // 2040 0x02, 0x07, 0x00, 0x50, 0x03 // 2050 }; // Array iSolarLunarTable stored the offset days // in New Year of solar calendar and lunar calendar from 1901 to 2050; private static final char[] iSolarLunarOffsetTable = { 49, 38, 28, 46, 34, 24, 43, 32, 21, 40, // 1910 29, 48, 36, 25, 44, 34, 22, 41, 31, 50, // 1920 38, 27, 46, 35, 23, 43, 32, 22, 40, 29, // 1930 47, 36, 25, 44, 34, 23, 41, 30, 49, 38, // 1940 26, 45, 35, 24, 43, 32, 21, 40, 28, 47, // 1950 36, 26, 44, 33, 23, 42, 30, 48, 38, 27, // 1960 45, 35, 24, 43, 32, 20, 39, 29, 47, 36, // 1970 26, 45, 33, 22, 41, 30, 48, 37, 27, 46, // 1980 35, 24, 43, 32, 50, 39, 28, 47, 36, 26, // 1990 45, 34, 22, 40, 30, 49, 37, 27, 46, 35, // 2000 23, 42, 31, 21, 39, 28, 48, 37, 25, 44, // 2010 33, 23, 41, 31, 50, 39, 28, 47, 35, 24, // 2020 42, 30, 21, 40, 28, 47, 36, 25, 43, 33, // 2030 22, 41, 30, 49, 37, 26, 44, 33, 23, 42, // 2040 31, 21, 40, 29, 47, 36, 25, 44, 32, 22, // 2050 }; // ====== 传回农历 y年的总天数 final private static int yearDays(int y) { int i, sum = 348; for (i = 0x8000; i > 0x8; i >>= 1) { if ((lunarInfo[y - 1900] & i) != 0) sum += 1; } return (sum + leapDays(y)); } // ====== 传回农历 y年闰月的天数 final private static int leapDays(int y) { if (leapMonth(y) != 0) { if ((lunarInfo[y - 1900] & 0x10000) != 0) return 30; else return 29; } else return 0; } // ====== 传回农历 y年闰哪个月 1-12 , 没闰传回 0 final private static int leapMonth(int y) { return (int) (lunarInfo[y - 1900] & 0xf); } // ====== 传回农历 y年m月的总天数 final private static int monthDays(int y, int m) { if ((lunarInfo[y - 1900] & (0x10000 >> m)) == 0) return 29; else return 30; } // ====== 传回农历 y年的生肖 final public String animalsYear() { final String[] Animals = new String[] { "鼠", "牛", "虎", "兔", "龙", "蛇", "马", "羊", "猴", "鸡", "狗", "猪" }; return Animals[(year - 4) % 12]; } // ====== 传入 月日的offset 传回干支, 0=甲子 final private static String cyclicalm(int num) { final String[] Gan = new String[] { "甲", "乙", "丙", "丁", "戊", "己", "庚", "辛", "壬", "癸" }; final String[] Zhi = new String[] { "子", "丑", "寅", "卯", "辰", "巳", "午", "未", "申", "酉", "戌", "亥" }; return (Gan[num % 10] + Zhi[num % 12]); } // ====== 传入 offset 传回干支, 0=甲子 final public String cyclical() { int num = year - 1900 + 36; return (cyclicalm(num)); } /** */ /** *   * 传出y年m月d日对应的农历.   * yearCyl3:农历年与1864的相差数 ?   * * monCyl4:从1900年1月31日以来,闰月数   * dayCyl5:与1900年1月31日相差的天数,再加40 ?   * @param * cal   * @return    */ public Lunar(Calendar cal) { this.clendar = cal; @SuppressWarnings("unused") int yearCyl, monCyl, dayCyl; int leapMonth = 0; Date baseDate = null; try { baseDate = chineseDateFormat.parse("1900年1月31日"); } catch (ParseException e) { e.printStackTrace(); // To change body of catch statement use // Options | File Templates. } // 求出和1900年1月31日相差的天数 int offset = (int) ((cal.getTime().getTime() - baseDate.getTime()) / 86400000L); dayCyl = offset + 40; monCyl = 14; // 用offset减去每农历年的天数 // 计算当天是农历第几天 // i最终结果是农历的年份 // offset是当年的第几天 int iYear, daysOfYear = 0; for (iYear = 1900; iYear 0; iYear++) { daysOfYear = yearDays(iYear); offset -= daysOfYear; monCyl += 12; } if (offset < 0) { offset += daysOfYear; iYear--; monCyl -= 12; } // 农历年份 year = iYear; yearCyl = iYear - 1864; leapMonth = leapMonth(iYear); // 闰哪个月,1-12 leap = false; // 用当年的天数offset,逐个减去每月(农历)的天数,求出当天是本月的第几天 int iMonth, daysOfMonth = 0; for (iMonth = 1; iMonth 0; iMonth++) { // 闰月 if (leapMonth > 0 && iMonth == (leapMonth + 1) && !leap) { --iMonth; leap = true; daysOfMonth = leapDays(year); } else daysOfMonth = monthDays(year, iMonth); offset -= daysOfMonth; // 解除闰月 if (leap && iMonth == (leapMonth + 1)) leap = false; if (!leap) monCyl++; } // offset为0时,并且刚才计算的月份是闰月,要校正 if (offset == 0 && leapMonth > 0 && iMonth == leapMonth + 1) { if (leap) { leap = false; } else { leap = true; --iMonth; --monCyl; } } // offset小于0时,也要校正 if (offset 0) { this.leap = true; } String dateStr =sCalendarLundarToSolar(year,month,day); try { Date d = chineseDateFormat.parse(dateStr); clendar = new GregorianCalendar(); clendar.setTime(d); } catch (ParseException e) { e.printStackTrace(); } } public static String sCalendarLundarToSolar(int iYear, int iMonth, int iDay) { int iSYear, iSMonth, iSDay; int iOffsetDays = iGetLNewYearOffsetDays(iYear, iMonth, iDay)+ iSolarLunarOffsetTable[iYear - 1901]; int iYearDays = bIsSolarLeapYear(iYear) ? 366 : 365; if (iOffsetDays >= iYearDays) { iSYear = iYear + 1; iOffsetDays -= iYearDays; } else { iSYear = iYear; } iSDay = iOffsetDays; for (iSMonth = 1; iOffsetDays >= 0; iSMonth++) { iSDay = iOffsetDays; iOffsetDays -= iGetSYearMonthDays(iSYear, iSMonth); } iSMonth--; return iSYear +"年"+iSMonth + "月"+ iSDay + "日"; } public static int iGetLNewYearOffsetDays(int iYear, int iMonth, int iDay) { int iOffsetDays = 0; int iLeapMonth = iGetLLeapMonth(iYear); if ((iLeapMonth > 0) && (iLeapMonth == iMonth - 12)) { iMonth = iLeapMonth; iOffsetDays += iGetLMonthDays(iYear, iMonth); } for (int i = 1; i < iMonth; i++) { iOffsetDays += iGetLMonthDays(iYear, i); if (i == iLeapMonth) iOffsetDays += iGetLMonthDays(iYear, iLeapMonth + 12); } iOffsetDays += iDay - 1; return iOffsetDays; } public static boolean bIsSolarLeapYear(int iYear) { return ((iYear % 4 == 0) && (iYear % 100 != 0) || iYear % 400 == 0); } // The days in the month of solar calendar static int iGetSYearMonthDays(int iYear, int iMonth) { if ((iMonth == 1) || (iMonth == 3) || (iMonth == 5) || (iMonth == 7) || (iMonth == 8) || (iMonth == 10) || (iMonth == 12)) return 31; else if ((iMonth == 4) || (iMonth == 6) || (iMonth == 9) || (iMonth == 11)) return 30; else if (iMonth == 2) { if (bIsSolarLeapYear(iYear)) return 29; else return 28; } else return 0; } // The offset days from New Year and the day when point out in solar // calendar public static int iGetSNewYearOffsetDays(int iYear, int iMonth, int iDay) { int iOffsetDays = 0; for (int i = 1; i > 4; } public static int iGetLMonthDays(int iYear, int iMonth) { int iLeapMonth = iGetLLeapMonth(iYear); if ((iMonth > 12) && (iMonth - 12 != iLeapMonth) || (iMonth > iLeapMonth)) == 0) return 29; else return 30; } if ((iLeapMonth > 0) && (iMonth > iLeapMonth)) iMonth++; if ((iLunarMonthDaysTable[iYear - 1901] & (0x8000 >> (iMonth - 1))) == 0) return 29; else return 30; } // Days in this year of lunar calendar public static int iGetLYearDays(int iYear) { int iYearDays = 0; int iLeapMonth = iGetLLeapMonth(iYear); for (int i = 1; i 0) iYearDays += iGetLMonthDays(iYear, iLeapMonth + 12); return iYearDays; } public static String getChinaDayString(int day) { String chineseTen[] = { "初", "十", "廿", "卅" }; int n = day % 10 == 0 ? 9 : day % 10 - 1; if (day > 30) return ""; if (day == 10) return "初十"; else return chineseTen[day / 10] + chineseNumber[n]; } public int getYear() { return year; } public void setYear(int year) {

2015-06-26

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

提示
确定要删除当前文章?
取消 删除