客户物料编码获取测试

package mztest;

 

import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
 
import com.kingdee.bos.BOSException;
import com.kingdee.eas.common.EASBizException;
import com.kingdee.eas.fm.common.FMIsqlFacadeFactory;
import com.kingdee.eas.fm.common.IFMIsqlFacade;

import edu.emory.mathcs.backport.java.util.Collections;
 
public class mz {
	private static final String DRIVER_CLASS = "oracle.jdbc.driver.OracleDriver";
 	private static String DATABASE_URL = "jdbc:oracle:thin:@192.168.0.8:1521:eas";;
	private static String DATABASE_USER = "*********";
	private static String DATABASE_PASSWORD = "***********";
	 
	
//	private static String DATABASE_URL = "jdbc:oracle:thin:@10.123.69.161:1521:KDDB1";;
//	private static String DATABASE_USER = "kingdee";
//	private static String DATABASE_PASSWORD = "kingdee";
 
	public static Connection getConn() {
		try {
			 Class.forName(DRIVER_CLASS);
			 Connection dbConnection = DriverManager.getConnection(
					DATABASE_URL, DATABASE_USER, DATABASE_PASSWORD);
			 return dbConnection;
		} catch (SQLException e) {
			 e.printStackTrace();
		} catch (ClassNotFoundException e) {
		 e.printStackTrace();
		}
	     return null;
	}
 
	public static void closeAll(Connection conn, PreparedStatement pstmt,
			ResultSet rs) {
		try {
			if (rs != null) {
				rs.close();
			}
			if (pstmt != null) {
				pstmt.close();
			}
			if (conn != null)
				conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
 
	
	public static void main(String[] args) throws FileNotFoundException, SQLException {
		
		String materialTypeNumber="08.00";
		
		
		ArrayList  numberList=  new ArrayList();
		ArrayList  numberstrList=  new ArrayList();
	       	 Connection conn = null;
		     PreparedStatement ps = null;
	         conn = getConn();
	 		String sql=" select    FNUMBER  from   T_BD_MATERIAL  where  FMATERIALGROUPID= (     select   fid  from   T_BD_MATERIALGROUP  where  FNUMBER='"+materialTypeNumber+"'   ) order by FNUMBER    ";	
	     	ps=conn.prepareStatement(sql);
	     	ResultSet executeSQL = ps.executeQuery();
	        String number="";
			while (executeSQL.next() ) {
		  number=	executeSQL.getString(1);
           	 int lastIndexOf = number.lastIndexOf(".");
              String  strc=  number.substring(lastIndexOf+1,number.length() ) ;
       	       Integer c= Integer.valueOf(number.substring(lastIndexOf+1,number.length() ) );
           	 numberList.add(c);
             numberstrList.add(strc);
			}
          
           if(numberList.size()<=0){
           	numberList.add(1);
            numberstrList.add("001");
           }
         
           Collections.sort(numberList);
           String   bigNumber=numberList.get(numberList.size() - 1).toString();
         
           System.out.println("输出numberList================================");
      	   System.out.println(numberList);
          
		  String c=materialTypeNumber+".";
		  String   augend= getMaxLength(   numberstrList   );
		 //被加数前面有0，前面的0会消失， 进行补0 
		 String format = String.format("%0"+augend.length()+"d", Long.parseLong(bigNumber)+1);
		 number=c+format;
		 System.out.println("输出================================");
	     System.out.println(number);
	 
	   
	 }
	
	
	
	
	
	
	  public static    String  getMaxLength(ArrayList  numberstrList   ){
		  int maxLengthIndex=0;
		   for (int i = 0; i < numberstrList.size(); i++) {
			   if(numberstrList.get(i).toString().length()>numberstrList.get(maxLengthIndex).toString().length()){
				   maxLengthIndex=i;
			   }
		  }
	   	return numberstrList.get(maxLengthIndex).toString();
	 
		  
	  }
	
	
	
	
 
}