?? restaurantmenu51.java
字號:
package restaurant;
import java.io.*;
import java.sql.*;
import javax.swing.JOptionPane;
import java.util.Vector;
import java.util.Calendar;
import java.util.Date;
public class RestaurantMenu51{
private DBCon con;
private Read read;
private Write write;
private Exit exit;
private Common common;
ResultSet rs=null;
public void selectStockInfo(){
String sql="select * from commodityIn";
con = new DBCon();
read = new Read(con.getConnection());
rs=read.executeQuery(sql);
}
public String selectStockInfo(String commodity){
Vector vec = new Vector();
common = new Common();
commodity=common.toChinese(commodity);
String sql="select * from commodityIn where commodity='"+commodity+"'";
con = new DBCon();
read = new Read(con.getConnection());
rs=read.executeQuery(sql);
try{
while(rs.next()){
vec.addElement(rs.getString("stockNo"));
vec.addElement(rs.getString("commodity"));
vec.addElement(rs.getString("operator"));
vec.addElement(rs.getString("amount"));
vec.addElement(rs.getString("price"));
vec.addElement(rs.getString("discount"));
vec.addElement(rs.getString("totalPrice"));
vec.addElement(rs.getString("stockDate"));
vec.addElement(rs.getString("remark"));
}
}catch(SQLException e){
System.err.println(e.getMessage());
}
exit = new Exit(con.getConnection());
exit.Close();
String str="";
if(vec.size()==9)
{
str="商品編號:"+vec.get(0)+"<br>";
str+="名稱:"+vec.get(1)+"<br>";
str+="進貨人:"+vec.get(2)+"<br>";
str+="數(shù)量:"+vec.get(3)+"<br>";
str+="單價:"+vec.get(4)+"<br>";
str+="折扣:"+vec.get(5)+"<br>";
str+="總金額:"+vec.get(6)+"<br>";
str+="金貨日期:"+vec.get(7)+"<br>";
str+="備注:"+vec.get(8)+"<br>";
}
if(vec.size()==0)
str="該商品不存在!";
return str;
}
public Vector getStockInfoInfo(){
Vector vec = new Vector();
try{
while(rs.next()){
vec.addElement(rs.getString("stockNo"));
vec.addElement(rs.getString("commodity"));
vec.addElement(rs.getString("operator"));
vec.addElement(rs.getString("amount"));
vec.addElement(rs.getString("price"));
vec.addElement(rs.getString("discount"));
vec.addElement(rs.getString("totalPrice"));
vec.addElement(rs.getString("stockDate"));
vec.addElement(rs.getString("remark"));
}
}catch(SQLException e){
System.err.println(e.getMessage());
}
exit = new Exit(con.getConnection());
exit.Close();
return vec;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -