📄 commoditymanage.java
字号:
int m=Integer.parseInt(d);
Business c=new Business();
CommodityManage CM=new CommodityManage();
if(m==10)
{
c.BusinessMenu();
c.choose();
}
else if(m==20)
{
System.out.println("-------------You have exited Main Menu!-------------");
System.exit(0);
}
else
{
System.out.println("Please Enter again!");
c.again();
}
}
public void choose()throws IOException
{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
String w=br.readLine();
int q=Integer.parseInt(w);
Business c=new Business();
CommodityManage CM=new CommodityManage();
Order o=new Order();
SoldDetail s=new SoldDetail();
{
switch(q)
{
case 1: o.OrderMenu(); o.choose(); break;
case 2: s.SoldMenu(); s.choose(); break;
case 0: System.out.println("You have returned to the Main Menu!");
CM.DisplayMenu();
CM.chooseMenu();
break;
default:
System.out.println("Please Enter again:"); c.choose(); break;
}
}
}
}
//-----------------------------------------------------------------------------------------------------------------//
//---------------------------------------------Here's Order Detail-------------------------------------------------//
class Order
{
static String ID;
public void OrderMenu()throws IOException
{
System.out.println(" |--------Order Menu--------|");
System.out.println(" 1.Display Order Detail");
System.out.println(" 2.Insert Order Detail");
System.out.println(" 3.Update Order Detail");
System.out.println(" 4.Delete Order Detail");
System.out.println(" 0.Exit");
System.out.println(" |--------------------------|");
System.out.print(" Please choose a number(0~4):");
Order o=new Order();
o.choose();
}
public void again()throws IOException
{
System.out.println("Return to the Order Menu ?");
System.out.print("Press '10' for Yes,Press '20' for No! ");
BufferedReader ar=new BufferedReader(new InputStreamReader(System.in));
String d=ar.readLine();
int m=Integer.parseInt(d);
Order o=new Order();
Business b=new Business();
if(m==10)
{
o.OrderMenu();
o.choose();
}
else if(m==20)
{
System.out.println("-------------You have exited Main Menu!-------------");
System.exit(0);
}
else
{
System.out.println("Please Enter again!");
o.again();
}
}
public void choose()throws IOException
{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
String w=br.readLine();
int p=Integer.parseInt(w);
Order o=new Order();
Business b=new Business();
{
switch(p)
{
case 1: o.DisplayOrder(); o.again(); break;
case 2: o.InsertOrder() ; o.again(); break;
case 3: o.UpdateOrder() ; o.again(); break;
case 4: o.DeleteOrder() ; o.again(); break;
case 0: System.out.println("You have returned to the Business Menu!");
b.BusinessMenu();
b.choose();
break;
default:
System.out.println("Please Enter again:"); o.choose(); break;
}
}
}
public void DisplayOrder()
{
System.out.println("-----------------1.DisplayOrder--------------------");
Connection con=null;
Statement stat;
ResultSet res=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:Commodity");
stat=con.createStatement();
res=stat.executeQuery("select * from OrderDetail");
if(res==null)
{
System.out.println("\n--------------Order Table is Null!--------------\n");
}
else
{
res=stat.executeQuery("select * from OrderDetail");
while(res.next())
{
System.out.println(" Order ID : "+res.getString(1));
System.out.println(" OrderDetail ID : "+res.getString(2));
System.out.println(" Supplier ID : "+res.getString(3));
System.out.println(" Quantity : "+res.getString(4));
System.out.println(" Order Date : "+res.getString(5));
System.out.println(" Shipment Date : "+res.getString(6));
System.out.println(" Remark : "+res.getString(7));
System.out.println(" Clerk : "+res.getString(8));
System.out.println("\n--------------------Order Detail-------------------\n");
}
}
}
catch(Exception e)
{
System.out.println("Could not query: "+e);
}
if (con!=null) con=null;
}
public void Display()
{
Connection con=null;
PreparedStatement stat;
ResultSet res=null;
BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:Commodity");
stat=con.prepareStatement("select * from OrderDetail where cOrderID=?");
stat.setString(1,(String)ID); //用值替换SQL语句中的问号参数
res=stat.executeQuery();
if(res==null)
{
System.out.println("\n--------------Order Table is Null!--------------");
return;
}
else
{
System.out.println(" Order ID : "+res.getString(1));
System.out.println(" OrderDetail ID : "+res.getString(2));
System.out.println(" Supplier ID : "+res.getString(3));
System.out.println(" Quantity : "+res.getString(4));
System.out.println(" Order Date : "+res.getString(5));
System.out.println(" Shipment Date : "+res.getString(6));
System.out.println(" Remark : "+res.getString(7));
System.out.println(" Clerk : "+res.getString(8));
System.out.println("");
}
}
catch(Exception e)
{
System.out.println("Could not display: "+e);
}
if (con!=null) con=null;
}
public void InsertOrder() throws IOException
{
System.out.println("-----------------2.InsertOrder--------------------");
Connection con=null;
PreparedStatement stat,order;
ResultSet res=null;
int count=0;
BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
try
{
String CommodityID,SupplierID,OrderQty,OrderID,judge,Remark,Clerk;
int i;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:Commodity");
while(true)
{
stat=con.prepareStatement("select * from SupplierDetail where cSupplierID in (select cSupplierID from Supply where cCommodityID=?)");
System.out.print("\nPlease Input the ID of Commodity(6) : ");
CommodityID=br.readLine();
stat.setString(1,CommodityID);
res=stat.executeQuery();
System.out.println("");
System.out.println("-----Please Choose the Supplier for this Commodity-----\n\n");
while(res.next())
{
System.out.println(" ID : "+res.getString(1));
System.out.println(" Name : "+res.getString(2));
System.out.println(" Description : "+res.getString(3));
System.out.println(" Telephone : "+res.getString(4));
System.out.println(" Address : "+res.getString(5));
System.out.println("Shipment Delay : "+res.getString(6));
System.out.println(" Appraisal : "+res.getString(7));
System.out.println("\n--------------------Choose Supplier-------------------\n");
}
System.out.println("");
System.out.print("Please Input the ID of Order(3) : ");
OrderID=br.readLine();
ID=OrderID;
System.out.print("Please Input the ID of Supplier(6) : ");
SupplierID=br.readLine();
System.out.print("Please Input the Quantity of Commodity(int) : ");
OrderQty=br.readLine();
System.out.print("Please Input Remark(50) : ");
Remark=br.readLine();
System.out.print("Please Input Your Name(50) : ");
Clerk=br.readLine();
System.out.println("\n----------------Please Check Input----------------\n");
System.out.print("Press 1 to Continue,Press Any Key to Input again : ");
judge=br.readLine();
System.out.println("");
i=Integer.parseInt(judge);
if(i!=1)continue;
else break;
}
order=con.prepareStatement("exec prcOrder ?,?,?,?,?,?");
order.setString(1,OrderID);
order.setString(2,CommodityID);
order.setString(3,SupplierID);
order.setInt(4,Integer.parseInt(OrderQty));
order.setString(5,Remark);
order.setString(6,Clerk);
count=order.executeUpdate();
if (count!=0) System.out.println("\n-------Table OrderDetail has Updated!-------\n");
}
catch(Exception e)
{
System.out.println("\n------------Error! Please Check the Input------------\n\n");
}
if (con!=null) con=null;
Log l=new Log();
l.GetDate();
FileWriter outF = new FileWriter("log.txt",true);
outF.write(" Inserted an Order \r\n");
outF.write("----------------------------------------------------- \r\n");
outF.close();
Order o=new Order();
o.Display();
}
public void UpdateOrder()throws IOException
{
System.out.println("-----------------3.UpdateOrder--------------------\n");
Connection con=null;
PreparedStatement stat=null;
int res=0;
BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:Commodity");
System.out.print("Please enter the cOrderID(3):");
String cID=br.readLine();
ID=cID;
System.out.println();
System.out.println("--------Update what?--------");
System.out.println(" 1.cCommodityID");
System.out.println(" 2.cSupplierID");
System.out.println(" 3.iOrderQty");
System.out.println(" 4.vOrderRemark");
System.out.println(" 5.vOrderClerk");
System.out.print("--------Please chose (0~5) : ");
String w=br.readLine();
int n=Integer.parseInt(w);
switch(n)
{
case 1: stat=con.prepareStatement("update OrderDetail set cCommodityID=? where cOrderID=?");
System.out.print("Enter new CommodityID(6) : ");break;
case 2: stat=con.prepareStatement("update OrderDetail set cSupplierID=? where cOrderID=?");
System.out.print("Enter new SupplierID(6) : ");break;
case 3: stat=con.prepareStatement("update OrderDetail set iOrderQty=? where cOrderID=?");
System.out.print("Enter new OrderQty(int) : ");break;
case 4: stat=con.prepareStatement("update OrderDetail set vOrderRemark=? where cOrderID=?");
System.out.print("Enter new Remark(50) : ");break;
case 5: stat=con.prepareStatement("update OrderDetail set vOrderClerk=? where cOrderID=?");
System.out.print("Enter new Clerk(50) : ");break;
default:System.out.println("--------Error! Please Check the Input!--------");break;
}
String newdata=br.readLine();
if(n==3) stat.setInt(1,Integer.parseInt(newdata));
else stat.setString(1,(String)newdata);
stat.setString(2,(String)cID);
res=stat.executeUpdate();
if (res!=0) System.out.println("-------Table OrderDetail has Updated!-------\n");
}
catch(Exception ex)
{
System.out.println("Could not Updata: "+ex);
}
if (con!=null)con=null;
Log l=new Log();
l.GetDate();
FileWriter outF = new FileWriter("log.txt",true);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -