一、日历生成说明
由于公司需要按照工作日进行计算,所以需要在数据库存储一套日历数据,标明每一天是工作日还是假日。
1.
现设计一个表,表结构如下:
CREATE TABLE `sys_calendar` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`day` varchar(32) DEFAULT NULL COMMENT '日期',
`type` tinyint(11) DEFAULT NULL COMMENT '日期类型:0-工作日,1-假日补班,2-法定假日,3-公休日',
`year` varchar(16) DEFAULT NULL COMMENT '年份',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=366 DEFAULT CHARSET=utf8;
2. 调用http://timor.tech/api/holiday/info/$date判断是假期还是工作日。
具体代码如下:
public static String request(String httpArg) {
//工作日对应结果为 0, 休息日对应结果为 1, 节假日对应的结果为 2
String httpUrl = "http://timor.tech/api/holiday/info/";
String result = "";
StringBuffer sbf = new StringBuffer();
httpUrl = httpUrl + httpArg;
try {
URL url = new URL(httpUrl);
HttpURLConnection connection = (HttpURLConnection) url
.openConnection();
connection.setRequestMethod("GET");
connection.setRequestProperty("User-Agent", "Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36)");
connection.connect();
InputStream is = connection.getInputStream();
BufferedReader reader = new BufferedReader(new InputStreamReader(is, "UTF-8"));
String strRead;
while ((strRead = reader.readLine()) != null) {
sbf.append(strRead);
sbf.append("\r\n");
}
reader.close();
JSONObject jsonObject = JSON.parseObject(String.valueOf(sbf));
// System.out.println("aaaaaa"+jsonObject);
result = jsonObject.getJSONObject("type").getString("type");
// 调用过快会被限制,睡上5秒
Thread.sleep(5000);
} catch (Exception e) {
e.printStackTrace();
}
return result;
}
public static void main(String[] args)
{
Calendar cal = Calendar.getInstance();//获取Calendar
cal.clear();
cal.setTime(new Date()); //设置日期
cal.set(Calendar.MONTH,0); //设置月份从1月开始
cal.set(Calendar.DAY_OF_MONTH, 1);
Integer year = cal.get(Calendar.YEAR); //获取设置的日期年份
for (int i = 0; i < 12; i++) {//循环输出一年中的12个月,
Integer month = cal.get(Calendar.MONTH)+1;
int day=cal.getActualMaximum(Calendar.DAY_OF_MONTH);//计算每个月有多少天
// System.out.println(year+"年"+month+"月"+"有"+day+"天");
for (int j = 0; j < day; j++,cal.add(Calendar.DATE, 1)) {//循环输出一个月中的每一天,cal.add()方法设置每次增加一天
Integer days = cal.get(Calendar.DATE);
// System.out.println(days+"日");
SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd");
String theDay = sf.format(cal.getTime());
String str = request(theDay);
if ("0".equals(str))
{
// 工作日
System.out.println("insert into sys_calendar (day,type,year) values ('"+ theDay+"',"+ 0 +",'"+ year+"');");
}else if ("2".equals(str))
{
// 法定节假日
System.out.println("insert into sys_calendar (day,type,year) values ('"+ theDay+"',"+ 2 +",'"+ year+"');");
}else if ("3".equals(str))
{
// 节假日调休补班,因为表的设计中type与接口的type字段1和3的含义不同,所以做了转换:当接口返回type为3时,保存到表中的type为1
System.out.println("insert into sys_calendar (day,type,year) values ('"+ theDay+"',"+ 1 +",'"+ year+"');");
}else if ("1".equals(str))
{
// 公休日,同上
System.out.println("insert into sys_calendar (day,type,year) values ('"+ theDay+"',"+ 3 +",'"+ year+"');");
}
}
cal.add(Calendar.MONTH, 0);// cal.add()方法设置每次增加一个月
}
}
更新于2022-01-03:
此接口http://api.goseek.cn/Tools/holiday不能使用了,大家可以到网上找类似的获取节假日的接口。此接口可用:http://timor.tech/api/holiday/info/$date
二、全量代码如下:
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import java.io.BufferedReader;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.URL;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
public class CalanderUtil {
public static String request(String httpArg) {
//工作日对应结果为 0, 休息日对应结果为 1, 节假日对应的结果为 2
String httpUrl = "http://timor.tech/api/holiday/info/";
String result = "";
StringBuffer sbf = new StringBuffer();
httpUrl = httpUrl + httpArg;
try {
URL url = new URL(httpUrl);
HttpURLConnection connection = (HttpURLConnection) url
.openConnection();
connection.setRequestMethod("GET");
connection.setRequestProperty("User-Agent", "Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36)");
connection.connect();
InputStream is = connection.getInputStream();
BufferedReader reader = new BufferedReader(new InputStreamReader(is, "UTF-8"));
String strRead;
while ((strRead = reader.readLine()) != null) {
sbf.append(strRead);
sbf.append("\r\n");
}
reader.close();
JSONObject jsonObject = JSON.parseObject(String.valueOf(sbf));
// System.out.println("aaaaaa"+jsonObject);
result = jsonObject.getJSONObject("type").getString("type");
// 调用过快会被限制,睡上5秒
Thread.sleep(5000);
} catch (Exception e) {
e.printStackTrace();
}
return result;
}
public static void main(String[] args)
{
Calendar cal = Calendar.getInstance();//获取Calendar
cal.clear();
String dateString = "2024-01-01";
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
try {
Date date = sdf.parse(dateString);
System.out.println("Date: " + date);
cal.setTime(date); //设置日期
} catch (Exception e) {
e.printStackTrace();
}
cal.set(Calendar.MONTH,0); //设置月份从1月开始
cal.set(Calendar.DAY_OF_MONTH, 1);
Integer year = cal.get(Calendar.YEAR); //获取设置的日期年份
for (int i = 0; i < 12; i++) {//循环输出一年中的12个月,
Integer month = cal.get(Calendar.MONTH)+1;
int day=cal.getActualMaximum(Calendar.DAY_OF_MONTH);//计算每个月有多少天
// System.out.println(year+"年"+month+"月"+"有"+day+"天");
for (int j = 0; j < day; j++,cal.add(Calendar.DATE, 1)) {//循环输出一个月中的每一天,cal.add()方法设置每次增加一天
Integer days = cal.get(Calendar.DATE);
// System.out.println(days+"日");
SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd");
String theDay = sf.format(cal.getTime());
String str = request(theDay);
if ("0".equals(str))
{
// 工作日
System.out.println("insert into sys_calendar (day,type,year) values ('"+ theDay+"',"+ 0 +",'"+ year+"');");
}else if ("2".equals(str))
{
// 法定节假日
System.out.println("insert into sys_calendar (day,type,year) values ('"+ theDay+"',"+ 2 +",'"+ year+"');");
}else if ("3".equals(str))
{
// 节假日调休补班,因为表的设计中type与接口的type字段1和3的含义不同,所以做了转换:当接口返回type为3时,保存到表中的type为1
System.out.println("insert into sys_calendar (day,type,year) values ('"+ theDay+"',"+ 1 +",'"+ year+"');");
}else if ("1".equals(str))
{
// 公休日,同上
System.out.println("insert into sys_calendar (day,type,year) values ('"+ theDay+"',"+ 3 +",'"+ year+"');");
}
}
cal.add(Calendar.MONTH, 0);// cal.add()方法设置每次增加一个月
}
}
}