createlongcarddialog.java~2~

来自「eidtplus注册码.txt eidtplus注册码.txt」· JAVA~2~ 代码 · 共 177 行

package parkingsystem;

import java.awt.*;
import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Rectangle;
import com.borland.dx.sql.dataset.*;
import com.borland.dx.sql.dataset.ConnectionDescriptor;
import com.borland.dx.sql.dataset.Load;
import com.borland.dx.sql.dataset.QueryDescriptor;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import com.borland.dbswing.JdbTextField;
import java.sql.*;

//import com.sun.jmx.snmp.*;

public class CreateLongCardDialog
    extends JDialog {
  JPanel panel1 = new JPanel();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JComboBox jComboBox1 = new JComboBox();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  QueryDataSet queryDataSet;
  Database database;
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  JdbTextField jdbTextField1 = new JdbTextField();
  JdbTextField jdbTextField2 = new JdbTextField();
  JdbTextField jdbTextField3 = new JdbTextField();

  public CreateLongCardDialog(Frame owner, String title, boolean modal,QueryDataSet queryDataSet,
  Database database) {
    super(owner, title, modal);
    this.queryDataSet=queryDataSet;
    this.database=database;
    try {
      setDefaultCloseOperation(DISPOSE_ON_CLOSE);
      jbInit();
      pack();
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }
  }

//  public CreateLongCardDialog() {
//    this(new Frame(), "CreateLongCardDialog", false);
//  }

  private void jbInit() throws Exception {
    panel1.setLayout(null);
    jLabel1.setText("卡   号：");
    jLabel1.setBounds(new Rectangle(41, 61, 96, 31));
    jLabel2.setText("密   码：");
    jLabel2.setBounds(new Rectangle(41, 114, 96, 31));
    jLabel3.setText("车 牌 号：");
    jLabel3.setBounds(new Rectangle(41, 166, 96, 31));
    jLabel4.setText("申请时长（月）：");
    jLabel4.setBounds(new Rectangle(41, 219, 96, 31));
    jLabel5.setText("应 收 费：");
    jLabel5.setBounds(new Rectangle(41, 271, 96, 31));
    jLabel6.setBounds(new Rectangle(145, 271, 152, 31));
    jLabel7.setText("填入卡的相关信息：");
    jLabel7.setBounds(new Rectangle(15, 21, 196, 19));
    jComboBox1.setBounds(new Rectangle(145, 219, 152, 38));
    jComboBox1.addActionListener(new
                                 CreateLongCardDialog_jComboBox1_actionAdapter(this));
    jButton1.setBounds(new Rectangle(46, 321, 99, 31));
    jButton1.setText("确  定");
    jButton1.addActionListener(new CreateLongCardDialog_jButton1_actionAdapter(this));
    jButton2.setBounds(new Rectangle(190, 321, 99, 31));
    jButton2.setText("取  消");
    jButton2.addActionListener(new CreateLongCardDialog_jButton2_actionAdapter(this));
    database1.setConnection(new ConnectionDescriptor(
        "jdbc:microsoft:sqlserver://Localhost:1433;DatabaseName=parkingdb",
        "sa", "123456", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
    queryDataSet1.setQuery(new QueryDescriptor(database1,
        "select Price from cardType where CardType=\'长期卡\'", null, true,
                                               Load.ALL));
    jdbTextField1.setColumnName("CardID");
    jdbTextField1.setDataSet(queryDataSet);
    jdbTextField1.setBounds(new Rectangle(145, 62, 152, 33));
    jdbTextField2.setColumnName("Password");
    jdbTextField2.setDataSet(queryDataSet);
    jdbTextField2.setBounds(new Rectangle(145, 114, 152, 33));
    jdbTextField3.setColumnName("CarNum");
    jdbTextField3.setDataSet(queryDataSet);
    jdbTextField3.setBounds(new Rectangle(145, 166, 152, 33));
    getContentPane().add(panel1);
    panel1.add(jLabel7);
    panel1.add(jLabel5);
    panel1.add(jLabel1, null);
    panel1.add(jLabel2);
    panel1.add(jLabel3);
    panel1.add(jLabel4);
    panel1.add(jLabel6);
    panel1.add(jComboBox1);
    panel1.add(jButton1);
    panel1.add(jButton2);
    panel1.add(jdbTextField1);
    panel1.add(jdbTextField3);
    panel1.add(jdbTextField2);
    for(int i=1;i<=12;i++){
      jComboBox1.addItem(i+"");
    }
    queryDataSet.last();
    queryDataSet.insertRow(false);
    queryDataSet.setString("CardTypw","长期卡");
  }

  public void jComboBox1_actionPerformed(ActionEvent e) {
    queryDataSet1.open();
    int month=Integer.parseInt(jComboBox1.getSelectedItem().toString());
    double money=queryDataSet1.getBigDecimal("Price").doubleValue()*month;
    jLabel6.setText(money+"");
    queryDataSet1.close();
    java.util.Date now=new java.util.Date();
    Timestamp t =new Timestamp(now.getTime());
    t.setMonth(t.getMonth()+Integer.parseInt(jComboBox1.getSelectedItem().toString()));
    queryDataSet.setTimestamp("TimeLimit",t);
  }

  public void jButton1_actionPerformed(ActionEvent actionEvent) {
    database.saveChanges(queryDataSet);
  }

  public void jButton2_actionPerformed(ActionEvent actionEvent) {
    queryDataSet.refresh();
    queryDataSet.last();
    queryDataSet.insertRow(false);
  }
}

class CreateLongCardDialog_jButton2_actionAdapter
    implements ActionListener {
  private CreateLongCardDialog adaptee;
  CreateLongCardDialog_jButton2_actionAdapter(CreateLongCardDialog adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent actionEvent) {
    adaptee.jButton2_actionPerformed(actionEvent);
  }
}

class CreateLongCardDialog_jButton1_actionAdapter
    implements ActionListener {
  private CreateLongCardDialog adaptee;
  CreateLongCardDialog_jButton1_actionAdapter(CreateLongCardDialog adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent actionEvent) {
    adaptee.jButton1_actionPerformed(actionEvent);
  }
}

class CreateLongCardDialog_jComboBox1_actionAdapter
    implements ActionListener {
  private CreateLongCardDialog adaptee;
  CreateLongCardDialog_jComboBox1_actionAdapter(CreateLongCardDialog adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox1_actionPerformed(e);
  }
}