loginop.java

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

package edu.whut.cwts.login;

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

public class LoginOp {
	public static boolean validateLogin(String yhdm, String yhmm) {
    //先要把PDA剔除此登陆系统中，由于此系统的用户中征稽处的人员代码无9位长度的限制，因此登陆时限制要放宽，对长度不做限制
		//对PDA的剔除，可以放在客户端数字过滤处理
		boolean result = false;
		ConnectDB conndb = new ConnectDB();
		ResultSet rs = null;
		/*if (yhdm.substring(6, 7).equals("P")) {
			return result;
		} else {}*/
			String sql = "select * from yhxxb where yhdm='" + yhdm.trim()
					+ "' and yhmm='" + yhmm.trim() + "'";
			try {
				rs = conndb.executeQuery(sql);
				if (rs.next()) {
					result = true;
				} else
					result = false;
			} catch (Exception e) {
				e.printStackTrace();
			}
		
		System.out.println("the validateLogin result is" + result);
		conndb.close();
		return result;
	}

	public static String findYhxm(String yhdm) {
		ArrayList result = new ArrayList();
		ConnectDB conndb = new ConnectDB();
		String sql = "SELECT yhxm from yhxxb where yhdm='" + yhdm.trim() + "'";
		Assert.pl(sql);
		ResultSet rs = conndb.executeQuery(sql);
		if (rs == null)
			return "";
		try {
			while (rs.next()) {
				result.add(rs.getString("yhxm"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		conndb.close();
		String mc = (String) result.get(0);
		return mc;
	}

	public static String findZddm(String yhdm) {
		ArrayList result = new ArrayList();
		ConnectDB conndb = new ConnectDB();
		String sql = "SELECT zddm from yhxxb where yhdm='" + yhdm.trim() + "'";
		Assert.pl(sql);
		ResultSet rs = conndb.executeQuery(sql);
		if (rs == null)
			return "";
		try {
			while (rs.next()) {
				result.add(rs.getString("zddm"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		conndb.close();
		String mc = (String) result.get(0);
		return mc;
	}

	public static String findZdmc(String zddm) {
		ArrayList result = new ArrayList();
		ConnectDB conndb = new ConnectDB();
		String sql = "SELECT zdmc from zdxxb where zddm='" + zddm.trim() + "'";
		Assert.pl(sql);
		ResultSet rs = conndb.executeQuery(sql);
		if (rs == null)
			return "";
		try {
			while (rs.next()) {
				result.add(rs.getString("zdmc"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		conndb.close();
		String mc = (String) result.get(0);
		return mc;
	}

	public ArrayList getRoleSet(String jsjh) {
		// 根据"_"拆分开来，放入ArrayList中
		ArrayList altoken = new ArrayList();
		StringTokenizer st = new StringTokenizer(jsjh, "_");
		String s_buffer = null;
		while (st.hasMoreTokens()) {
			s_buffer = st.nextToken();
			altoken.add(s_buffer);
		}
		return altoken;
	}

	public List getRoles(String yhdm) { // 获取角色集合，返回List对象
		List rolelist = new ArrayList();
		ConnectDB conndb = new ConnectDB();
		String jsjh = "";
		String sql = "select jsjh from yhxxb where yhdm='" + yhdm + "' ";
		try {
			ResultSet rs = conndb.executeQuery(sql);
			if(rs.next())
			{jsjh = rs.getString("jsjh");}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		rolelist = getRoleSet(jsjh);
		conndb.close();
		return rolelist;
	}

	public String getPowers(List rolelist) {// 获取权限集合，返回List对象
		List powerlist = new ArrayList();
		List powerlist1 = new ArrayList();
		String jsdm = "";
		String qxjh = "";
		
		int i = 0;
		for (int j = 0; j < rolelist.size(); j++) {
			jsdm = (String) rolelist.get(j);
			ConnectDB conndb = new ConnectDB();
			powerlist1.clear();
			String sql = "select qxjh from jsb where jsdm= '" + jsdm + "'";
			try {
				ResultSet rs = conndb.executeQuery(sql);
				if(rs.next())
				{qxjh = rs.getString("qxjh");}
				System.out.println(qxjh);
				powerlist1 = 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();
			}
			conndb.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 String formZddm(String zddm){
		if(zddm.substring(0,1).equals("0"))zddm="000000";
		return zddm;
	}

	public static int getLogicLevel(String zddm){
		int departmentlogicLevel=0;
		zddm=formZddm(zddm);
		
		  if(zddm.equals("000000"))
          {
			//System.out.println("征稽处");
			departmentlogicLevel=0;
		   }
		  else if(zddm.equals(" "))
          {
			//System.out.println("用户个人");
			departmentlogicLevel=9;
		   }
				  
		  

		
	      else if(zddm.equals("100000"))
		  {
			//System.out.println("征稽处征收科");
	    	 departmentlogicLevel=3;
		   }
		
		  else if(zddm.substring(2).equals("0000")){
			departmentlogicLevel=1;//中心站或直属站
		   }
        
		
		
		  else if(zddm.substring(2,4).equals("00")){
			if(!zddm.substring(4,6).equals("00"))departmentlogicLevel=3;//征稽点或征稽分站
			
		   }
		
		  else if(!zddm.substring(2,4).equals("00") && zddm.substring(4,6).equals("00") ){
			if(zddm.substring(2,4).equals("01"))departmentlogicLevel=3;//中心站或直属站征收科
			else departmentlogicLevel=2;//征稽站
			
		   }
		
		  else if(!zddm.substring(2,4).equals("00") && zddm.substring(4,6).equals("01")){
			departmentlogicLevel=3;//征稽站直征点
			
		   }
		
		  else if(!zddm.substring(2,4).equals("00") && !zddm.substring(4,6).equals("00") && !zddm.substring(4,6).equals("01")){
			if(!zddm.substring(2,4).equals("01"))departmentlogicLevel=3;//征稽点
		   }

	
		return departmentlogicLevel;
	}
}