pzmcctrl.java

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

package edu.whut.cwts.pg.fafang;

import edu.whut.cwts.pg.db.*;

import java.util.*;
import java.sql.*;

public class PzmcCtrl {
	
	//添加票种，返回1表示操作成功
	public int add(Pzmc pz)throws SQLException
	{
		ConnectDB conn=new ConnectDB();
		String sql="insert into pzmc(pzzl,pzmc) values('"+pz.getPzzl()+"','"+pz.getPzmc()+"')";
		int flag=conn.executeUpdate(sql);
		conn.close();
		return flag;	
	}
	
	//修改票证种类
	public int Update(Pzmc pz)throws SQLException
	{
		ConnectDB conn=new ConnectDB();
		String sql="update Pzmc set pzmc='"+pz.getPzmc()+"'where pzzl='"+pz.getPzzl()+"'";
		int flag=conn.executeUpdate(sql);
		conn.close();
		return flag;	
	}
	
	public int remove(Pzmc pz)throws SQLException
	{
		ConnectDB conn=new ConnectDB();
		String sql="delete from pzmc where pzzl='"+pz.getPzzl()+"'";
		int flag=conn.executeUpdate(sql);
		conn.close();
		return flag;
	}
	
	//获取所有票证
	public static ArrayList getAllPz()throws SQLException
	{
		ConnectDB conn=new ConnectDB();
		String sql="select * from pzmc";
		conn.executeQuery(sql);
		ArrayList result=new ArrayList();
		ResultSet rs=conn.executeQuery(sql);
		while(rs.next())
		{
			result.add(new Pzmc(rs.getString("pzzl"),rs.getString("pzmc")));
		}
		return result;
	}
	
	public static ArrayList getEndPermittedPz(String yhdm)throws SQLException
	{
		ArrayList pzlx=new ArrayList();
		String flag=yhdm.substring(6,7);
		if(flag.equalsIgnoreCase("p"))
		{
			ConnectDB conn=new ConnectDB();
			System.out.println(flag);
			String sql="select * from pzmc where pzzl='4'";
			conn.executeQuery(sql);
			ResultSet rs=conn.executeQuery(sql);
			while(rs.next())
			{
				pzlx.add(new Pzmc(rs.getString("pzzl"),rs.getString("pzmc")));
			}
		}
		else
		{
			System.out.println(yhdm.substring(0,6));
			System.out.println("fsafjds");
			pzlx=getEndPermittedPzy(yhdm.substring(0,6));
		}
		return pzlx;
			
	}
	//获得此站点可以获得的票据列表
	public static ArrayList getPermittedPz(String zddm)throws SQLException
	{
		ArrayList pzlx=new ArrayList();
		
		if(DepartmentCtrl.getLevel(zddm).equals("1")||DepartmentCtrl.getLevel(zddm).equals("5"))
		{
			ConnectDB conn=new ConnectDB();
			String sql="select * from pzmc where pzzl='1' or pzzl='2' or pzzl='3' or pzzl='5' or pzzl='6'";
			conn.executeQuery(sql);
			ResultSet rs=conn.executeQuery(sql);
			while(rs.next())
			{
				pzlx.add(new Pzmc(rs.getString("pzzl"),rs.getString("pzmc")));
			}
		}
		
		if(DepartmentCtrl.getLevel(zddm).equals("2"))
		{
		 ConnectDB conn=new ConnectDB();
		 String sql="select * from pzmc";
		 conn.executeQuery(sql);
		 ArrayList result=new ArrayList();
		 ResultSet rs=conn.executeQuery(sql);
		 while(rs.next())
		  {
			result.add(new Pzmc(rs.getString("pzzl"),rs.getString("pzmc")));
		  }
		 return result;
		}
		
		if((DepartmentCtrl.getLevel(zddm).equals("4"))||(DepartmentCtrl.getLevel(zddm).equals("6")))
		   {
			ConnectDB conn=new ConnectDB();
			String sql="select * from pzmc where pzzl='1' or pzzl='2' or pzzl='4'";
			conn.executeQuery(sql);
			ResultSet rs=conn.executeQuery(sql);
			while(rs.next())
			{
				pzlx.add(new Pzmc(rs.getString("pzzl"),rs.getString("pzmc")));
			}
		   }
		if((DepartmentCtrl.getLevel(zddm).equals("7")))
		{
			ConnectDB conn=new ConnectDB();
			String sql="select * from pzmc where pzzl='1' or pzzl='2' or pzzl='3' or pzzl='5'";
			conn.executeQuery(sql);
			ResultSet rs=conn.executeQuery(sql);
			while(rs.next())
			{
				pzlx.add(new Pzmc(rs.getString("pzzl"),rs.getString("pzmc")));
			}
		}
		if(DepartmentCtrl.getLevel(zddm).equals("3"))
		{
			ConnectDB conn=new ConnectDB();
			String sql="select * from pzmc where pzzl='1' or pzzl='2' or pzzl='3' or pzzl='4' or pzzl='5'";
			conn.executeQuery(sql);
			ResultSet rs=conn.executeQuery(sql);
			while(rs.next())
			{
				pzlx.add(new Pzmc(rs.getString("pzzl"),rs.getString("pzmc")));
			}
		}
		return pzlx;
	}
	
//	获得此站点可以获得的票据列表
	public static ArrayList getEndPermittedPzy(String zddm)throws SQLException
	{
		ArrayList pzlx=new ArrayList();
		
		if(DepartmentCtrl.getLevel(zddm).equals("1")||DepartmentCtrl.getLevel(zddm).equals("5"))
		{
			ConnectDB conn=new ConnectDB();
			String sql="select * from pzmc where pzzl='1' or pzzl='2' or pzzl='3' or pzzl='5' or pzzl='6'";
			conn.executeQuery(sql);
			ResultSet rs=conn.executeQuery(sql);
			while(rs.next())
			{
				pzlx.add(new Pzmc(rs.getString("pzzl"),rs.getString("pzmc")));
			}
		}
		
		if(DepartmentCtrl.getLevel(zddm).equals("2"))
			{
			ConnectDB conn=new ConnectDB();
			String sql="select * from pzmc";
			conn.executeQuery(sql);
			ResultSet rs=conn.executeQuery(sql);
			while(rs.next())
			{
				pzlx.add(new Pzmc(rs.getString("pzzl"),rs.getString("pzmc")));
			}
			return pzlx;
			}
		if((DepartmentCtrl.getLevel(zddm).equals("4"))||(DepartmentCtrl.getLevel(zddm).equals("6")))
		   {
			ConnectDB conn=new ConnectDB();
			String sql="select * from pzmc where pzzl='1' or pzzl='2' or pzzl='3'";
			conn.executeQuery(sql);
			ResultSet rs=conn.executeQuery(sql);
			while(rs.next())
			{
				pzlx.add(new Pzmc(rs.getString("pzzl"),rs.getString("pzmc")));
			}
		   }
		if(DepartmentCtrl.getLevel(zddm).equals("7"))
		{
			ConnectDB conn=new ConnectDB();
			String sql="select * from pzmc where pzzl='1' or pzzl='2' or pzzl='3' or pzzl='5'";
			conn.executeQuery(sql);
			ResultSet rs=conn.executeQuery(sql);
			while(rs.next())
			{
				pzlx.add(new Pzmc(rs.getString("pzzl"),rs.getString("pzmc")));
			}
		}
		if(DepartmentCtrl.getLevel(zddm).equals("3"))
		{
			ConnectDB conn=new ConnectDB();
			String sql="select * from pzmc where pzzl='1' or pzzl='2' or pzzl='3' or pzzl='4' or pzzl='5'";
			conn.executeQuery(sql);
			ResultSet rs=conn.executeQuery(sql);
			while(rs.next())
			{
				pzlx.add(new Pzmc(rs.getString("pzzl"),rs.getString("pzmc")));
			}
		}
		return pzlx;
	}
	
	public static void main(String args[])
	{
		try{
		getEndPermittedPz("123456123");
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
}