📄 salefindaction.java
字号:
package action.implementclass.dialogaction;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Iterator;
import java.util.Vector;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
import view.dialog.SaleFindDialog;
import view.dialog.dialogoper.SaleFindOper;
import vo.SaleProductVo;
import dao.SaleDao;
/**
* 销售查询事件
* @author wenjie
*
*/
public class SaleFindAction implements ActionListener {
public void actionPerformed(ActionEvent e) {
String name = e.getActionCommand();
if (name.equals("显示全部")) {
Vector v = new SaleDao().getSaleInfo();
Iterator iter = v.iterator();
DefaultTableModel model = (DefaultTableModel) SaleFindDialog.table
.getModel();
int counts = model.getRowCount();
// 循环删除jtable中的所有数据
for (int i = counts - 1; i >= 0; i--) {
model.removeRow(i);
}
while (iter.hasNext()) {
SaleProductVo value = (SaleProductVo) iter.next();
Object[] data = { new Integer(value.getProduct_id()),
value.getProduct_name(), value.getProduct_type(),
new Double(value.getProduct_price()),
new Double(value.getPrice_pct()), new Integer(value.getSale_num()),
new Double(value.getSale_sum()), value.getSale_date() };
model.addRow(data);
}
} else if (name.equals("确定")) {
Vector v = null;
if (SaleFindDialog.product_idBtn.isSelected()) {
v = new SaleDao().getSaleById(Integer
.parseInt(SaleFindDialog.product_id.getText()));
} else if (SaleFindDialog.product_nameBtn.isSelected()) {
v = new SaleDao().getSaleByName(SaleFindDialog.product_name.getText());
} else if (SaleFindDialog.product_typeBtn.isSelected()) {
v = new SaleDao().getSaleByType(SaleFindDialog.product_type
.getSelectedItem().toString());
} else if (SaleFindDialog.txtSaleDateBtn.isSelected()) {
v = new SaleDao().getSaleByDate(SaleFindDialog.txtSaleDate
.getSelectedItem().toString());
}
Iterator iter = v.iterator();
DefaultTableModel model = (DefaultTableModel) SaleFindDialog.table
.getModel();
int counts = model.getRowCount();
// 循环删除jtable中的所有数据
for (int i = counts - 1; i >= 0; i--) {
model.removeRow(i);
}
//重新循环获得jtable中新的数据
while (iter.hasNext()) {
SaleProductVo value = (SaleProductVo) iter.next();
Object[] data = { new Integer(value.getProduct_id()),
value.getProduct_name(), value.getProduct_type(),
new Double(value.getProduct_price()),
new Double(value.getPrice_pct()), new Integer(value.getSale_num()),
new Double(value.getSale_sum()), value.getSale_date() };
model.addRow(data);
}if(model.getRowCount()==0){
JOptionPane.showMessageDialog(null,"无相关销售记录");
}
} else if (name.equals("条件重置")) {
SaleFindOper.initialTextValue();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -