judgedbversion.java

java 读写EXCEL文件的源码

/********************************************************************
 *
 * $RCSfile: JudgeDBVersion.java,v $  $Revision: 1.1 $  $Date: 2003/09/22 08:06:24 $
 *
 * $Log: JudgeDBVersion.java,v $
 * Revision 1.1  2003/09/22 08:06:24  icestone
 * init
 *
 *
 *
 **********************************************************************/
package pcdmupgradedata;
/**
*功能：判断数据库版本是否是2.2
*算法依据：根据光交接箱的新增的端子排列的字段来判断
*入：connection
*出：boolean
**/
import java.sql.*;
import java.net.*;
import java.util.*;

public class JudgeDBVersion{

   public static boolean getNewVersion(Connection conn){
           boolean jVersion=false;
          jVersion =getFlagv2(conn);

        return jVersion;
   } //end getNewVersion

   public static boolean getFlagNew(Connection conn,boolean b_flag){
           boolean jChanged=false;
          jChanged =getFlagnew(conn,b_flag);

        return jChanged;
   }
/**
*类内部判断静态方法
*/
  private static boolean getFlagv2(Connection conn){
     boolean getflage=false;
     String jvalue;
     String sql="select FIELDNAME  from COLNAME where TABLENAME='光交接箱'";
    try{
         Statement SqlStatement = conn.createStatement();
         ResultSet Jvalue=SqlStatement.executeQuery(sql);
	     while(Jvalue.next())
              {
		jvalue=Jvalue.getString(1);
		if(jvalue.equals("端子排列方式"))
		 {
		  getflage=true;
		  break;
	         }//end if
	      }//end while
         SqlStatement.close();
         Jvalue.close();
        }catch(java.sql.SQLException e){
// Debug.print("jdugeversion sql error!"+e);

       }//end try
      return getflage;
   }//end

  private static boolean getFlagnew(Connection conn,boolean b_flag){
     boolean getNewFlag=false;
     String jvalue;
     String tname;
     String sql="select *  from  tab";
     if(b_flag==false)
       tname="P_USERVSRANGE";
     else
       tname="ZJDY_T";

    try{
         Statement SqlStatement = conn.createStatement();
         ResultSet Jvalue=SqlStatement.executeQuery(sql);
	     while(Jvalue.next())
              {
		jvalue=Jvalue.getString(1);
/*考虑用P_USERS来判断*/
		if(jvalue.equals(tname))
		 {
		  getNewFlag=true;
		  break;
	         }//end if
	      }//end while
         SqlStatement.close();
         Jvalue.close();
        }catch(java.sql.SQLException e){
// Debug.print("jdugeversion sql error!"+e);

       }//end try
      return getNewFlag;
   }//end

/*判断新旧管孔编码方式*/
/*
  public static boolean isOld_gkCode
  (
   Connection conn
  )
  {
   String TmpStr=null;
   StringTokenizer CodeToken;
   boolean flag=false;
   String sql="select 管孔编码  from  管孔 where rownum=1 and 管孔编码 is not null";
   String gkCode=null;

    try{
         Statement SqlStatement = conn.createStatement();
         ResultSet Jvalue=SqlStatement.executeQuery(sql);
	     while(Jvalue.next())
              {
		gkCode=Jvalue.getString(1);
	      }//end while
         SqlStatement.close();
         Jvalue.close();
        }catch(java.sql.SQLException e){
       }//end try
 
             if(gkCode==null)return true;
             CodeToken = new StringTokenizer(gkCode,"/",false);
             while(CodeToken.hasMoreTokens())
              {
                 TmpStr= ((String)CodeToken.nextToken()).trim();
                 if(TmpStr.equals("A")||TmpStr.equals("B")||TmpStr.equals("C") ||TmpStr.equals("D") || TmpStr.equals("E")|| TmpStr.equals("F")|| TmpStr.equals("G")||TmpStr.equals("H") ||TmpStr.equals("I") || TmpStr.equals("J"))
                   {
                    flag=true;
                    break;
                   }
              }//end while
             return flag;

   }//end    isOld_gkCode
*/

}//end JudgeDBVersion