Chinaunix首页 | 论坛 | 博客

FineReport爱好者的ChinaUnix博客

首页　| 　博文目录　| 　关于我

FineReport爱好者

  • 博客访问： 209409
  • 博文数量： 97
  • 博客积分： 0
  • 博客等级： 民兵
  • 技术积分： 1024
  • 用 户 组： 普通用户
  • 注册时间： 2014-04-03 09:03
文章分类

全部博文（97）

文章存档

2017年（17）

2016年（54）

2015年（25）

2014年（1）

我的朋友
最近访客
推荐博文
相关博文
如何利用自定义函数把阳历转换成阴历

分类： Java

2016-06-02 14:38:12

数据库保存的是阳历日期，有时候会遇到把阳历换成阴历的需求，例如下图把阳历转换成阴历。


这个问题是我在开发报表过程中遇到的一个小需求，利用的工具是FineReport8.0版本，解决思路是首先定义一个可以将阳历转为阴历的类，然后自定义FineReport函数，在run方法中获取年月日参数并调用之前的类将阳历转为阴历，最终返回给报表。

实现步骤：

1、  阳历转阴历的类

FineReport里面会提供一个现成的农历日历工具类SolarToLunar，该类中通过today(intyear, int month, int day)方法可将输入的年、月、日对应的阳历转为阴历日期，完整代码如下：

点击(此处)折叠或打开

  1. package com.fr.function;
  2. import java.text.SimpleDateFormat;
  3. import java.util.Calendar;
  4. import java.util.Date;
  5. import java.util.GregorianCalendar;
  6. import java.util.Locale;
  7. public class SolarToLunar {
  8.     final private static long[] lunarInfo = new long[] { 0x04bd8, 0x04ae0,
  9.             0x0a570, 0x054d5, 0x0d260, 0x0d950, 0x16554, 0x056a0, 0x09ad0,
  10.             0x055d2, 0x04ae0, 0x0a5b6, 0x0a4d0, 0x0d250, 0x1d255, 0x0b540,
  11.             0x0d6a0, 0x0ada2, 0x095b0, 0x14977, 0x04970, 0x0a4b0, 0x0b4b5,
  12.             0x06a50, 0x06d40, 0x1ab54, 0x02b60, 0x09570, 0x052f2, 0x04970,
  13.             0x06566, 0x0d4a0, 0x0ea50, 0x06e95, 0x05ad0, 0x02b60, 0x186e3,
  14.             0x092e0, 0x1c8d7, 0x0c950, 0x0d4a0, 0x1d8a6, 0x0b550, 0x056a0,
  15.             0x1a5b4, 0x025d0, 0x092d0, 0x0d2b2, 0x0a950, 0x0b557, 0x06ca0,
  16.             0x0b550, 0x15355, 0x04da0, 0x0a5d0, 0x14573, 0x052d0, 0x0a9a8,
  17.             0x0e950, 0x06aa0, 0x0aea6, 0x0ab50, 0x04b60, 0x0aae4, 0x0a570,
  18.             0x05260, 0x0f263, 0x0d950, 0x05b57, 0x056a0, 0x096d0, 0x04dd5,
  19.             0x04ad0, 0x0a4d0, 0x0d4d4, 0x0d250, 0x0d558, 0x0b540, 0x0b5a0,
  20.             0x195a6, 0x095b0, 0x049b0, 0x0a974, 0x0a4b0, 0x0b27a, 0x06a50,
  21.             0x06d40, 0x0af46, 0x0ab60, 0x09570, 0x04af5, 0x04970, 0x064b0,
  22.             0x074a3, 0x0ea50, 0x06b58, 0x055c0, 0x0ab60, 0x096d5, 0x092e0,
  23.             0x0c960, 0x0d954, 0x0d4a0, 0x0da50, 0x07552, 0x056a0, 0x0abb7,
  24.             0x025d0, 0x092d0, 0x0cab5, 0x0a950, 0x0b4a0, 0x0baa4, 0x0ad50,
  25.             0x055d9, 0x04ba0, 0x0a5b0, 0x15176, 0x052b0, 0x0a930, 0x07954,
  26.             0x06aa0, 0x0ad50, 0x05b52, 0x04b60, 0x0a6e6, 0x0a4e0, 0x0d260,
  27.             0x0ea65, 0x0d530, 0x05aa0, 0x076a3, 0x096d0, 0x04bd7, 0x04ad0,
  28.             0x0a4d0, 0x1d0b6, 0x0d250, 0x0d520, 0x0dd45, 0x0b5a0, 0x056d0,
  29.             0x055b2, 0x049b0, 0x0a577, 0x0a4b0, 0x0aa50, 0x1b255, 0x06d20,
  30.             0x0ada0 };

  32.     final private static int[] year20 = new int[] { 1, 4, 1, 2, 1, 2, 1, 1, 2,
  33.             1, 2, 1 };

  35.     final private static int[] year19 = new int[] { 0, 3, 0, 1, 0, 1, 0, 0, 1,
  36.             0, 1, 0 };

  38.     final private static int[] year2000 = new int[] { 0, 3, 1, 2, 1, 2, 1, 1,
  39.             2, 1, 2, 1 };

  41.     public final static String[] nStr1 = new String[] { "", "正", "二", "三", "四",
  42.             "五", "六", "七", "八", "九", "十", "十一", "十二" };

  44.     private final static String[] Gan = new String[] { "甲", "乙", "丙", "丁", "戊",
  45.             "己", "庚", "辛", "壬", "癸" };

  47.     private final static String[] Zhi = new String[] { "子", "丑", "寅", "卯", "辰",
  48.             "巳", "午", "未", "申", "酉", "戌", "亥" };

  50.     private final static String[] Animals = new String[] { "鼠", "牛", "虎", "兔",
  51.             "龙", "蛇", "马", "羊", "猴", "鸡", "狗", "猪" };

  53.     private final static String[] solarTerm = new String[] { "小寒", "大寒", "立春",
  54.             "雨水", "惊蛰", "春分", "清明", "谷雨", "立夏", "小满", "芒种", "夏至", "小暑", "大暑",
  55.             "立秋", "处暑", "白露", "秋分", "寒露", "霜降", "立冬", "小雪", "大雪", "冬至" };

  57.     private final static String[] sFtv = new String[] { "0101*元旦", "0214 情人节",
  58.             "0308 妇女节", "0312 植树节", "0315 消费者权益日", "0401 愚人节", "0501 劳动节",
  59.             "0504 青年节", "0512 护士节", "0601 儿童节", "0701 建党节", "0801 建军节",
  60.             "0808 父亲节", "0909 毛泽东逝世纪念", "0910 教师节", "0928 孔子诞辰", "1001*国庆节",
  61.             "1006 老人节", "1024 联合国日", "1112 孙中山诞辰", "1220 澳门回归", "1225 圣诞节",
  62.             "1226 毛泽东诞辰" };

  64.     private final static String[] lFtv = new String[] { "0101*农历春节",
  65.             "0115 元宵节", "0505 端午节", "0707 七夕情人节", "0815 中秋节", "0909 重阳节",
  66.             "1208 腊八节", "1224 小年", "0100*除夕" };

  68.     /**
  69.      * 传回农历 y年的总天数
  70.      *
  71.      * @param y
  72.      * @return
  73.      */
  74.     final private static int lYearDays(int y) {
  75.         int i, sum = 348;
  76.         for (i = 0x8000; i > 0x8; i >>= 1) {
  77.             if ((lunarInfo[y - 1900] & i) != 0)
  78.                 sum += 1;
  79.         }
  80.         return (sum + leapDays(y));
  81.     }

  83.     /**
  84.      * 传回农历 y年闰月的天数
  85.      *
  86.      * @param y
  87.      * @return
  88.      */
  89.     final private static int leapDays(int y) {
  90.         if (leapMonth(y) != 0) {
  91.             if ((lunarInfo[y - 1900] & 0x10000) != 0)
  92.                 return 30;
  93.             else
  94.                 return 29;
  95.         } else
  96.             return 0;
  97.     }

  99.     /**
  100.      * 传回农历 y年闰哪个月 1-12 , 没闰传回 0
  101.      *
  102.      * @param y
  103.      * @return
  104.      */
  105.     final private static int leapMonth(int y) {
  106.         return (int) (lunarInfo[y - 1900] & 0xf);
  107.     }

  109.     /**
  110.      * 传回农历 y年m月的总天数
  111.      *
  112.      * @param y
  113.      * @param m
  114.      * @return
  115.      */
  116.     final private static int monthDays(int y, int m) {
  117.         if ((lunarInfo[y - 1900] & (0x10000 >> m)) == 0)
  118.             return 29;
  119.         else
  120.             return 30;
  121.     }

  123.     /**
  124.      * 传回农历 y年的生肖
  125.      *
  126.      * @param y
  127.      * @return
  128.      */
  129.     final public static String AnimalsYear(int y) {
  130.         return Animals[(y - 4) % 12];
  131.     }

  133.     /**
  134.      * 传入 月日的offset 传回干支,0=甲子
  135.      *
  136.      * @param num
  137.      * @return
  138.      */
  139.     final private static String cyclicalm(int num) {
  140.         return (Gan[num % 10] + Zhi[num % 12]);
  141.     }

  143.     /**
  144.      * 传入 offset 传回干支, 0=甲子
  145.      *
  146.      * @param y
  147.      * @return
  148.      */
  149.     final public static String cyclical(int y) {
  150.         int num = y - 1900 + 36;
  151.         return (cyclicalm(num));
  152.     }

  154.     /**
  155.      * 传出农历.year0 .month1 .day2 .yearCyl3 .monCyl4 .dayCyl5 .isLeap6
  156.      *
  157.      * @param y
  158.      * @param m
  159.      * @return
  160.      */
  161.     final private long[] Lunar(int y, int m) {
  162.         long[] nongDate = new long[7];
  163.         int i = 0, temp = 0, leap = 0;
  164.         Date baseDate = new GregorianCalendar(1900 + 1900, 1, 31).getTime();
  165.         Date objDate = new GregorianCalendar(y + 1900, m, 1).getTime();
  166.         long offset = (objDate.getTime() - baseDate.getTime()) / 86400000L;
  167.         if (y < 2000)
  168.             offset += year19[m - 1];
  169.         if (y > 2000)
  170.             offset += year20[m - 1];
  171.         if (y == 2000)
  172.             offset += year2000[m - 1];
  173.         nongDate[5] = offset + 40;
  174.         nongDate[4] = 14;

  176.         for (i = 1900; i < 2050 && offset > 0; i++) {
  177.             temp = lYearDays(i);
  178.             offset -= temp;
  179.             nongDate[4] += 12;
  180.         }
  181.         if (offset < 0) {
  182.             offset += temp;
  183.             i--;
  184.             nongDate[4] -= 12;
  185.         }
  186.         nongDate[0] = i;
  187.         nongDate[3] = i - 1864;
  188.         leap = leapMonth(i); // 闰哪个月
  189.         nongDate[6] = 0;

  191.         for (i = 1; i < 13 && offset > 0; i++) {
  192.             // 闰月
  193.             if (leap > 0 && i == (leap + 1) && nongDate[6] == 0) {
  194.                 --i;
  195.                 nongDate[6] = 1;
  196.                 temp = leapDays((int) nongDate[0]);
  197.             } else {
  198.                 temp = monthDays((int) nongDate[0], i);
  199.             }

  201.             // 解除闰月
  202.             if (nongDate[6] == 1 && i == (leap + 1))
  203.                 nongDate[6] = 0;
  204.             offset -= temp;
  205.             if (nongDate[6] == 0)
  206.                 nongDate[4]++;
  207.         }

  209.         if (offset == 0 && leap > 0 && i == leap + 1) {
  210.             if (nongDate[6] == 1) {
  211.                 nongDate[6] = 0;
  212.             } else {
  213.                 nongDate[6] = 1;
  214.                 --i;
  215.                 --nongDate[4];
  216.             }
  217.         }
  218.         if (offset < 0) {
  219.             offset += temp;
  220.             --i;
  221.             --nongDate[4];
  222.         }
  223.         nongDate[1] = i;
  224.         nongDate[2] = offset + 1;
  225.         return nongDate;
  226.     }

  228.     /**
  229.      * 传出y年m月d日对应的农历.year0 .month1 .day2 .yearCyl3 .monCyl4 .dayCyl5 .isLeap6
  230.      *
  231.      * @param y
  232.      * @param m
  233.      * @param d
  234.      * @return
  235.      */
  236.     final public static long[] calElement(int y, int m, int d) {
  237.         long[] nongDate = new long[7];
  238.         int i = 0, temp = 0, leap = 0;
  239.         Date baseDate = new GregorianCalendar(0 + 1900, 0, 31).getTime();
  240.         Date objDate = new GregorianCalendar(y, m - 1, d).getTime();
  241.         long offset = (objDate.getTime() - baseDate.getTime()) / 86400000L;
  242.         nongDate[5] = offset + 40;
  243.         nongDate[4] = 14;

  245.         for (i = 1900; i < 2050 && offset > 0; i++) {
  246.             temp = lYearDays(i);
  247.             offset -= temp;
  248.             nongDate[4] += 12;
  249.         }
  250.         if (offset < 0) {
  251.             offset += temp;
  252.             i--;
  253.             nongDate[4] -= 12;
  254.         }
  255.         nongDate[0] = i;
  256.         nongDate[3] = i - 1864;
  257.         leap = leapMonth(i); // 闰哪个月
  258.         nongDate[6] = 0;

  260.         for (i = 1; i < 13 && offset > 0; i++) {
  261.             // 闰月
  262.             if (leap > 0 && i == (leap + 1) && nongDate[6] == 0) {
  263.                 --i;
  264.                 nongDate[6] = 1;
  265.                 temp = leapDays((int) nongDate[0]);
  266.             } else {
  267.                 temp = monthDays((int) nongDate[0], i);
  268.             }

  270.             // 解除闰月
  271.             if (nongDate[6] == 1 && i == (leap + 1))
  272.                 nongDate[6] = 0;
  273.             offset -= temp;
  274.             if (nongDate[6] == 0)
  275.                 nongDate[4]++;
  276.         }

  278.         if (offset == 0 && leap > 0 && i == leap + 1) {
  279.             if (nongDate[6] == 1) {
  280.                 nongDate[6] = 0;
  281.             } else {
  282.                 nongDate[6] = 1;
  283.                 --i;
  284.                 --nongDate[4];
  285.             }
  286.         }
  287.         if (offset < 0) {
  288.             offset += temp;
  289.             --i;
  290.             --nongDate[4];
  291.         }
  292.         nongDate[1] = i;
  293.         nongDate[2] = offset + 1;
  294.         return nongDate;
  295.     }

  297.     public final static String getChinaDate(int day) {
  298.         String a = "";
  299.         if (day == 10)
  300.             return "初十";
  301.         if (day == 20)
  302.             return "二十";
  303.         if (day == 30)
  304.             return "三十";
  305.         int two = (int) ((day) / 10);
  306.         if (two == 0)
  307.             a = "初";
  308.         if (two == 1)
  309.             a = "十";
  310.         if (two == 2)
  311.             a = "廿";
  312.         if (two == 3)
  313.             a = "三";
  314.         int one = (int) (day % 10);
  315.         switch (one) {
  316.         case 1:
  317.             a += "一";
  318.             break;
  319.         case 2:
  320.             a += "二";
  321.             break;
  322.         case 3:
  323.             a += "三";
  324.             break;
  325.         case 4:
  326.             a += "四";
  327.             break;
  328.         case 5:
  329.             a += "五";
  330.             break;
  331.         case 6:
  332.             a += "六";
  333.             break;
  334.         case 7:
  335.             a += "七";
  336.             break;
  337.         case 8:
  338.             a += "八";
  339.             break;
  340.         case 9:
  341.             a += "九";
  342.             break;
  343.         }
  344.         return a;
  345.     }

  347.     public static String today(int y, int m, int d) {
  348.         int year = y;
  349.         int month = m;
  350.         int date = d;
  351.         long[] l = calElement(year, month, date);
  352.         StringBuffer sToday = new StringBuffer();
  353.         try {

  355.             sToday.append(" 农历");
  356.             sToday.append(cyclical(year));
  357.             sToday.append('(');
  358.             sToday.append(AnimalsYear(year));
  359.             sToday.append(")年");
  360.             sToday.append(nStr1[(int) l[1]]);
  361.             sToday.append("月");
  362.             sToday.append(getChinaDate((int) (l[2])));
  363.             return sToday.toString();
  364.         } finally {
  365.             sToday = null;
  366.         }
  367.     }

  369.     private static SimpleDateFormat sdf = new SimpleDateFormat(
  370.             "yyyy年M月d日 EEEEE");

  372.     /**
  373.      * 农历日历工具使用演示
  374.      *
  375.      * @param args
  376.      */
  377.     public static void main(String[] args) {
  378.         System.out.println(today(1988, 10, 27));
  379.     }
  380. } 

2、自定义FineReport函数

自定义函数Lunar扩展于AbstractFunction，并重写run方法，获得年月日参数值，调用农历日历工具类SolarToLunar的today方法，求得农历日期并返回，代码如下：


点击(此处)折叠或打开

  1. package com.fr.function;

  3. import com.fr.script.AbstractFunction;
  4.    
  5. public class Lunar extends AbstractFunction {
  6.     public Object run(Object[] args) {
  7.         String result = "";
  8.         int y = Integer.parseInt(args[0].toString());
  9.         int m = Integer.parseInt(args[1].toString());
  10.         int d = Integer.parseInt(args[2].toString());
  11.         result = SolarToLunar.today(y, m, d);
  12.         return result;
  13.     }
  14. }

3、编译并运行

编译自定义函数

编译Lunar.java和SolarToLunar.java类生成Lunar.class和SolarToLunar.class文件拷贝至报表应用所在目录/WEB-INF/classes/com/fr/function下。

注册自定义函数

启动设计器，点击服务器|函数管理器，新增函数取名为Lunar，选择Lunar.class类，如下图：


自定义函数定义好了就可以在设计器中直接使用。

比如在单元格中写入公式=Lunar(2011,7,11)，预览模板，可以看到日期2011年7月11日阳历就可以转换成阴历。

若数据库日期类型字段如图：


拖到模板设计界面，设置高级属性，在自定义显示值里面输入公式Lunar(year($),month($),day($$$))，如下图设置，则可把保存在数据库里面的阳历日期转换成阴历了。




阅读(913) | 评论(0) | 转发(0) |
0

上一篇：报表工具如何实现多次导入Excel

下一篇：报表开发导出各种格式文件的API

给主人留下些什么吧！~~
关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册

Copyright 2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有

感谢所有关心和支持过ChinaUnix的朋友们

16024965号-6