archivecasedao.java

dgbas公文管理核心java源码

package com.jasson.business.archive;

import java.io.*;
import java.sql.*;
import java.util.Collection;
import java.util.ArrayList;
import java.util.Vector;
import com.jasson.business.common.DbConn;
import com.jasson.common.ExtendString;
import com.jasson.common.*;

public class ArchiveCaseDAO
{
	private int YearNO;
	private String CategoryNO;
	private String CaseNO;
	private String CaseName;
	private int KeepYear;
    private String ErrMsg;

	public ArchiveCaseDAO( int YearNO, String CategoryNO, String CaseNO, String CaseName, int KeepYear )
	{
		this.YearNO = YearNO;
		this.CategoryNO = CategoryNO;
		this.CaseNO = CaseNO;
		this.CaseName = CaseName;
		this.KeepYear = KeepYear;
	}
	public ArchiveCaseDAO()
	{
	}
	public int getYearNO()
	{
		return this.YearNO;
	}
	public void setYearNO(int  YearNO)
	{
		this.YearNO = YearNO;
	}
	public String getCategoryNO()
	{
		return this.CategoryNO;
	}
	public void setCategoryNO(String  CategoryNO)
	{
		this.CategoryNO = CategoryNO;
	}
	public String getCaseNO()
	{
		return this.CaseNO;
	}
	public void setCaseNO(String  CaseNO)
	{
		this.CaseNO = CaseNO;
	}
	public String getCaseName()
	{
		return this.CaseName;
	}
	public void setCaseName(String  CaseName)
	{
		this.CaseName = CaseName;
	}
	public int getKeepYear()
	{
		return this.KeepYear;
	}
	public void setKeepYear(int  KeepYear)
	{
		this.KeepYear = KeepYear;
	}

    public String getErrMsg()
	{
		return this.ErrMsg;
	}
	public void setErrMsg(String  errMsg)
	{
		this.ErrMsg = errMsg;
	}

	public static ArchiveCaseDAO find(String CategoryNO, String CaseNO, int YearNO)
	{
        ExtendString Exs = new ExtendString();
		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		ArchiveCaseDAO result = null;
		try
 		{
			DbConn dbConn = new DbConn();
			con = dbConn.getConnection();
			ps = con.prepareStatement("select  YearNO, CategoryNO, CaseNO, CaseName, KeepYear from TArchiveCase where CategoryNO = ? and CaseNO = ? and YearNO = ?");
			ps.setString(1, CategoryNO);
            ps.setString(2, CaseNO);
            ps.setInt(3, YearNO);
			rs = ps.executeQuery();
			if (rs.next())
            {
                result = new ArchiveCaseDAO( rs.getInt(1), Exs.dbDecode(rs.getString(2)),  Exs.dbDecode(rs.getString(3)),  Exs.dbDecode(rs.getString(4)), rs.getInt(5));
			}
			rs.close();
			rs = null;
			ps.close();
			ps = null;
			con.close();
			con = null;
		}
		catch (Exception ex)
		{
            System.out.println("System error:" + ex.getMessage());
		}
		finally
		 {
			if (rs != null)
			 {
				try
				{
					rs.close();
				}
				catch (Exception ex)
                {
                    System.out.println("System error:" + ex.getMessage());
                }
				rs = null;
			}
			if (ps != null)
			{
				try
				{
					ps.close();
				}
				catch (Exception ex)
                {
                    System.out.println("System error:" + ex.getMessage());
		        }
				ps = null;
			}
			if (con != null)
			{
				try
				{
					con.close();
				}
				catch (Exception ex)
                {
                    System.out.println("System error:" + ex.getMessage());
                }
				con = null;
			}
		}
		return result;
	}

    public static ArchiveCaseDAO[] findByCategoryNOAndYearNO(String categoryNO, int yearNO)
	{
        ExtendString Exs = new ExtendString();
		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		ArchiveCaseDAO result = null;
		Collection results = new ArrayList();
		try
		{
			DbConn dbConn = new DbConn();
			con = dbConn.getConnection();
            ps = con.prepareStatement("select YearNO, CategoryNO, CaseNO, CaseName, KeepYear from TArchiveCase where CategoryNO = ? and YearNO = ? ");
			ps.setString(1, categoryNO);
            ps.setInt(2,yearNO);
			rs = ps.executeQuery();
			while (rs.next())
			{
                //result = new ArchiveCaseDAO( rs.getInt(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getInt(5));
                result = new ArchiveCaseDAO();
                result.setYearNO(rs.getInt("YearNO"));
                result.setCategoryNO(Exs.dbDecode(rs.getString("CategoryNO")));
                result.setCaseNO(Exs.dbDecode(rs.getString("CaseNO")));
                result.setCaseName(Exs.dbDecode(rs.getString("CaseName")));
                result.setKeepYear(rs.getInt("KeepYear"));
                results.add(result);
			}
			rs.close();
			rs = null;
			ps.close();
			ps = null;
			con.close();
			con = null;
		}
		catch (Exception ex)
		{
            System.out.println("System error:" + ex.getMessage());
		}
		finally
		 {
			if (rs != null)
			 {
				try
				{
					rs.close();
				}
				catch (Exception ex)
                {
                    System.out.println("System error:" + ex.getMessage());
                }
				rs = null;
			}
			if (ps != null)
			{
				try
				{
					ps.close();
				}
				catch (Exception ex)
                {
                    System.out.println("System error:" + ex.getMessage());
                }
				ps = null;
			}
			if (con != null)
			{
				try
				{
					con.close();
				}
				catch (Exception ex)
                {
                    System.out.println("System error:" + ex.getMessage());
                }
				con = null;
			}
		}
        ArchiveCaseDAO[] aArchiveCaseDAO = (ArchiveCaseDAO[])results.toArray(new ArchiveCaseDAO[0]);
        if (aArchiveCaseDAO!=null && aArchiveCaseDAO.length==0) return null;
		return aArchiveCaseDAO;
	}

	public static ArchiveCaseDAO[] findAll()
	{
        ExtendString Exs = new ExtendString();
		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		ArchiveCaseDAO result = null;
		Collection results = new ArrayList();
		try
		{
			DbConn dbConn = new DbConn();
			con = dbConn.getConnection();
			ps = con.prepareStatement("select  YearNO, CategoryNO, CaseNO, CaseName, KeepYear from TArchiveCase");
			rs = ps.executeQuery();
			while (rs.next())
			{
                //result = new ArchiveCaseDAO( rs.getInt(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getInt(5));
                result = new ArchiveCaseDAO();
                result.setYearNO(rs.getInt("YearNO"));
                result.setCategoryNO(Exs.dbDecode(rs.getString("CategoryNO")));
                result.setCaseNO(Exs.dbDecode(rs.getString("CaseNO")));
                result.setCaseName(Exs.dbDecode(rs.getString("CaseName")));
                result.setKeepYear(rs.getInt("KeepYear"));
                results.add(result);
			}
			rs.close();
			rs = null;
			ps.close();
			ps = null;
			con.close();
			con = null;
		}
		catch (Exception ex)
		{
            System.out.println("System error:" + ex.getMessage());
		}
		finally
		 {
			if (rs != null)
			 {
				try
				{
					rs.close();
				}
				catch (Exception ex)
                {
                    System.out.println("System error:" + ex.getMessage());
                }
				rs = null;
			}
			if (ps != null)
			{
				try
				{
					ps.close();
				}
				catch (Exception ex)
                {
                    System.out.println("System error:" + ex.getMessage());
                }
				ps = null;
			}
			if (con != null)
			{
				try
				{
					con.close();
				}
				catch (Exception ex)
                {
                    System.out.println("System error:" + ex.getMessage());
                }
				con = null;
			}
		}
        ArchiveCaseDAO[] aArchiveCaseDAO = (ArchiveCaseDAO[])results.toArray(new ArchiveCaseDAO[0]);
        if (aArchiveCaseDAO!=null && aArchiveCaseDAO.length==0) return null;
		return aArchiveCaseDAO;
	}

	public static ArchiveCaseDAO[] findToCategory(String sCategoryNO,int iYearNO)
	{
        ExtendString Exs = new ExtendString();
		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		ArchiveCaseDAO result = null;
		Collection results = new ArrayList();
		try
		{
			DbConn dbConn = new DbConn();
			con = dbConn.getConnection();
			String sql="select distinct CategoryNO from TArchiveCase where YearNO="+iYearNO;
			if (sCategoryNO!=null&&!sCategoryNO.equals("")){
				sql+=" and CategoryNO like '%"+sCategoryNO+"%'";
			}
			ps = con.prepareStatement(sql);
			rs = ps.executeQuery();
			while (rs.next())
			{
                result = new ArchiveCaseDAO();
                result.setCategoryNO(Exs.dbDecode(rs.getString("CategoryNO")));
                results.add(result);
			}
			rs.close();
			rs = null;
			ps.close();
			ps = null;
			con.close();
			con = null;
		}
		catch (Exception ex)
		{
            System.out.println("System error:" + ex.getMessage());
		}
		finally
		 {
			if (rs != null)
			 {
				try
				{
					rs.close();
				}
				catch (Exception ex)
                {
                    System.out.println("System error:" + ex.getMessage());
                }
				rs = null;
			}
			if (ps != null)
			{
				try
				{
					ps.close();
				}
				catch (Exception ex)
                {
                    System.out.println("System error:" + ex.getMessage());
                }
				ps = null;
			}
			if (con != null)
			{
				try
				{
					con.close();
				}
				catch (Exception ex)
                {
                    System.out.println("System error:" + ex.getMessage());
                }
				con = null;
			}
		}
        ArchiveCaseDAO[] aArchiveCaseDAO = (ArchiveCaseDAO[])results.toArray(new ArchiveCaseDAO[0]);
        if (aArchiveCaseDAO!=null && aArchiveCaseDAO.length==0) return null;
		return aArchiveCaseDAO;
	}
	public long insert()
	{
		Connection con = null;
		PreparedStatement ps = null;
		long lngSQLReturn = -1;
		long lngReturn = -1;
		try
		{
			DbConn dbConn = new DbConn();
			con = dbConn.getConnection();
            ExtendCalendar ExCal = new ExtendCalendar();
			if (con != null)
			{
				ps = con.prepareStatement("insert into TArchiveCase ( YearNO, CategoryNO, CaseNO, CaseName, KeepYear) values ( ?, ?, ?, ?, ?)");
				ps.setInt(1, ExCal.getYear(ExCal.getDate()));
				ps.setString(2, getCategoryNO());
				ps.setString(3, getCaseNO());
				ps.setString(4, getCaseName());
				ps.setInt(5, getKeepYear());
				lngReturn = ps.executeUpdate();;
				ps.close();
			}
			con.close();
		}
		catch (SQLException sqlException)
		{
		}
		finally
		 {
			if (ps != null)
			{
				try
				{
					ps.close();
				}
				catch (SQLException sqlException)
				{
				}
				ps = null;
			}
			if (con != null)
			{
				try
				{
					con.close();
				}
				catch (SQLException sqlException)
				{
				}
				con = null;
			}
		}
		return lngReturn;
	}
    /**
     * よ猭