liufeihuwudi的博客

原创 oracle varchar2类型如何转化为date类型

SELECT TO_CHAR(CAST(CAST(‘26-2月 -19 03.34.47.000000 下午’ AS TIMESTAMP) AS DATE), ‘yyyy-MM-dd hh24:mi:ss’) FROM DUAL;

原创 接近8000字的Spring/SpringBoot常用注解总结

https://www.toutiao.com/article/6818828234700882436/?log_from=81a998c7d49d1_1685694253739

原创 java读取text&excel测试类

读取txt文件和excel

原创 字段动态获取

字段动态获取。

原创 查询三级数据结构sql语句

查询sql语句

原创 java判断最后一个/后的2个字符

java判断最后一个/后的2个字符

原创 Collection添加属性

Collection添加元素

原创 创建DBLINK语句

create public database link lfhconnect to yanxibefore identified by yanxibeforeusing ‘(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(LOAD_BALANCE = yes)(FAILOVER = ON)(

原创 查看用户名和密码

select instance_rrn,instance_id,instance_descfrom named_object awhere a.object = ‘USER’ select user_rrn,user_name,password from user_profile bwhere b.user_rrn = 用户号【注：密码采用StringUtils.encodeByMD5()进行MD5编码保存】...

原创 EXT页面小数位自动四舍五入问题

原创 maximum number of expressions in a list is 1000

原创 List迭代器

List<LotStepHistory> list = entry.getValue(); Iterator<LotStepHistory> iterator = list.iterator(); while (iterator.hasNext()) { LotStepHistory stepHistory = iterator.next(); if (stepHistory.getMoveOutQty1() == null) { iterator.r..

原创 批次消耗物料历史

select h.material_type as 物料类型,h.lot_number as 物料条码, h.lot_ids as 批次号,h.consumption_qty as 事务数量, h.consumption_date as 操作时间, m.customer_lot_number as 客户批次号,(select instance_id from named_object z where z.instance_rrn = h.item_rrn ) as 物料号,( select z.m

原创 Ext.js行变色

function changeRowClass(record, rowIndex, rowParams, store) {var arrays =new Array();gridStore.each(function(record) {arrays.push(record.data);});for (j =0 ;j<arrays.length;j++){if (record.get(‘waferId’) == arrays[j].waferId) {return “x-grid-re.

原创 在线照片换底色网站

https://www.bgconverter.com/

转载 java生成pdf

https://my.oschina.net/lujianing/blog/894365

原创 oracle查询父菜单及父菜单下的子菜单

selectt1.*fromwork_area t1whereexists (select1fromwork_area twheret.owner = ‘HXX’and ( t.parent_work_area_rrn = t1.sys_rrnor ( t.parent_work_area_rrn = t1.parent_work_area_rrnor t.sys_rrn = t1.sys_rrn )) )

原创 java自动编号

//查看当天的编号 String number =mapper.getTodayNumber("XT-03-"+sdf.format(date)); if(number==null) { wxtaskNo="0001"; }else { if(Integer.parseInt(number)<10) { wxtaskNo=(Integer.parseInt(number)+1)<10?"000"+String.valueOf((Integer.p...

原创 ext 打开多tab页面

var mainTabPanel = Ext.getCmp("PackageLotTabPanel");var url = "/mycim2/salesOrder.do?action=transWorkOrder&salesOrder="+salesOrder+"&productId="+productId+"&planQty="+planQty+"&customer="+customer; mainTabPanel.add({ id:'transOrderTab

原创 liquibase

https://docs.liquibase.com/change-types/community/add-not-null-constraint.html

原创 Liquibase修改表字段

databaseChangeLog:changeSet:id: renameColumn-WORKORDER-table-PLANNED_QTYauthor: feihu liuchanges:- renameColumn:newColumnName: PLANNED_QTYoldColumnName: PLANNED_YIELDtableName: WORKORDER

原创 修改weblogic打包console编码格式

原创 java图片增加水印

package com.vcim.common.utils;import com.sun.image.codec.jpeg.JPEGCodec;import com.sun.image.codec.jpeg.JPEGImageEncoder;import javax.imageio.ImageIO;import java.awt.*;import java.awt.image.BufferedImage;import java.io.*;/** * @author liufeihu

原创 ext.js 弹出自定义输入框

var addWin; var formPanelCf = new Ext.form.FormPanel({ autoWidth:false, layout:"form", frame:true, labelWidth:200, labelAlign:"right", items:[{ xtype:"label", height

原创 List集合实现分页

int start = MapUtils.getIntValue(whereMap, “start”);int pageSize = MapUtils.getIntValue(whereMap, “pageSize”);int pageNumber = start / pageSize + 1;int totalCount = returnList.size();//结果集总数List newList=returnList.subList(pageSize*(pageNumber-1), ((pag

原创 添加key value 为List 的数据

Map<String, List<LotInventoryDO>> lotNumberMap = Maps.newHashMap(); for (LotInventoryDO lotInventoryLine : lotInvLineList) { List<LotInventoryDO> lotInvLineForMapList; String lotNumber = lotInventoryLi...

原创 java图片转成姓名文字那种

import javax.imageio.ImageIO;import java.awt.*;import java.awt.image.BufferedImage;import java.io.File;import java.io.FileOutputStream;class MyFontImage {public static void createFongImg(String path){String base = “崔敏”;try{BufferedImage image = Im

原创 json转list

private List<Map<String,Object>> jsonStringToLotBondWaferList(String snArray) { List<Map<String,Object>> rwLocationList = new ArrayList<>(); JSONArray jsonArray = JSONUtils.toJSONArray(snArray); for (Object object : jsonArr

原创 ext.js 判断相等并求数组差集

Ext.Array.each(allRecords, function(item) {if(!Ext.ifExist(item,recordList)){leftRecordList.push(item.data);};});Ext.ifExist = function(item,recordList) {for(var i=0;i<recordList.length;i++){if (item.data.unitId == recordList[i].unitId ){return

原创 ext.js 设置选中checkbox

if (unitIdList.indexOf(lotId) == -1){ MyCim.notify.alert(i18n_msg_not_this_lot_frame); }else{ var selectedLines = new Array(); Ext.Array.each(records, function(item) { if(item.data.unitId == lotId){ selectedLines.push(item); } });.

原创 List按照指定字段排序

private static void ListSort(List<EquipmentMaterial> list) { Collections.sort(list, new Comparator<EquipmentMaterial>() { @Override public int compare(EquipmentMaterial n1, EquipmentMaterial n2) { try {

原创 更新操作getSqlBuilder

return getSqlBuilder().update(tableName).setByCamel(Lists.newArrayList(“STATUS”, “CLOSE_TIME”)).where(“PLAN_RRN”).eq(outOfControlActionPlan.getPlanRrn()).varParameter(new Object[]{outOfControlActionPlan.getStatus(), outOfControlActionPlan.getCloseTime()

原创 parse a minutes in string to a time formated as HH:mm:ss

/** * parse a minutes in string to a time formated as HH:mm:ss * * @param minStr * @return */private String minsToTime(String minStr) { final char COLON = ':'; String[] parts = minStr.split("\\."); StringBuffer result = new StringBuffer(

原创 Oracle字符串拼接 循环拼接

```with temp as (select replace(replace( replace(aa.WAFER_LIST,’[’,’’),’]’,’’),’"’,’’) waferlist,CUSTOMER_LOT_IDfrom (SELECT OBJECT_RRN,COPRODUCT_RRN,COPRODUCT_ID,MAIN_PRODUCT_RRN,MAIN_PRODUCT_ID,WORKORDER_RRN,WORKORDER_ID,CROSS_DIE,COOD_DIE,WA

原创 二插搜索树

https://www.cs.usfca.edu/~galles/visualization/Algorithms.html；https://visualgo.net/zh/bst

原创 基于freemarker导出excel

https://blog.csdn.net/ZhangY1217/article/details/82383344

原创 mysql 合并逗号隔开的字段值并去重

selecta.org_order,org_id,a.org_name,grid_code,a.operator_name,group_concat(distinct(a.operator)) as operator,group_concat(distinct(a.name)) as operator_name from (SELECTsubstring_index( substring_index( a.operator_name, ',', b.help_topic_i

原创 字符串拼接使用“+”还是StringBuilder

https://www.cnblogs.com/bobo503/p/12939558.html

原创 layUi 单元格编辑判断 iframe 表格某一列是否为空

var flagType =false;var flagWeek =false; $.each($("#monthDevice").contents().find("tr"),function (index,item) { if (index > 0) { var maintainTypeName = ""; var week =""; $.each($(item).find("td"),function (i,obj) { if (obj.datase

原创 Mysql查询数据包含 合计列

select (case org_order when 003 then (@i:=@i+1) else (@i:=@i+3) end) order_index,z.* from (select case when t.org_order is null then ‘合计’ else (select a.org_name from ct_organization a where a.org_order =t.org_order) end as org_orders, min(t.org_order)