searchsubdepartment.java

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

/** 
* Copyright 2007 Wuhan University of Technology. 
* All right reserved. 
* Create on 2007-1-10
*/ 

package edu.whut.cwts.maintain.action;

/**
 * @author Zhulili
 *
 */

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import edu.whut.cwts.datasource.DBConnect;

public class SearchSubdepartment {

	/**
	 * @param args
	 * @throws SQLException 
	 */
	public ArrayList getZjz(String zddm) throws SQLException{
		
		String center=zddm.substring(0,2);
		
		String sql="select zdmc from zdxxb where (zddm like '"+center+"%00' or zddm like '"+center+"00%') and zddm<>'"+center+"0000' ";
				 
		 DBConnect dbconn=new DBConnect();
		 			
		 ResultSet rs=dbconn.executeQuery(sql);
		//System.out.println("test");
		ArrayList zjz=new ArrayList();
		while (rs.next()){
			zjz.add(rs.getString("zdmc"));
		}
		return zjz;
	
		
	}
	
	public ArrayList getZjd(String zdmc) throws SQLException{
		String sqlzjd="";
		String sqlzddm="select zddm from zdxxb where zdmc='"+zdmc.trim()+"'";
		System.out.println(sqlzddm);
		 DBConnect dbconn=new DBConnect();
		 ArrayList zjd=new ArrayList();	
		 ResultSet rs=dbconn.executeQuery(sqlzddm);
		 while (rs.next()){
				String zddm=rs.getString("zddm");
				String zjdzm=zddm.substring(0,4);
				sqlzjd="select *from zdxxb where zddm like '"+zjdzm+"%' and zddm<>"+zddm+"";
				System.out.println(sqlzjd);
				DBConnect dbconn2=new DBConnect();
					
				ResultSet rs2=dbconn2.executeQuery(sqlzjd);
				System.out.println("test");
				
				while (rs2.next()){
					zjd.add(rs2.getString("zdmc"));
				}
				System.out.println(zjdzm);
				
			}
		 return zjd;
	}
	public String getZdmc(String zddm) throws SQLException{
		String sql="select zdmc from zdxxb where zddm='"+zddm+"'";
		DBConnect dbconn2=new DBConnect();
		String zdmc="";
		ResultSet rs2=dbconn2.executeQuery(sql);
		System.out.println("test");
		
		while (rs2.next()){
			zdmc=rs2.getString("zdmc");
		}
		return zdmc;
	}
	public String getZddm(String zdmc) throws SQLException{
		String sql="select zddm from zdxxb where zdmc='"+zdmc+"'";
		DBConnect dbconn2=new DBConnect();
		String zddm="";
		ResultSet rs2=dbconn2.executeQuery(sql);
		System.out.println("test");
		
		while (rs2.next()){
			zddm=rs2.getString("zddm");
		}
		return zddm;
	}
	public int departmentupdate(String zddm,String zdmc){
		String sql="update zdxxb set zdmc='"+zdmc+"' where zddm='"+zddm+"'";
		System.out.println(sql);
		DBConnect dbconn2=new DBConnect();
		int flag=0;
		try {
			flag = dbconn2.executeUpdate(sql);
			
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		//System.out.println(flag);
		return flag;
		
		
	}
	
	public boolean departmentdelete(String zddm){
		String sql="delete zdxxb where zddm='"+zddm+"'";
		System.out.println(sql);
		DBConnect dbconn2=new DBConnect();
		boolean flag=true;
		flag = dbconn2.executeDelete(sql);
		//System.out.println(flag);
		return flag;
		
		
	}
	public String departmentzddmCal(String level,String zddm){
		String sqlselect="";
		String newzddm="";
		if(level.trim().equals("1")){
			sqlselect="select cast(isnull(max(zddm),'100000') as int)+10000  from zdxxb where zddm like '1%0000' and zddm<>'100000'  ";
		   // System.out.println(sqlselect);	
		    //System.out.println("cccccccccccc");
		}
		else if(level.trim().equals("2")){
			sqlselect="select cast(isnull(max(zddm),'200000') as int)+10000 from zdxxb where zddm like '2%0000' and zddm<>'100000'  ";
			
		}
        else if(level.trim().equals("3")){
        	String center=zddm.substring(0,2);
        	sqlselect="select cast(isnull(max(zddm),'"+center+"0000') as int)+100 from zdxxb where zddm like '"+center+"%00' and zddm<>'"+center+"0000' ";
		}
        else if(level.trim().equals("4")){
			String station="";
			try {
				station = this.getZddm(zddm).substring(0,4);
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
			sqlselect="select cast(isnull(max(zddm),'"+station+"00') as int)+1 from zdxxb where zddm like '"+station+"%' and zddm<>'"+station+"00' ";
		}
        else if(level.trim().equals("5")){
			String center2=zddm.substring(0,2);
			sqlselect="select cast(isnull(max(zddm),'"+center2+"0000') as int)+1 from zdxxb where zddm like '"+center2+"00%' and zddm<>'"+center2+"0000'";
		}
		DBConnect dbconn=new DBConnect();
		
		ResultSet rs;
		try {
			rs=dbconn.executeQuery(sqlselect);
			while (rs.next()){
				newzddm=rs.getString(1);
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		
		
			
		
		
		return newzddm;
		
	}
	public boolean departmentinsert(String zdmc,String level,String zddm){
		
		String sqlinsert="";
		String sqlinsert2="";
		
		boolean flag1=true;
		boolean flag2=true;
		
		if(level.trim().equals("1")){//中心站
			String newzddm=this.departmentzddmCal(level,zddm);
			String zsd=newzddm.substring(0,2)+"01"+"00";//征收科
		
			sqlinsert="insert into zdxxb(zddm,zdmc) values('"+newzddm+"','"+zdmc+"') ";
			sqlinsert2="insert into zdxxb(zddm,zdmc) values('"+zsd+"','"+zdmc+"征收科')";
		}
		else if(level.trim().equals("2")){//直征点
			String newzddm=this.departmentzddmCal(level,zddm);
			String zzd=newzddm.substring(0,2)+"01"+"00";//直征点
			
			sqlinsert="insert into zdxxb(zddm,zdmc) values('"+newzddm+"','"+zdmc+"') ";
			sqlinsert2="insert into zdxxb(zddm,zdmc) values('"+zzd+"','"+zdmc+"直征点')";
		}
        else if(level.trim().equals("3")){
        	String newzddm=this.departmentzddmCal(level,zddm);
        	String zzd=newzddm.substring(0,4)+"01";//直征点
			
			sqlinsert="insert into zdxxb(zddm,zdmc) values('"+newzddm+"','"+zdmc+"') ";
			sqlinsert2="insert into zdxxb(zddm,zdmc) values('"+zzd+"','"+zdmc+"直征点')";
		}
        else if(level.trim().equals("4")){//征稽点
        			
			sqlinsert="insert into zdxxb(zddm,zdmc) values('"+zddm+"','"+zdmc+"') ";
		
		}
        else if(level.trim().equals("5")){//征稽分站或征稽点
        	String newzddm=this.departmentzddmCal(level,zddm);
        	sqlinsert="insert into zdxxb(zddm,zdmc) values('"+newzddm+"','"+zdmc+"') ";
		}
		DBConnect dbconn=new DBConnect();
		DBConnect dbconn2=new DBConnect();
		try {
			flag1=dbconn.executeInsert(sqlinsert);
			if(sqlinsert2.equals(""))flag2=false;
			else flag2=dbconn2.executeInsert(sqlinsert2);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		if(flag1==false&&flag2==false)return true;
		else return false;
		
		
	}
	
	public static void main(String[] args) throws SQLException  {
		// TODO 自动生成方法存根
		SearchSubdepartment yy=new SearchSubdepartment();
		String uu=yy.departmentzddmCal("1","0000");
		System.out.println(uu);
	}
	

}