package PbuliClass;
|
import java.awt.Color;
|
import java.awt.Container;
|
import java.awt.Dimension;
|
import java.awt.Font;
|
import java.awt.Toolkit;
|
import java.awt.event.ActionEvent;
|
import java.awt.event.ActionListener;
|
import java.awt.event.WindowEvent;
|
import java.awt.event.WindowListener;
|
import java.text.ParseException;
|
import java.text.SimpleDateFormat;
|
import java.util.Date;
|
import javax.swing.ButtonGroup;
|
import javax.swing.JButton;
|
import javax.swing.JFrame;
|
import javax.swing.JPanel;
|
import javax.swing.JProgressBar;
|
import javax.swing.JRadioButton;
|
|
import ColorAndFont.UIColor;
|
import ColorAndFont.buttonTitle;
|
import DataBase.DatabaseManagement;
|
import Method.GetNowTime;
|
|
|
/**µ¼³ö±í¸ñ°´Å¥*/
|
public class OutButton {
|
|
static String addtime=null;
|
static String dataName=null;
|
JlableModel choose=new JlableModel("µ¼³öÑ¡Ôñ:"); ;//¿ìËÙÑ¡Ôñ
|
JlableModel start=new JlableModel("¿ªÊ¼Ê±¼ä:"); ;//¿ìËÙÑ¡Ôñ
|
JlableModel stop=new JlableModel("½áÊøʱ¼ä:"); ;//¿ìËÙÑ¡Ôñ
|
JlableModel jl_jingdu=new JlableModel("Íê³É½ø¶ÈÏÔʾ:"); //¿ìËÙÑ¡Ôñ
|
JRadioButton all=null;
|
JRadioButton day=null;
|
JRadioButton week=null;
|
JButton start_button=null;//Ñ¡Ôñ¿ªÊ¼Ê±¼ä
|
JButton stop_button=null;//Ñ¡Ôñ½áÊøʱ¼ä
|
JButtonModel sure_button=null;//È·¶¨°´Å¥
|
JButtonModel quxiao_button=null;
|
ButtonGroup group=new ButtonGroup();
|
String startTime;//¹ì¼£²éѯ¿ªÊ¼Ê±¼ä
|
String stopTime;//¹ì¼£²éѯ¼¼Êõʱ¼ä
|
String sql;
|
static JProgressBar progressBar=null;
|
|
JPanel mb=null;//ÉêÃ÷Ò»¸öÃæ°å
|
static int size;//Ñ¡ÖеÄÊý¾ÝÌõÊý
|
boolean ok=false;
|
ChooseDialog choosed=null;
|
|
|
public JButtonModel get_ouotport_button() {
|
JButtonModel outport=null;//µ¼³ö±í¸ñ°´Å¥
|
outport=new JButtonModel(buttonTitle.getOutport());
|
outport.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
if(choosed==null) {
|
choosed=new ChooseDialog();
|
}
|
}
|
});
|
return outport;
|
}
|
|
|
|
public JButton getStart_button() {
|
if(start_button==null) {
|
start_button=new GetDate();
|
start_button.setBackground(UIColor.getNorth_color());
|
}
|
return start_button;
|
}
|
|
public JButton getStop_button() {
|
if(stop_button==null) {
|
stop_button=new GetDate();
|
stop_button.setBackground(UIColor.getNorth_color());
|
}
|
return stop_button;
|
}
|
|
public JButtonModel getSure_button() {
|
if(sure_button==null) {
|
sure_button=new JButtonModel("µ¼ ³ö");
|
sure_button.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
|
progressBar.setValue(0);
|
progressBar.setBackground(Color.pink);
|
|
if(( !all.isSelected() && !day.isSelected() && !week.isSelected())) {
|
stopTime=stop_button.getText();
|
startTime=start_button.getText();
|
if(stopTime.equals(startTime) && !all.isSelected()) {
|
ShowMessage.zidingyi("¿ªÊ¼Ê±¼ä²»ÄܵÈÓÚ½áÊøʱ¼ä£¡");
|
return;
|
}
|
|
if(getTimeDifference(stopTime,startTime)<0) {
|
ShowMessage.zidingyi("¿ªÊ¼Ê±¼äÐèÒªÔçÓÚ½áÊøʱ¼ä£¡");
|
return;
|
|
}
|
sql="SELECT * FROM "+getDataName()+" WHERE "+getAddtime()
|
+" > '"+startTime+"' and "+ getAddtime()+" < '"+stopTime+"'";
|
|
size=DatabaseManagement.serch(sql).size();
|
if(size >65535) {
|
double j=size/65535;
|
int maxPageNumber=(int) Math.ceil(j)+1;
|
ShowMessage.zidingyi("ÒÑÑ¡ÖÐ"+size+"ÌõÊý¾Ý,´óÓÚ65535Ìõ£¬½«×Ô¶¯·ÖΪ"+maxPageNumber+"¸ö±í¸ñµ¼³ö¡£");
|
ok=true;
|
}else if(size>0) {
|
ShowMessage.zidingyi("ÒÑÑ¡ÖÐ"+size+"ÌõÊý¾Ý¡£");
|
ok=true;
|
}else if(size==0) {
|
ShowMessage.zidingyi_24("ÒÑÑ¡ÖÐ"+size+"ÌõÊý¾Ý¡£");
|
ok=false;
|
return;
|
}
|
}
|
|
if((all.isSelected() || day.isSelected() || week.isSelected()) || ok) {
|
new ImExport().export(mb,sql);
|
}
|
|
day.setSelected(false);
|
all.setSelected(false);
|
week.setSelected(false);
|
ok=false;
|
|
|
|
}
|
});
|
}
|
return sure_button;
|
}
|
|
|
|
|
/**Ñ¡Ôñµ¼³öʱ¶Ô»°¿ò*/
|
class ChooseDialog extends JFrame implements WindowListener {
|
|
/**
|
*
|
*/
|
private static final long serialVersionUID = 1L;
|
|
/**»ñÈ¡¶Ô»°¿ò·½·¨
|
* @return */
|
public ChooseDialog() {
|
group.add(getDay());
|
group.add(getWeek());
|
group.add(getAll());
|
Toolkit toolkit = getToolkit();// »ñµÃ´°Ì幤¾ß°ü
|
Dimension screenSize = toolkit.getScreenSize();// »ñÈ¡ÆÁÄ»´óС
|
int width = (int) (screenSize.width* 0.5);// ¼ÆËã´°Ìåпí¶È
|
int height = (int) (screenSize.height * 0.5);// ¼ÆËã´°Ìåпí¶È
|
int x0=width-240;//´°Ìåx0×ø±ê
|
int y0=height-160;//´°Ìåy0×ø±ê
|
Container rq=getContentPane();
|
rq.add(getMb());
|
this.setTitle("Ñ¡Ôñµ¼³öʱ¼ä¶Ô»°¿ò");
|
this.setBounds(x0, y0,480,320);
|
this.setVisible(true);
|
this.setAlwaysOnTop(true);//2023.07.13 zsh ±£³Ö×ÜÊÇÖö¥
|
this.addWindowListener((WindowListener) this);
|
}
|
|
/**¹Ø±Õ¶Ô»°¿ò·½·¨*/
|
public void closeTagDialog() {
|
choosed.dispose();
|
choosed=null;
|
day.setSelected(false);
|
all.setSelected(false);
|
week.setSelected(false);
|
ok=false;
|
|
}
|
|
/**»ñÈ¡Ãæ°å*/
|
public JPanel getMb() {
|
if(mb==null){
|
mb=new JPanel();
|
mb.setLayout(null);
|
mb.setBackground(UIColor.getNorth_color());
|
|
|
start.setBounds(30, 30,80, 25);
|
getStart_button().setBounds(110, 30,180, 25);
|
|
stop.setBounds(30, 75, 80, 25);
|
getStop_button().setBounds(110, 75, 180, 25);
|
|
choose.setBounds(30, 120,140, 25);
|
getAll().setBounds(100, 120, 80, 25);
|
getDay().setBounds(180, 120,80, 25);
|
getWeek().setBounds(260, 120, 80, 25);
|
jl_jingdu.setBounds(30, 165, 100, 25);
|
getProgressBar().setBounds(130, 165, 160,25);
|
getSure_button().setBounds(130, 220,80, 25);
|
getQuxiao_button().setBounds(230, 220, 80, 25);
|
|
mb.add(getStart_button());
|
mb.add(getStop_button());
|
mb.add(start);
|
mb.add(stop);
|
mb.add(choose);
|
mb.add(all);
|
mb.add(day);
|
mb.add(week);
|
mb.add(jl_jingdu);
|
mb.add(progressBar);
|
mb.add(getSure_button() );
|
mb.add(getQuxiao_button());
|
}
|
|
return mb;
|
}
|
|
public JButtonModel getQuxiao_button() {
|
if(quxiao_button==null) {
|
quxiao_button=new JButtonModel("È¡ Ïû");
|
quxiao_button.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
|
day.setSelected(false);
|
all.setSelected(false);
|
week.setSelected(false);
|
closeTagDialog();
|
}
|
});
|
}
|
return quxiao_button;
|
}
|
|
@Override
|
public void windowOpened(WindowEvent e) {
|
// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù
|
|
}
|
|
@Override
|
public void windowClosing(WindowEvent e) {
|
// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù
|
choosed=null;
|
}
|
|
@Override
|
public void windowClosed(WindowEvent e) {
|
// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù
|
|
}
|
|
@Override
|
public void windowIconified(WindowEvent e) {
|
// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù
|
|
}
|
|
@Override
|
public void windowDeiconified(WindowEvent e) {
|
// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù
|
|
}
|
|
@Override
|
public void windowActivated(WindowEvent e) {
|
// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù
|
|
}
|
|
@Override
|
public void windowDeactivated(WindowEvent e) {
|
// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù
|
|
}
|
}
|
|
|
|
|
public static String getAddtime() {
|
return addtime;
|
}
|
|
|
|
public static String getDataName() {
|
return dataName;
|
}
|
|
|
|
public static void setAddtime(String addtime) {
|
OutButton.addtime = addtime;
|
}
|
|
|
|
public static void setDataName(String dataName) {
|
OutButton.dataName = dataName;
|
}
|
|
|
|
public static JProgressBar getProgressBar() {
|
if(progressBar==null) {
|
progressBar=new JProgressBar();
|
progressBar.setStringPainted(true);
|
progressBar.setIndeterminate(true);
|
progressBar.setFont(new Font("΢ÈíÑźÚ", Font.PLAIN, 16));
|
progressBar.setBackground(Color.pink);
|
}
|
return progressBar;
|
}
|
|
|
|
|
public JRadioButton getAll() {
|
if(all==null) {
|
all=new JRadioButton("È«²¿µ¼³ö");
|
all.setBackground(UIColor.getNorth_color());
|
all.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
if(all.isSelected()) {
|
sql="SELECT * FROM "+getDataName();
|
size=DatabaseManagement.serch(sql).size();
|
if(size >65535) {
|
double j=size/65535;
|
int maxPageNumber=(int) Math.ceil(j)+1;
|
ShowMessage.zidingyi_24("ÒÑÑ¡ÖÐ"+size+"ÌõÊý¾Ý,´óÓÚ65535Ìõ£¬½«×Ô¶¯·ÖΪ"+maxPageNumber+"¸ö±í¸ñµ¼³ö¡£");
|
ok=true;
|
}else if(size >0) {
|
ShowMessage.zidingyi_24("ÒÑÑ¡ÖÐ"+size+"ÌõÊý¾Ý¡£");
|
ok=true;
|
}else if(size==0) {
|
ShowMessage.zidingyi_24("ÒÑÑ¡ÖÐ"+size+"ÌõÊý¾Ý¡£");
|
ok=false;
|
}
|
|
}
|
|
}
|
});
|
}
|
return all;
|
}
|
|
|
|
public JRadioButton getDay() {
|
if(day==null) {
|
day=new JRadioButton("½ñÌì");
|
day.setBackground(UIColor.getNorth_color());
|
day.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
if(day.isSelected()) {
|
startTime=GetNowTime.getTimeDay(0);
|
stopTime=GetNowTime.getTimeDay(-1);
|
sql="SELECT * FROM "+getDataName()+" WHERE "+getAddtime()
|
+" > '"+stopTime+"' and "+ getAddtime()+" < '"+startTime+"'";
|
size=DatabaseManagement.serch(sql).size();
|
if(size >65535) {
|
double j=size/65535;
|
int maxPageNumber=(int) Math.ceil(j)+1;
|
ShowMessage.zidingyi_24("ÒÑÑ¡ÖÐ"+size+"ÌõÊý¾Ý,´óÓÚ65535Ìõ£¬½«×Ô¶¯·ÖΪ"+maxPageNumber+"¸ö±í¸ñµ¼³ö¡£");
|
ok=true;
|
}else if(size>0){
|
ShowMessage.zidingyi_24("ÒÑÑ¡ÖÐ"+size+"ÌõÊý¾Ý¡£");
|
ok=true;
|
}else if(size==0) {
|
ShowMessage.zidingyi_24("ÒÑÑ¡ÖÐ"+size+"ÌõÊý¾Ý¡£");
|
ok=false;
|
}
|
}
|
}
|
});
|
}
|
return day;
|
}
|
|
|
|
public JRadioButton getWeek() {
|
if(week==null) {
|
week=new JRadioButton("×î½ü7Ìì");
|
week.setBackground(UIColor.getNorth_color());
|
week.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
if(week.isSelected()) {
|
startTime=GetNowTime.getTimeDay(0);
|
stopTime=GetNowTime.getTimeDay(-7);
|
sql="SELECT * FROM "+getDataName()+" WHERE "+getAddtime()
|
+" > '"+stopTime+"' and "+ getAddtime()+" < '"+startTime+"'";
|
size=DatabaseManagement.serch(sql).size();
|
if(size >65535) {
|
double j=size/65535;
|
int maxPageNumber=(int) Math.ceil(j)+1;
|
ShowMessage.zidingyi_24("ÒÑÑ¡ÖÐ"+size+"ÌõÊý¾Ý,´óÓÚ65535Ìõ£¬½«×Ô¶¯·ÖΪ"+maxPageNumber+"¸ö±í¸ñµ¼³ö¡£");
|
ok=true;
|
}else if(size>0) {
|
ShowMessage.zidingyi_24("ÒÑÑ¡ÖÐ"+size+"ÌõÊý¾Ý¡£");
|
ok=true;
|
}else if(size==0) {
|
ShowMessage.zidingyi_24("ÒÑÑ¡ÖÐ"+size+"ÌõÊý¾Ý¡£");
|
ok=false;
|
}
|
}
|
|
}
|
});
|
}
|
return week;
|
}
|
|
|
|
public static int getSize() {
|
return size;
|
}
|
|
|
public long getTimeDifference(String strTime1,String strTime2) {
|
//¸ñʽÈÕÆÚ¸ñʽ£¬ÔÚ´ËÎÒÓõÄÊÇ"2018-01-24 19:49:50"ÕâÖÖ¸ñʽ
|
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
long cha=0;
|
try {
|
Date now = df.parse(strTime1);
|
Date date = df.parse(strTime2);
|
cha=(int) (now.getTime()-date.getTime()); //»ñȡʱ¼ä²î
|
} catch (ParseException e) {
|
e.printStackTrace();
|
}
|
return cha;
|
|
}
|
|
|
|
}
|
