?? xiaoshouchaxun.java
字號:
package internalFrame.shangPinXiaoShou;
import java.awt.Font;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.Insets;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyAdapter;
import java.awt.event.KeyEvent;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import javax.swing.DefaultComboBoxModel;
import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JComboBox;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.event.InternalFrameAdapter;
import javax.swing.event.InternalFrameEvent;
import javax.swing.table.DefaultTableModel;
import model.TabSellDetail;
import model.TabSellMain;
import model.Userlist;
import org.springframework.beans.BeansException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;
import dao.UserDAO;
public class XiaoShouChaXun extends JInternalFrame
implements ApplicationContextAware {
private JButton button;
private JTextField endDate;
private JTextField startDate;
private JTable table;
private JTextField content;
private JComboBox operation;
private JComboBox condition;
private Userlist user;
private UserDAO dao;
private ApplicationContext appContext;
private DefaultTableModel dftm;
private JCheckBox selectDate;
public void setApplicationContext(ApplicationContext app)
throws BeansException {
appContext = app;
dao = (UserDAO) appContext.getBean("DAOProxyTransactionFactory");
user = (Userlist) appContext.getBean("loginUser");
}
public XiaoShouChaXun() {
addInternalFrameListener(new InternalFrameAdapter() {
public void internalFrameActivated(final InternalFrameEvent e) {
java.sql.Date date=new java.sql.Date(System.currentTimeMillis());
endDate.setText(date.toString());
date.setMonth(0);
date.setDate(1);
startDate.setText(date.toString());
}
});
setMaximizable(true);
setIconifiable(true);
setClosable(true);
setTitle("銷售信息查詢");
getContentPane().setLayout(new GridBagLayout());
setBounds(100, 100, 609, 375);
final JLabel label = new JLabel();
label.setFont(new Font("", Font.PLAIN, 14));
label.setText(" 選擇查詢條件：");
final GridBagConstraints gridBagConstraints = new GridBagConstraints();
gridBagConstraints.gridy = 0;
gridBagConstraints.gridx = 0;
getContentPane().add(label, gridBagConstraints);
condition = new JComboBox();
condition.setModel(new DefaultComboBoxModel(new String[] {"客戶全稱", "銷售票號"}));
condition.setFont(new Font("", Font.PLAIN, 14));
final GridBagConstraints gridBagConstraints_1 = new GridBagConstraints();
gridBagConstraints_1.gridy = 0;
gridBagConstraints_1.gridx = 1;
getContentPane().add(condition, gridBagConstraints_1);
operation = new JComboBox();
operation.setModel(new DefaultComboBoxModel(new String[]{"等于", "包含"}));
operation.setFont(new Font("", Font.PLAIN, 14));
final GridBagConstraints gridBagConstraints_2 = new GridBagConstraints();
gridBagConstraints_2.gridy = 0;
gridBagConstraints_2.gridx = 4;
getContentPane().add(operation, gridBagConstraints_2);
content = new JTextField();
content.addKeyListener(new KeyAdapter() {
public void keyReleased(final KeyEvent e) {
if(e.getKeyCode()==10) {
button.doClick();
}
}
});
content.setFont(new Font("", Font.PLAIN, 14));
final GridBagConstraints gridBagConstraints_3 = new GridBagConstraints();
gridBagConstraints_3.gridwidth = 2;
gridBagConstraints_3.ipadx = 105;
gridBagConstraints_3.insets = new Insets(0, 10, 0, 10);
gridBagConstraints_3.fill = GridBagConstraints.HORIZONTAL;
gridBagConstraints_3.weightx = 1.0;
gridBagConstraints_3.gridy = 0;
gridBagConstraints_3.gridx = 5;
getContentPane().add(content, gridBagConstraints_3);
button = new JButton();
button.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
boolean selDate = selectDate.isSelected();
if(content.getText().equals("")) {
JOptionPane.showMessageDialog(getContentPane(), "請輸入查詢內容！");
return;
}
if(selDate) {
if(startDate.getText()==null||startDate.getText().equals("")) {
JOptionPane.showMessageDialog(getContentPane(), "請輸入查詢的開始日期！");
return;
}
if(endDate.getText()==null||endDate.getText().equals("")) {
JOptionPane.showMessageDialog(getContentPane(), "請輸入查詢的結束日期！");
return;
}
}
List list;
String con = condition.getSelectedIndex() == 0
? "tabSellMain.khname "
: "tabSellMain.sellId ";
int oper = operation.getSelectedIndex();
String opstr = oper == 0 ? "= " : "like ";
String cont = content.getText();
list = dao.queryObject("from TabSellDetail where "
+ con
+ opstr
+ (oper == 0 ? "'"+cont+"'" : "'%" + cont + "%'")
+ (selDate ? " and tabSellMain.xsdate>'" + startDate.getText()
+ "' and tabSellMain.xsdate<='" + endDate.getText()+" 23:59:59'" : ""));
Iterator iterator = list.iterator();
updateTable(iterator);
}
});
final GridBagConstraints gridBagConstraints_4 = new GridBagConstraints();
gridBagConstraints_4.insets = new Insets(0, 0, 0, 10);
gridBagConstraints_4.gridy = 0;
gridBagConstraints_4.gridx = 7;
getContentPane().add(button, gridBagConstraints_4);
button.setFont(new Font("", Font.PLAIN, 12));
button.setText("查詢");
selectDate = new JCheckBox();
selectDate.setFont(new Font("", Font.PLAIN, 14));
final GridBagConstraints gridBagConstraints_7 = new GridBagConstraints();
gridBagConstraints_7.anchor = GridBagConstraints.EAST;
gridBagConstraints_7.insets = new Insets(0, 10, 0, 0);
gridBagConstraints_7.gridy = 1;
gridBagConstraints_7.gridx = 0;
getContentPane().add(selectDate, gridBagConstraints_7);
final JLabel label_1 = new JLabel();
label_1.setFont(new Font("", Font.PLAIN, 14));
label_1.setText("指定查詢日期 從");
final GridBagConstraints gridBagConstraints_8 = new GridBagConstraints();
gridBagConstraints_8.anchor = GridBagConstraints.EAST;
gridBagConstraints_8.gridy = 1;
gridBagConstraints_8.gridx = 1;
getContentPane().add(label_1, gridBagConstraints_8);
startDate = new JTextField();
final GridBagConstraints gridBagConstraints_9 = new GridBagConstraints();
gridBagConstraints_9.ipadx = 70;
gridBagConstraints_9.insets = new Insets(0, 0, 0, 0);
gridBagConstraints_9.gridwidth = 3;
gridBagConstraints_9.fill = GridBagConstraints.HORIZONTAL;
gridBagConstraints_9.gridy = 1;
gridBagConstraints_9.gridx = 2;
getContentPane().add(startDate, gridBagConstraints_9);
final JLabel label_2 = new JLabel();
label_2.setFont(new Font("", Font.PLAIN, 14));
final GridBagConstraints gridBagConstraints_10 = new GridBagConstraints();
gridBagConstraints_10.gridy = 1;
gridBagConstraints_10.gridx = 5;
getContentPane().add(label_2, gridBagConstraints_10);
label_2.setText("到");
endDate = new JTextField();
endDate.addKeyListener(content.getKeyListeners()[0]);
final GridBagConstraints gridBagConstraints_11 = new GridBagConstraints();
gridBagConstraints_11.ipadx = 90;
gridBagConstraints_11.anchor = GridBagConstraints.WEST;
gridBagConstraints_11.insets = new Insets(0, 0, 0, 0);
gridBagConstraints_11.gridy = 1;
gridBagConstraints_11.gridx = 6;
getContentPane().add(endDate, gridBagConstraints_11);
final JButton button_1 = new JButton();
button_1.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
content.setText("");
List list=dao.queryObject("from TabSellDetail");
Iterator iterator=list.iterator();
updateTable(iterator);
}
});
final GridBagConstraints gridBagConstraints_5 = new GridBagConstraints();
gridBagConstraints_5.insets = new Insets(0, 0, 0, 10);
gridBagConstraints_5.gridy = 1;
gridBagConstraints_5.gridx = 7;
getContentPane().add(button_1, gridBagConstraints_5);
button_1.setFont(new Font("", Font.PLAIN, 12));
button_1.setText("顯示全部數據");
final JScrollPane scrollPane = new JScrollPane();
final GridBagConstraints gridBagConstraints_6 = new GridBagConstraints();
gridBagConstraints_6.weighty = 1.0;
gridBagConstraints_6.anchor = GridBagConstraints.NORTH;
gridBagConstraints_6.insets = new Insets(0, 10, 5, 10);
gridBagConstraints_6.fill = GridBagConstraints.BOTH;
gridBagConstraints_6.gridwidth = 9;
gridBagConstraints_6.gridy = 2;
gridBagConstraints_6.gridx = 0;
getContentPane().add(scrollPane, gridBagConstraints_6);
table = new JTable();
table.setEnabled(false);
table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
table.setShowGrid(true);
table.putClientProperty("Quaqua.Table.style", "striped");
dftm = (DefaultTableModel)table.getModel();
String[] tableHeads = new String[]{"銷售票號", "商品編號", "商品名稱", "規格", "單價",
"數量", "金額", "客戶全稱", "銷售日期", "操作員", "經手人", "結算方式"};
dftm.setColumnIdentifiers(tableHeads);
scrollPane.setViewportView(table);
}
private void updateTable(Iterator iterator) {
int rowCount=dftm.getRowCount();
for(int i=0;i<rowCount;i++) {
dftm.removeRow(0);
}
while(iterator.hasNext()) {
Vector vector=new Vector();
TabSellDetail sellDetail=(TabSellDetail)iterator.next();
vector.add(sellDetail.getTabSellMain().getSellId());
vector.add(sellDetail.getTabSpinfo().getId());
vector.add(sellDetail.getTabSpinfo().getSpname());
vector.add(sellDetail.getTabSpinfo().getGg());
vector.add(sellDetail.getDj());
vector.add(sellDetail.getSl());
vector.add(sellDetail.getDj()*sellDetail.getSl());
vector.add(sellDetail.getTabSellMain().getKhname());
vector.add(sellDetail.getTabSellMain().getXsdate());
vector.add(sellDetail.getTabSellMain().getCzy());
vector.add(sellDetail.getTabSellMain().getJsr());
vector.add(sellDetail.getTabSellMain().getJsfs());
dftm.addRow(vector);
}
}
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -