docservice.java

基于hibernate + struts框架 采用mssql数据库,因容量原因,把lib删去了. 由于这是我第一个作品,有很多地方需要改进. 希望大家多提意见. qq: 258268936

package com.hdlb.service;

import java.util.Date;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.QueryException;

import com.hdlb.dao.IDoc;
import com.hdlb.factory.DAOFactory;
import com.hdlb.hibernate.TDoc;
import com.hdlb.util.TimeFactory;

public class DocService implements IDocService {

	public List getDoc(String factor, String content) {
		// TODO Auto-generated method stub
		System.out.println("content: " + content);
		IDoc operator = DAOFactory.getDocDAO();
		List list = null;
		try {
			if ("标题".equals(factor)) {

				Query q = operator
						.createQuery("select doc from TDoc doc where doc.fdocname=?");
				q.setString(0, content);
				list = q.list();

			} else if ("文号".equals(factor)) {
				Query q = operator
						.createQuery("select doc from TDoc doc where doc.fdoczihao=?");
				q.setString(0, content);
				list = q.list();
			} else if ("时间".equals(factor)) {
				Query q = operator
						.createQuery("select doc from TDoc doc where doc.fsendtime=?");
				q.setString(0, content);
				list = q.list();
			} else if ("文种".equals(factor)) {
				Query q = operator
						.createQuery("select doc from TDoc doc where doc.ftype=?");
				q.setString(0, content);
				list = q.list();
			} else if ("关键词".equals(factor)) {
				String sql = "select doc from TDoc doc where doc.fdocname like ?";
				Query q = operator.createQuery(sql);
				q.setString(0, "%" + content + "%");
				System.out.println(sql);
				list = q.list();
			}
		} catch (QueryException e) {
			e.printStackTrace();
		}
		return list;
	}

	public List getDocByType(String type) {
		System.out.println("in DocService getDocByType method");
		IDoc operator = DAOFactory.getDocDAO();
		List list = null;
		try {
			Query q = operator
					.createQuery("select doc from TDoc doc where doc.ftype=?");
			System.out.println(type);
			q.setString(0, type);
			list = q.list();
			// return list;
		} catch (Exception e) {
			e.printStackTrace();

		}
		return list;
	}

	public int getNumByType(String type, boolean b) {
		// TODO Auto-generated method stub
		IDoc operator = DAOFactory.getDocDAO();
		String state = "";
		if (b) {
			state = "已完成";
		} else {
			state = "未完成";
		}
		String queryString = "select count(doc) from TDoc doc where doc.ftype=? and doc.fstate=?";
		Query q = operator.createQuery(queryString);
		q.setString(0, type);
		q.setString(1, state);
		return ((Integer) q.iterate().next()).intValue();

	}

	public int getNumById(int id, boolean b) {
		IDoc operator = DAOFactory.getDocDAO();
		String state = "";
		if (b) {
			state = "已完成";
		} else {
			state = "未完成";
		}
		String queryString = "select count(doc) from TDoc doc where doc.fid=? and doc.fstate=?";
		Query q = operator.createQuery(queryString);
		q.setInteger(0, id);
		q.setString(1, state);
		return ((Integer) q.iterate().next()).intValue();
	}

	public List getUrgentDoc() {
		IDoc operator = DAOFactory.getDocDAO();
		// 取得当前时间
		String stringBefore2Now = TimeFactory.getNDayBeforeCurrentDate(2);
		System.out.println("stringBefore3Now:" + stringBefore2Now);
		Date dateBefore3Now = TimeFactory.switchStringToDate(stringBefore2Now);

		String queryString = "select doc from TDoc doc where doc.fsendtime<? order by doc.fsendtime"; 
		Query q = operator.createQuery(queryString);
		q.setDate(0,dateBefore3Now);

		System.out.println("sql语句:" + queryString);
		return q.list();
	}

	public List getMonitorDoc() {
		IDoc operator = DAOFactory.getDocDAO();
		String stringAfter2Now = TimeFactory.getNDayAfterCurrentDate(2);
		Date dateAfter3Now = TimeFactory.switchStringToDate(stringAfter2Now);
		String queryString = "select doc from TDoc doc where doc.fsendtime>? order by doc.fsendtime";
		Query q = operator.createQuery(queryString);
		q.setDate(0,dateAfter3Now);
		
		return q.list();
	}

}