businessgradeimp.java

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

package com.jn0801.clubmanage.dao;

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

import com.jn0801.clubmanage.dto.BusinessGradeBean;
import com.jn0801.clubmanage.dto.MassLevel;
import com.jn0801.tools.DBConnection;

/**
 * 联盟商家质量级别评定的实现类
 * 
 * @author jzh
 * 
 */
public class BusinessGradeImp implements
		BusinessGradeInf {

	/**
	 * 查询所有联盟商家质量级别评定
	 * 
	 * @param orderby
	 *            排序的依据
	 * @return 所有联盟商家质量级别评定的集合类
	 */
	public List<BusinessGradeBean> listBusinessGrade(String orderby) {

		List<BusinessGradeBean> list = new ArrayList<BusinessGradeBean>();

		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;

		String sql = "";
		sql = sql + "select a.nid as nid,bsname,"
				+ "nvl(bslevel,0) as bslevel,nvl(sname,'未评价') as levelname ";
		sql = sql + "from businessbasicinfotable a ";
		sql = sql + "left outer join  masslevel b ";
		sql = sql + "on a.bslevel = b.nid ";

		if (orderby.equals("bslevel1")) {
			sql = sql + "where bslevel > 0 ";
			sql = sql + "order by bslevel";
		} else if (orderby.equals("bslevel0")) {
			sql = sql + "where nvl(bslevel,0) = 0 ";
			sql = sql + "order by nid";
		} else {
			sql = sql + "order by nid";
		}

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

			while (rs.next()) {

				BusinessGradeBean bgb = new BusinessGradeBean();
				bgb.setNid(rs.getLong("nid"));
				bgb.setBsname(rs.getString("bsname"));
				bgb.setBslevel(rs.getLong("bslevel"));
				bgb.setLevelname(rs.getString("levelname"));

				list.add(bgb);

			}

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				if (rs != null)
					rs.close();
				if (stmt != null)
					stmt.close();
				if (conn != null)
					conn.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return list;
	}

	/**
	 * 根据商家编号查询联盟商家
	 * 
	 * @param nid
	 *            商家编号
	 * @return 联盟商家
	 */
	public BusinessGradeBean searchBusInfoById(Long nid) {

		BusinessGradeBean bgb = null;
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		String sql = "select * from businessbasicinfotable where nid =" + nid;
		
		try {
			conn = DBConnection.getConnection();
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
			
			while(rs.next()){
				bgb = new BusinessGradeBean();
				bgb.setNid(rs.getLong("nid"));
				bgb.setBsname(rs.getString("bsName"));
				bgb.setPartnertype(rs.getString("partnerType"));
				bgb.setBsaddress(rs.getString("bsAddress"));
				bgb.setBslevel(rs.getLong("bsLevel"));
			}
			
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			try {
				if (rs != null)
					rs.close();
				if (stmt != null)
					stmt.close();
				if (conn != null)
					conn.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		

		return bgb;
	}

	/**
	 * 查找所有联盟商家质量级别表
	 * @return 联盟商家质量级别表的集合类
	 */
	public List<MassLevel> listMassLevel() {
		
		List<MassLevel> list = new ArrayList<MassLevel>();
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		String sql = "select * from masslevel";
		
		try {
			
			conn = DBConnection.getConnection();
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
			
			while(rs.next()){
				MassLevel masslevel = new MassLevel();
				masslevel.setNid(rs.getLong("nid"));
				masslevel.setSname(rs.getString("sname"));
				list.add(masslevel);
			}
			
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			try {
				if (rs != null)
					rs.close();
				if (stmt != null)
					stmt.close();
				if (conn != null)
					conn.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		
		return list;
	}

	/**
	 * 评定联盟商家质量等级
	 * @param nid 商家编号
	 * @param bslevel 质量等级
	 * @return 是否成功
	 */
	public boolean updateBusGrade(Long nid, Long bslevel) {
		
		boolean tag = false;
		
		Connection conn = null;
		Statement stmt = null;
		int i= 0;
		String sql = "update businessbasicinfotable set bslevel =" +bslevel + " where nid =" +nid;
		
		try {
			conn = DBConnection.getConnection();
			stmt = conn.createStatement();
			i = stmt.executeUpdate(sql);
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			try {
				if (stmt != null)
					stmt.close();
				if (conn != null)
					conn.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		
		if(i>0)
			tag = true;
		
		return tag;
	}
}