intergralrequisitiondaoimpl.java

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

package com.jn0801.intergral.requisition;

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

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

import com.jn0801.common.UserInfo;
import com.jn0801.tools.DBConnection;

public class IntergralRequisitionDaoImpl extends HibernateDaoSupport implements
		IntergralRequisitionDao {

	/**
	 * 此方法根据号码返回用户信息
	 * 
	 * @param phone
	 * @return
	 */
	public UserInfo showUserInfo(String phone) {
		UserInfo userInfo = null;
		String hql = "select userinfo from UserInfo userinfo where userinfo.phone='"
				+ phone + "'";
		List list = this.getHibernateTemplate().find(hql);
		if (list.size() != 0) {
			userInfo = (UserInfo) list.get(0);
		}
		return userInfo;
	}

	/**
	 * 此方法通过用户积分申请
	 * 
	 * @param phone
	 */
	public void acceptRequisition(String phone) {
		Connection connection = null;
		Statement statement = null;
		String sql = "";
		try {
			connection = DBConnection.getConnection();
			statement = connection.createStatement();
			sql = "update userinfo set integralsign='1' where phone='" + phone
					+ "'";
			statement.executeUpdate(sql);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DBConnection.close(null, null, statement, connection);
		}
	}
}