powerdao.java

文件的上传和下载的实现,用JAva编写,非常简单

/** 
* Copyright 2007 Wuhan University of Technology. 
* All right reserved. 
* Create on 2007-4-6
*/ 

package edu.whut.cwts.maintain.action;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import edu.whut.cwts.datasource.DBConnect;

/**
 * @author dwr
 *
 */
public class PowerDAO {

	/**
	 * @param args
	 */
	public List getRoles(String yhdm)
	{
		List rolelist = new ArrayList();
		DBConnect dbconn=new DBConnect();
		UserDAO userDAO = new UserDAO();
		String jsjh="";
		String sql = "select jsjh from yhxxb where yhdm='"+ yhdm.trim() +"' ";
		try
		{
			ResultSet rs = dbconn.executeQuery(sql);
			if(rs.next())
			jsjh=rs.getString("jsjh");
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
			 dbconn.close();
			rolelist = userDAO.getRoleSet(jsjh);
		return rolelist;
	}
		
	public String getPowers(List rolelist)
	{
		List powerlist = new ArrayList();
		List powerlist1 = new ArrayList();
		String jsdm="";
		String qxjh="";
		int i=0;
		UserDAO userDAO = new UserDAO();
		for(int j=0;j<rolelist.size();j++){
			jsdm=(String) rolelist.get(j);
		DBConnect dbconn=new DBConnect();
		powerlist1.clear();
		String sql = "select qxjh from jsb where jsdm= '"+ jsdm.trim() +"'";
		try
		{
			ResultSet rs = dbconn.executeQuery(sql);
			if(rs.next())
			qxjh=rs.getString("qxjh");
			System.out.println(qxjh);
			powerlist1=userDAO.getRoleSet(qxjh);
			for(int m=0;m<powerlist1.size();m++){
				//System.out.println(powerlist1.get(m));
				powerlist.add(i,powerlist1.get(m));
				i++;
				}
			
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
			dbconn.close();
		}		
			for(int n=0;n<powerlist.size();n++){
				for(int x=n+1;x<powerlist.size();x++){
					if(powerlist.get(x).equals(powerlist.get(n)))
						powerlist.remove(x);
			    }
		    }
		String powers="_";
	    for(int p=0;p<powerlist.size();p++){
		   powers=powers+powerlist.get(p)+"_";}
	    return powers;
	}
	
	public static void main(String[] args) {
		// TODO 自动生成方法存根
    String yhdm="1";
    PowerDAO powerDAO=new PowerDAO();
    List rolelist=new ArrayList();
    String powers="";
    rolelist=powerDAO.getRoles(yhdm);
    for(int i=0;i<rolelist.size();i++){
    	System.out.print(rolelist.get(i)+",");}
    System.out.println("\n");
    powers=powerDAO.getPowers(rolelist);
    System.out.println("\n");    
    System.out.print(powers);
	}

}