datadictionarydaoimpl.java

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

package com.jn0801.datadictionary;

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

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import org.springframework.orm.hibernate3.HibernateTemplate;
import org.springframework.orm.hibernate3.HibernateTransactionManager;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import org.springframework.transaction.interceptor.TransactionProxyFactoryBean;
import org.springframework.transaction.support.DefaultTransactionDefinition;

import com.jn0801.tools.DBConnection;

public class DataDictionaryDaoImpl extends HibernateDaoSupport implements
		DataDictionaryDao {
	/** 
	 * 此方法根据条件列出数据
	 * 
	 * @param sname
	 * @param npid
	 * @return
	 */
	public List listData(long npid) {
		List<DataDictionary> dataList = new ArrayList<DataDictionary>();
		String hql = "select data from DataDictionary data where 1=1";
		if (npid != -1) {
			hql = hql + " and npid=" + npid;
		}
		dataList = this.getHibernateTemplate().find(hql);
		return dataList;
	}

	/**
	 * 此方法根据条件列出数据
	 * 
	 * @param sname
	 * @return
	 */
	public List listData(String sname) {
		List dataList = new ArrayList();
		Connection connection = null;
		Statement statement = null;
		ResultSet resultSet = null;
		String sql = "";
		try {
			connection = DBConnection.getConnection();
			statement = connection.createStatement();
			sql = "select b.sname from datadictionary a,datadictionary b where a.nid=b.npid and a.sname='"
					+ sname + "'";
			resultSet = statement.executeQuery(sql);
			while(resultSet.next()){
				Map map = new HashMap();
				map.put("sname", resultSet.getObject(1));
				dataList.add(map);
			}
		} catch (Exception e) {
			// TODO: handle exception
		} finally {
			DBConnection.close(resultSet, null, statement, connection);
		}
		return dataList;
	}

	/**
	 * 此方法保存一条数据
	 * 
	 * @param dataDictionary
	 * @return
	 */
	public boolean saveData(DataDictionary dataDictionary) {
		boolean flag = false;

		return flag;
	}

	/**
	 * 此方法删除一条数据
	 * 
	 * @param sname
	 * @return
	 */
	public boolean deleteData(String sname) {
		boolean flag = false;

		return flag;
	}

	/**
	 * 此方法更新一条数据
	 * 
	 * @param dataDictionary
	 * @return
	 */
	public boolean updataData(DataDictionary dataDictionary) {
		boolean flag = false;

		return flag;
	}
}