📄 dboperate.java
字号:
break;
case 11:
for(int i=0;i<storeDB.size();i++)
{
salesRD tmpS = (salesRD)storeDB.elementAt(i);
stmt.execute("insert into " + tn
+" values ('"+ (tmpS.ID).trim() +"','"+(tmpS.salesrecordID).trim() +"','"
+(tmpS.MedicineID).trim() +"','"+(tmpS.Amount).trim() +"');");
}
break;
case 12:
for(int i=0;i<storeDB.size();i++)
{
storeplan tmpS = (storeplan)storeDB.elementAt(i);
stmt.execute("insert into " + tn
+" values ('"+ (tmpS.BranchID).trim() +"','"+(tmpS.MedicineID).trim() +"','"
+(tmpS.uptime).trim() +"','"+(tmpS.limitation).trim() +"');");
}
break;
case 13:
for(int i=0;i<storeDB.size();i++)
{
outgo tmpS = (outgo)storeDB.elementAt(i);
stmt.execute("insert into " + tn
+" values ('"+ (tmpS.outgoID).trim() +"','"+(tmpS.storeid).trim() +"','"+(tmpS.branchID).trim() +"','"+(tmpS.aorderid).trim() +"','"+(tmpS.startdate).trim() +"','"
+(tmpS.endate).trim() +"','"+(tmpS.checked).trim() +"');");
}
break;
case 14:
for(int i=0;i<storeDB.size();i++)
{
outgodetail tmpS = (outgodetail)storeDB.elementAt(i);
stmt.execute("insert into " + tn
+" values ('"+ (tmpS.outgoID).trim() +"','"+(tmpS.medicineID).trim() +"','"+(tmpS.saleamount).trim() +"','"+(tmpS.outamount).trim() +"','"
+(tmpS.finished).trim() +"','"+(tmpS.notes).trim() +"');");
}
break;
case 15:
for(int i=0;i<storeDB.size();i++)
{
damageRecord tmpS = (damageRecord)storeDB.elementAt(i);
stmt.execute("insert into " + tn
+" values ('"+ (tmpS.id).trim() +"','"+(tmpS.branchID).trim()+"','"+(tmpS.medicineID).trim() +"','"+(tmpS.ddate).trim() +"','"
+(tmpS.amount).trim() +"','"+(tmpS.employeeid).trim()+"','"+(tmpS.type).trim() +"');");
}
break;
case 16:
for(int i=0;i<storeDB.size();i++)
{
drsrecord tmpS = (drsrecord)storeDB.elementAt(i);
stmt.execute("insert into " + tn
+" values ('"+ (tmpS.employeeid).trim() +"','"+(tmpS.recordid).trim()+"','"+(tmpS.tp).trim() +"','"+(tmpS.np).trim() +"');");
}
break;
case 17:
for(int i=0;i<storeDB.size();i++)
{
storeinrecord tmpS = (storeinrecord)storeDB.elementAt(i);
stmt.execute("insert into " + tn
+" values ('"+ (tmpS.id).trim() +"','"+(tmpS.orderid).trim()+"','"+(tmpS.MedicineID).trim()+"','"+(tmpS.BranchID).trim()+"','"+(tmpS.sdate).trim()+"','"+(tmpS.amount).trim()+"','"+(tmpS.employeeid).trim() +"','"+(tmpS.type).trim() +"');");
}
break;
case 18:
for(int i=0;i<storeDB.size();i++)
{
department tmpZ = (department)storeDB.elementAt(i);
stmt.execute("insert into " + tn
+" values ('"+ (tmpZ.departmentid).trim() +"','"+(tmpZ.name).trim() +"','"
+(tmpZ.info).trim() +"','"+(tmpZ.employeeid).trim() +"','"
+(tmpZ.right).trim() +"');");
}
break;
case 19:
for(int i=0;i<storeDB.size();i++)
{
medicineorder tmpS = (medicineorder)storeDB.elementAt(i);
// System.out.println("insert into " + tn
// +" values ('"+ (tmpS.getOrderid()).trim() +"','"+ (tmpS.getDepartmentid()).trim()+"','"+ (tmpS.getMedicineid()).trim() +"','"+(tmpS.getProviderid()).trim()+"','"+(tmpS.getAccount()).trim()+"','"+(tmpS.getBarcode()).trim()+"','"+(tmpS.getDate()).trim()+"','"+(tmpS.getPrice()).trim()+"','"+(tmpS.getStaffid()).trim() +"');");
stmt.execute("insert into " + tn
+" values ('"+ (tmpS.orderid).trim() +"','"+ (tmpS.departmentid).trim()+"','"+ (tmpS.medicineid).trim() +"','"
+(tmpS.providerid).trim()+"','"+(tmpS.amount).trim()+"','"+(tmpS.barcode).trim()+"','"+(tmpS.odate).trim()+"','"
+(tmpS.price).trim()+"','"+(tmpS.employeeid).trim()+"','"+(tmpS.confirm).trim()+"','"+(tmpS.delivery).trim()+"','"
+(tmpS.finish).trim() +"');");
}
break;
case 20:
for(int i=0;i<storeDB.size();i++)
{
medicinetype tmpS = (medicinetype)storeDB.elementAt(i);
// System.out.println("insert into " + tn
// +" values ('"+ (tmpS.getPmrid()).trim() +"','"+ (tmpS.getNmrid()).trim()+"','"+ (tmpS.getType()).trim() +"');");
stmt.execute("insert into " + tn
+" values ('"+ (tmpS.pmrid).trim() +"','"+ (tmpS.nmrid).trim()+"','"+ (tmpS.type).trim() +"');");
}
break;
case 21:
for(int i=0;i<storeDB.size();i++)
{
medicineprice tmpS = (medicineprice)storeDB.elementAt(i);
// System.out.println("insert into " + tn
// +" values ('"+ (tmpS.getPmrid()).trim() +"','"+ (tmpS.getNmrid()).trim()+"','"+ (tmpS.getType()).trim() +"');");
stmt.execute("insert into " + tn
+" values ('"+ (tmpS.mrid).trim() +"','"+ (tmpS.providerid).trim()+"','"+ (tmpS.amount).trim()+"','"+ (tmpS.price).trim() +"');");
}
break;
case 22:
for(int i=0;i<storeDB.size();i++)
{
provider tmpS = (provider)storeDB.elementAt(i);
// provider tmpS = (provider)storeDB.elementAt(i);
stmt.execute("insert into " + tn
+" values ('"+ (tmpS.providerid).trim() +"','"+ (tmpS.name).trim() +"','"+(tmpS.address).trim()+"','"+(tmpS.tel).trim()+"','"+(tmpS.email).trim()+"','"+(tmpS.info).trim() +"');");
}
break;
case 23:
for(int i=0;i<storeDB.size();i++)
{
manufacture tmpS = (manufacture)storeDB.elementAt(i);
// System.out.println("insert into " + tn
// +" values ('"+ (tmpS.getPmrid()).trim() +"','"+ (tmpS.getNmrid()).trim()+"','"+ (tmpS.getType()).trim() +"');");
stmt.execute("insert into " + tn
+" values ('"+ (tmpS.manuid).trim() +"','"+ (tmpS.name).trim()
+"','"+ (tmpS.address).trim()+"','"+ (tmpS.tel).trim()
+"','"+ (tmpS.email).trim()+"','"+ (tmpS.info).trim()+"');");
}
break;
case 24:
for(int i=0;i<storeDB.size();i++)
{
medicineclassify tmpS = (medicineclassify)storeDB.elementAt(i);
stmt.execute("insert into " + tn
+" values ('"+ (tmpS.mrid).trim() +"','"+ (tmpS.medicineid).trim() +"','"+(tmpS.providerid).trim() +"','"+(tmpS.manuid).trim()+"','"+(tmpS.unit).trim() +"');");
}
break;
case 25:
for(int i=0;i<storeDB.size();i++)
{
med tmpS = (med)storeDB.elementAt(i);
stmt.execute("insert into medicine"
+" values ('"+ (tmpS.MedicineID).trim() +"','"+ (tmpS.MedicineName).trim()+"','"+ (tmpS.status).trim() +"');");
}
break;
case 26:
for(int i=0;i<storeDB.size();i++)
{
mstorecheck tmpS = (mstorecheck)storeDB.elementAt(i);
stmt.execute("insert into mstorecheck"
+" values ('"+ (tmpS.BranchID).trim() +"','"+ (tmpS.mrid).trim() +"','"
+ (tmpS.dtime).trim()+"','"+ (tmpS.oamount).trim()+"','"+ (tmpS.amount).trim()+"','"+ (tmpS.employeeid).trim() +"');");
}
break;
case 27:
for(int i=0;i<storeDB.size();i++)
{
agent tmpS = (agent)storeDB.elementAt(i);
// System.out.println("insert into " + tn
// +" values ('"+ (tmpS.getPmrid()).trim() +"','"+ (tmpS.getNmrid()).trim()+"','"+ (tmpS.getType()).trim() +"');");
stmt.execute("insert into " + tn
+" values ('"+ (tmpS.agentid).trim() +"','"+ (tmpS.name).trim()
+"','"+ (tmpS.address).trim()+"','"+ (tmpS.area).trim()
+"','"+ (tmpS.city).trim()+"','"+ (tmpS.country).trim()
+"','"+ (tmpS.postcode).trim()+"','"+ (tmpS.tel).trim()
+"','"+ (tmpS.email).trim()+"','"+ (tmpS.info).trim()
+"','"+ (tmpS.type).trim()+"');");
}
break;
case 28:
for(int i=0;i<storeDB.size();i++)
{
agentOrder tmpS = (agentOrder)storeDB.elementAt(i);
// System.out.println("insert into " + tn
// +" values ('"+ (tmpS.orderid).trim() +"','"+ (tmpS.agentid).trim()
// +"','"+ (tmpS.mrid).trim()+"','"+ (tmpS.adate).trim()
// +"','"+ (tmpS.amount).trim()+"','"+ (tmpS.price).trim()
// +"','"+ (tmpS.employeeid).trim()+"','"+ (tmpS.confirm).trim()
// +"','"+ (tmpS.delivery).trim()+"','"+ (tmpS.finish).trim()+"');");
stmt.execute("insert into " + tn
+" values ('"+ (tmpS.orderid).trim() +"','"+ (tmpS.agentid).trim()
+"','"+ (tmpS.mrid).trim()+"','"+ (tmpS.adate).trim()
+"','"+ (tmpS.amount).trim()+"','"+ (tmpS.price).trim()
+"','"+ (tmpS.employeeid).trim()+"','"+ (tmpS.confirm).trim()
+"','"+ (tmpS.delivery).trim()+"','"+ (tmpS.finish).trim()+"');");
}
break;
case 29:
for(int i=0;i<storeDB.size();i++)
{
mstore tmpS = (mstore)storeDB.elementAt(i);
stmt.execute("insert into " + tn
+" values ('"+ (tmpS.BranchID).trim() +"','"+ (tmpS.mrid).trim()
+"','"+ (tmpS.amount).trim()+"');");
}
break;
case 30:
for(int i=0;i<storeDB.size();i++)
{
shift tmpS = (shift)storeDB.elementAt(i);
stmt.execute("insert into " + tn
+" values ('"+ (tmpS.shiftid).trim() +"','"+ (tmpS.branchID).trim()
+"','"+ (tmpS.employeeid).trim()+"','"+ (tmpS.start).trim()
+"','"+ (tmpS.end).trim()+"','"+ (tmpS.rstart).trim()
+"','"+ (tmpS.rend).trim()
+"','"+ (tmpS.rate).trim()+"');");
}
break;
case 31:
for(int i=0;i<storeDB.size();i++)
{
morder tmpS = (morder)storeDB.elementAt(i);
stmt.execute("insert into " + tn
+" values ('"+ (tmpS.orderid).trim() +"','"+ (tmpS.departmentid).trim()
+"','"+ (tmpS.providerid).trim()+"','"+ (tmpS.odate).trim()
+"','"+ (tmpS.employeeid).trim()+"','"+ (tmpS.ddate).trim()
+"','"+ (tmpS.daddress).trim()+"','"+ (tmpS.pdate).trim()
+"','"+ (tmpS.paytype).trim()+"','"+ (tmpS.info).trim()
+"','"+ (tmpS.cm).trim()+"','"+ (tmpS.delivery).trim()
+"','"+ (tmpS.finish).trim()+"');");
}
break;
case 32:
for(int i=0;i<storeDB.size();i++)
{
morderD tmpS = (morderD)storeDB.elementAt(i);
stmt.execute("insert into " + tn
+" values ('"+ (tmpS.orderid).trim() +"','"+ (tmpS.medicineid).trim()
+"','"+ (tmpS.amount).trim()+"','"+ (tmpS.barcode).trim()
+"','"+ (tmpS.price).trim()+"','"+ (tmpS.info).trim()+"');");
}
break;
}
stmt.close();
}
catch (SQLException se)
{
// Inform user of any SQL errors
System.out.println("SQL Exception: " + se.getMessage( ));
se.printStackTrace(System.out);
}
catch (Exception e)
{
System.err.println("problems with SQL sent to "+ dbname+
": "+e.getMessage());
}
con.close();
}
catch (Exception e)
{
System.err.println("problems connecting to "+dbname);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -