testsubdepartment.java

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

/** 
* Copyright 2007 Wuhan University of Technology. 
* All right reserved. 
* Create on 2007-3-28
*/ 
package edu.whut.cwts.maintain.util;

import java.sql.ResultSet;
import java.sql.SQLException;

import edu.whut.cwts.datasource.DBConnect;
/**
 * @author dwr
 *
 */
public class TestSubDepartment {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO 自动生成方法存根
		String zddm="100000";
		if(zddm=="0")
		zddm="000000";
        String sql="";
		if(zddm.equals("000000")){
			//System.out.println("征稽处");			
			sql="select * from zdxxb where zddm like '%0000' or zddm='100000' and zddm<>"+zddm+"";}						
		else if(zddm.substring(2).equals("0000")){
			String center=zddm.substring(0,2);		
			sql="select zdmc from zdxxb where (zddm like '"+center+"%00' or zddm like '"+center+"00%') and zddm<>'"+center+"0000' ";
			//中心站或直属站
			} 	
			
		else if(!zddm.substring(2,4).equals("00") && zddm.substring(4,6).equals("00") && !zddm.substring(2,4).equals("01")){	
			String zjdzm=zddm.substring(0,4);
			sql="select * from zdxxb where zddm like '"+zjdzm+"%' and zddm<>"+zddm+"";//征稽站						
			}					
		else
			sql="";
		DBConnect dbconn=new DBConnect();
		String id="";
		try{
			 ResultSet rs=dbconn.executeQuery(sql);	
			 while(rs.next())
			 {
				 id=rs.getString(1);
				 System.out.println(id);
			 }
			}
			 catch (SQLException e) {
					e.printStackTrace();}
		dbconn.close(); 
		
	}

}