dlgfindalarm.java

实现网络GPS定位车辆的位置

package MapperClientApplet;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.table.*;
import java.util.*;
import java.net.*;
import java.io.*;



public class DlgFindAlarm extends JDialog {
  JPanel panel1 = new JPanel();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JLabel jLabel1 = new JLabel();
  public static JComboBox BeginYear = new JComboBox();
  public static JComboBox BeginMonth = new JComboBox();
  public static JComboBox BeginDay = new JComboBox();
  public static JComboBox EndYear = new JComboBox();
  public static JComboBox EndMonth = new JComboBox();
  public static JComboBox EndDay = new JComboBox();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JLabel jLabel8 = new JLabel();
  JLabel jLabel9 = new JLabel();
  public static JComboBox BeginHour = new JComboBox();
  public static JComboBox EndHour = new JComboBox();
  public static JComboBox BeginMinute = new JComboBox();
  public static JComboBox EndMinute = new JComboBox();
  JLabel jLabel10 = new JLabel();
  JLabel jLabel11 = new JLabel();
  JLabel jLabel12 = new JLabel();
  JLabel jLabel13 = new JLabel();
  public JScrollPane jScrollPaneRight = new JScrollPane();
  public final String FindAlarm_TOOL = "13";
  String m_BeginDateTime = null;
  String m_EndDateTime = null;
  String m_tool;
  String url;
  public String m_sessionURL;
  Thread FindAlarmThread;
  String Alar_CardId=null;
  JLabel lCarStatus = new JLabel();
  public static DefaultTableModel tableModel=new DefaultTableModel();
  //public Label Alar_CarStatus = new Label();

  // public PropertyEditor jTable = new PropertyEditor();
  JTable jTable = new JTable();
  public JLabel jLabel14 = new JLabel();
  GridBagLayout gridBagLayout1 = new GridBagLayout();
  //public DefaultTableModel tableModel = new DefaultTableModel();

  Vector srcdata=new Vector();

  public DlgFindAlarm(Frame frame, String title, boolean modal) {
    super(frame, title, modal);
    try {
      jbInit();
      pack();
    }
    catch (Exception ex) {

      ex.printStackTrace();
    }
  }

  public DlgFindAlarm(String tel) {
       Alar_CardId=tel;
 //   this(null, "", false);
    try
       {
       jbInit();
       pack();
        }
     catch (Exception ex)
        {

       ex.printStackTrace();
        }

  }

  private void jbInit() throws Exception {
    panel1.setLayout(gridBagLayout1);
    this.getContentPane().setLayout(null);
    jButton1.setFont(new java.awt.Font("Dialog", 0, 12));
    jButton1.setText("确   定");

    jButton1.addActionListener(new DlgFindAlarm_jButton1_actionAdapter(this));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 12));
    jButton2.setText("退   出");

    jButton2.addActionListener(new DlgFindAlarm_jButton2_actionAdapter(this));
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 14));
    jLabel1.setForeground(Color.blue);
    jLabel1.setRequestFocusEnabled(true);
    jLabel1.setHorizontalAlignment(SwingConstants.CENTER);
    jLabel1.setText("请选择报警记录起始时间");
    BeginYear.setRequestFocusEnabled(true);
    BeginYear.addActionListener(new DlgFindAlarm_BeginYear_actionAdapter(this));
    BeginMonth.setRequestFocusEnabled(true);
    BeginDay.setRequestFocusEnabled(true);
    EndYear.setRequestFocusEnabled(true);
    EndMonth.setRequestFocusEnabled(true);
    EndDay.setRequestFocusEnabled(true);
    this.setTitle("报警记录查询设置");

    jLabel2.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel2.setText("年");
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel3.setText("月");
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel4.setText("日");
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel5.setText("年");
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel6.setText("月");
    jLabel7.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel7.setText("日");
    jLabel8.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel8.setText("起始时间");
    jLabel9.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel9.setText("结束时间");
    BeginHour.setRequestFocusEnabled(true);
    EndHour.setRequestFocusEnabled(true);
    BeginMinute.setRequestFocusEnabled(true);
    EndMinute.setRequestFocusEnabled(true);
    panel1.setMinimumSize(new Dimension(500, 500));
    panel1.setOpaque(true);
    panel1.setPreferredSize(new Dimension(500, 500));
    panel1.setBounds(new Rectangle(-1, 0, 504, 397));
    jLabel10.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel10.setText("时");
    jLabel11.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel11.setText("时");
    jLabel12.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel12.setText("分");
    jLabel13.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel13.setText("分");
    jLabel14.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel14.setText("车辆报警信息:");
    ///////////////////////////////////////////////////////////////////////////////////////////
   // Alar_CarStatus.setBounds(0,MapPicHeigth-100,MapPicWidth,20);
    jLabel14.setBackground(Color.white);
    jLabel14.setForeground(Color.blue);
    //this.add(Alar_CarStatus,null);
    jScrollPaneRight.setHorizontalScrollBarPolicy(JScrollPane.
        HORIZONTAL_SCROLLBAR_AS_NEEDED);
    jScrollPaneRight.setVerticalScrollBarPolicy(JScrollPane.
                                                VERTICAL_SCROLLBAR_ALWAYS);
    jScrollPaneRight.setViewportBorder(BorderFactory.createLineBorder(Color.
        black));
    //this.add(jScrollPaneRight, null);
    jTable.setBounds(0, 180, 200, 80);
    //this.add(label1, null);

    jTable.setBorder(BorderFactory.createLoweredBevelBorder());
    jTable.setCellSelectionEnabled(true);
    //jTable.setEditable(false);
    jTable.setEnabled(true);
    jTable.setCellSelectionEnabled(false);
    //jdbTable.setTableHeader(null);
    this.setBackground(Color.magenta);



    //jTable.setModel(tableModel);

    //jTable.setRowSelectionAllowed(true);
    panel1.add(jLabel1,  new GridBagConstraints(3, 0, 5, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 32), 34, 11));
    panel1.add(EndYear,  new GridBagConstraints(1, 2, 1, 1, 1.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.HORIZONTAL, new Insets(0, 10, 0, 0), 32, 0));
    panel1.add(jLabel8,  new GridBagConstraints(0, 1, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 17, 0, 0), 0, 0));
    panel1.add(BeginYear,  new GridBagConstraints(1, 0, 1, 2, 1.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.HORIZONTAL, new Insets(24, 10, 0, 0), 32, 0));
    panel1.add(jLabel2,  new GridBagConstraints(2, 0, 1, 2, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(23, 11, 0, 0), 9, 4));
    panel1.add(BeginMonth,  new GridBagConstraints(3, 0, 1, 2, 1.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.HORIZONTAL, new Insets(24, 0, 0, 0), 29, 0));
    panel1.add(jLabel3,  new GridBagConstraints(4, 0, 1, 2, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(24, 6, 0, 0), 12, 4));
    panel1.add(BeginDay,  new GridBagConstraints(5, 0, 1, 2, 1.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.HORIZONTAL, new Insets(24, 0, 0, 0), 26, 0));
    panel1.add(jLabel4,  new GridBagConstraints(6, 0, 1, 2, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(24, 0, 0, 0), 11, 4));
    panel1.add(BeginHour,  new GridBagConstraints(7, 0, 1, 2, 1.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.HORIZONTAL, new Insets(24, 0, 0, 0), 27, 0));
    panel1.add(jLabel10,  new GridBagConstraints(8, 0, 1, 2, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(23, 6, 0, 0), 14, 5));
    panel1.add(BeginMinute,  new GridBagConstraints(9, 0, 1, 2, 1.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.HORIZONTAL, new Insets(24, 0, 0, 0), 19, 0));
    panel1.add(jLabel12,  new GridBagConstraints(10, 1, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 22), 0, 0));
    panel1.add(jLabel9,  new GridBagConstraints(0, 2, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(9, 17, 0, 0), 0, 0));
    panel1.add(jLabel5,  new GridBagConstraints(2, 2, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 11, 0, 0), 9, 4));
    panel1.add(EndMonth,  new GridBagConstraints(3, 2, 1, 1, 1.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.HORIZONTAL, new Insets(0, 0, 0, 0), 29, 0));
    panel1.add(jLabel6,  new GridBagConstraints(4, 2, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 6, 0, 0), 13, 4));
    panel1.add(EndDay,  new GridBagConstraints(5, 2, 1, 1, 1.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.HORIZONTAL, new Insets(0, 0, 0, 0), 26, 0));
    panel1.add(jLabel7,  new GridBagConstraints(6, 2, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 10, 4));
    panel1.add(EndHour,  new GridBagConstraints(7, 2, 1, 1, 1.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.HORIZONTAL, new Insets(0, 0, 0, 0), 27, 0));
    panel1.add(jLabel11,  new GridBagConstraints(8, 2, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(7, 6, 0, 0), 13, 3));
    panel1.add(EndMinute,  new GridBagConstraints(9, 2, 1, 1, 1.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.HORIZONTAL, new Insets(0, 0, 0, 0), 19, 0));
    panel1.add(jLabel13,  new GridBagConstraints(10, 2, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(9, 0, 0, 22), 0, 0));
    panel1.add(jScrollPaneRight,  new GridBagConstraints(0, 4, 11, 1, 1.0, 1.0
            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(0, 17, 0, 11), 4, -316));
    panel1.add(jLabel14,  new GridBagConstraints(0, 3, 10, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 17, 0, 0), 373, 0));
    panel1.add(jButton1,  new GridBagConstraints(1, 5, 3, 1, 0.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(14, 58, 180, 29), 3, -3));
    panel1.add(jButton2,  new GridBagConstraints(5, 5, 3, 1, 0.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(15, 26, 180, 32), 6, -4));
    jScrollPaneRight.getViewport().add(jTable, null);
    // panel1.add(jScrollPane1,     new XYConstraints(8, 248, 485, 130));
    // jScrollPane1.getViewport().add(jTable, null);
    // this.add(jScrollPaneRight,null);

    String row[] = new String[5];
    String[] columnName={"车辆ID","车主姓名","车辆牌照","报警时间","报警类型"};
    Vector cname=new Vector(5);
    cname.add(columnName[0]);
    cname.add(columnName[1]);
    cname.add(columnName[2]);
    cname.add(columnName[3]);
    cname.add(columnName[4]);
    DefaultTableModel model=new DefaultTableModel(srcdata,cname);
    jTable.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);

    jTable.setModel(model);
//dp    jTable.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
//    jTable.setRowHeaderVisible(true) ;
//    jTable.updateUI();

//          tableModel.addColumn("车辆ID");
//          tableModel.addColumn("车主姓名");
//          tableModel.addColumn("车辆牌照");
//          tableModel.addColumn("报警时间");
//          tableModel.addColumn("报警类型");
   // tableModel.addColumn("报警处理");
//      jTable.setModel(tableModel);
   // tableModel.addRow(row);
////////////////////////////////////////////////////////////////////////////////////////////////
    this.getContentPane().add(panel1, null);
    String m_temp = "0";
    int i = 0;
    for (i = 3; i <= 8; i++) {
      BeginYear.addItem("200" + i);
      EndYear.addItem("200" + i);
    }
    for (i = 1; i < 13; i++) {
      if (i < 10) {
        m_temp = "0" + i;
      }
      else {
        m_temp = String.valueOf(i).toString();
      }
      //BeginYear.addItem("test");

      BeginMonth.addItem(m_temp); //+String.valueOf(i).toString());
      EndMonth.addItem(m_temp);   //+String.valueOf(i).toString());
    }
    for (i = 1; i <= 31; i++) {
      if (i < 10) {
        m_temp = "0" + i;
      }
      else {
        m_temp = String.valueOf(i).toString();
      }
      BeginDay.addItem(m_temp); //+String.valueOf(i).toString());
      EndDay.addItem(m_temp); //+String.valueOf(i).toString());
    }
    for (i = 0; i <= 23; i++) {
      if (i < 10) {
        m_temp = "0" + i;
      }
      else {
        m_temp = String.valueOf(i).toString();
      }
      BeginHour.addItem(m_temp); //+String.valueOf(i).toString());
      EndHour.addItem(m_temp);   //+String.valueOf(i).toString());
    }
    for (i = 0; i <= 59; i++) {
      if (i < 10) {
        m_temp = "0" + i;
      }
      else {
        m_temp = String.valueOf(i).toString();
      }
      BeginMinute.addItem(m_temp); //+String.valueOf(i).toString());
      EndMinute.addItem(m_temp);   //+String.valueOf(i).toString());
    }
  }
//////end of jbinit()
  void BeginYear_actionPerformed(ActionEvent e) {

  }

  void jButton1_actionPerformed(ActionEvent e) {
    jLabel14.setText("当前选择车辆的报警信息：");  //+m_CarTel+",要操作车辆请点击相应按钮，请慎重，以免造成损失！");
    // dispose();
//    Alar_CardId=MapperClientApplet.alarm_cardid;
//    Alar_CardId="10000080";
    m_BeginDateTime = DlgFindAlarm.BeginYear.getSelectedItem().toString()
        + DlgFindAlarm.BeginMonth.getSelectedItem().toString()
        + DlgFindAlarm.BeginDay.getSelectedItem().toString()
        + DlgFindAlarm.BeginHour.getSelectedItem().toString()
        + DlgFindAlarm.BeginMinute.getSelectedItem().toString();

    m_EndDateTime = DlgFindAlarm.EndYear.getSelectedItem().toString()
        + DlgFindAlarm.EndMonth.getSelectedItem().toString()
        + DlgFindAlarm.EndDay.getSelectedItem().toString()
        + DlgFindAlarm.EndHour.getSelectedItem().toString()
        + DlgFindAlarm.EndMinute.getSelectedItem().toString();

    String url = m_sessionURL;
    m_tool = FindAlarm_TOOL;
    //Alar_CardId=MapperClientApplet.m_cardid;

    url += "?tool=" + m_tool;
    ///ALERT_INFO
    String Sql = "7#select CARDID,USER_NAME,CAR_NO,INFO_DATE,ALERT_TYPE FROM ALERT_HST where CardId='" +
        Alar_CardId + "'  and TO_CHAR(INFO_DATE,'YYYYMMDDHH24MI')>='" +
        m_BeginDateTime + "' and TO_CHAR(INFO_DATE,'YYYYMMDD HH24MI')<='" +
        m_EndDateTime + "' order by INFO_DATE";
   // System.out.println(Sql);

  ReturnS(Sql);
//    FindAlarmThread = new tcpServerFindAlarmThread (jLabel14, convertToChinese(Alar_CardId),Sql, url);
//    FindAlarmThread.start();

  }

  void jButton2_actionPerformed(ActionEvent e)
  {

    this.jTable.repaint();
    this.jTable.updateUI();
    //DlgFindAlarm.tableModel.removeRow(DlgFindAlarm.tableModel.getRowCount());
    dispose();
  }

  class DlgFindAlarm_BeginYear_actionAdapter
      implements java.awt.event.ActionListener {