/**
*
*/
package com.cs.from;
import java.awt.Font;
import java.awt.Frame;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Vector;
import javax.swing.BorderFactory;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JDialog;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.JTableHeader;
import com.cs.means.SelectEarning;
import com.cs.tools.DateChooser;
import com.cs.tools.FromTool;
/**
* 用来计算总的捐赠金额
* @author ahtam
* @time 2019年9月31日
* @copyRight ahtam
*/
public class CalcDonation extends JDialog{
JPanel jP = new JPanel();
JLabel jL2 = new JLabel();
JLabel jL3 = new JLabel();
JLabel jL4 = new JLabel();
JLabel jL5 = new JLabel();
JLabel jL6 = new JLabel();
JLabel jL7 = new JLabel();
JLabel jL8 = new JLabel();
JLabel jL9 = new JLabel();
JButton jButton_OK = new JButton();
final DateChooser start=new DateChooser();
final DateChooser end=new DateChooser();
JLabel jL15 = new JLabel();
JLabel jL16 = new JLabel();
public CalcDonation(Frame owner, String title, boolean modal) {
super(owner, title, modal);
try {
setDefaultCloseOperation(DISPOSE_ON_CLOSE);
jbInit();
pack();
} catch (Exception exception) {
exception.printStackTrace();
}
}
public CalcDonation() {
this(new Frame(), "捐赠总额查询", false);
this.setSize(430,200);
this.setLocation(FromTool.getLocX(430), FromTool.getLocY(200));
}
private void jbInit() throws Exception {
jP.setLayout(null);
jL2.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
jL2.setText("起始日期");
jL2.setBounds(new Rectangle(36, 31, 66, 20));
start.setBounds(new Rectangle(101, 31, 120,20));
jL6.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
jL6.setText("结束日期");
jL6.setBounds(new Rectangle(36, 62, 67, 20));
end.setBounds(new Rectangle(101, 62,120, 20));
jButton_OK.setBounds(new Rectangle(270, 46, 63, 24));
jButton_OK.setText("确定");
jButton_OK.addActionListener(new jB_OK_actionAdapter(this));
jL15.setFont(new java.awt.Font("宋体", Font.BOLD, 30));
jL15.setText("捐赠总额:");
jL15.setBounds(new Rectangle(36,100, 176, 47));
jL16.setFont(new java.awt.Font("宋体", Font.BOLD, 30));
jL16.setBorder(BorderFactory.createEtchedBorder());
jL16.setBounds(new Rectangle(215, 100, 183, 46));
getContentPane().add(jP);
jP.add(jL2);
jP.add(start);
jP.add(jL6);
jP.add(end);
jP.add(jButton_OK);
jP.add(jL15);
jP.add(jL16);
}
public void jButton_OK_actionPerformed(ActionEvent e) {
String str1=start.date().substring(0,10); //得取起始日期年月日
String str2=end.date().substring(0,10); //得到结束日期年月日
String s1=str1.substring(0, 4)+str1.substring(5, 7)+str1.substring(8, 10);
String s2=str2.substring(0, 4)+str2.substring(5, 7)+str2.substring(8, 10);
String result=SelectEarning.allDonation(str1, str2);//2019-02-21
if(Integer.valueOf(s2)-Integer.valueOf(s1)<0){
JOptionPane.showMessageDialog(this, "请注意起始/结束日期", "提示",
JOptionPane.ERROR_MESSAGE);
return;
}
if(result==null)JOptionPane.showMessageDialog(this, "数据库异常", "提示",JOptionPane.ERROR_MESSAGE);
else {
jL16.setText(result);
return ;
}
}
}
class jB_OK_actionAdapter implements ActionListener {
private CalcDonation adaptee;
jB_OK_actionAdapter(CalcDonation adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton_OK_actionPerformed(e);
}
}
一键复制
编辑
Web IDE
原始数据
按行查看
历史