?? pandian.java
字號:
/*
* 創建日期 2008-4-23
*
* TODO 要更改此生成的文件的模板,請轉至
* 窗口 - 首選項 - Java - 代碼樣式 - 代碼模板
*/
package appsm.view;
import java.util.Vector;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.JButton;
import javax.swing.JLabel;
import appsm.util.RetrieveObject;
/**
* @author Administrator
*
* TODO 要更改此生成的類型注釋的模板,請轉至
* 窗口 - 首選項 - Java - 代碼樣式 - 代碼模板
*/
public class Pandian extends JFrame {
private javax.swing.JPanel jContentPane = null;
private JTextField jTextField = null;
private JTextField jTextField1 = null;
private JButton jButton = null;
private JLabel jLabel = null;
private JLabel jLabel1 = null;
/**
* This is the default constructor
*/
public Pandian() {
super();
initialize();
}
/**
* This method initializes this
*
* @return void
*/
private void initialize() {
this.setSize(412, 167);
this.setContentPane(getJContentPane());
this.setTitle("盤點");
}
/**
* This method initializes jContentPane
*
* @return javax.swing.JPanel
*/
private javax.swing.JPanel getJContentPane() {
if(jContentPane == null) {
jLabel1 = new JLabel();
jLabel = new JLabel();
jContentPane = new javax.swing.JPanel();
jContentPane.setLayout(null);
jLabel.setBounds(47, 15, 221, 21); // Generated
jLabel.setText("請輸入盤點日期:格式如2008-05-01"); // Generated
jLabel.setFont(new java.awt.Font("Dialog", java.awt.Font.PLAIN, 12)); // Generated
jLabel1.setBounds(143, 46, 40, 27); // Generated
jLabel1.setText("至"); // Generated
jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.CENTER); // Generated
jContentPane.add(getJTextField(), null); // Generated
jContentPane.add(getJTextField1(), null); // Generated
jContentPane.add(getJButton(), null); // Generated
jContentPane.add(jLabel, null); // Generated
jContentPane.add(jLabel1, null); // Generated
}
return jContentPane;
}
/**
* This method initializes jTextField
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField() {
if (jTextField == null) {
try {
jTextField = new JTextField();
jTextField.setBounds(48, 47, 90, 26); // Generated
}
catch (java.lang.Throwable e) {
// TODO: Something
}
}
return jTextField;
}
/**
* This method initializes jTextField1
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField1() {
if (jTextField1 == null) {
try {
jTextField1 = new JTextField();
jTextField1.setBounds(187, 47, 89, 26); // Generated
}
catch (java.lang.Throwable e) {
// TODO: Something
}
}
return jTextField1;
}
/**
* This method initializes jButton
*
* @return javax.swing.JButton
*/
private JButton getJButton() {
if (jButton == null) {
try {
jButton = new JButton();
jButton.setBounds(301, 48, 66, 25); // Generated
jButton.setText("盤點"); // Generated
jButton.setFont(new java.awt.Font("Dialog", java.awt.Font.PLAIN, 14)); // Generated
jButton.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
String jt1=jTextField.getText().trim();
String jt2=jTextField1.getText().trim();
String sql="select sum(goodsPrice*goodsNumber) from tb_sellHistory where cast(left(goodstime,charindex(' ' , goodstime)-1) as datetime) between '"+jt1+"' and '"+jt2+"'";
Vector vdata=null;
RetrieveObject ro=new RetrieveObject();
vdata=ro.getObjectRow(sql);
JOptionPane.showMessageDialog(null,"金額合計:"+vdata.get(0)+"");
}
});
}
catch (java.lang.Throwable e) {
// TODO: Something
}
}
return jButton;
}
} // @jve:decl-index=0:visual-constraint="10,10"
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -