audlogimp.java

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

package com.jn0801.grademanage;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.jn0801.tools.DBConnection;

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

/**
 * 
 * 客户分级手动审核 的实现类
 * 
 * @author ypy
 * 
 */
public class AudLogImp extends HibernateDaoSupport implements AudLogIFC {

	/**
	 * 添加审核日志
	 * 
	 * @param audUserLog
	 *            审核日志的持久类；
	 * @return 添加是否成功，返回 true 添加成功，返回 false 添加失败；
	 */
	public boolean addAudLog(Auditinguserlog audUserLog) {
		// TODO 自动生成方法存根
		boolean flag = false;
		try {
			this.getHibernateTemplate().save(audUserLog);
			flag = true;
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
			flag = false;
		}
		return flag;
	}

	/**
	 * 根据 操作人 查询日志
	 * 
	 * @param sname
	 *            操作人的名字
	 * @return 查询到的结果集
	 */
	public List searchAudLogByName(String sname) {
		// TODO 自动生成方法存根
		List list = new ArrayList();
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;

		StringBuffer sql = new StringBuffer();
		sql.append("select * from auditinguserlog where 1=1");
		if (sname != null) {
			sql.append(" and auduser='" + sname + "'");// 传入 审核人 查找他所操做过的日志
		}

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

			while (rs.next()) {
				Auditinguserlog audUserLog = new Auditinguserlog();
				audUserLog.setNid(rs.getLong("nid"));
				audUserLog.setUserid(rs.getLong("userid"));
				audUserLog.setBeauduser(rs.getString("beauduser"));
				audUserLog.setAuduser(rs.getString("auduser"));
				audUserLog.setAudtime(rs.getString("audtime"));
				list.add(audUserLog);
			}
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
		return list;
	}

}