关闭

RSA算法加密/解密工具类

import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.ObjectInputStream; import java.io.ObjectOutputStream; import java.math.BigInteger; import jav...
阅读(196) 评论(0)

java md5加密

public class MD5Utils { // 全局数组 private final static String[] strDigits = { "0", "1", "2", "3", "4", "5", "6", "7", "8", "9", "a", "b", "c", "d", "e", "f" }; public MD5Utils() { } // ...
阅读(59) 评论(0)

java excel 导出

public class ExcelUtils { /** * 对象反射 */ public static Object getFieldValueByName(String fieldName, Object o) { try { String firstLetter = fieldName.substring(0, 1).toUpperCase(); String getter ...
阅读(49) 评论(0)

hibernate执行sql 行转列

String hql = "select a.*,a.measure,b.productId,b.product from (select code,name,measure,"; int count = 0; if(mm==2){ count=30; }else if(mm==1||mm==3||mm==5||mm==7||mm==8||mm==10||mm==12){ count=3...
阅读(153) 评论(0)

mysql 行转列

SELECT ifnull(CODE, 'total') AS CODE, sum(IF(dd = '1', quantity, 0)) AS '1', sum(IF(dd = '2', quantity, 0)) AS '2', sum(IF(dd = '3', quantity, 0)) AS '3', sum(IF(dd = '4', quantity, 0)) AS '4', ...
阅读(70) 评论(0)

日期生成 mysql

DROP PROCEDURE IF EXISTS pro_dim_date; CREATE PROCEDURE pro_dim_date (IN bdate DATE, IN edate DATE) BEGIN DECLARE var DATE DEFAULT bdate; DECLARE evar DATE DEFAULT DATE_ADD(edate, INTER...
阅读(69) 评论(0)

mysql 行转列

mysql 行转列...
阅读(55) 评论(0)
    个人资料
    • 访问:655次
    • 积分:64
    • 等级:
    • 排名:千里之外
    • 原创:6篇
    • 转载:1篇
    • 译文:0篇
    • 评论:0条
    文章存档