?? restaurantmenu23.java
字號(hào):
package restaurant;
import java.io.*;
import java.sql.*;
import javax.swing.JOptionPane;
import java.util.Vector;
import java.util.Calendar;
public class RestaurantMenu23{
private DBCon con;
private Read read;
private Write write;
private Exit exit;
private Common common;
ResultSet rs=null;
public void input(Vector inputMessage){
common = new Common();
String sql="insert into commodityIn values(";
sql+="'"+common.toChinese((String)inputMessage.get(0))+"',";
sql+="'"+common.toChinese((String)inputMessage.get(1))+"',";
sql+="'"+common.toChinese((String)inputMessage.get(2))+"',";
sql+=Integer.parseInt(common.toChinese((String)inputMessage.get(3)))+",";
sql+=Integer.parseInt(common.toChinese((String)inputMessage.get(4)))+",";
sql+=Integer.parseInt(common.toChinese((String)inputMessage.get(5)))+",";
sql+=Integer.parseInt(common.toChinese((String)inputMessage.get(3)))*Integer.parseInt(common.toChinese((String)inputMessage.get(4)))*Integer.parseInt(common.toChinese((String)inputMessage.get(5)))/10+",";
sql+="now(),";
sql+="'"+common.toChinese((String)inputMessage.get(6))+"')";
con = new DBCon();
write = new Write(con.getConnection());
write.executeUpdate(sql);
common=new Common();
common.WriteSystemLog("酒店經(jīng)理:"+common.toChinese((String)inputMessage.get(2))+"進(jìn)貨入庫."+common.getNowTime());
exit = new Exit(con.getConnection());
exit.Close();
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -