如何高效导出百万POI数据，打造长尾关键词策略？
- 内容介绍
- 文章标签
- 相关推荐
本文共计4456个文字，预计阅读时间需要18分钟。
javaimport org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.Row;import java.io.File;import java.io.FileOutputStream;import java.lang.reflect.Method;import java.util.ArrayList;import java.util.List;
package test;
import java.io.File;
import java.io.FileOutputStream;
import java.lang.reflect.Method;
import java.util.ArrayList;
import java.util.List;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.xssf.streaming.SXSSFSheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
public class ExcelExportSXXSSF {
// 定义工作表
private SXSSFWorkbook wb;
/**
* 定义工作表中的sheet
*/
private Sheet sh;
/**
* 定义保存在内存中的数量,-1表示手动控制
*/
private int flushRows;
/** 导出文件行数 */
private int rownum;
/** 导出文件列数 */
private int colnum;
/** 导出文件的存放路径 */
private String filePath;
/** 下载导出文件的路径 */
private String fileWebPath;
/**文件名称前缀*/
private String filePrefix;
/**导出文件全路径*/
private String fileAllPath;
/** 导出文件列标题 */
private List
package test;
import java.io.UnsupportedEncodingException;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.ParsePosition;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Collections;
import java.util.Comparator;
import java.util.Date;
import java.util.HashSet;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.StringTokenizer;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
public class MyUtil {
private static final String CNUMBER_PATTERN = "^[0-9]*$";// 判断数字的正则表达式
private static SimpleDateFormat bartDateFormat = new SimpleDateFormat(
"yyyy-MM-dd");
public static int getYear(Date date) {
try {
String form_date = bartDateFormat.format(date);
return Integer.parseInt(form_date.substring(0, 4));
} catch (Exception ex) {
return Integer.parseInt(getCurrentTime().substring(0, 4));
}
}
public static int getMonth(Date date) {
try {
String form_date = bartDateFormat.format(date);
return Integer.parseInt(form_date.substring(5, form_date
.lastIndexOf("-")));
} catch (Exception ex) {
String currenttimel = getCurrentTime();
return Integer.parseInt(currenttimel.substring(5, currenttimel
.lastIndexOf("-")));
}
}
public static int getDay(Date date) {
try {
String form_date = bartDateFormat.format(date);
return Integer.parseInt(form_date.substring(form_date
.lastIndexOf("-") + 1, form_date.length()));
} catch (Exception ex) {
String currenttimel = getCurrentTime();
return Integer.parseInt(currenttimel.substring(5, currenttimel
.lastIndexOf("-")));
}
}
public static String[] getMonth_days(Date date) {
String[] month_day = { "31", "28", "31", "30", "31", "30", "31", "31",
"30", "31", "30", "31" };
int year = getYear(date);
if (((year % 4 == 0) && (year % 100 != 0)) || (year % 400 == 0))
month_day[1] = "29";
return month_day;
}
public static int getCount(String str, String sign) {
if (str == null) {
return 0;
}
StringTokenizer s = new StringTokenizer(str, sign);
return s.countTokens();
}
public static String[] getArray(String str, String sign) {
int count = getCount(str, sign);
int j = 0;
String[] arr = new String[count];
for (int i = 0; i < count; i++) {
if (str.indexOf(sign) != -1) {
j = str.indexOf(sign);
arr[i] = str.substring(0, j);
str = str.substring(j + 1);
} else {
arr[i] = str;
}
// System.out.println(arr[i]);
}
return arr;
}
public static String getCurrentTime() {
java.sql.Timestamp temp = new java.sql.Timestamp(System
.currentTimeMillis());
return (temp.toString()).substring(0, 19);
}
public static Date toDateType(String s) {
DateFormat df = DateFormat.getDateInstance();
df.setLenient(false);
s = s.replace('/', '-');
s = s.replace('.', '.');
try {
return df.parse(s);
} catch (Exception e) {
return null;
}
}
public static String unicodeToGB(String strIn) {
byte[] b;
String strOut = null;
if (strIn == null || (strIn.trim()).equals("")) {
return strIn;
}
try {
b = strIn.getBytes("GBK");
strOut = new String(b, "ISO8859_1");
} catch (UnsupportedEncodingException e) {
}
return strOut;
}
public static String GBToUnicode(String strIn) {
String strOut = null;
if (strIn == null || (strIn.trim().equals(""))) {
return strIn;
}
try {
byte[] b = strIn.getBytes("ISO8859_1");
strOut = new String(b, "GBK");
} catch (Exception e) {
}
return strOut;
}
public static String UTFToUnicode(String strIn) {
String strOut = null;
if (strIn == null || (strIn.trim().equals(""))) {
return strIn;
}
try {
byte[] b = strIn.getBytes("ISO8859_1");
strOut = new String(b, "UTF-8");
} catch (Exception e) {
}
return strOut;
}
public static String UTFToGBK(String strIn) {
String strOut = null;
if (strIn == null || (strIn.trim().equals(""))) {
return strIn;
}
try {
byte[] b = strIn.getBytes("GBK");
strOut = new String(b, "UTF-8");
} catch (Exception e) {
}
return strOut;
}
public static String buildURL(Map parameters) {
StringBuffer url = new StringBuffer();
if (parameters != null && parameters.size() > 0) {
url.append("?");
for (Iterator iter = parameters.keySet().iterator(); iter.hasNext();) {
String key = (String) iter.next();
String[] values = (String[]) parameters.get(key);
for (int i = 0; i < values.length; i++) {
url.append(key).append("=").append(values[i]).append("&");
}
}
}
return url.toString();
}
/**
* 获得当前时间(根据格式字符串)
*
* @param format
* String 格式字符串
* @return String
*/
public static String getDateByFormat(String format) {
Calendar date = Calendar.getInstance();
//System.out.print("date.getTime()==="+date.getTime());
java.text.SimpleDateFormat sim = new java.text.SimpleDateFormat(format);
String str = sim.format(date.getTime());
return str;
}
/**
* 获得当前时间
*
* @return String
*/
public static String getDate() {
Calendar date = Calendar.getInstance();
java.text.SimpleDateFormat sim = new java.text.SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
String str = sim.format(date.getTime());
return str;
}
/**
* 获得当前时间
*
* @return Date
*/
public static Date getNowDate() {
/*Calendar date = Calendar.getInstance();
return date.getTime();*/
return getDate(getDate());
}
/**
* 字符串转换为时间
*
* @param date
* String
* @return Date
*/
public static Date getDate(String date) {
try {
SimpleDateFormat localTime = new SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
Date date1 = localTime.parse(date);
return date1;
}
catch (ParseException ex) {
ex.printStackTrace();
}
return null;
}
/**
* 字符串转换为时间2
*
* @param date
* String
* @return Date
*/
public static Date getDate2(String date) {
try {
SimpleDateFormat localTime = new SimpleDateFormat("yyyy-MM-dd");
Date date1 = localTime.parse(date);
return date1;
}
catch (ParseException ex) {
ex.printStackTrace();
}
return null;
}
/**
* 字符串转换为时间3
*
* @param date
* String
* @return Date
*/
public static Date getDate3(String date) {
try {
SimpleDateFormat localTime = new SimpleDateFormat("yyyy-MM");
Date date1 = localTime.parse(date);
return date1;
}
catch (ParseException ex) {
ex.printStackTrace();
}
return null;
}
/**
* 字符串转换为时间3
*
* @param date
* String
* @return Date
*/
public static Date getDateByHHMM(String date) {
try {
SimpleDateFormat localTime = new SimpleDateFormat("HH:mm");
Date date1 = localTime.parse(date);
return date1;
}
catch (ParseException ex) {
ex.printStackTrace();
}
return null;
}
/**
* 字符串转换为时间3
*
* @param date
* String
* @return Date
*/
public static Date getDate4(String date) {
try {
SimpleDateFormat localTime = new SimpleDateFormat("yyyy");
Date date1 = localTime.parse(date);
return date1;
}
catch (ParseException ex) {
ex.printStackTrace();
}
return null;
}
/**
* 取得秒数
*/
public static Long getDateDiff_Second(Date d1, Date d2) {
return (d2.getTime() - d1.getTime()) / 1000;
}
/**
* 取得分钟
*
* @param d1
* Date
* @param d2
* Date
* @return Long
*/
public static Long getDateDiff_Minute(Date d1, Date d2) {
return (d2.getTime() - d1.getTime()) / (1000 * 60);
}
/**
* 取得小时
*
* @param d1
* Date
* @param d2
* Date
* @return Long
*/
public static Long getDateDiff_Hour(Date d1, Date d2) {
return (d2.getTime() - d1.getTime()) / (1000 * 3600);
}
public static Long getDateDiff_Hour(String d1, String d2) {
return (getDate(d2).getTime() - getDate(d1).getTime()) / (1000 * 3600);
}
/**
* 取得天数
*
* @param d1
* Date
* @param d2
* Date
* @return Long
*/
public static Long getDateDiff_Day(Date d1, Date d2) {
return (d2.getTime() - d1.getTime()) / (1000 * 3600 * 24);
}
public static Long getDateDiff_Day(String d1, String d2) {
return (getDate(d2).getTime() - getDate(d1).getTime())
/ (1000 * 3600 * 24);
}
/**
* 取得星期间隔
*
* @param d1
* Date
* @param d2
* Date
* @return Long
*/
public static Long getDateDiff_Week(Date d1, Date d2) {
return (d2.getTime() - d1.getTime()) / (1000 * 3600 * 24 * 7);
}
/**
* 取得当前时间的 间隔多少小时之后的时间
*
* @param hour
* int
* @return String
*/
public static String getDateAdd(int hour) {
Calendar calendar = Calendar.getInstance();
java.text.SimpleDateFormat sd = new SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
calendar.set(Calendar.HOUR, hour + calendar.get(Calendar.HOUR));
String enddate = sd.format(calendar.getTime());
return enddate;
}
/**
* 取得当前时间的 间隔多少小时之后的时间
*
* @param hour
* int
* @return String
*/
public static String getDateAdd(String starttime, int hour) {
Calendar calendar = Calendar.getInstance();
java.text.SimpleDateFormat sd = new SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
calendar.setTime(getDate(starttime));
calendar.set(Calendar.HOUR, hour + calendar.get(Calendar.HOUR));
String date = sd.format(calendar.getTime());
return date;
}
public static Date getDateAdd(Date starttime, int hour) {
Calendar calendar = Calendar.getInstance();
java.text.SimpleDateFormat sd = new SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
calendar.setTime(starttime);
calendar.set(Calendar.HOUR, hour + calendar.get(Calendar.HOUR));
return calendar.getTime();
}
/**
* 取得当前时间的 间隔多少小时之后的时间
*
* @param hour
* int
* @return String
*/
public static String getDateAdd2(String starttime, int hour) {
Calendar calendar = Calendar.getInstance();
java.text.SimpleDateFormat sd = new SimpleDateFormat("yyyy-MM-dd");
calendar.setTime(getDate2(starttime));
calendar.set(Calendar.HOUR, hour + calendar.get(Calendar.HOUR));
String date = sd.format(calendar.getTime());
return date;
}
/**
* 取得当前时间的 间隔多少秒之后的时间
*
* @param hour
* int
* @return String
*/
public static String getDateAddSecond(String starttime, long second) {
Calendar calendar = Calendar.getInstance();
java.text.SimpleDateFormat sd = new SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
calendar.setTime(getDate2(starttime));
calendar.set(Calendar.SECOND, (int) (second + calendar
.get(Calendar.SECOND)));
String date = sd.format(calendar.getTime());
return date;
}
/**
* 获得时间格式的文件名称
*
* @return String
*/
public static String getFileName() {
Calendar date = Calendar.getInstance();
java.text.SimpleDateFormat sim = new java.text.SimpleDateFormat(
"yyyyMMdd_hhmmss");
String str = sim.format(date.getTime());
return str;
}
// 获得月日
public static String get_MM_DD(String s) {
java.text.SimpleDateFormat sim = new java.text.SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
Date date;
String str = "";
try {
date = sim.parse(s);
sim = new java.text.SimpleDateFormat("[MM-dd]");
str = sim.format(date.getTime());
} catch (ParseException e) {
e.printStackTrace();
} finally {
return str;
}
}
// 获得年月日
public static String get_YYYY_MM_DD(String s) {
java.text.SimpleDateFormat sim = new java.text.SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
Date date;
String str = "";
try {
date = sim.parse(s);
sim = new java.text.SimpleDateFormat("yyyy-MM-dd");
str = sim.format(date.getTime());
} catch (ParseException e) {
e.printStackTrace();
} finally {
return str;
}
}
// 获得年月
public static String get_YYYY_MM(String s) {
java.text.SimpleDateFormat sim = new java.text.SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
Date date;
String str = "";
try {
date = sim.parse(s);
sim = new java.text.SimpleDateFormat("yyyy-MM");
str = sim.format(date.getTime());
} catch (ParseException e) {
e.printStackTrace();
} finally {
return str;
}
}
// 获得年
public static String get_YYYY(String s) {
java.text.SimpleDateFormat sim = new java.text.SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
Date date;
String str = "";
try {
date = sim.parse(s);
sim = new java.text.SimpleDateFormat("yyyy");
str = sim.format(date.getTime());
} catch (ParseException e) {
e.printStackTrace();
} finally {
return str;
}
}
/**
* 检查IP是否合法
*
* @param value
* @return
*/
public static boolean ipValid(String s) {
String regex0 = "(2[0-4]\\d)" + "|(25[0-5])";
String regex1 = "1\\d{2}";
String regex2 = "[1-9]\\d";
String regex3 = "\\d";
String regex = "(" + regex0 + ")|(" + regex1 + ")|(" + regex2 + ")|("
+ regex3 + ")";
regex = "(" + regex + ").(" + regex + ").(" + regex + ").(" + regex
+ ")";
Pattern p = Pattern.compile(regex);
Matcher m = p.matcher(s);
return m.matches();
}
/**
* 将java.util.Date 格式转换为字符串格式'yyyy-MM-dd HH:mm:ss'(24小时制)
* 如Sat May 11 17:24:21 CST 2002 to '2002-05-11 17:24:21'
*
* @param time
* Date 日期
* @return String 字符串
*/
public static String dateToString(Date time) {
SimpleDateFormat formatter;
formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String ctime = formatter.format(time);
return ctime;
}
public static String dateToString2(Date time) {
SimpleDateFormat formatter;
formatter = new SimpleDateFormat("yyyy-MM-dd");
String ctime = formatter.format(time);
return ctime;
}
public static String yymmdddateToString(Date time) {
SimpleDateFormat formatter;
formatter = new SimpleDateFormat("yyyyMMdd");
String ctime = formatter.format(time);
return ctime;
}
public static String hhmmssdateToString(Date time) {
SimpleDateFormat formatter;
formatter = new SimpleDateFormat("hhmmss");
String ctime = formatter.format(time);
return ctime;
}
/**
* 将java.util.Date 格式转换为字符串格式'yyyy-MM-dd HH:mm:ss a'(12小时制)
* 如Sat May 11 17:23:22 CST 2002 to '2002-05-11 05:23:22 下午'
*
* @param time
* Date 日期
* @param x
* int 任意整数如：1
* @return String 字符串
*/
public static String dateToString(Date time, int x) {
SimpleDateFormat formatter;
formatter = new SimpleDateFormat("yyyy-MM-dd KK:mm:ss a");
String ctime = formatter.format(time);
return ctime;
}
// 判断字符串是否为Null或“”
public static boolean isNotNullAndEmpty(String str) {
if (null != str && !str.equals("")) {
return true;
}
return false;
}
// 判断列表是否为Null或大小为0
public static boolean isNotNullAndZero(List list) {
if (null != list && list.size() > 0) {
return true;
}
return false;
}
// 判断字符串是否为Null，trim之后判断是否为空
public static boolean isNotNullAndEmptyByTrim(String str) {
if (null != str && !str.trim().equals("")) {
return true;
}
return false;
}
// 删除ArrayList中重复元素
public static List removeDuplicate(List list) {
HashSet h = new HashSet(list);
list.clear();
list.addAll(h);
return list;
}
// 判断当前天是否为月末时间即加一天是否为下个月
public static boolean isTheLastMonthDAY() {
String curtime = getDate();
String nexttime = getDateAdd(curtime, 24);
if (!get_YYYY_MM(curtime).equals(get_YYYY_MM(nexttime))) {
return true;
}
return false;
}
/**
* 编码转换
*
* @param str
* @return
*/
public static String getReadStr(String str) {
try {
String temp_p = str;
byte[] temp_t = temp_p.getBytes("ISO-8859-1");
String unicode = new String(temp_t, "gb2312");
return unicode;
} catch (Exception e) {
return "null";
}
}
public static String isoTOUTF(String str) {
try {
String temp_p = str;
byte[] temp_t = temp_p.getBytes("ISO-8859-1");
String unicode = new String(temp_t, "UTF-8");
return unicode;
} catch (Exception e) {
return "null";
}
}
public static String utfTOISO(String str) {
try {
String temp_p = str;
byte[] temp_t = temp_p.getBytes("UTF-8");
String unicode = new String(temp_t, "ISO-8859-1");
return unicode;
} catch (Exception e) {
return "null";
}
}
public static String toHtml(String str) {
if (str == null) {
return "";
} else {
str = str.replaceAll("<", "<");
str = str.replaceAll(">", ">");
str = str.replaceAll("'", "''");
str = str.replaceAll(" ", "");
str = str.replaceAll("\n", "
");
}
return str;
}
public static String toText(String str) {
if (str == null) {
return "";
} else {
str = str.replaceAll("<", "<");
str = str.replaceAll(">", ">");
str = str.replaceAll("''", "'");
str = str.replaceAll("", " ");
str = str.replaceAll("
", "\n");
}
return str;
}
/**
* 去掉字符串的html代码
*
* @param htmlStr
* 字符串
* @return 结果
*/
public static String htmlToStr(String htmlStr) {
String result = "";
boolean flag = true;
if (htmlStr == null) {
return null;
}
char[] a = htmlStr.toCharArray();
int length = a.length;
for (int i = 0; i < length; i++) {
if (a[i] == '<') {
flag = false;
continue;
}
if (a[i] == '>') {
flag = true;
continue;
}
if (flag == true) {
result += a[i];
}
}
return result.toString().replaceAll("", " ");
}
/**
* 去掉字符串里面的html代码。
* 要求数据要规范，比如大于小于号要配套,否则会被集体误杀。
*
* @paramcontent 内容
* @return去掉后的内容
*/
public static String stripHtml(String content) {
content = content.replaceAll("
", "rn");
content = content.replaceAll("
package test;
import java.util.Date;
public class Ypxx {
private String bm;
private String mc;
private float price;
private String kkk;
private String pzwh;
private Date pzwhyxq;
private String jky;
private String bzcz;
private String bzdw;
private Double lsjg;
private String lsjgcc;
private String zlcc;
private String zlccsm;
private String ypjybg;
private String ypjybgbm;
private Date ypjybgyxq;
private String jyzt;
private String vchar1;
public Ypxx(String bm,String mc,float price){
this.bm = bm;
this.mc = mc;
this.price = price;
}
public String getKkk() {
return kkk;
}
public void setKkk(String kkk) {
this.kkk = kkk;
}
public String getPzwh() {
return pzwh;
}
public void setPzwh(String pzwh) {
this.pzwh = pzwh;
}
public Date getPzwhyxq() {
return pzwhyxq;
}
public void setPzwhyxq(Date pzwhyxq) {
this.pzwhyxq = pzwhyxq;
}
public String getJky() {
return jky;
}
public void setJky(String jky) {
this.jky = jky;
}
public String getBzcz() {
return bzcz;
}
public void setBzcz(String bzcz) {
this.bzcz = bzcz;
}
public String getBzdw() {
return bzdw;
}
public void setBzdw(String bzdw) {
this.bzdw = bzdw;
}
public Double getLsjg() {
return lsjg;
}
public void setLsjg(Double lsjg) {
this.lsjg = lsjg;
}
public String getLsjgcc() {
return lsjgcc;
}
public void setLsjgcc(String lsjgcc) {
this.lsjgcc = lsjgcc;
}
public String getZlcc() {
return zlcc;
}
public void setZlcc(String zlcc) {
this.zlcc = zlcc;
}
public String getZlccsm() {
return zlccsm;
}
public void setZlccsm(String zlccsm) {
this.zlccsm = zlccsm;
}
public String getYpjybg() {
return ypjybg;
}
public void setYpjybg(String ypjybg) {
this.ypjybg = ypjybg;
}
public String getYpjybgbm() {
return ypjybgbm;
}
public void setYpjybgbm(String ypjybgbm) {
this.ypjybgbm = ypjybgbm;
}
public Date getYpjybgyxq() {
return ypjybgyxq;
}
public void setYpjybgyxq(Date ypjybgyxq) {
this.ypjybgyxq = ypjybgyxq;
}
public String getJyzt() {
return jyzt;
}
public void setJyzt(String jyzt) {
this.jyzt = jyzt;
}
public String getVchar1() {
return vchar1;
}
public void setVchar1(String vchar1) {
this.vchar1 = vchar1;
}
public String getBm() {
return bm;
}
public void setBm(String bm) {
this.bm = bm;
}
public String getMc() {
return mc;
}
public void setMc(String mc) {
this.mc = mc;
}
public float getPrice() {
return price;
}
public void setPrice(float price) {
this.price = price;
}
@Override
public String toString() {
return "Ypxx [bm=" + bm + ", mc=" + mc + ", price=" + price + "]";
}
}
本文共计4456个文字，预计阅读时间需要18分钟。
javaimport org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.Row;import java.io.File;import java.io.FileOutputStream;import java.lang.reflect.Method;import java.util.ArrayList;import java.util.List;
package test;
import java.io.File;
import java.io.FileOutputStream;
import java.lang.reflect.Method;
import java.util.ArrayList;
import java.util.List;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.xssf.streaming.SXSSFSheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
public class ExcelExportSXXSSF {
// 定义工作表
private SXSSFWorkbook wb;
/**
* 定义工作表中的sheet
*/
private Sheet sh;
/**
* 定义保存在内存中的数量,-1表示手动控制
*/
private int flushRows;
/** 导出文件行数 */
private int rownum;
/** 导出文件列数 */
private int colnum;
/** 导出文件的存放路径 */
private String filePath;
/** 下载导出文件的路径 */
private String fileWebPath;
/**文件名称前缀*/
private String filePrefix;
/**导出文件全路径*/
private String fileAllPath;
/** 导出文件列标题 */
private List
package test;
import java.io.UnsupportedEncodingException;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.ParsePosition;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Collections;
import java.util.Comparator;
import java.util.Date;
import java.util.HashSet;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.StringTokenizer;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
public class MyUtil {
private static final String CNUMBER_PATTERN = "^[0-9]*$";// 判断数字的正则表达式
private static SimpleDateFormat bartDateFormat = new SimpleDateFormat(
"yyyy-MM-dd");
public static int getYear(Date date) {
try {
String form_date = bartDateFormat.format(date);
return Integer.parseInt(form_date.substring(0, 4));
} catch (Exception ex) {
return Integer.parseInt(getCurrentTime().substring(0, 4));
}
}
public static int getMonth(Date date) {
try {
String form_date = bartDateFormat.format(date);
return Integer.parseInt(form_date.substring(5, form_date
.lastIndexOf("-")));
} catch (Exception ex) {
String currenttimel = getCurrentTime();
return Integer.parseInt(currenttimel.substring(5, currenttimel
.lastIndexOf("-")));
}
}
public static int getDay(Date date) {
try {
String form_date = bartDateFormat.format(date);
return Integer.parseInt(form_date.substring(form_date
.lastIndexOf("-") + 1, form_date.length()));
} catch (Exception ex) {
String currenttimel = getCurrentTime();
return Integer.parseInt(currenttimel.substring(5, currenttimel
.lastIndexOf("-")));
}
}
public static String[] getMonth_days(Date date) {
String[] month_day = { "31", "28", "31", "30", "31", "30", "31", "31",
"30", "31", "30", "31" };
int year = getYear(date);
if (((year % 4 == 0) && (year % 100 != 0)) || (year % 400 == 0))
month_day[1] = "29";
return month_day;
}
public static int getCount(String str, String sign) {
if (str == null) {
return 0;
}
StringTokenizer s = new StringTokenizer(str, sign);
return s.countTokens();
}
public static String[] getArray(String str, String sign) {
int count = getCount(str, sign);
int j = 0;
String[] arr = new String[count];
for (int i = 0; i < count; i++) {
if (str.indexOf(sign) != -1) {
j = str.indexOf(sign);
arr[i] = str.substring(0, j);
str = str.substring(j + 1);
} else {
arr[i] = str;
}
// System.out.println(arr[i]);
}
return arr;
}
public static String getCurrentTime() {
java.sql.Timestamp temp = new java.sql.Timestamp(System
.currentTimeMillis());
return (temp.toString()).substring(0, 19);
}
public static Date toDateType(String s) {
DateFormat df = DateFormat.getDateInstance();
df.setLenient(false);
s = s.replace('/', '-');
s = s.replace('.', '.');
try {
return df.parse(s);
} catch (Exception e) {
return null;
}
}
public static String unicodeToGB(String strIn) {
byte[] b;
String strOut = null;
if (strIn == null || (strIn.trim()).equals("")) {
return strIn;
}
try {
b = strIn.getBytes("GBK");
strOut = new String(b, "ISO8859_1");
} catch (UnsupportedEncodingException e) {
}
return strOut;
}
public static String GBToUnicode(String strIn) {
String strOut = null;
if (strIn == null || (strIn.trim().equals(""))) {
return strIn;
}
try {
byte[] b = strIn.getBytes("ISO8859_1");
strOut = new String(b, "GBK");
} catch (Exception e) {
}
return strOut;
}
public static String UTFToUnicode(String strIn) {
String strOut = null;
if (strIn == null || (strIn.trim().equals(""))) {
return strIn;
}
try {
byte[] b = strIn.getBytes("ISO8859_1");
strOut = new String(b, "UTF-8");
} catch (Exception e) {
}
return strOut;
}
public static String UTFToGBK(String strIn) {
String strOut = null;
if (strIn == null || (strIn.trim().equals(""))) {
return strIn;
}
try {
byte[] b = strIn.getBytes("GBK");
strOut = new String(b, "UTF-8");
} catch (Exception e) {
}
return strOut;
}
public static String buildURL(Map parameters) {
StringBuffer url = new StringBuffer();
if (parameters != null && parameters.size() > 0) {
url.append("?");
for (Iterator iter = parameters.keySet().iterator(); iter.hasNext();) {
String key = (String) iter.next();
String[] values = (String[]) parameters.get(key);
for (int i = 0; i < values.length; i++) {
url.append(key).append("=").append(values[i]).append("&");
}
}
}
return url.toString();
}
/**
* 获得当前时间(根据格式字符串)
*
* @param format
* String 格式字符串
* @return String
*/
public static String getDateByFormat(String format) {
Calendar date = Calendar.getInstance();
//System.out.print("date.getTime()==="+date.getTime());
java.text.SimpleDateFormat sim = new java.text.SimpleDateFormat(format);
String str = sim.format(date.getTime());
return str;
}
/**
* 获得当前时间
*
* @return String
*/
public static String getDate() {
Calendar date = Calendar.getInstance();
java.text.SimpleDateFormat sim = new java.text.SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
String str = sim.format(date.getTime());
return str;
}
/**
* 获得当前时间
*
* @return Date
*/
public static Date getNowDate() {
/*Calendar date = Calendar.getInstance();
return date.getTime();*/
return getDate(getDate());
}
/**
* 字符串转换为时间
*
* @param date
* String
* @return Date
*/
public static Date getDate(String date) {
try {
SimpleDateFormat localTime = new SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
Date date1 = localTime.parse(date);
return date1;
}
catch (ParseException ex) {
ex.printStackTrace();
}
return null;
}
/**
* 字符串转换为时间2
*
* @param date
* String
* @return Date
*/
public static Date getDate2(String date) {
try {
SimpleDateFormat localTime = new SimpleDateFormat("yyyy-MM-dd");
Date date1 = localTime.parse(date);
return date1;
}
catch (ParseException ex) {
ex.printStackTrace();
}
return null;
}
/**
* 字符串转换为时间3
*
* @param date
* String
* @return Date
*/
public static Date getDate3(String date) {
try {
SimpleDateFormat localTime = new SimpleDateFormat("yyyy-MM");
Date date1 = localTime.parse(date);
return date1;
}
catch (ParseException ex) {
ex.printStackTrace();
}
return null;
}
/**
* 字符串转换为时间3
*
* @param date
* String
* @return Date
*/
public static Date getDateByHHMM(String date) {
try {
SimpleDateFormat localTime = new SimpleDateFormat("HH:mm");
Date date1 = localTime.parse(date);
return date1;
}
catch (ParseException ex) {
ex.printStackTrace();
}
return null;
}
/**
* 字符串转换为时间3
*
* @param date
* String
* @return Date
*/
public static Date getDate4(String date) {
try {
SimpleDateFormat localTime = new SimpleDateFormat("yyyy");
Date date1 = localTime.parse(date);
return date1;
}
catch (ParseException ex) {
ex.printStackTrace();
}
return null;
}
/**
* 取得秒数
*/
public static Long getDateDiff_Second(Date d1, Date d2) {
return (d2.getTime() - d1.getTime()) / 1000;
}
/**
* 取得分钟
*
* @param d1
* Date
* @param d2
* Date
* @return Long
*/
public static Long getDateDiff_Minute(Date d1, Date d2) {
return (d2.getTime() - d1.getTime()) / (1000 * 60);
}
/**
* 取得小时
*
* @param d1
* Date
* @param d2
* Date
* @return Long
*/
public static Long getDateDiff_Hour(Date d1, Date d2) {
return (d2.getTime() - d1.getTime()) / (1000 * 3600);
}
public static Long getDateDiff_Hour(String d1, String d2) {
return (getDate(d2).getTime() - getDate(d1).getTime()) / (1000 * 3600);
}
/**
* 取得天数
*
* @param d1
* Date
* @param d2
* Date
* @return Long
*/
public static Long getDateDiff_Day(Date d1, Date d2) {
return (d2.getTime() - d1.getTime()) / (1000 * 3600 * 24);
}
public static Long getDateDiff_Day(String d1, String d2) {
return (getDate(d2).getTime() - getDate(d1).getTime())
/ (1000 * 3600 * 24);
}
/**
* 取得星期间隔
*
* @param d1
* Date
* @param d2
* Date
* @return Long
*/
public static Long getDateDiff_Week(Date d1, Date d2) {
return (d2.getTime() - d1.getTime()) / (1000 * 3600 * 24 * 7);
}
/**
* 取得当前时间的 间隔多少小时之后的时间
*
* @param hour
* int
* @return String
*/
public static String getDateAdd(int hour) {
Calendar calendar = Calendar.getInstance();
java.text.SimpleDateFormat sd = new SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
calendar.set(Calendar.HOUR, hour + calendar.get(Calendar.HOUR));
String enddate = sd.format(calendar.getTime());
return enddate;
}
/**
* 取得当前时间的 间隔多少小时之后的时间
*
* @param hour
* int
* @return String
*/
public static String getDateAdd(String starttime, int hour) {
Calendar calendar = Calendar.getInstance();
java.text.SimpleDateFormat sd = new SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
calendar.setTime(getDate(starttime));
calendar.set(Calendar.HOUR, hour + calendar.get(Calendar.HOUR));
String date = sd.format(calendar.getTime());
return date;
}
public static Date getDateAdd(Date starttime, int hour) {
Calendar calendar = Calendar.getInstance();
java.text.SimpleDateFormat sd = new SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
calendar.setTime(starttime);
calendar.set(Calendar.HOUR, hour + calendar.get(Calendar.HOUR));
return calendar.getTime();
}
/**
* 取得当前时间的 间隔多少小时之后的时间
*
* @param hour
* int
* @return String
*/
public static String getDateAdd2(String starttime, int hour) {
Calendar calendar = Calendar.getInstance();
java.text.SimpleDateFormat sd = new SimpleDateFormat("yyyy-MM-dd");
calendar.setTime(getDate2(starttime));
calendar.set(Calendar.HOUR, hour + calendar.get(Calendar.HOUR));
String date = sd.format(calendar.getTime());
return date;
}
/**
* 取得当前时间的 间隔多少秒之后的时间
*
* @param hour
* int
* @return String
*/
public static String getDateAddSecond(String starttime, long second) {
Calendar calendar = Calendar.getInstance();
java.text.SimpleDateFormat sd = new SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
calendar.setTime(getDate2(starttime));
calendar.set(Calendar.SECOND, (int) (second + calendar
.get(Calendar.SECOND)));
String date = sd.format(calendar.getTime());
return date;
}
/**
* 获得时间格式的文件名称
*
* @return String
*/
public static String getFileName() {
Calendar date = Calendar.getInstance();
java.text.SimpleDateFormat sim = new java.text.SimpleDateFormat(
"yyyyMMdd_hhmmss");
String str = sim.format(date.getTime());
return str;
}
// 获得月日
public static String get_MM_DD(String s) {
java.text.SimpleDateFormat sim = new java.text.SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
Date date;
String str = "";
try {
date = sim.parse(s);
sim = new java.text.SimpleDateFormat("[MM-dd]");
str = sim.format(date.getTime());
} catch (ParseException e) {
e.printStackTrace();
} finally {
return str;
}
}
// 获得年月日
public static String get_YYYY_MM_DD(String s) {
java.text.SimpleDateFormat sim = new java.text.SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
Date date;
String str = "";
try {
date = sim.parse(s);
sim = new java.text.SimpleDateFormat("yyyy-MM-dd");
str = sim.format(date.getTime());
} catch (ParseException e) {
e.printStackTrace();
} finally {
return str;
}
}
// 获得年月
public static String get_YYYY_MM(String s) {
java.text.SimpleDateFormat sim = new java.text.SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
Date date;
String str = "";
try {
date = sim.parse(s);
sim = new java.text.SimpleDateFormat("yyyy-MM");
str = sim.format(date.getTime());
} catch (ParseException e) {
e.printStackTrace();
} finally {
return str;
}
}
// 获得年
public static String get_YYYY(String s) {
java.text.SimpleDateFormat sim = new java.text.SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
Date date;
String str = "";
try {
date = sim.parse(s);
sim = new java.text.SimpleDateFormat("yyyy");
str = sim.format(date.getTime());
} catch (ParseException e) {
e.printStackTrace();
} finally {
return str;
}
}
/**
* 检查IP是否合法
*
* @param value
* @return
*/
public static boolean ipValid(String s) {
String regex0 = "(2[0-4]\\d)" + "|(25[0-5])";
String regex1 = "1\\d{2}";
String regex2 = "[1-9]\\d";
String regex3 = "\\d";
String regex = "(" + regex0 + ")|(" + regex1 + ")|(" + regex2 + ")|("
+ regex3 + ")";
regex = "(" + regex + ").(" + regex + ").(" + regex + ").(" + regex
+ ")";
Pattern p = Pattern.compile(regex);
Matcher m = p.matcher(s);
return m.matches();
}
/**
* 将java.util.Date 格式转换为字符串格式'yyyy-MM-dd HH:mm:ss'(24小时制)
* 如Sat May 11 17:24:21 CST 2002 to '2002-05-11 17:24:21'
*
* @param time
* Date 日期
* @return String 字符串
*/
public static String dateToString(Date time) {
SimpleDateFormat formatter;
formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String ctime = formatter.format(time);
return ctime;
}
public static String dateToString2(Date time) {
SimpleDateFormat formatter;
formatter = new SimpleDateFormat("yyyy-MM-dd");
String ctime = formatter.format(time);
return ctime;
}
public static String yymmdddateToString(Date time) {
SimpleDateFormat formatter;
formatter = new SimpleDateFormat("yyyyMMdd");
String ctime = formatter.format(time);
return ctime;
}
public static String hhmmssdateToString(Date time) {
SimpleDateFormat formatter;
formatter = new SimpleDateFormat("hhmmss");
String ctime = formatter.format(time);
return ctime;
}
/**
* 将java.util.Date 格式转换为字符串格式'yyyy-MM-dd HH:mm:ss a'(12小时制)
* 如Sat May 11 17:23:22 CST 2002 to '2002-05-11 05:23:22 下午'
*
* @param time
* Date 日期
* @param x
* int 任意整数如：1
* @return String 字符串
*/
public static String dateToString(Date time, int x) {
SimpleDateFormat formatter;
formatter = new SimpleDateFormat("yyyy-MM-dd KK:mm:ss a");
String ctime = formatter.format(time);
return ctime;
}
// 判断字符串是否为Null或“”
public static boolean isNotNullAndEmpty(String str) {
if (null != str && !str.equals("")) {
return true;
}
return false;
}
// 判断列表是否为Null或大小为0
public static boolean isNotNullAndZero(List list) {
if (null != list && list.size() > 0) {
return true;
}
return false;
}
// 判断字符串是否为Null，trim之后判断是否为空
public static boolean isNotNullAndEmptyByTrim(String str) {
if (null != str && !str.trim().equals("")) {
return true;
}
return false;
}
// 删除ArrayList中重复元素
public static List removeDuplicate(List list) {
HashSet h = new HashSet(list);
list.clear();
list.addAll(h);
return list;
}
// 判断当前天是否为月末时间即加一天是否为下个月
public static boolean isTheLastMonthDAY() {
String curtime = getDate();
String nexttime = getDateAdd(curtime, 24);
if (!get_YYYY_MM(curtime).equals(get_YYYY_MM(nexttime))) {
return true;
}
return false;
}
/**
* 编码转换
*
* @param str
* @return
*/
public static String getReadStr(String str) {
try {
String temp_p = str;
byte[] temp_t = temp_p.getBytes("ISO-8859-1");
String unicode = new String(temp_t, "gb2312");
return unicode;
} catch (Exception e) {
return "null";
}
}
public static String isoTOUTF(String str) {
try {
String temp_p = str;
byte[] temp_t = temp_p.getBytes("ISO-8859-1");
String unicode = new String(temp_t, "UTF-8");
return unicode;
} catch (Exception e) {
return "null";
}
}
public static String utfTOISO(String str) {
try {
String temp_p = str;
byte[] temp_t = temp_p.getBytes("UTF-8");
String unicode = new String(temp_t, "ISO-8859-1");
return unicode;
} catch (Exception e) {
return "null";
}
}
public static String toHtml(String str) {
if (str == null) {
return "";
} else {
str = str.replaceAll("<", "<");
str = str.replaceAll(">", ">");
str = str.replaceAll("'", "''");
str = str.replaceAll(" ", "");
str = str.replaceAll("\n", "
");
}
return str;
}
public static String toText(String str) {
if (str == null) {
return "";
} else {
str = str.replaceAll("<", "<");
str = str.replaceAll(">", ">");
str = str.replaceAll("''", "'");
str = str.replaceAll("", " ");
str = str.replaceAll("
", "\n");
}
return str;
}
/**
* 去掉字符串的html代码
*
* @param htmlStr
* 字符串
* @return 结果
*/
public static String htmlToStr(String htmlStr) {
String result = "";
boolean flag = true;
if (htmlStr == null) {
return null;
}
char[] a = htmlStr.toCharArray();
int length = a.length;
for (int i = 0; i < length; i++) {
if (a[i] == '<') {
flag = false;
continue;
}
if (a[i] == '>') {
flag = true;
continue;
}
if (flag == true) {
result += a[i];
}
}
return result.toString().replaceAll("", " ");
}
/**
* 去掉字符串里面的html代码。
* 要求数据要规范，比如大于小于号要配套,否则会被集体误杀。
*
* @paramcontent 内容
* @return去掉后的内容
*/
public static String stripHtml(String content) {
content = content.replaceAll("
", "rn");
content = content.replaceAll("
package test;
import java.util.Date;
public class Ypxx {
private String bm;
private String mc;
private float price;
private String kkk;
private String pzwh;
private Date pzwhyxq;
private String jky;
private String bzcz;
private String bzdw;
private Double lsjg;
private String lsjgcc;
private String zlcc;
private String zlccsm;
private String ypjybg;
private String ypjybgbm;
private Date ypjybgyxq;
private String jyzt;
private String vchar1;
public Ypxx(String bm,String mc,float price){
this.bm = bm;
this.mc = mc;
this.price = price;
}
public String getKkk() {
return kkk;
}
public void setKkk(String kkk) {
this.kkk = kkk;
}
public String getPzwh() {
return pzwh;
}
public void setPzwh(String pzwh) {
this.pzwh = pzwh;
}
public Date getPzwhyxq() {
return pzwhyxq;
}
public void setPzwhyxq(Date pzwhyxq) {
this.pzwhyxq = pzwhyxq;
}
public String getJky() {
return jky;
}
public void setJky(String jky) {
this.jky = jky;
}
public String getBzcz() {
return bzcz;
}
public void setBzcz(String bzcz) {
this.bzcz = bzcz;
}
public String getBzdw() {
return bzdw;
}
public void setBzdw(String bzdw) {
this.bzdw = bzdw;
}
public Double getLsjg() {
return lsjg;
}
public void setLsjg(Double lsjg) {
this.lsjg = lsjg;
}
public String getLsjgcc() {
return lsjgcc;
}
public void setLsjgcc(String lsjgcc) {
this.lsjgcc = lsjgcc;
}
public String getZlcc() {
return zlcc;
}
public void setZlcc(String zlcc) {
this.zlcc = zlcc;
}
public String getZlccsm() {
return zlccsm;
}
public void setZlccsm(String zlccsm) {
this.zlccsm = zlccsm;
}
public String getYpjybg() {
return ypjybg;
}
public void setYpjybg(String ypjybg) {
this.ypjybg = ypjybg;
}
public String getYpjybgbm() {
return ypjybgbm;
}
public void setYpjybgbm(String ypjybgbm) {
this.ypjybgbm = ypjybgbm;
}
public Date getYpjybgyxq() {
return ypjybgyxq;
}
public void setYpjybgyxq(Date ypjybgyxq) {
this.ypjybgyxq = ypjybgyxq;
}
public String getJyzt() {
return jyzt;
}
public void setJyzt(String jyzt) {
this.jyzt = jyzt;
}
public String getVchar1() {
return vchar1;
}
public void setVchar1(String vchar1) {
this.vchar1 = vchar1;
}
public String getBm() {
return bm;
}
public void setBm(String bm) {
this.bm = bm;
}
public String getMc() {
return mc;
}
public void setMc(String mc) {
this.mc = mc;
}
public float getPrice() {
return price;
}
public void setPrice(float price) {
this.price = price;
}
@Override
public String toString() {
return "Ypxx [bm=" + bm + ", mc=" + mc + ", price=" + price + "]";
}
}