logincrmemproledao.java

基于SSH (struts+spring+hibernate)框架设计的 CRM客户关系管理系统

package com.csu.crm.login.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Iterator;
import java.util.List;

import org.springframework.context.ApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.csu.crm.common.vo.CrmRight;
import com.csu.crm.login.ConnectionHelper;


public class LoginCrmEmpRoleDAO extends HibernateDaoSupport{
	private JdbcTemplate jdbcTemplate;
	
	public JdbcTemplate getJdbcTemplate() {
		return jdbcTemplate;
	}

	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}

	public List findbyid(String id){
		List list = null;
			Connection conn = ConnectionHelper.getConnection();
			PreparedStatement ps = null;
			ResultSet rs = null;
			System.out.println("end1");
			
			try{
				String select = "select distinct g.right_id  from CRM_ROLE_RIGHT g " +
					"where g.role_id in(select e.role_id from " +
					"CRM_EMP_ROLE e where e.employee_id=?)";
				ps = conn.prepareStatement(select);
				ps.setString(1,id);
				rs = ps.executeQuery();
				System.out.println("end2");
				while(rs.next()){
					System.out.println("end3");
					String rightId = rs.getString("RIGHT_ID");
					List list1 = getHibernateTemplate().find("from CrmRight as crmright where crmright.rightId='"+rightId+"'");
					System.out.println("end4");
					Iterator it = list1.iterator();
					System.out.println("end5");
					while(it.hasNext()){
						System.out.println("end7");
						CrmRight crmRight = (CrmRight)it.next();
						list.add(crmRight);
						System.out.println("end6");
					}
				}
				
			}catch(Exception ex){
				ex.printStackTrace();
			}finally{
				ConnectionHelper.closeConnection(rs, ps, conn);
			}
			
			System.out.println("end");
			
		return list;
	}
	public static LoginCrmEmpRoleDAO getFromApplicationContext(
			ApplicationContext ctx) {
		return (LoginCrmEmpRoleDAO) ctx.getBean("LoginCrmEmpRoleDAO");
	}
}