logserviceimpl.java

一段很有意义的源码,看了就知道,不信试一试啊!

package com.wondersgroup.basemodule.logmanage.service.impl;

import java.io.File;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.io.RandomAccessFile;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

import com.wondersgroup.basemodule.attachmentmanage.bo.AttachBO;
import com.wondersgroup.basemodule.logmanage.bo.LogBo;
import com.wondersgroup.basemodule.logmanage.dao.LogDAO;
import com.wondersgroup.basemodule.logmanage.service.LogService;
import com.wondersgroup.framework.core.bo.Page;

public class LogServiceImpl implements LogService {
	private LogDAO logDao;
	
	private static final String BK_FILE_PATH="自己改";
	public void saveLog(LogBo logBo) {
		// TODO Auto-generated method stub
		this.logDao.save(logBo);

	}

	public void setLogDao(LogDAO logDao) {
		this.logDao = logDao;
	}
	
	public	LogBo loadLogByID(long id){
		return (LogBo) this.logDao.load(new Long(id));
	}
	public	void deleteLog(LogBo logBo){
		logDao.delete(logBo);
	}
	public Page searchLog(int pageNo, int pageSize,Map m){
		Page page=new Page();
		 String tj="";
		 String hql = "from LogBo b where b.removed=0";
		 String hql2 = "select count(*) from LogBo b where b.removed=0";
		 if(m.get("SDATE")!=null && m.get("EDATE")!=null && m.get("SDATE").toString().length()>0 && m.get("EDATE").toString().length()>0){
			 tj+="	and DATE(b.operateTime)>=DATE('"+m.get("SDATE")+"')";
			 tj+="	and DATE(b.operateTime)<=DATE('"+m.get("EDATE")+"')";
		 } 
		 hql+=tj;
		 hql2+=tj;
		 page = logDao.findByHQLWithPage(hql, pageNo, pageSize,hql2);
		 return page;
	}
	public List searchLog(Map m){
		 String tj="";
		 String hql = "from LogBo b where b.removed=0";
		 String hql2 = "select count(*) from LogBo b where b.removed=0";
		 if(m.get("SDATE")!=null && m.get("EDATE")!=null && m.get("SDATE").toString().length()>0 && m.get("EDATE").toString().length()>0){
			 tj+="	and DATE(b.operateTime)>=DATE('"+m.get("SDATE")+"')";
			 tj+="	and DATE(b.operateTime)<=DATE('"+m.get("EDATE")+"')";
		 } 
		 hql+=tj;
		 hql2+=tj;
		 List list=logDao.findAll();
		 return list==null?new ArrayList():list;
	}
	public String [] saveByText(List list){
		String FileName=""+new Date().getYear()+new Date().getMonth()+new Date().getDate()+(new Date().getTime())+".txt";
		if(list.size()==0)appendText(BK_FILE_PATH+"\\"+FileName,"没有记录.....");
		for(int i=0;i<list.size();i++){
			LogBo lb=(LogBo)list.get(i);
			StringBuffer sb=new StringBuffer();
			sb.append("\t"+lb.getId());
			sb.append("\t"+lb.getLogData());
			sb.append("\t"+lb.getLogDate());
			sb.append("\t"+lb.getOperater());
			sb.append("\t"+lb.getOperateTime());
			sb.append("\t"+lb.getArea());
			sb.append("\t"+lb.getBaseModule().getModuleName()); 
			appendText(BK_FILE_PATH+"\\"+FileName,sb.toString());
		} 
		return new String[]{BK_FILE_PATH,FileName};
	}
	public String [] saveByExcel(List list){
		String FileName=""+new Date().getYear()+new Date().getMonth()+new Date().getDate()+(new Date().getTime())+".xls";
		try{
			OutputStream os=new  FileOutputStream(BK_FILE_PATH+"\\"+FileName);
			jxl.write.WritableWorkbook  wwb = jxl.Workbook.createWorkbook(os);
			WritableSheet ws = wwb.createSheet("sheet1", 0);//
			WritableFont wf = new WritableFont(WritableFont.TIMES, 12, WritableFont.NO_BOLD, false);
			WritableCellFormat wcfF = new WritableCellFormat(wf);
			SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
			for(int i=0;i<list.size();i++){
				LogBo lb=(LogBo)list.get(i);
				Label label0=new Label(0, i, String.valueOf(lb.getId()));
				ws.addCell(label0); 
				Label label1=new Label(1, i, lb.getLogData());
				ws.addCell(label1); 
				Label label2=new Label(2, i, formatter.format(lb.getLogDate()));
				ws.addCell(label2); 
				Label label3=new Label(3, i, lb.getOperater());
				ws.addCell(label3);
				Label label4=new Label(4, i, formatter.format(lb.getOperateTime()));
				ws.addCell(label4); 
				Label label5=new Label(5, i, String.valueOf(lb.getArea()));
				ws.addCell(label5); 
				Label label6=new Label(6, i, lb.getBaseModule().getModuleName());
				ws.addCell(label6); 
			}
			wwb.write();
			wwb.close();
			os.close(); 
			return new String[]{BK_FILE_PATH,FileName};
		}catch(Exception ex){
			return new String[]{"",""};
		} 
	}
	public String [] saveByAccess(List list){
		return new String[]{"",""};
	}
	
	/**
	 * 写入文件
	 * 
	 * @param filepath
	 */
	public static void appendText(String filepath, String appendValue) {
		try { 
			File filename = new File(filepath);
			String  str=new String(appendValue.getBytes("8859_1"),"UTF-8");
			RandomAccessFile rf = new RandomAccessFile(filename, "rw");
			rf.seek(rf.length()); 
			byte[]   ba   =   appendValue.getBytes();   
			rf.write(ba);   
			rf.writeBytes("\r\n");
			rf.close();  
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	} 

}