data:video/mp4;base64,
data:image/png;base64,
data:application/pdf;base64,
mybatis
在需要忽略的属性上增加@transient注解
TK:
Example example = new Example(DlDictionary.class);
Example.Criteria criteria = example.createCriteria();
List<String> typeCodes = new ArrayList<>();
typeCodes.add("16");
criteria.andIn("typecode", typeCodes);
criteria.andEqualTo("uptypecode", "39");
List<DlDictionary> dlDictionaries = dlDictionaryService.selectByExample(example);
Example example = new Example(DlOperationlog.class);
example.orderBy("optDate");
Example.Criteria criteria = example.createCriteria();
criteria.andEqualTo("injuredTaskCode", injuredTaskCode);
转换:
String userCodes = requestBody.getString("userCodes");
JSONArray objects = JSONArray.parseArray(userCodes);
List<String> strings = objects.toJavaList(String.class);
JSONObject requestBody = JSONObject.parseObject(params);
Map<String,String> tempInfo = (Map)requestBody.get("tempInfo");
Temp temp = JSON.parseObject(JSON.toJSONString(tempInfo), Temp.class);
接收数组:
String indexCodes = requestBody.getString("indexCodes");
List<Map<String, Object>> indexCodesList = JsonUtil.json2List(indexCodes);
获取当天零点:
Calendar calendar = Calendar.getInstance();
calendar.setTime(new Date());
calendar.set(Calendar.HOUR_OF_DAY, 0);
calendar.set(Calendar.MINUTE, 0);
calendar.set(Calendar.SECOND, 0);
Date zero = calendar.getTime();
System.out.println("zero:::::"+zero);
接收数组:{"requestHead":{"user":"sean"},"requestBody": {"userCode":"1","indexCodes":[{"indexCode":"1"},{"indexCode":"2"},{"indexCode":"3"}]}}
ArrayList<Map<String, String>> indexCodesList = (ArrayList) requestBody.get("indexCodes");
List foreach遍历:
public List<DLTaskIndex> selectTaskCountIndex(String userCode, List<Map<String, String>> indexCodeList) {
List<String> indexCodes= new ArrayList<String>();
indexCodeList.forEach(map ->{
indexCodes.add(map.get("indexCode"));
});
return mapper.selectTaskCountIndex(userCode,indexCodes);
}
获取当月第一天:
SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd");
Calendar cale = Calendar.getInstance();
cale.add(Calendar.MONTH, 0);
cale.set(Calendar.DAY_OF_MONTH, 1);
System.out.println("Calendar :" + cale.getTime());
String firstday = sdf1.format(cale.getTime()); //返回2022-02-01
//获取指定时间的时间戳,除以1000说明得到的是秒级别的时间戳(10位)
long time1 = (new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")).parse("2022-02-21 34:44:12", new ParsePosition(0)).getTime() / 1000;
System.out.println("Calendar.MONTH -1 的时间戳:" + time1);
//获取时间戳
long now1 = System.currentTimeMillis();
long now2 = new Date().getTime();
System.out.println("当前时间戳:" +now1);
System.out.println("当前时间戳:" +now2);
/**
* 传入 String 2022-02-21 返回当月第一天 2022-02-01
* @param date String
* @return 返回当月第一天String 2022-02-01
*/
public String getFirstDay(String date){
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
ParsePosition pos = new ParsePosition(0);
Date startdate = sdf.parse(date, pos);
Calendar cale = Calendar.getInstance();
cale.setTime(startdate);
cale.add(Calendar.MONTH, 0);
cale.set(Calendar.DAY_OF_MONTH, 1);
System.out.println("Calendar :" + cale.getTime());
String firstday = sdf.format(cale.getTime());
return firstday;
}
/**
*传入 String 2022-02-21 返回当月最后一天 2022-02-28
* @param date String
* @return String
*/
public String getLastDayOfMonth(String date) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
ParsePosition pos = new ParsePosition(0);
Date enddate = sdf.parse(date, pos);
Calendar cal = Calendar.getInstance();
cal.setTime(enddate);
int last = cal.getActualMaximum(Calendar.DAY_OF_MONTH);
cal.set(Calendar.DAY_OF_MONTH, last);
Date time = cal.getTime();
String enddateStr = sdf.format(time);
return enddateStr;
}
sql:
Mysql字符串字段判断是否包含某个字符串的方法
方法一:like
SELECT * FROM 表名 WHERE 字段名 like "%字符%";
方法二:find_in_set()
利用mysql 字符串函数 find_in_set();
SELECT * FROM users WHERE find_in_set('字符', 字段名);
DATEDIFF() 函数返回两个日期之间的天数。
日期比较大小:
今天在写mapper.xml 使用<= ,>= 居然编译报错,第一次遇到,网上查询了解决方法:
进行转义:
原符号 < <= > >= & ' "
替换符号 < <= > >= & ' "