cardextenddialog.java~1~
来自「eidtplus注册码.txt eidtplus注册码.txt」· JAVA~1~ 代码 · 共 165 行
JAVA~1~
165 行
package parkingsystem;
import java.awt.*;
import javax.swing.*;
import java.awt.Rectangle;
import java.awt.BorderLayout;
import com.borland.dbswing.JdbTextField;
import java.sql.*;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.QueryDataSet;
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;
public class CardExtendDialog
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();
JButton jButton1 = new JButton();
JButton jButton2 = new JButton();
JComboBox jComboBox1 = new JComboBox();
JdbTextField jdbTextField1 = new JdbTextField();
Timestamp timeLimit;
QueryDataSet queryDataSet;
Database database;
Database database1 = new Database();
QueryDataSet queryDataSet1 = new QueryDataSet();
public CardExtendDialog(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 CardExtendDialog() {
// this(new Frame(), "CardExtendDialog", false);
// }
private void jbInit() throws Exception {
panel1.setLayout(null);
jLabel1.setText("卡 号:");
jLabel1.setBounds(new Rectangle(57, 39, 88, 26));
jLabel2.setText("有 效 期:");
jLabel2.setBounds(new Rectangle(57, 87, 88, 26));
jLabel3.setText("续期时长:");
jLabel3.setBounds(new Rectangle(57, 135, 88, 26));
jLabel4.setText("应 收 费:");
jLabel4.setBounds(new Rectangle(57, 183, 88, 26));
jLabel5.setBounds(new Rectangle(164, 87, 141, 26));
jLabel6.setBounds(new Rectangle(164, 183, 141, 26));
jButton1.setBounds(new Rectangle(52, 238, 105, 29));
jButton1.setText("确 定");
jButton1.addActionListener(new CardExtendDialog_jButton1_actionAdapter(this));
jButton2.setBounds(new Rectangle(209, 238, 105, 29));
jButton2.setText("取 消");
jButton2.addActionListener(new CardExtendDialog_jButton2_actionAdapter(this));
jComboBox1.setBounds(new Rectangle(164, 135, 141, 26));
jComboBox1.addActionListener(new CardExtendDialog_jComboBox1_actionAdapter(this));
jdbTextField1.setEditable(false);
jdbTextField1.setColumnName("CardID");
jdbTextField1.setBounds(new Rectangle(164, 39, 141, 26));
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));
panel1.add(jLabel6);
panel1.add(jLabel5);
panel1.add(jLabel4);
panel1.add(jLabel3);
panel1.add(jLabel2);
panel1.add(jLabel1);
panel1.add(jButton1);
panel1.add(jButton2);
panel1.add(jComboBox1);
panel1.add(jdbTextField1);
this.getContentPane().add(panel1, java.awt.BorderLayout.CENTER);
for(int i=1;i<=12;i++){
jComboBox1.addItem(i+"");
}
jdbTextField1.setDataSet(queryDataSet);
timeLimit=queryDataSet.getTimestamp("TimeLimit");
jLabel5.setText(timeLimit.toString());
}
public void jComboBox1_actionPerformed(ActionEvent e) {
int month=Integer.parseInt(jComboBox1.getSelectedItem().toString());
queryDataSet1.open();
double money=queryDataSet1.getBigDecimal("Price").doubleValue()*month;
jLabel6.setText(money+"");
}
public void jButton1_actionPerformed(ActionEvent actionEvent) {
java.util.Date now=new java.util.Date();
Timestamp timeNow=new Timestamp(now.getTime());
int month=Integer.parseInt(jComboBox1.getSelectedItem().toString());
if(timeLimit.after(timeNow)){
timeLimit.setMonth(timeLimit.getMonth()+month);
queryDataSet.setTimestamp("TimeLimit",timeLimit);
}else {
timeNow.setMonth(timeNow.getMonth()+month);
queryDataSet.setTimestamp("TimeLimit",timeLimit);
}
queryDataSet.saveChanges();
}
public void jButton2_actionPerformed(ActionEvent actionEvent) {
queryDataSet.refresh();
jComboBox1.setSelectedIndex(0);
}
}
class CardExtendDialog_jButton2_actionAdapter
implements ActionListener {
private CardExtendDialog adaptee;
CardExtendDialog_jButton2_actionAdapter(CardExtendDialog adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent actionEvent) {
adaptee.jButton2_actionPerformed(actionEvent);
}
}
class CardExtendDialog_jButton1_actionAdapter
implements ActionListener {
private CardExtendDialog adaptee;
CardExtendDialog_jButton1_actionAdapter(CardExtendDialog adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent actionEvent) {
adaptee.jButton1_actionPerformed(actionEvent);
}
}
class CardExtendDialog_jComboBox1_actionAdapter
implements ActionListener {
private CardExtendDialog adaptee;
CardExtendDialog_jComboBox1_actionAdapter(CardExtendDialog adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jComboBox1_actionPerformed(e);
}
}
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?