dboperate.java

connect DATABASE by java

        {
            index = 0;
        }
        else if(tn.compareTo("costlog")==0)
        {
            index = 1;
        }
        else if(tn.compareTo("costtype")==0)
        {
            index = 2;
        }
        else if(tn.compareTo("employee")==0)
        {
            index = 3;
        }
        else if(tn.compareTo("manager")==0)
        {
            index = 4;
        }
        else if(tn.compareTo("region")==0)
        {
            index = 5;
        }
        else if(tn.compareTo("salesrecord")==0)
        {
            index = 6;
        }
        else if(tn.compareTo("sregion")==0)
        {
            index = 7;
        }
        else if(tn.compareTo("worklog")==0)
        {
            index = 8;
        }
        else if(tn.compareTo("storecheck")==0)
        {
            index = 9;
        }
        else if(tn.compareTo("salesR")==0)
        {
            index = 10;
        }
        else if(tn.compareTo("salesRD")==0)
        {
            index = 11;
        }
        else if(tn.compareTo("storeplan")==0)
        {
            index = 12;
        }
        else if(tn.compareTo("outgo")==0)
        {
            index = 13;
        }
        else if(tn.compareTo("outgodetail")==0)
        {
            index = 14;
        }
        else if(tn.compareTo("damageRecord")==0)
        {
            index = 15;
        }
        else if(tn.compareTo("drsrecord")==0)
        {
            index = 16;
        }
        else if(tn.compareTo("storeinrecord")==0)
        {
            index = 17;
        }
        else if(tn.compareTo("department")==0)
        {
            index = 18;
        }
        else if(tn.compareTo("medicineorder")==0)
        {
            index = 19;
        }
        else if(tn.compareTo("medicinetype")==0)
        {
            index = 20;
        }
        else if(tn.compareTo("medicineprice")==0)
        {
            index = 21;
        }
        else if(tn.compareTo("provider")==0)
        {
            index = 22;
        }
        else if(tn.compareTo("manufacture")==0)
        {
            index = 23;
        }
        else if(tn.compareTo("medicineclassify")==0)
        {
            index = 24;
        }
        else if(tn.compareTo("med")==0)
        {
            index = 25;
        }
        else if(tn.compareTo("mstorecheck")==0)
        {
            index = 26;
        }
        else if(tn.compareTo("agent")==0)
        {
            index = 27;
        }
        else if(tn.compareTo("agentOrder")==0)
        {
            index = 28;
        }
        else if(tn.compareTo("mstore")==0)
        {
            index = 29;
        }
        else if(tn.compareTo("shift")==0)
        {
            index = 30;
        }
        else if(tn.compareTo("morder")==0)
        {
            index = 31;
        }
        else if(tn.compareTo("morderD")==0)
        {
            index = 32;
        }
        try 
        {
            // This is where we load the driver
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } 
        catch (ClassNotFoundException e) 
        {
            System.out.println("Unable to load Driver Class");
            //return;
        }              
        Statement stmt = null;
        Connection con=null;
        try
        {
            con =  DriverManager.getConnection("jdbc:odbc:"+dbname,user,pw);
            stmt = con.createStatement();
            try 
            {                
                switch(index)
                {
                    case 0: 
                        for(int i=0;i<storeDB.size();i++)
                        {
                            branch tmpJ = (branch)storeDB.elementAt(i);
                            stmt.execute("insert into " + tn 
                                +" values ('"+tmpJ.branchid+"','"+tmpJ.branchname+"','"+tmpJ.region
                                +tmpJ.agentid+","+tmpJ.manager+","+tmpJ.wkstdl
                                +tmpJ.wkl1+","+tmpJ.wkl2+","+tmpJ.wel3
                                +tmpJ.salesstd+","+tmpJ.drstd+","+tmpJ.sundayopen+");");
                            //branchid,branchname,region,brand,manager,wkstdl,wkl1,wkl2,wkl3,salesstd,drstd,sundayopen
                        }
                        break;
                    case 1:
                        for(int i=0;i<storeDB.size();i++)
                        {
                            costlog tmpS = (costlog)storeDB.elementAt(i);
                            stmt.execute("insert into " + tn 
                                +" values ("+ (tmpS.costid).trim() +","+(tmpS.salesrecordid).trim() +","
                                +(tmpS.costtype).trim() +","+(tmpS.amount).trim() +");");
                        }
                        break;
                    case 2:
                        for(int i=0;i<storeDB.size();i++)
                        {
                            costtype tmpS = (costtype)storeDB.elementAt(i);
                            stmt.execute("insert into " + tn 
                                +" values ("+ (tmpS.costtypeid).trim() +",'"+(tmpS.typename).trim()+"');");
                        }
                        break;
                    case 3:
                        for(int i=0;i<storeDB.size();i++)
                        {
                            employee tmpZ = (employee)storeDB.elementAt(i);
                            stmt.execute("insert into " + tn 
                                +" values ('"+ (tmpZ.employeeID).trim() +"','"+(tmpZ.employeename).trim() +"',"
                                +(tmpZ.company).trim() +",'"+(tmpZ.isdr).trim() +"','"
                                +(tmpZ.department).trim() +"');");
                        }
                        break;
                    case 4:
                        for(int i=0;i<storeDB.size();i++)
                        {
                            manager tmpZ = (manager)storeDB.elementAt(i);
                            stmt.execute("insert into " + tn 
                                +" values ("+ (tmpZ.mid).trim() +",'"+(tmpZ.manager).trim()  +"');");
                        }
                        break;
                    case 5:
                        for(int i=0;i<storeDB.size();i++)
                        {
                            region tmpS = (region)storeDB.elementAt(i);
                            stmt.execute("insert into " + tn 
                                +" values ("+ (tmpS.regionID).trim() +",'"+(tmpS.regionName).trim()  +"');");
                        }
                        break;
                    case 6:
                        for(int i=0;i<storeDB.size();i++)
                        {
                            salesrecord tmpS = (salesrecord)storeDB.elementAt(i);
                            stmt.execute("insert into " + tn 
                                +" values ('"+ (tmpS.recordID).trim() +"','"+(tmpS.branchID).trim() +"',"
                                +(tmpS.cashincome).trim() +","+(tmpS.chequeincome).trim() +","+(tmpS.cardincome).trim()+","
                                +(tmpS.serviceincome).trim() +","+(tmpS.dayincome).trim()+","+(tmpS.totalp).trim() +","
                                +(tmpS.newp).trim()+","+(tmpS.acup).trim() +","+(tmpS.emp).trim() +",'"+(tmpS.date).trim()+"');");
                        }
                        break;
                    case 7:
                        for(int i=0;i<storeDB.size();i++)
                        {
                            sregion tmpS = (sregion)storeDB.elementAt(i);
                            stmt.execute("insert into " + tn 
                                +" values ("+ (tmpS.sregionID).trim() +","+(tmpS.bregionID).trim() +",'"
                                +(tmpS.sregionName).trim() +"');");
                        }
                        break;
                    case 8:
                        for(int i=0;i<storeDB.size();i++)
                        {
                            worklog tmpS = (worklog)storeDB.elementAt(i);
                            stmt.execute("insert into " + tn 
                                +" values ('"+ (tmpS.logid).trim() +"','"+(tmpS.employeeid).trim() +"','"+(tmpS.recordid).trim() +"');");
                        }
                        break;
                    case 9:
                        for(int i=0;i<storeDB.size();i++)
                        {
                            storecheck tmpS = (storecheck)storeDB.elementAt(i);
//                             System.out.println("insert into " + tn 
//                                 +" values ("+ (tmpS.id).trim() +","+(tmpS.BranchID).trim() +","+(tmpS.MedicineID).trim() +","+(tmpS.amount).trim() +","+(tmpS.dtime).trim()+","+(tmpS.employeeID).trim()+");");
                            stmt.execute("insert into " + tn 
                                +" values ('"+ (tmpS.id).trim() +"','"+(tmpS.BranchID).trim() +"','"+(tmpS.MedicineID).trim() +"','"+(tmpS.amount).trim() +"','"+(tmpS.dtime).trim()+"','"+(tmpS.employeeID).trim()+"');");
                        }
                        break;
                    case 10:
                        for(int i=0;i<storeDB.size();i++)
                        {
                            salesR tmpS = (salesR)storeDB.elementAt(i);
                            stmt.execute("insert into " + tn 
                                +" values ('"+ (tmpS.salesrecordID).trim() +"','"+(tmpS.BranchID).trim() +"','"
                                +(tmpS.Date).trim() +"','"+(tmpS.checked).trim() +"');");
                        }