logimp.java

自己制作的联通CRM,支持客户分类,管理,升级,积分管理等等..

package com.jn0801.company;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.jn0801.company.dao.LinkmanLogBean;
import com.jn0801.tools.DBConnection;
import com.jn0801.tools.PageDAO;

public class LogIMP extends HibernateDaoSupport implements LogIFC {

	/**
	 * 查询集团联系人信息日志
	 * 
	 * @param log
	 * @param request
	 * @return 返回查询到的結果集
	 */
	public List searchLog(LinkmanLogBean log, HttpServletRequest request) {

		int count = 0;
		PageDAO pageDAO = new PageDAO(request);
		pageDAO.setPagesize(20);
		count = getCount(log);// 获取总记录数
		pageDAO.setRscount(count);
		int currentPage = pageDAO.getCurrentPage();
		int pagecount = pageDAO.getPageCount();// 获取一共有多少页
		int pageSize = pageDAO.getPagesize();// 获取每页显示多少条记录
		int maxResult = currentPage * pageSize;// 获取结束行
		String pageTool = pageDAO.pagetool(PageDAO.BbsText);// 构建工具条
		request.setAttribute("pageTool", pageTool);

		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		List list = new ArrayList();
		StringBuffer sql = new StringBuffer();
		sql.append("select * from COMPANYLINKMANLOG where 1=1");
		if (log.getNid() != 0) {
			sql.append(" and nid=" + log.getNid());
		}
		if (log.getOperatetype() != null && !log.getOperatetype().equals("")) {
			sql
					.append(" and operatetype like '%" + log.getOperatetype()
							+ "%'");
		}
		if (log.getOptionuser() != null && !log.getOptionuser().equals("")) {
			sql.append(" and optionuser like '%" + log.getOptionuser() + "%'");
		}
		if (log.getOptiondate() != null && !log.getOptiondate().equals("")) {
			sql.append(" and optiondate like '%" + log.getOptiondate() + "%'");
		}

		try {
			conn = DBConnection.getConnection();
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql.toString());

			while (rs.next()) {
				LinkmanLogBean bean = new LinkmanLogBean();
				bean.setNid(rs.getLong("nid"));
				bean.setOperatetype(rs.getString("operatetype"));
				bean.setOptionuser(rs.getString("optionuser"));
				bean.setOptiondate(rs.getString("optiondate"));
				list.add(bean);
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		return list;
	}

	private int getCount(LinkmanLogBean log) {
		int i = 0;
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		StringBuffer sql = new StringBuffer();
		sql.append("select count(nid) from companylinkmaninfo where 1=1");
		if (log.getNid() != 0) {
			sql.append(" and nid=" + log.getNid());
		}
		if (log.getOperatetype() != null && !log.getOperatetype().equals("")) {
			sql
					.append(" and operatetype like '%" + log.getOperatetype()
							+ "%'");
		}
		if (log.getOptionuser() != null && !log.getOptionuser().equals("")) {
			sql.append(" and optionuser like '%" + log.getOptionuser() + "%'");
		}
		if (log.getOptiondate() != null && !log.getOptiondate().equals("")) {
			sql.append(" and optiondate like '%" + log.getOptiondate() + "%'");
		}
		try {
			conn = DBConnection.getConnection();
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql.toString());
			if (rs.next()) {
				i = rs.getInt(1);
			}

		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		} finally {
			DBConnection.close(rs, null, stmt, conn);
		}
		return i;
	}

}