Click here to Skip to main content
12,452,066 members (59,553 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: Java
how to put each field in different Classes of single package and call them finally in a single class alse need to generatethe output in report and convert it to .exe file ... I use NETBEANS as my...

package newpackage;
import java.sql.*;
import java.util.regex.*;
  public class Telecom {
         public Telecom(){
            connect();
                      }
    public void connect(){
        try{
                       
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          String db= "jdbc:odbc:Driver={Microsoft Access Driver " + "(*.mdb, *.accdb)};DBQ=D:\\TelecomeDatabase.mdb";
 
          Connection con = DriverManager.getConnection(db," ","fun##)&book");
          Statement st = con.createStatement();
          String sql = "select * from CustomerInfo";
          ResultSet rs = st.executeQuery(sql);
          
                        while (rs.next())
                    {
                            
    String record = rs.getString("RecordNo");
    String file = rs.getString("FileNo");
    String Deposit = rs.getString("Deposite");
                            
        // to convert the encrypted image name
                            file=fileName(file);
                            
            // Deposit                                           
                          Deposit = dpst(Deposit);
                            
                            String pattern1="UiRCcOs74Q3oiro9v6oSfw==";
                            String pattern2="0iMNFDYVBEEO3GpeehM2CA==";
                            
                            boolean patternMatched1 = Pattern.matches(pattern1, Deposit);	
                            boolean patternMatched2 = Pattern.matches(pattern2, Deposit);
                            
                            if(!(patternMatched1||patternMatched2))
                            {
                                   
                            System.out.println(file+ "..."+record+"...Deposit");
                            }
                            
// Balance                            
                            
                            String Balance = rs.getString("Balance");
                            
                            String pattern3="DFRnh7oBC9LDv0C92bHbGg==";
                            String pattern4="PncOzpz3N\\+RmEODQoQGPxg==";
                            
                            boolean patternMatched3 = Pattern.matches(pattern3, Balance);	
                            boolean patternMatched4 = Pattern.matches(pattern4, Balance);
                            
                            if(!(patternMatched3||patternMatched4))
                            {
                                   
                            System.out.println(file+ "..."+record+"...Balance");
                            }
                            
                            String CreditRate = rs.getString("CreditRate");
                            
                            String pattern5="OiTWdthYeBQoIuEWrqPCtg==";
                            String pattern6="kuYahrq16NK1HikHf\\+YuMg==";
                            String pattern7="tmpM9sJUbcf08DoWzE2ldA==";
                            String pattern8="ieWCqWGkCXeaudyQDzgYGA==";
                            
                            boolean patternMatched5 = Pattern.matches(pattern5, CreditRate);	
                            boolean patternMatched6 = Pattern.matches(pattern6, CreditRate);
                            boolean patternMatched7 = Pattern.matches(pattern7, CreditRate);	
                            boolean patternMatched8 = Pattern.matches(pattern8, CreditRate);
                            
                            if(!(patternMatched5||patternMatched6||patternMatched7||patternMatched8))
                            {
                                System.out.println(file+ "..."+record+"...Credit Rate");
                            }
                            
                            String CreditCardType = rs.getString("CreditCardType");
                            
                            String pattern9="oXvcSJdOQc9b46204kKezvftNBZgdKduN9alJDmtYXU=";
                            String pattern10="2Tdl06j/8NjZXJzvfCmX1zi89WdyzYOlrhqNkylMt1o=";
                            String pattern11="GgmPy73mg\\+yUORJd5YMLh8/r26ADX4NQJ99OGrjTk3w=";
                            String pattern12="7kmJx3eb0j\\+y2dcGkTfk6LwhRGKnyvU5PjrQGovaXsY=";
                            
                            boolean patternMatched9 = Pattern.matches(pattern9, CreditCardType);
                            boolean patternMatched10 = Pattern.matches(pattern10, CreditCardType);
                            boolean patternMatched11 = Pattern.matches(pattern11, CreditCardType);
                            boolean patternMatched12 = Pattern.matches(pattern12, CreditCardType);
                        
                            
                       if(!(patternMatched9||patternMatched10||patternMatched11||patternMatched12))     
                        {
                                System.out.println(file+ "..."+record+"...Credit Card Type");
                            }
                       
                       String ResidenceType = rs.getString("ResidenceType");
                       
                       String pattern13="zbJTBGb9/KQ7UfB6AN2ulg==";
                       String pattern14="zmVQcb33scaoIwku18zkig==";
                       String pattern15="MZtJrvB\\+hf7xJYdQMXiv9w==";
                       String pattern16="amowvWupkIBeAXbq3Jxd6gWLtSZNB3SkeenZC0xTYto=";
                       String pattern17="D4kMFp4kL6\\+8T1UbuPgNBmVO\\+xJTnZQQVbYlLB0wdg4=";
 
                       
                       boolean patternMatched13 = Pattern.matches(pattern13, ResidenceType);
                       boolean patternMatched14 = Pattern.matches(pattern14, ResidenceType);
                       boolean patternMatched15 = Pattern.matches(pattern15, ResidenceType);
                       boolean patternMatched16 = Pattern.matches(pattern16, ResidenceType);
                       boolean patternMatched17 = Pattern.matches(pattern17, ResidenceType);
                   
                       if(!(patternMatched13||patternMatched14||patternMatched15||patternMatched16||patternMatched17))     
                        {
                                System.out.println(file+ "..."+record+"...Residence Type");
                            }
                       
                       String CustomerType = rs.getString("CustomerType");
                       
                       String pattern18="Fp/KIzASZkHW9ctJstRxbg==";
                       String pattern19="vkBudelL5R0afTvRdTrdKw==";
                       String pattern20="F3W00U8\\+lNjATjzFNng0gw==";
 
                       boolean patternMatched18 = Pattern.matches(pattern18, CustomerType);
 
                     boolean patternMatched19 = Pattern.matches(pattern19, CustomerType);
 
                    boolean patternMatched20 = Pattern.matches(pattern20, CustomerType);
                    
                    if(!(patternMatched19||patternMatched20||patternMatched18))     
                        {
                                System.out.println(file+ "..."+record+"...Customer type");
                        }
String ExtraValueIncluded = rs.getString("ExtraValueIncluded");
 
String pattern21="mTXPTMad/SLKXudCOBqLmT3jtgOt67ZK9Rf2\\+N1O6e0=";
String pattern22="6AX4l\\+GYYr2oU86Y1jZ3K8QMBjchUUNcyVVmebTJLNQ=";
String pattern23="SIXy8Zr5rF7EsrJv7\\+5qZkgWD7nouEbO7Eg4/gJH2HI=";
String pattern24="xDJHEnXULwMtsanwm4SSeooxBGtq6wATTg2DJqLOGLo=";
 
boolean patternMatched21 = Pattern.matches(pattern21, ExtraValueIncluded);
 
boolean patternMatched22 = Pattern.matches(pattern22, ExtraValueIncluded);
 
boolean patternMatched23 = Pattern.matches(pattern23, ExtraValueIncluded);
 
boolean patternMatched24 = Pattern.matches(pattern24, ExtraValueIncluded);
 
if(!(patternMatched21||patternMatched22||patternMatched23||patternMatched24))     
                        {
                                System.out.println(file+ "..."+record+"...Extra Value Included");
                            }
String Text = rs.getString("TBText");                   
String pattern25="UiRCcOs74Q3oiro9v6oSfw==";
String pattern26="2K98siCx\\+cc9w/44k/VTTQ==";
String pattern27="DFRnh7oBC9LDv0C92bHbGg==";
String pattern28="NWqmEVFdjMVj9d8hNTRLUQ==";
String pattern29="QCtxZMEp94h9snQ0Uamj4A==";
 
boolean patternMatched25 = Pattern.matches(pattern25, Text);
 
boolean patternMatched26 = Pattern.matches(pattern26, Text);
 
boolean patternMatched27 = Pattern.matches(pattern27, Text);
 
boolean patternMatched28 = Pattern.matches(pattern28, Text);
 
boolean patternMatched29 = Pattern.matches(pattern29, Text);
 
if(!(patternMatched29||patternMatched28||patternMatched25||patternMatched26||patternMatched27))     
                        {
                                System.out.println(file+ "..."+record+"...Text");
                            }
String Mins = rs.getString("Mins");
        
String pattern30="fYei8TfdPLCWSd9gUXpJmg==";
String pattern31="88gwpjGGPIwidwxEvHZIsA==";
String pattern32="qMQFXjzODpSXf8VwL6Z0hQ==";
String pattern33="0iMNFDYVBEEO3GpeehM2CA==";
 
boolean patternMatched30 = Pattern.matches(pattern30, Mins);
 
boolean patternMatched31 = Pattern.matches(pattern31, Mins);
 
boolean patternMatched32 = Pattern.matches(pattern32, Mins);
 
boolean patternMatched33 = Pattern.matches(pattern33, Mins);
 
if(!(patternMatched31||patternMatched32||patternMatched33||patternMatched30))     
                        {
                                System.out.println(file+ "..."+record+"...Mins");
                            }
 
String MonthlyCost = rs.getString("MonthlyCost");
        
String pattern34="uwykPsksTM383IJGgj\\+GAA==";
String pattern35="PfOwVP7xbIBAuzv3WDWM8g==";
String pattern36="eGJq2UOBRSgu6rnE60Mvmg==";
String pattern37="Dh5gJxWNQ/DFkJSN\\+Q8LGQ==";
 
boolean patternMatched34 = Pattern.matches(pattern34, MonthlyCost);
boolean patternMatched35 = Pattern.matches(pattern35, MonthlyCost);
boolean patternMatched36 = Pattern.matches(pattern36, MonthlyCost);
boolean patternMatched37 = Pattern.matches(pattern37, MonthlyCost);
 
if(!(patternMatched34||patternMatched35||patternMatched36||patternMatched37))     
                        {
                                System.out.println(file+ "..."+record+"...Monthly Cost");
                            }
String PhoneCost = rs.getString("PhoneCost");
 
String pattern38="k9rRO5wKHPifVYlllLMQCNPf56VMkGU0H8h\\+KB6KYFU=";
String pattern39="ukOwAUOJvJR2yuD1OoPNCKiy0vpnIG2EC\\+jbCFIXVxM=";
String pattern40="KkEOg8dtKB0O65fef6MhmH8ondjYlLrsMk55uhFxa5w=";
 
boolean patternMatched38 = Pattern.matches(pattern38, PhoneCost);
boolean patternMatched39 = Pattern.matches(pattern39, PhoneCost);
boolean patternMatched40 = Pattern.matches(pattern40, PhoneCost);
 
if(!(patternMatched38||patternMatched39||patternMatched40))     
                        {
                                System.out.println(file+ "..."+record+"...Phone Cost");
                            }
//Price Plans
String PricePlans = rs.getString("PricePlans");
 
String pattern41="y9AUpXvGGtu/0widKlegHA==";
String pattern42="bSxl7U9PPtavIFZmSpnG9w==";
String pattern43="r4vADDPljNA8nbBAgqKToQ==";
String pattern44="JJdhItri9H97N2Avu2NAOA==";
String pattern45="Hdt1VEvAYNnb8rzDbzdcLw==";
String pattern46="cXs2AsfJ7jkomqS0d1yjnA==";
String pattern47="vrpZCh4VyxuY34rjLHm\\+KA==";
String pattern48="f3mPaxQgCVJaElaNOqyqbQ==";
 
boolean patternMatched41 = Pattern.matches(pattern41, PricePlans);
boolean patternMatched42 = Pattern.matches(pattern42, PricePlans);
boolean patternMatched43 = Pattern.matches(pattern43, PricePlans);
boolean patternMatched44 = Pattern.matches(pattern44, PricePlans);
boolean patternMatched45 = Pattern.matches(pattern45, PricePlans);
boolean patternMatched46 = Pattern.matches(pattern46, PricePlans);
boolean patternMatched47 = Pattern.matches(pattern47, PricePlans);
boolean patternMatched48 = Pattern.matches(pattern48, PricePlans);
 
if(!(patternMatched42||patternMatched41||patternMatched43||patternMatched44||patternMatched45||patternMatched46||patternMatched47||patternMatched48))     
                        {
                                System.out.println(file+ "..."+record+"...Price Plans");
                            }
 

// Agency Code

String AgencyCode = rs.getString("AgencyCode");
 
String pattern51="TQhRDxUok2UPF4\\+QAdeCRA==";
String pattern52="qxeMzVPQpzdyZgweQbCozw==";
String pattern53="9RmNXDLZou7EMJ99fJf6rg==";
String pattern54="PP5VpcHCM3SVUd9A4tvE9A==";
String pattern55="BMmY1YyUmMpEapX9asDX1g==";
String pattern56="w/50Hoo0oKgN2TvRDs\\+a7A==";
String pattern57="UQ2YaISpCO\\+8Amc1F\\+mAiw==";
String pattern58="eHUBMoFkcv3ESfVmGjWakQ==";
String pattern59="1NXbpYpEKpRnqyKfPjNlbA==";
String pattern60="FFQTCQithk7eMeTw2uILmg==";
String pattern61="rhZMYDAYvbcHnJjz2YJpSg==";
String pattern62="9Ku5ANlHIlPPwHWkKZNaPg==";
String pattern63="\\+hKaW6yb2zoKHluRVEMwAw==";
String pattern64="7pmNMnwxJAaItZ4CL4lMWQ==";
String pattern65="NFpIPLWzRong968u6wLdFQ==";
String pattern66="p5e71aZY3CHGkSrFFdrA1Q==";
String pattern67="UZk\\+kzJMGCJq88jbAIX\\+KQ==";
String pattern68="ztydsFZkUz5biEswx/dPjA==";
String pattern69="cxZLNull2tZ\\+AbMH68XRxw==";
String pattern70="Q2fqA427qQsMUWjBN84hwQ==";
String pattern71="GJUGyJqXJ5shmI84HfI2Mg==";
String pattern72="yuUKH/14L1A\\+syhCKLUgQw==";
 
boolean patternMatched51= Pattern.matches(pattern51, AgencyCode);
boolean patternMatched52= Pattern.matches(pattern52, AgencyCode);
boolean patternMatched53= Pattern.matches(pattern53, AgencyCode);
boolean patternMatched54= Pattern.matches(pattern54, AgencyCode);
boolean patternMatched55= Pattern.matches(pattern55, AgencyCode);
boolean patternMatched56= Pattern.matches(pattern56, AgencyCode);
boolean patternMatched57= Pattern.matches(pattern57, AgencyCode);
boolean patternMatched58= Pattern.matches(pattern58, AgencyCode);
boolean patternMatched59= Pattern.matches(pattern59, AgencyCode);
boolean patternMatched60= Pattern.matches(pattern60, AgencyCode);
boolean patternMatched61= Pattern.matches(pattern61, AgencyCode);
boolean patternMatched62= Pattern.matches(pattern62, AgencyCode);
boolean patternMatched63= Pattern.matches(pattern63, AgencyCode);
boolean patternMatched64= Pattern.matches(pattern64, AgencyCode);
boolean patternMatched65= Pattern.matches(pattern65, AgencyCode);
boolean patternMatched66= Pattern.matches(pattern66, AgencyCode);
boolean patternMatched67= Pattern.matches(pattern67, AgencyCode);
boolean patternMatched68= Pattern.matches(pattern68, AgencyCode);
boolean patternMatched69= Pattern.matches(pattern69, AgencyCode);
boolean patternMatched70= Pattern.matches(pattern70, AgencyCode);
boolean patternMatched71= Pattern.matches(pattern71, AgencyCode);
boolean patternMatched72= Pattern.matches(pattern72, AgencyCode);
 
if(!(patternMatched51||patternMatched52||patternMatched53||patternMatched54||patternMatched55||patternMatched56||patternMatched57||patternMatched58||patternMatched59||patternMatched60||patternMatched61||patternMatched62||patternMatched63||patternMatched64||patternMatched65||patternMatched66||patternMatched67||patternMatched68||patternMatched69||patternMatched70||patternMatched71||patternMatched72))
{
    System.out.println(file+ "..."+record+"...Agency Code");
}
 
//Agency Name

String AgencyName = rs.getString("AgencyName");
 
String pattern73="5sSxnO\\+OHgbRkhaTKVwiHA9CkDxCMSZtAGybJbUrVaA=";
String pattern74="tdLv65ExHEcO68xYTvEkVw==";
String pattern75="uZuXQqsQPCAoPRNjNdtSzj91FNA79wyyNNjXKkwTv/4=";
String pattern76="RJ00Pk260VPYdHKzXIiefg==";
String pattern77="\\+ikIXvp\\+Jt4TIoYrlf07UF2rCf764YBefMYWXTmBcTw=";
String pattern78="EQUxWHLQna1GAM2MOpan3uZ2RcwdFAKzyPPWF1sfaZ8=";
String pattern79="1wf9oXxvklighhqwgft\\+DlmSRaJW5ma91vxXWdqGQQI=";
String pattern80="8id5B1QFFBIbr3A8DFh8tA==";
String pattern81="qJBi9F\\+QFhq8DRTKFNgXW940vXyE34igOViNgQ7SMYQ=";
String pattern82="PuePswsF0U61CQXfHAL6nrT/VsowjgvAkeFD0Q22p78=";
String pattern83="g/qQ2vQexhD7AOfJnKxDbs07igUA6L4ys1zhUCvso6E=";
String pattern84="PzZi\\+YdpWl8CuYNh5NGEvZuUP/LCGYHSOuY1bCm\\+rNg=";
String pattern85="4vaI6vba1io3kqrIzHub/GyYefNAQX3oKt3mstDrwYg=";
String pattern86="Zj4X8OQXRUb43YG/RIeHnrLIwQirusho0MQgcjtXgXU=";
String pattern87="XeIc1B5K1G\\+W\\+bdJFL8MbSyW6gAwy9Wn6wAviHeJCdI=";
String pattern88="5\\+gP0yojpUc3ivrta8TNHSvigfjSqREpcDxEAxSwcpI=";
String pattern89="cDnP\\+QenvFEsCEnQyffLC9mGTyfQlIVNZ0gL8k3EVr8=";
String pattern90="l234VtzmbGrpdN/Ov3rPUqxCucONCS0Oiuc1uDbs3sY=";
String pattern91="o1NAtWNjRYkhZD5B83PxBQ==";
String pattern92="s0rWVDnIWb8aGMa/eZH01A==";
String pattern93="ouRL3RKYA3PpdCEN\\+VB9tA==";
String pattern94="M8zyf4dF\\+H7CcAUydTGs1jEADndczDuv5nMM85/LUE8=";
String pattern95="p53jNSaE2Kiwqz5KWdWs1HtG\\+NaSekvkx7Rgz6rA\\+98=";
String pattern96="7eksisq66ICw\\+ha0rjMTzpWNOFT1Za7Ax1JCVtteuqY=";
 

boolean patternMatched73= Pattern.matches(pattern73, AgencyName);
boolean patternMatched74= Pattern.matches(pattern74, AgencyName);
boolean patternMatched75= Pattern.matches(pattern75, AgencyName);
boolean patternMatched76= Pattern.matches(pattern76, AgencyName);
boolean patternMatched77= Pattern.matches(pattern77, AgencyName);
boolean patternMatched78= Pattern.matches(pattern78, AgencyName);
boolean patternMatched79= Pattern.matches(pattern79, AgencyName);
boolean patternMatched80= Pattern.matches(pattern80, AgencyName);
boolean patternMatched81= Pattern.matches(pattern81, AgencyName);
boolean patternMatched82= Pattern.matches(pattern82, AgencyName);
boolean patternMatched83= Pattern.matches(pattern83, AgencyName);
boolean patternMatched84= Pattern.matches(pattern84, AgencyName);
boolean patternMatched85= Pattern.matches(pattern85, AgencyName);
boolean patternMatched86= Pattern.matches(pattern86, AgencyName);
boolean patternMatched87= Pattern.matches(pattern87, AgencyName);
boolean patternMatched88= Pattern.matches(pattern88, AgencyName);
boolean patternMatched89= Pattern.matches(pattern89, AgencyName);
boolean patternMatched90= Pattern.matches(pattern90, AgencyName);
boolean patternMatched91= Pattern.matches(pattern91, AgencyName);
boolean patternMatched92= Pattern.matches(pattern92, AgencyName);
boolean patternMatched93= Pattern.matches(pattern93, AgencyName);
boolean patternMatched94= Pattern.matches(pattern94, AgencyName);
boolean patternMatched95= Pattern.matches(pattern95, AgencyName);
boolean patternMatched96= Pattern.matches(pattern96, AgencyName);
 
if(!(patternMatched73||patternMatched74||patternMatched75||patternMatched76||patternMatched77||patternMatched78||patternMatched79||patternMatched80||patternMatched81||patternMatched82||patternMatched83||patternMatched84||patternMatched85||patternMatched86||patternMatched87||patternMatched88||patternMatched89||patternMatched90||patternMatched91||patternMatched92||patternMatched93||patternMatched94||patternMatched95||patternMatched96))
{
    System.out.println(file+ "..."+record+"...Agency Name");
}
 
//Company Name

String CompanyName = rs.getString("CompanyName");
 
String pattern97="zR87QIGwpufeOiiX\\+me9jQ==";
String pattern98="ScGgKyCt0gtn0cJeWL8Qkg==";
String pattern99="3zuJIl/2UHUSxGdCDs5fbQ==";
String pattern100="WTUqiXtELoAWSanfN6plhg==";
String pattern101="smNVx3wEJVWUDhdxPZNAbg==";
String pattern102="Lf/OwkErEisjkp2SdgF8kPQMDtPMJFdfSRH2xlx\\+2B4=";
String pattern103="9b2uNsDgHroLMIzixviKkphgyLxq2VevszEv50e0Evk=";
String pattern104="iuxDvGxXXsnNKZMfz3w/wj3T/vjuJui\\+wM47wln\\+IaA=";
String pattern105="g5dN05yfTn0VPrAHHqLOZg==";
String pattern106="KU7cbwr3h0oi7JbP9amJXA==";
String pattern107="m6jl2IRYpLNInt9EM5UXLQ==";
String pattern108="b6MtLa/olrzsQttalJ2c2A==";
String pattern109="NGt5BFu\\+mkFtWG7KpEohDA==";
String pattern110="zhkHixUwV2yWP/r52fqFbA==";
String pattern111="awoWChrsARwIXzWLL\\+muW5zd5iUn2IQ2C\\+\\+Q8RGOCBs=";
String pattern112="3nis\\+GD/DLwX6LhfOrdrsg==";
String pattern113="TE5NGOi0WF/nWk\\+VlzZQvf4azopFwFggNP0OdSw5sEg=";
String pattern114="Um3/U9JdL1WE4j/O599xXnNkrijh35RezU6epSSuVqg=";
 
boolean patternMatched97= Pattern.matches(pattern97, CompanyName);
boolean patternMatched98= Pattern.matches(pattern98, CompanyName);
boolean patternMatched99= Pattern.matches(pattern99, CompanyName);
boolean patternMatched100= Pattern.matches(pattern100, CompanyName);
boolean patternMatched101= Pattern.matches(pattern101, CompanyName);
boolean patternMatched102= Pattern.matches(pattern102, CompanyName);
boolean patternMatched103= Pattern.matches(pattern103, CompanyName);
boolean patternMatched104= Pattern.matches(pattern104, CompanyName);
boolean patternMatched105= Pattern.matches(pattern105, CompanyName);
boolean patternMatched106= Pattern.matches(pattern106, CompanyName);
boolean patternMatched107= Pattern.matches(pattern107, CompanyName);
boolean patternMatched108= Pattern.matches(pattern108, CompanyName);
boolean patternMatched109= Pattern.matches(pattern109, CompanyName);
boolean patternMatched110= Pattern.matches(pattern110, CompanyName);
boolean patternMatched111= Pattern.matches(pattern111, CompanyName);
boolean patternMatched112= Pattern.matches(pattern112, CompanyName);
boolean patternMatched113= Pattern.matches(pattern113, CompanyName);
boolean patternMatched114= Pattern.matches(pattern114, CompanyName);
 
if(!(patternMatched97||
patternMatched98||
patternMatched99||
patternMatched100||
patternMatched101||
patternMatched102||
patternMatched103||
patternMatched104||
patternMatched105||
patternMatched106||
patternMatched107||
patternMatched108||
patternMatched109||
patternMatched110||
patternMatched111||
patternMatched112||
patternMatched113||
patternMatched114
))
{
     System.out.println(file+ "..."+record+"...Company Name");
}
 
// Device name

String DeviceName = rs.getString("DeviceName");
 
String pattern115="yn1iqmj3ZmFmMsjnj3zWzQ==";
String pattern116="MUYNF8MHwp\\+fUZHGie\\+sZQ==";
String pattern117="a0lZuj7V6yepO98jIfXLZA==";
String pattern118="tCo25I4MFirgyrCFvtd3XA==";
String pattern119="WWZNVO/jnk5d8yHasts9zg==";
String pattern120="ceB\\+SbA7pzjV5TmmhwUvbA==";
String pattern121="GA788RHISAmADR5NwO1axg==";
String pattern122="Vvt6G8/h3XdlVdXJtNihSg==";
String pattern123="MASxFMjIe7QviJXHBZLcPA==";
String pattern124="IMHp9GMwVsUSEj5OMnNy5PJKUyduWOK5a3vGITA8Nlo=";
String pattern125="hIT4jPjAxWPbQkvM1tOD\\+Q==";
String pattern126="o9Q1C9zfjyYPPia95vl4rQ==";
String pattern127="J9vreVr2xnmed\\+lsjuYRUQ==";
String pattern128="oD8dPfw33ULQvvh9\\+hwOLA==";
String pattern129="gHbor\\+9cdfRc6YhdA6FKBQ==";
String pattern130="bIQ9ERimJPs7Tea9gZ7DXw==";
String pattern131="fRNkY/yE6aJe0ZWkCBOYHA==";
String pattern132="gihO4DK3EN06\\+oNNQt0CGA==";
String pattern133="ZeRe91XYPZgiSK\\+HDJKJOw==";
String pattern134="EkAoBVhtw3AE89Mr8sqjNw==";
String pattern135="wn\\+rBq7wLSsRnVyPtGtZ9w==";
String pattern136="JtmkXgyWwYyJYp8iz9a0Lw==";
String pattern137="UK2\\+eqA2PnGzxsARqsdWcg==";
String pattern138="HDglcs9O74UC9bdi02H\\+RBBW8a0aze9/YkKLBhgqEbo=";
String pattern139="VoChfx6TJBuK4sKvf88zXg==";
String pattern140="CzhLlUAVRlYXMXrDcMqiSg==";
String pattern141="xg2/HwfXfQ8/6RmeMapVvA==";
String pattern142="XhH7u6iy2FKc4iDHzysdKA==";
String pattern143="t/srL/4VsVgGiv4wfsmfuw==";
String pattern144="7x5Bw2OZ5s6W8oG6wf48Ww==";
String pattern145="l\\+1Nvh7RCJJ5VrvVWp3IsHd8UtgCaG/9jrg8cU6Deyc=";
String pattern146="l\\+1Nvh7RCJJ5VrvVWp3IsFG2oH0E/cB1wCBqq2NADoo=";
String pattern147="qUeCQxwlyDhv4DlLfqwaez53QRotX4Se\\+aXLE7MeHMo=";
String pattern148="Ev2/I9sukccqqROX18HIukp5xA6LwreLTvGS/TKBJR4=";
String pattern149="Ev2/I9sukccqqROX18HIurV57cNM8OqbrWMPJE9dVuk=";
String pattern150="96g/o8DPVFpJEKnbn7FKWDBCe09mx36nn6FR8/XnPPI=";
String pattern151="96g/o8DPVFpJEKnbn7FKWHqbRLeZKmCXZA\\+jhmz/PyA=";
String pattern152="96g/o8DPVFpJEKnbn7FKWCF5nWEvpfT7m0on1qZ8I2k=";
String pattern153="NvhUMIbLXgrfCcKuF0d24ppyhZtnjX4ixPbEncktNVM=";
String pattern154="0TewXPBR7iv6nE1Q/Y83Tg==";
 
boolean patternMatched115= Pattern.matches(pattern115, DeviceName);
boolean patternMatched116= Pattern.matches(pattern116, DeviceName);
boolean patternMatched117= Pattern.matches(pattern117, DeviceName);
boolean patternMatched118= Pattern.matches(pattern118, DeviceName);
boolean patternMatched119= Pattern.matches(pattern119, DeviceName);
boolean patternMatched120= Pattern.matches(pattern120, DeviceName);
boolean patternMatched121= Pattern.matches(pattern121, DeviceName);
boolean patternMatched122= Pattern.matches(pattern122, DeviceName);
boolean patternMatched123= Pattern.matches(pattern123, DeviceName);
boolean patternMatched124= Pattern.matches(pattern124, DeviceName);
boolean patternMatched125= Pattern.matches(pattern125, DeviceName);
boolean patternMatched126= Pattern.matches(pattern126, DeviceName);
boolean patternMatched127= Pattern.matches(pattern127, DeviceName);
boolean patternMatched128= Pattern.matches(pattern128, DeviceName);
boolean patternMatched129= Pattern.matches(pattern129, DeviceName);
boolean patternMatched130= Pattern.matches(pattern130, DeviceName);
boolean patternMatched131= Pattern.matches(pattern131, DeviceName);
boolean patternMatched132= Pattern.matches(pattern132, DeviceName);
boolean patternMatched133= Pattern.matches(pattern133, DeviceName);
boolean patternMatched134= Pattern.matches(pattern134, DeviceName);
boolean patternMatched135= Pattern.matches(pattern135, DeviceName);
boolean patternMatched136= Pattern.matches(pattern136, DeviceName);
boolean patternMatched137= Pattern.matches(pattern137, DeviceName);
boolean patternMatched138= Pattern.matches(pattern138, DeviceName);
boolean patternMatched139= Pattern.matches(pattern139, DeviceName);
boolean patternMatched140= Pattern.matches(pattern140, DeviceName);
boolean patternMatched141= Pattern.matches(pattern141, DeviceName);
boolean patternMatched142= Pattern.matches(pattern142, DeviceName);
boolean patternMatched143= Pattern.matches(pattern143, DeviceName);
boolean patternMatched144= Pattern.matches(pattern144, DeviceName);
boolean patternMatched145= Pattern.matches(pattern145, DeviceName);
boolean patternMatched146= Pattern.matches(pattern146, DeviceName);
boolean patternMatched147= Pattern.matches(pattern147, DeviceName);
boolean patternMatched148= Pattern.matches(pattern148, DeviceName);
boolean patternMatched149= Pattern.matches(pattern149, DeviceName);
boolean patternMatched150= Pattern.matches(pattern150, DeviceName);
boolean patternMatched151= Pattern.matches(pattern151, DeviceName);
boolean patternMatched152= Pattern.matches(pattern152, DeviceName);
boolean patternMatched153= Pattern.matches(pattern153, DeviceName);
boolean patternMatched154= Pattern.matches(pattern154, DeviceName);
 
if(!(patternMatched115||
patternMatched116||
patternMatched117||
patternMatched118||
patternMatched119||
patternMatched120||
patternMatched121||
patternMatched122||
patternMatched123||
patternMatched124||
patternMatched125||
patternMatched126||
patternMatched127||
patternMatched128||
patternMatched129||
patternMatched130||
patternMatched131||
patternMatched132||
patternMatched133||
patternMatched134||
patternMatched135||
patternMatched136||
patternMatched137||
patternMatched138||
patternMatched139||
patternMatched140||
patternMatched141||
patternMatched142||
patternMatched143||
patternMatched144||
patternMatched145||
patternMatched146||
patternMatched147||
patternMatched148||
patternMatched149||
patternMatched150||
patternMatched151||
patternMatched152||
patternMatched153||
patternMatched154
))
    
{
    System.out.println(file+ "..."+record+"...Device Name");
}
 
//Credit card No

String CreditCardNo = rs.getString("CreditCardNo");
 
if(!(CreditCardNo.length()== 44))
 //if ( ! (string1.equals(string2)) )       

    
   {
    System.out.println(file+ "..."+record+"...Credit Card No");
}
 
                    }                
} catch(Exception ex){
      
  }
          }
    
    public String fileName(String file)
    {
file = file.replace("TjbAv5JDDGemMXTV1t8BsQ==","Image1");
file = file.replace("k7URUDpXYL/2VKGa0qT0nQ==","Image2");
file = file.replace("+MsdL3hBM9IlHhGVUvDzrw==","Image3");
file = file.replace("jMMDjjUuufwVe2jLOJpLFg==","Image4");
file = file.replace("LxuC0cy3iecPKG+Q8eEqqA==","Image5");
file = file.replace("YgMr9Xe70xUft8gxf12YDw==","Image6");
file = file.replace("gFaYVfWCHJbqRYq9taCDuA==","Image7");
file = file.replace("MxpJ/r0GLxk6jFBj/lr0mA==","Image8");
file = file.replace("O3CaYwro05EpDM4VreYVcw==","Image9");
// removed a part
// goes on until "Image300"

file = file.replace("k1G6OTqqkyzfzJ4VnnCHRA==","IMAGE 151");
file = file.replace("7w2/+wS6rh583cgYPXTrZA==","IMAGE 152");
file = file.replace("s9VvMIzT0rsthyykIxaW4w==","IMAGE 153");
file = file.replace("yeVDYE2ffyAwQ2RgqZqTaA==","IMAGE 154");
file = file.replace("y7+voeIIOOM43HK4UX1gDQ==","IMAGE 155");
file = file.replace("Jr8XpGdU/ClM9DhxYn3Cgw==","IMAGE 156");
file = file.replace("dN2viP6lBMstOPMKNy4X1Q==","IMAGE 157");
file = file.replace("FAHnRRMssC1bLWAn7RHR9w==","IMAGE 158");
file = file.replace("JFfl/oqVQL2tyQt2iw5UWA==","IMAGE 159");
// removed a part
// goes on until "IMAGE 300"

 
        return file;
    }
    
    /*public String dpst(String Deposit)
    {
        String record = rs.getString("RecordNo");
       String file = rs.getString("FileNo");
        String Deposit = rs.getString("Deposite");
        String pattern1="UiRCcOs74Q3oiro9v6oSfw==";
        String pattern2="0iMNFDYVBEEO3GpeehM2CA==";
                            
                            boolean patternMatched1 = Pattern.matches(pattern1, Deposit);	
                            boolean patternMatched2 = Pattern.matches(pattern2, Deposit);
                            
                            if(!(patternMatched1||patternMatched2))
                            {
                                   
                            System.out.println(file+ "..."+record+"...Deposit");
                            }
                            
                            return Deposit;
    }*/
    
    public static void main(String[] args) {
        // TODO code application logic here
        
        new Telecom();
       
    }
}

[torsten]changed title to short form and added code block[/torsten]
[torsten]...also removed a repeating part of the code block....[/torsten]
Posted 1-Jan-13 21:01pm
Updated 1-Jan-13 21:15pm
TorstenH.34.9K
v2
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

So first of all I tried to give it some format...

Then I thought "Holly s***, what is that?".

So please explain what this monster should be?

You are on a complete false path there. I assume you figured how to get a String from the ByteArray in the InputStream.
But you need to make it more than that, you can't do it all by using String manipulations.
If anything in that page changes the code will fail directly.
  Permalink  
v2
Comments
alexpandy1 2-Jan-13 3:34am
   
package newpackage;

import java.sql.*;
import java.util.regex.*;

public class Telecom {

public Telecom(){
connect();
}
public void connect(){
try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String db= "jdbc:odbc:Driver={Microsoft Access Driver " + "(*.mdb, *.accdb)};DBQ=D:\\TelecomeDatabase.mdb";

Connection con = DriverManager.getConnection(db," ","fun##)&book");
Statement st = con.createStatement();
String sql = "select * from CustomerInfo";
ResultSet rs = st.executeQuery(sql);


while (rs.next())
{

String record = rs.getString("RecordNo");
String file = rs.getString("FileNo");
//String Deposit = rs.getString("Deposite");


// to convert the encrypted image name
file=fileName(file);


// Deposit
//Deposit = dpst(Deposit);

String pattern1="UiRCcOs74Q3oiro9v6oSfw==";
String pattern2="0iMNFDYVBEEO3GpeehM2CA==";

boolean patternMatched1 = Pattern.matches(pattern1, Deposit);
boolean patternMatched2 = Pattern.matches(pattern2, Deposit);

if(!(patternMatched1||patternMatched2))
{

System.out.println(file+ "..."+record+"...Deposit");
}

// Balance

String Balance = rs.getString("Balance");

String pattern3="DFRnh7oBC9LDv0C92bHbGg==";
String pattern4="PncOzpz3N\\+RmEODQoQGPxg==";

boolean patternMatched3 = Pattern.matches(pattern3, Balance);
boolean patternMatched4 = Pattern.matches(pattern4, Balance);

if(!(patternMatched3||patternMatched4))
{

System.out.println(file+ "..."+record+"...Balance");
}



}
} catch(Exception ex){

}
}

public String fileName(String file)
{
file = file.replace("TjbAv5JDDGemMXTV1t8BsQ==","Image1");
file = file.replace("k7URUDpXYL/2VKGa0qT0nQ==","Image2");
file = file.replace("+MsdL3hBM9IlHhGVUvDzrw==","Image3");
file = file.replace("jMMDjjUuufwVe2jLOJpLFg==","Image4");



return file;
}


public static void main(String[] args) {

new Telecom();

}
}
Orcun Iyigun 2-Jan-13 3:36am
   
I felt the same and said to myself "what the hech did i just skim through" while scrolling down the page... Don't get me wrong OP had an art there :)
alexpandy1 2-Jan-13 3:36am
   
I must now split this into 4 different classes and in the main class must call all the three to make it understand for my Team Leader clearly
TorstenH. 2-Jan-13 8:11am
   
You need a data model,.

Your team leader will never except this.
jibesh 2-Jan-13 3:59am
   
TorstenH I appreciate your patience.

+5 :)
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Look at what you want to do and see where a logical separation can be made. For example you could create a class that looks at the different pattern types, and has functions to check matches against the strings that are coming as input. Such functions could return an enum value that identifies the agent or transaction etc. Take a look here[^] for some useful suggestions about some of the classes that can help you.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160826.1 | Last Updated 2 Jan 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100