📄 perform.java
字号:
}
}
catch (Exception ae) {
//ae.printStackTrace();
JOptionPane.showMessageDialog(desktop,"查询出现异常！","警告",2);//0是错误类型x,1是信息类型圆形i，2是警告三角i,3是问号
}
}
}
class QueryAsGoodsNamePerform implements ActionListener {
public void actionPerformed(ActionEvent e) {
// TODO 自动生成方法存根
Vector vector = new Vector();
DefaultTableModel defTableModel = (DefaultTableModel)jTable.getModel();
//药品编码","药品名称","库存量","生产厂家","规格","零售价格
String goodsId,goodsName,manufacturer,standard;
int stocks;
float retailPrice;
((DefaultTableModel)jTable.getModel()).getDataVector().removeAllElements();
((DefaultTableModel)jTable.getModel()).fireTableDataChanged();
try {
DBConnection dbc = new DBConnection();
Connection conn = dbc.getDBConnection();
Statement stmt = conn.createStatement();
String sql;
ResultSet rst;
goodsName = txt_goodsName.getText().trim();
sql = "select * from stock where goodsName = '" + goodsName + "'";
rst = stmt.executeQuery(sql);
if(rst.next()) {
goodsId = rst.getString(1);
stocks = rst.getInt(3);
manufacturer = rst.getString(4);
standard = rst.getString(5);
retailPrice = rst.getFloat(6);
vector.add(goodsId);
vector.add(goodsName);
vector.add(stocks);
vector.add(manufacturer);
vector.add(standard);
vector.add(retailPrice);
defTableModel.getDataVector().add(vector);
((DefaultTableModel)jTable.getModel()).fireTableDataChanged();
}
else {
JOptionPane.showMessageDialog(desktop,"没有满足条件的查询结果！","提示",1);//0是错误类型x,1是信息类型圆形i，2是警告三角i,3是问号
return;
}
}
catch (Exception ae) {
ae.printStackTrace();
}
}
}
}
class PurQueryPerform extends Perform {
// 进药查询：按药品代码，药品名称，采购日期查询。
private MyInternalFrame purQuery = new MyInternalFrame();
private JScrollPane jScrollPane = null;
private JTable jTable = null;
private String []columnNames={"单据号","商品编码","采购价","采购数量","采购日期","供应商"};
private Object[][]p ={};
private DefaultTableModel defaultTable = new DefaultTableModel(p,columnNames);
private JLabel lab_goodsId, lab_goodsName,lab_purDateFrom,lab_purDateTo;
private JTextField txt_goodsId,txt_goodsName,txt_purDateFrom,txt_purDateTo;
private JButton btn_QueryAsGoodsId,btn_QueryAsGoodsName,btn_QueryAsPurDate;
public PurQueryPerform(JDesktopPane desktop) {
this.desktop = desktop;
}
public void actionPerformed(ActionEvent e) {
// TODO 自动生成方法存根
lab_goodsId = new JLabel("商品代码");
lab_goodsName = new JLabel("商品名称");
lab_purDateFrom = new JLabel("采购日期 从");
lab_purDateTo = new JLabel(" 至");
txt_goodsId = new JTextField();
txt_goodsName = new JTextField();
txt_purDateFrom = new JTextField();
txt_purDateTo = new JTextField();
btn_QueryAsGoodsId = new JButton("按商品代码查询");
btn_QueryAsGoodsName = new JButton("按商品名称查询");
btn_QueryAsPurDate = new JButton("按采购日期查询");
lab_goodsId.setBounds(20,10,100,20);
lab_goodsName.setBounds(20,40,100,20);
lab_purDateFrom.setBounds(20,70,120,20);
lab_purDateTo.setBounds(240,70,40,20);
txt_goodsId.setBounds(140,10,100,20);
txt_goodsName.setBounds(140,40,100,20);
txt_purDateFrom.setBounds(140,70,100,20);
txt_purDateTo.setBounds(280,70,100,20);
btn_QueryAsGoodsId.setBounds(380,10,180,20);
btn_QueryAsGoodsName.setBounds(380,40,180,20);
btn_QueryAsPurDate.setBounds(380,70,180,20);
btn_QueryAsGoodsId.addActionListener(new QueryAsGoodsIdPerform());
btn_QueryAsGoodsName.addActionListener(new QueryAsGoodsNamePerform());
btn_QueryAsPurDate.addActionListener(new QueryAsPurDatePerform());
jTable = new JTable();
jTable.setModel(defaultTable);
jScrollPane = new JScrollPane(jTable);
jScrollPane.setViewportView(jTable);
jScrollPane.setBounds(20,100,860,450);
purQuery.setTitle("进货查询");
purQuery.setLayout(null);
purQuery.add(lab_goodsId);
purQuery.add(lab_goodsName);
purQuery.add(lab_purDateFrom);
purQuery.add(lab_purDateTo);
purQuery.add(txt_goodsId);
purQuery.add(txt_goodsName);
purQuery.add(txt_purDateFrom);
purQuery.add(txt_purDateTo);
purQuery.add(btn_QueryAsGoodsId);
purQuery.add(btn_QueryAsGoodsName);
purQuery.add(btn_QueryAsPurDate);
purQuery.add(jScrollPane);
purQuery.setVisible(true);
desktop.add(purQuery,1);
}
class QueryAsGoodsIdPerform implements ActionListener {
public void actionPerformed(ActionEvent e) {
// TODO 自动生成方法存根
List list = new ArrayList();
Query query = new PurQuery();
//DBPurchaseTable dbPur = new DBPurchaseTable();
DefaultTableModel defTableModel = (DefaultTableModel)jTable.getModel();
//"单据号","药品编码","采购价","采购数量","采购日期","供应商"
String goodsId;
((DefaultTableModel)jTable.getModel()).getDataVector().removeAllElements();
((DefaultTableModel)jTable.getModel()).fireTableDataChanged();
try {
goodsId = txt_goodsId.getText().trim();
list = query.getIdQuery(goodsId);
int size = list.size();
//System.out.println("size = " + size);
if(size > 0) {
for( int i = 0 ; i < list.size() ; i ++ ) {
Vector vector = new Vector();//必须放在内部,否则会出现vector的内容重复的问题
DBPurchaseTable dbPur =(DBPurchaseTable) list.get(i);
vector.add(dbPur.getReceiptId());
vector.add(dbPur.getMedicineId());
vector.add(dbPur.getPurPrice());
vector.add(dbPur.getPurQuantity());
vector.add(dbPur.getPurDate());
vector.add(dbPur.getSupplier());
defTableModel.addRow(vector);
/*
System.out.println("------------外部接收---------------------");
System.out.println(dbPur.getReceiptId());
System.out.println(dbPur.getMedicineId());
System.out.println(dbPur.getPurPrice());
System.out.println(dbPur.getPurQuantity());
System.out.println(dbPur.getPurDate());
System.out.println(dbPur.getSupplier());
System.out.println("---------------------------------");
*/
}((DefaultTableModel)jTable.getModel()).fireTableDataChanged();
}
else {
JOptionPane.showMessageDialog(desktop,"没有满足条件的查询结果！","提示",1);//0是错误类型x,1是信息类型圆形i，2是警告三角i,3是问号
return;
}
}
catch (Exception ae) {
ae.printStackTrace();
}
}
}
class QueryAsGoodsNamePerform implements ActionListener {
public void actionPerformed(ActionEvent e) {
// TODO 自动生成方法存根
List list = new ArrayList();
Query query = new PurQuery();
DBPurchaseTable dbPur = new DBPurchaseTable();
DefaultTableModel defTableModel = (DefaultTableModel)jTable.getModel();
String goodsName;
((DefaultTableModel)jTable.getModel()).getDataVector().removeAllElements();
((DefaultTableModel)jTable.getModel()).fireTableDataChanged();
try {
goodsName = txt_goodsName.getText().trim();
list = query.getNameQuery(goodsName);
int size = list.size();
//System.out.println("size = " + size);
if(size > 0) {
for( int i = 0 ; i < list.size() ; i ++ ) {
Vector vector = new Vector();
dbPur =(DBPurchaseTable) list.get(i);
vector.add(dbPur.getReceiptId());
vector.add(dbPur.getMedicineId());
vector.add(dbPur.getPurPrice());
vector.add(dbPur.getPurQuantity());
vector.add(dbPur.getPurDate());
vector.add(dbPur.getSupplier());
defTableModel.addRow(vector);
//defTableModel.fireTableDataChanged();
}((DefaultTableModel)jTable.getModel()).fireTableDataChanged();
}
else {
JOptionPane.showMessageDialog(desktop,"没有满足条件的查询结果！","提示",1);//0是错误类型x,1是信息类型圆形i，2是警告三角i,3是问号
return;
}
}
catch (Exception ae) {
ae.printStackTrace();
}
}
}
class QueryAsPurDatePerform implements ActionListener {
public void actionPerformed(ActionEvent e) {
// TODO 自动生成方法存根
List list = new ArrayList();
Query query = new PurQuery();
DBPurchaseTable dbPur = new DBPurchaseTable();
DefaultTableModel defTableModel = (DefaultTableModel)jTable.getModel();
//"单据号","药品编码","采购价","采购数量","采购日期","供应商"
String purDateFrom,purDateTo;
((DefaultTableModel)jTable.getModel()).getDataVector().removeAllElements();
((DefaultTableModel)jTable.getModel()).fireTableDataChanged();
try {
purDateFrom = txt_purDateFrom.getText().trim();
purDateTo = txt_purDateTo.getText().trim();
list = query.getDateQuery(purDateFrom,purDateTo);
int size = list.size();
//System.out.println("size = " + size);
if(size > 0) {
for( int i = 0 ; i < list.size() ; i ++ ) {
Vector vector = new Vector();
dbPur =(DBPurchaseTable) list.get(i);
vector.add(dbPur.getReceiptId());
vector.add(dbPur.getMedicineId());
vector.add(dbPur.getPurPrice());
vector.add(dbPur.getPurQuantity());
vector.add(dbPur.getPurDate());
vector.add(dbPur.getSupplier());
defTableModel.addRow(vector);
//defTableModel.fireTableDataChanged();
}((DefaultTableModel)jTable.getModel()).fireTableDataChanged();
}
else {
JOptionPane.showMessageDialog(desktop,"没有满足条件的查询结果！","提示",1);//0是错误类型x,1是信息类型圆形i，2是警告三角i,3是问号
return;
}
}
catch (Exception ae) {
ae.printStackTrace();
}
}
}
}
class SellQueryPerform extends Perform {
// 售药查询：按药品代码，药品名称、销售日期查询。
private MyInternalFrame sellQuery = new MyInternalFrame();
private JScrollPane jScrollPane = null;
private JTable jTable = null;
private String []columnNames={"顾客号","商品编码","销售数量","采购日期","单价"};
private Object[][]p ={};
private DefaultTableModel defaultTable = new DefaultTableModel(p,columnNames);
private JLabel lab_goodsId, lab_goodsName,lab_sellDateFrom,lab_sellDateTo;
private JTextField txt_goodsId,txt_goodsName,txt_sellDateFrom,txt_sellDateTo;
private JButton btn_QueryAsGoodsId,btn_QueryAsGoodsName,btn_QueryAsSellDate;
public SellQueryPerform(JDesktopPane desktop) {
this.desktop = desktop;
}
public void actionPerformed(ActionEvent e) {
// TODO 自动生成方法存根
lab_goodsId = new JLabel("商品代码");
lab_goodsName = new JLabel("商品名称");
lab_sellDateFrom = new JLabel("采购日期 从");
lab_sellDateTo = new JLabel(" 至");
txt_goodsId = new JTextField();
txt_goodsName = new JTextField();
txt_sellDateFrom = new JTextField();
txt_sellDateTo = new JTextField();
btn_QueryAsGoodsId = new JButton("按商品代码查询");
btn_QueryAsGoodsName = new JButton("按商品名称查询");
btn_QueryAsSellDate = new JButton("按销售日期查询");
btn_QueryAsGoodsId.addActionListener(new QueryAsGoodsIdPerform());
btn_QueryAsGoodsName.addActionListener(new QueryAsGoodsNamePerform());
btn_QueryAsSellDate.addActionListener(new QueryAsSellDatePerform());
lab_goodsId.setBounds(20,10,100,20);
lab_goodsName.setBounds(20,40,100,20);
lab_sellDateFrom.setBounds(20,70,120,20);
lab_sellDateTo.setBounds(240,70,40,20);
txt_goodsId.setBounds(140,10,100,20);
txt_goodsName.setBounds(140,40,100,20);
txt_sellDateFrom.setBounds(140,70,100,20);
txt_sellDateTo.setBounds(280,70,100,20);
btn_QueryAsGoodsId.setBounds(380,10,180,20);
btn_QueryAsGoodsName.setBounds(380,40,180,20);
btn_QueryAsSellDate.setBounds(380,70,180,20);
jTable = new JTable();
jTable.setModel(defaultTable);
jScrollPane = new JScrollPane(jTable);
jScrollPane.setViewportView(jTable);
jScrollPane.setBounds(20,100,860,450);
sellQuery.setTitle("售货查询");
sellQuery.setLayout(null);
sellQuery.add(lab_goodsId);
sellQuery.add(lab_goodsName);
sellQuery.add(lab_sellDateFrom);
sellQuery.add(lab_sellDateTo);
sellQuery.add(txt_goodsId);
sellQuery.add(txt_goodsName);
sellQuery.add(txt_sellDateFrom);
sellQuery.add(txt_sellDateTo);
sellQuery.add(btn_QueryAsGoodsId);
sellQuery.add(btn_QueryAsGoodsName);
sellQuery.add(btn_QueryAsSellDate);
sellQuery.add(jScrollPane);
sellQuery.setVisible(true);
desktop.add(sellQuery,0);
}
class QueryAsGoodsIdPerform implements ActionListener {
public void actionPerformed(ActionEvent e) {
// TODO 自动生成方法存根
List list = new ArrayList();
Query query = new SellQuery();
DBSellTable dbSell = new DBSellTable();
DefaultTableModel defTableModel = (DefaultTableModel)jTable.getModel();
String medId;
((DefaultTableModel)jTable.getModel()).getDataVector().removeAllElements();
((DefaultTableModel)jTable.getModel()).fireTableDataChanged();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -