validatehc.java

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

package edu.whut.cwts.hc;


import java.sql.*;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.GregorianCalendar;

public class ValidateHc {
	public static boolean validateCjdjh(String cjdjh)
	//按照船检登记号验证航次（国内）船舶信息是否存在
	{
		boolean result = true;
		ConnectDB conndb = new ConnectDB();
		ResultSet rs = null;
		String sql = "select * from cbxxb where cjdjh='" +cjdjh.trim()+ "'";
		try {
			rs = conndb.executeQuery(sql);
			if (rs.next()) {
				result = true;
			} else
				result = false;
		} catch (Exception e) {
			e.printStackTrace();
		}
		System.out.println("the cjdjhSearch result is" + result);
		conndb.close();
		return result;
	}

	public static int validateCmch(String cmch)
	//按照船名船号验证航次（国内）船舶信息是否存在、唯一、多条
	{
		ArrayList array = new ArrayList();
		int result = 0;
		ConnectDB conndb = new ConnectDB();
		ResultSet rs = null;
		String sql = "select * from cbxxb where cmch='" +cmch.trim()+ "'";
		try {
			rs = conndb.executeQuery(sql);
			if (rs == null)
				return 0;//不存在记录则返回0
			while (rs.next()) {
				array.add(new Cbxxb(rs.getString("cjdjh"),
						rs.getString("cmch"), rs.getString("gsdm"), rs
								.getString("cz"), rs.getString("czsfzh"), rs
								.getFloat("gl"), rs.getFloat("jd"), rs
								.getFloat("zd"), rs.getFloat("zzd"), rs
								.getString("cjg"), rs.getString("sfyy"), rs
								.getString("yyzh"), rs.getString("xgsj")));
			}
			if (array.size() == 1) {
				result = 1;//查到一条船返回1
			} 
			if (array.size() > 1) {
				result = 2;//查到多条船返回2
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		System.out.println("the cmchSearch result is" + result);
		conndb.close();
		return result;
	}

	public static boolean validateMzyw(String cjdjh, String mzzt) {
		//检查船舶（国内）是否办理了免征业务（mzzt为2，有效期起小于等于当前时间，有效期止大于等于当前时间的船舶则免征）
		boolean result = false;
		ConnectDB conndb = new ConnectDB();
		ResultSet rs = null;
		Date dt = new Date();
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
	    String nowtime=sdf.format(dt);
		System.out.println(nowtime);
		String sql = "select * from mzywb where cjdjh='" + cjdjh
				+ "' and mzzt='" +mzzt.trim()+ "' and yxq_q<='" +nowtime.trim()+ "' and yxq_z>='" +nowtime.trim()+ "'";
		try {
			rs = conndb.executeQuery(sql);
			if (rs.next()) {
				result = true;
			} else
				result = false;
		} catch (Exception e) {
			e.printStackTrace();
		}
		System.out.println("the mzywSearch result is" + result);
		conndb.close();
		return result;
	}

	public static boolean validateTjz(String cjdjh, String sfzf) {
		// 检查船舶（国内）是否办理了统缴业务（根据统缴证记录中sfzf为正常，有效期起小于等于当前时间，有效期止大于等于当前时间的船舶免航次）
		boolean result = false;
		ConnectDB conndb = new ConnectDB();
		ResultSet rs = null;
		//String nowtime = new java.util.Date().toLocaleString();//定义的是当前时间
		Date dt = new Date();
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
	    String nowtime=sdf.format(dt);
		//System.out.println(nowtime);
		String sql = "select * from tjz where cjdjh='" +cjdjh.trim()+ "' and sfzf='"
				+sfzf.trim()+ "' and yxqq<='" +nowtime.trim()+ "' and yxqz>='" +nowtime.trim()+ "'";
		try {
			rs = conndb.executeQuery(sql);
			if (rs.next()) {
				result = true;
			} else
				result = false;
		} catch (Exception e) {
			e.printStackTrace();
		}
		System.out.println("the tjzSearch result is" + result);
		conndb.close();
		return result;
	}

	public static boolean validateXccb(String cjdjh, String xczt) {
		//检查船舶（国内）是否存在于协查名单中（按照船检登记号，xczt为0表示处于协查状态）
		boolean result = true;
		ConnectDB conndb = new ConnectDB();
		ResultSet rs = null;
		String sql = "select * from xccbmd where cjdjh='"+ cjdjh.trim()
				+"' and xczt='" + xczt.trim()+ "' ";
		try {
			rs = conndb.executeQuery(sql);
			if (rs.next()) {
				result = true;
			} else
				result = false;
		} catch (Exception e) {
			e.printStackTrace();
		}
		System.out.println("the xccbSearch result is" + result);
		conndb.close();
		return result;
	}

	public static boolean validateHmd(String cjdjh) {
		//检查船舶（国内）是否存在于黑名单中（按照船检登记号,且黑名单类型为船舶类型'0'）
		boolean result = true;
		ConnectDB conndb = new ConnectDB();
		ResultSet rs = null;
		String sql = "select * from cbhmd where dwbm='"+cjdjh.trim()+ "' and hmdlx='0'";
		try {
			rs = conndb.executeQuery(sql);
			if (rs.next()) {
				result = true;
			} else
				result = false;
		} catch (Exception e) {
			e.printStackTrace();
		}
		System.out.println("the hmdSearch result is" + result);
		conndb.close();
		return result;
	}
/*******************************************************************/
	  /******************国际航线船舶信息的处理*****************/
/*******************************************************************/
	public static int validateCmchGj(String cmch)
	{ //按照船名船号验证航次（国际）船舶信息是否存在
		int result = 0;
		ConnectDB conndb = new ConnectDB();
		ResultSet rs = null;
		String sql="select * from gjcbb where cmch='"+cmch.trim()+"'";
		try {
			rs = conndb.executeQuery(sql);
			Assert.pl(sql);
			if (rs.next()) {
				result = 1;
			} else
				result = 0;
		} catch (Exception e) {
			e.printStackTrace();
		}
		System.out.println("the validateCmchGj result is" + result);
		conndb.close();
		return result;		
		}
/*******************************************************************/
	  /******************票据号码验证的处理*****************/
/*******************************************************************/	
	public static boolean validatePzhm(String pzzl, String pzhm, String syzt,
			String dprdm) {
		//验证票据号码有效性 四重验证（pzzl国际航线为1，国内为2；syzt为4）
		boolean result = false;
		ConnectDB conndb = new ConnectDB();
		ResultSet rs = null;
		String sql = "select * from pjztb where pzhm='"+pzhm.trim()+"'and pzzl='"
				+pzzl.trim()+ "' and syzt='" +syzt.trim()+ "' and dprdm='" +dprdm.trim()+ "'";
		try {
			rs = conndb.executeQuery(sql);
			Assert.pl(sql);
			if (rs.next()) {
				result = true;
			} else
				result = false;
		} catch (Exception e) {
			e.printStackTrace();
		}
		System.out.println("the validatePzhm result is" + result);
		conndb.close();
		return result;
	}
	public static boolean validateGjhcExist(String pzhm,String zddm) 
	{   //查找国际航次票表中记录是否存在（服务于达帐处理业务,在达帐处理之前先要判断票据号码对应数据是否存在）
		boolean result = false;
		ConnectDB conndb = new ConnectDB();
		ResultSet rs = null;
		String sql = "select * from gjhc where pzhm='"+pzhm.trim()+"' and zddm='"+zddm.trim()+"'";
		try {
			rs = conndb.executeQuery(sql);
			Assert.pl(sql);
			if (rs.next()) {
				result = true;
			} else
				result = false;
		} catch (Exception e) {
			e.printStackTrace();
		}
		System.out.println("the validateGjhcExist result is" + result);
		conndb.close();
		return result;
	}	
/*******************************************************************/
	  /******************航次信息录入的判断处理*****************/
/*******************************************************************/	
    public static boolean validateHcxxdj(String cjdjh,String qsg,String qygrq){
    	//验证航次信息是否已经录入（船检登记号+起始港+起运港日期 三重验证）
		boolean result = false;
		ConnectDB conndb = new ConnectDB();
		ResultSet rs = null;
		String sql = "select * from hcxxdjb where cjdjh='"+cjdjh.trim()+"'and qsg='"
				+qsg.trim()+ "' and qygrq='" +qygrq.trim()+ "'";
		try {
			rs = conndb.executeQuery(sql);
			Assert.pl(sql);
			if (rs.next()) {
				result = true;
			} else
				result = false;
		} catch (Exception e) {
			e.printStackTrace();
		}
		System.out.println("the validateHcxxdj result is" + result);
		conndb.close();
		return result; 	
    }
   
}