- 博客(19)
- 收藏
- 关注
RSS订阅原创 es6 js group by
text(){ const inventory = [ { name: 'asparagus', type: 'vegetables', quantity: 5 }, { name: 'bananas', type: 'fruit', quantity: 0 }, { name: 'goat', type: 'meat', quantity: 23 }, { name: 'cherries', type: 'f...
2022-04-28 15:19:35
967
原创 mysql 设置uuid函数
CREATE FUNCTION getUUID() RETURNS VARCHAR(32)RETURN REPLACE(md5(UUID()),"-","")
2021-09-30 14:35:21
502
原创 java 输入奇数 打印沙漏
public static void main(String[] args) { Scanner scanner = new Scanner(System.in); int n=scanner.nextInt(); for(int i =n;-i<=n;i=i-2){ int z=i; if(i<0){ if(z==-1){ continue; } z=-i; }.
2021-04-20 11:30:01
256
原创 读取mybatis-plus日志文件生成update,insert 语句
public class readLog { public static void main(String[] args) throws FileNotFoundException { System.setOut(new PrintStream(new FileOutputStream("D://sql.sql"))); StringBuilder stringBuilder = new StringBuilder(); FileInputStrea.
2021-01-25 16:20:05
509
2
原创 java获取时间下周几的时间
public static void main(String[] args) throws ParseException { //时间 Date date = sdf.parse("2020-10-10"); //0代表周日1代表周一 以此类推 int week = 2; SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); Calendar cal = Calendar.getInstance();..
2020-10-10 17:19:11
675
原创 mysql模拟oralce 编写to_date函数
create function to_date(str_date varchar(256),format varchar(256)) RETURNS varchar(256)begin declare c varchar(256); if INSTR(lower(format),'mm')=0 THEN set str_date = CONCAT(str_date,'01'); set format = CONCAT(format,'mm'); ...
2020-07-01 11:58:20
265
原创 oralce mysql 密码加密解密函数
//oralcecreate or replace function "DECRYPT_DES"(p_text varchar2,p_key varchar2) return varchar2 is v_text varchar2(2000);begin dbms_obfuscation_toolkit.DESDECRYPT(input_string => UTL_RAW.CAST_TO_varchar2(p_text),key_string =>p_key, decryp...
2020-07-01 11:16:26
223
原创 idea201903 控制台乱码问题
右上角tomcat 配置-Dfile.encoding=UTF-8增加-Dfile.encoding=UTF-8-Dconsole.encoding=UTF-8
2020-05-21 09:17:16
173
原创 java List 求和 返回求和bean
/** * * @param <T> * @param all 返回总和Bean * @param list 求和数据 * @param ignoreFieldNames忽略求和字段 * @return */ public static <T> T setSumListsToBean(T all...
2020-03-30 15:33:10
775
原创 vue java后台导出Excel 兼容ie
//jsexport function exportExcel(params,url) { let form = document.createElement("form") let cloneObj=function(obj) { let newObj = {}; if (obj instanceof Array) { newObj = []; ...
2020-03-13 09:03:10
340
原创 exl office 中文转拼音首字母大写
1.alt+F112.右击页签 插入模块3.复制内容Function hztopy(hzpy As String) As StringDim hzstring As String, pystring As StringDim hzpysum As Integer, hzi As Integer, hzpyhex As Integerhzstring = Trim(hzpy)...
2019-05-20 17:18:50
1124
原创 获取日期年月的最后一天
/** * * @param 日期格式yyyymm * @return 最后一天日期 */ private Date yearMonthEnd(String reportDate) { Calendar cal = Calendar.getInstance(); cal.set(Calendar.YEAR,I...
2019-03-01 10:45:55
481
原创 oralce sql decode，相似函数 ，逗号列转行，分组排序， 生成有关系的32id，获取年的列
decode（字段，=1，为a,=2,为3）= decode(field,1,a,2,3);oracle 相似函数 :UTL_MATCH.edit_distance_similarity();补位数https://blog.csdn.net/dhf984721977/article/details/79939743select to_char('.02','fm99990.00')...
2019-01-11 16:18:27
185
原创 list java8 stream 转 map，数组，set，排序，分组，求和
list转mapMap <String,String> basicMap= basicList.stream().collect(Collectors.toMap(BasicDict::getValue, BasicDict::getName,(k1,k2) -> k1));list转数组String [] name = list.stream().map(Entit...
2018-12-14 18:55:54
745
原创 sql操作数据
//单引号连接||chr(39)||//拿到表列SELECT t.COLUMN_NAME||',' FROM USER_TAB_COLUMNS t where t.TABLE_NAME='表名';//表数据还原 //启动行移动 alter table tablename enable row movement; //闪回到该时间 flashback ...
2018-11-27 09:41:31
174
原创 jdbc日志配置
------------- db.properties:connectDB=jdbc\:log4jdbc:sqlserver\://192.168.100.37\:1433;DatabaseName\=USER00012018 ------------- log4j.properties:log4j.rootLogger = DEBUG,stdout,filelog4j.log...
2018-11-22 09:35:21
1191
原创 poi 插入公式
Cell cell = row.createCell(colIdx++); CellAddress a =row.createCell(colIdx).getAddress(); CellAddress b =row.createCell(colIdx+4...
2018-11-15 09:42:20
5770
原创 list BigDecimal 求和 java8
list.stream().mapToDouble(e->e.getValue().doubleValue()).reduce(0, Double::sum);
2018-11-15 09:02:47
18515
2
原创 Poi 导入格式转换
private String getValue(HSSFCell cell) { String cellValue = ""; DecimalFormat df = new DecimalFormat("#.0000"); if(cell!=null){ switch (cell.getCellType()) { ...
2018-09-13 16:57:46
640
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人