?? caigouchaxun.java
字號(hào):
package internalFrame.caiGouGuanLi;
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.util.Date;
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.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 org.springframework.beans.BeansException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;
import dao.UserDAO;
import model.TabCgdan;
public class CaiGouChaXun extends JInternalFrame
implements
ApplicationContextAware {
private JTextField endDate;
private JTextField beginDate;
private JTable table;
private JTextField conditionContent;
private JComboBox conditionOperation;
private JComboBox conditionName;
private ApplicationContext appContext;
private UserDAO dao;
public void setApplicationContext(ApplicationContext app)
throws BeansException {
appContext = app;
dao = (UserDAO) appContext.getBean("DAOProxyTransactionFactory");
}
public CaiGouChaXun() {
addInternalFrameListener(new InternalFrameAdapter() {
public void internalFrameActivated(final InternalFrameEvent e) {
Date date = new Date();
String year = (date.getYear() + 1900) + "";
String month = "-" + (date.getMonth() + 1);
String day = "-" + (date.getDate());
beginDate.setText(year + "-01-01");
endDate.setText(year + month + day);
}
});
setMaximizable(true);
setIconifiable(true);
setClosable(true);
setTitle("采購(gòu)查詢(xún)");
getContentPane().setLayout(new GridBagLayout());
setBounds(100, 100, 609, 375);
final JScrollPane scrollPane = new JScrollPane();
scrollPane.setAutoscrolls(true);
final GridBagConstraints gridBagConstraints_6 = new GridBagConstraints();
gridBagConstraints_6.weighty = 1.0;
gridBagConstraints_6.anchor = GridBagConstraints.NORTH;
gridBagConstraints_6.insets = new Insets(0, 10, 0, 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");
final DefaultTableModel dftm = (DefaultTableModel) table.getModel();
String[] tableHeads = new String[]{"采購(gòu)單號(hào)", "商品名稱(chēng)", "廠商", "規(guī)格", "包裝",
"單位", "數(shù)量", "單價(jià)", "金額", "采購(gòu)日期", "備注"};
dftm.setColumnIdentifiers(tableHeads);
scrollPane.setViewportView(table);
final JLabel label = new JLabel();
label.setFont(new Font("", Font.PLAIN, 14));
label.setText(" 選擇查詢(xún)條件：");
final GridBagConstraints gridBagConstraints = new GridBagConstraints();
gridBagConstraints.gridy = 0;
gridBagConstraints.gridx = 0;
getContentPane().add(label, gridBagConstraints);
conditionName = new JComboBox();
conditionName.setModel(new DefaultComboBoxModel(new String[]{"商品名稱(chēng)"}));
conditionName.setFont(new Font("", Font.PLAIN, 14));
final GridBagConstraints gridBagConstraints_1 = new GridBagConstraints();
gridBagConstraints_1.gridy = 0;
gridBagConstraints_1.gridx = 1;
getContentPane().add(conditionName, gridBagConstraints_1);
conditionOperation = new JComboBox();
conditionOperation.setModel(new DefaultComboBoxModel(new String[]{"等于",
"包含"}));
conditionOperation.setFont(new Font("", Font.PLAIN, 14));
final GridBagConstraints gridBagConstraints_2 = new GridBagConstraints();
gridBagConstraints_2.gridy = 0;
gridBagConstraints_2.gridx = 4;
getContentPane().add(conditionOperation, gridBagConstraints_2);
conditionContent = new JTextField();
conditionContent.setFont(new Font("", Font.PLAIN, 14));
final GridBagConstraints gridBagConstraints_3 = new GridBagConstraints();
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 = 6;
getContentPane().add(conditionContent, gridBagConstraints_3);
final JCheckBox setupQueryDate = new JCheckBox();
setupQueryDate.setFont(new Font("", Font.PLAIN, 14));
setupQueryDate.setText("指定查詢(xún)?nèi)掌?quot;);
final GridBagConstraints gridBagConstraints_7 = new GridBagConstraints();
gridBagConstraints_7.gridy = 1;
gridBagConstraints_7.gridx = 0;
getContentPane().add(setupQueryDate, 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);
beginDate = 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(beginDate, 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();
final GridBagConstraints gridBagConstraints_11 = new GridBagConstraints();
gridBagConstraints_11.anchor = GridBagConstraints.WEST;
gridBagConstraints_11.insets = new Insets(0, 0, 0, 110);
gridBagConstraints_11.fill = GridBagConstraints.HORIZONTAL;
gridBagConstraints_11.gridy = 1;
gridBagConstraints_11.gridx = 6;
getContentPane().add(endDate, gridBagConstraints_11);
final JButton showAllButton = new JButton();
showAllButton.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
conditionContent.setText("");
List list = dao.queryObject("from TabCgdan");
updateTable(list, dftm);
}
});
final GridBagConstraints gridBagConstraints_5 = new GridBagConstraints();
gridBagConstraints_5.gridy = 1;
gridBagConstraints_5.gridx = 7;
getContentPane().add(showAllButton, gridBagConstraints_5);
showAllButton.setFont(new Font("", Font.PLAIN, 12));
showAllButton.setText("顯示全部數(shù)據(jù)");
final JButton queryButton = new JButton();
queryButton.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
String conOperation, content, beginTime, endTime;
List list;
conOperation = conditionOperation.getSelectedItem().toString();
content = conditionContent.getText().trim();
beginTime = beginDate.getText().trim();
endTime = getMaxDate(endDate.getText());
if (setupQueryDate.isSelected()) {
System.out.println(conOperation);
if (conOperation.equals("等于")) {
String sql = "from TabCgdan where id.spname='"
+ content + "' and id.cgdate>'" + beginTime
+ "' and id.cgdate<'" + endTime + "'";
list = dao.queryObject(sql);
System.out.println(sql);
System.out.println(list.size());
} else
list = dao
.queryObject("from TabCgdan where id.spname like '%"
+ content
+ "%' and id.cgdate>'"
+ beginTime
+ "' and id.cgdate<'"
+ endTime + "'");
} else {
if (conOperation.equals("等于"))
list = dao
.queryObject("from TabCgdan where id.spname='"
+ content + "'");
else
list = dao
.queryObject("from TabCgdan where id.spname like '%"
+ content + "%'");
}
updateTable(list, dftm);
}
});
final GridBagConstraints gridBagConstraints_4 = new GridBagConstraints();
gridBagConstraints_4.gridy = 0;
gridBagConstraints_4.gridx = 7;
getContentPane().add(queryButton, gridBagConstraints_4);
queryButton.setFont(new Font("", Font.PLAIN, 12));
queryButton.setText("查詢(xún)");
}
private void updateTable(List list, final DefaultTableModel dftm) {
int num = dftm.getRowCount();
for (int i = 0; i < num; i++)
dftm.removeRow(0);
if (list == null)
return;
Iterator iterator = list.iterator();
TabCgdan cgInfo;
while (iterator.hasNext()) {
cgInfo = (TabCgdan) iterator.next();
Vector rowData = new Vector();
rowData.add(cgInfo.getId().trim());
rowData.add(cgInfo.getSpname().trim());
rowData.add(cgInfo.getCs().trim());
rowData.add(cgInfo.getGg().trim());
rowData.add(cgInfo.getBz().trim());
rowData.add(cgInfo.getDw().trim());
rowData.add(cgInfo.getSl().trim());
rowData.add(cgInfo.getDj().trim());
rowData.add(cgInfo.getJe().trim());
rowData.add(cgInfo.getCgdate().toLocaleString());
rowData.add(cgInfo.getMemo().trim());
dftm.addRow(rowData);
}
}
private String getMaxDate(String str) {
str = str.trim();
str = str.replaceAll("-", "/");
Date d = new Date(str);
d.setDate(d.getDate() + 1);
return d.toLocaleString();
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -