📄 cdmanage.java
字号:
//光盘管理面板
package client;
import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.*;
import com.borland.dbswing.DBDisposeMonitor;
import server.action.BusinessAction;
import server.entity.Card;
import server.entity.Cd;
import server.dao.Cddao;
import java.util.Vector;
public class Cdmanage extends JPanel{
//创建面板
JTabbedPane cdtab = new JTabbedPane();
JPanel pnlout=new JPanel();
JPanel pnlin=new JPanel();
JTextField txfcdoutcardid = new JTextField("");
JPasswordField txfcdoutcardpwd = new JPasswordField("");
JLabel jLabel1 = new JLabel("客户密码:");
JLabel jLabel2 = new JLabel("客户卡号:");
Database database1 = new Database();
QueryDataSet queryDataSet1 = new QueryDataSet();
DBDisposeMonitor dBDisposeMonitor1 = new DBDisposeMonitor(); //构造函数
JButton btncdoutok = new JButton();
JButton btncdoutclear = new JButton();
JLabel lblcdoutpic = new JLabel(new ImageIcon(".\\pic\\cdmanager\\cdout.jpg"));
JLabel lblcdinpic = new JLabel(new ImageIcon(".\\pic\\cdmanager\\cdin.jpg"));
JTextField txfcdincdid = new JTextField("");
JLabel jLabel3 = new JLabel("客户卡号:");
JButton btncdinclear = new JButton();
JButton btncdinok = new JButton();
JLabel lnlcdoutinf1 = new JLabel();
JLabel jLabel5 = new JLabel("客户密码:");
JTextField txfcdoutcdid = new JTextField("");
JTextField txfcdincardid = new JTextField("");
JLabel jLabel4 = new JLabel("客户卡号:");
JLabel jLabel7 = new JLabel();
JLabel lnlcdininf1 = new JLabel();
JTextField jTextField1 = new JTextField("");
JTextField txfcdinusername = new JTextField("");
JLabel jLabel6 = new JLabel("客户卡号:");
JLabel lnlcdininf2 = new JLabel();
JLabel lnlcdininf3 = new JLabel();
JLabel lnlcdoutinf3 = new JLabel();
JLabel lnlcdoutinf2 = new JLabel();
JLabel backpic = new JLabel(new ImageIcon(".\\pic\\mainback.jpg"));
public Cdmanage() {
try {
jbInit();
} catch (Exception ex) {
ex.printStackTrace();
}
}
//组建构造
private void jbInit() throws Exception
{
txfcdoutcardid.setBounds(new Rectangle(162, 60, 105, 25));
pnlout.setLayout(null);
this.setLayout(null);
this.setSize(794,473);
cdtab.setBounds(new Rectangle(115, 60, 570,310));
cdtab.setFont(new Font("宋体",0,12));
txfcdoutcardid.setText("");
jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
jLabel1.setBounds(new Rectangle(74, 103, 62, 31));
jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
jLabel2.setBounds(new Rectangle(74, 57, 62, 31));
txfcdoutcardpwd.setBounds(new Rectangle(162, 106, 105, 25));
database1.setConnection(new ConnectionDescriptor("jdbc:odbc:mrs", "","", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
database1.setDatabaseName("");
queryDataSet1.setReadOnly(true);
queryDataSet1.setSchemaName("");
queryDataSet1.setTableName("");
queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from cd\n\n", null, true, Load.ALL));
btncdoutok.setBounds(new Rectangle(72, 229, 83, 32));
btncdoutok.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
btncdoutok.setText("借 出");
btncdoutok.addActionListener(new Cdmanage_btncdoutok_actionAdapter(this));
btncdoutclear.setBounds(new Rectangle(186, 229, 83, 32));
btncdoutclear.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
btncdoutclear.setText("重 置");
btncdoutclear.addActionListener(new Cdmanage_btncdoutclear_actionAdapter(this));
lblcdoutpic.setBackground(Color.white);
lblcdoutpic.setText("");
lblcdoutpic.setBounds(new Rectangle(0, 0, 569, 289));
lblcdinpic.setBounds(new Rectangle(0, 0, 569, 289));
pnlin.setLayout(null);
txfcdincdid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
txfcdincdid.setBounds(new Rectangle(162, 60, 105, 25));
jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
jLabel3.setText("客户卡号:");
jLabel3.setBounds(new Rectangle(74, 103, 62, 31));
btncdinclear.setBounds(new Rectangle(186, 229, 83, 32));
btncdinclear.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
btncdinclear.setText("重 置");
btncdinclear.addActionListener(new Cdmanage_btncdinclear_actionAdapter(this));
btncdinok.setBounds(new Rectangle(72, 229, 83, 32));
btncdinok.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
btncdinok.setText("归 还");
btncdinok.addActionListener(new Cdmanage_btncdinok_actionAdapter(this));
lnlcdoutinf1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
lnlcdoutinf1.setText("");
lnlcdoutinf1.setBounds(new Rectangle(301, 58, 223, 20));
jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
jLabel5.setText("光盘编号:");
jLabel5.setBounds(new Rectangle(74, 152, 62, 31));
txfcdoutcdid.setBounds(new Rectangle(162, 155, 65, 25));
txfcdincardid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
txfcdincardid.setEditable(false);
txfcdincardid.setText("");
txfcdincardid.setBounds(new Rectangle(162, 106, 105, 25));
jLabel4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
jLabel4.setText("碟片编号:");
jLabel4.setBounds(new Rectangle(74, 57, 62, 31));
jLabel7.setText("jLabel7");
jLabel7.setBounds(new Rectangle(0, 0, 34, 16));
lnlcdininf1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
lnlcdininf1.setText("");
lnlcdininf1.setBounds(new Rectangle(301, 58, 223, 20));
jTextField1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
jTextField1.setEditable(false);
jTextField1.setBounds(new Rectangle(162, 106, 105, 25));
txfcdinusername.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
txfcdinusername.setEditable(false);
txfcdinusername.setBounds(new Rectangle(162, 154,105, 25));
jLabel6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
jLabel6.setText("客户姓名:");
jLabel6.setBounds(new Rectangle(74, 151, 62, 31));
lnlcdininf2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
lnlcdininf2.setBounds(new Rectangle(301, 80, 223, 20));
lnlcdininf3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
lnlcdininf3.setText("");
lnlcdininf3.setBounds(new Rectangle(301, 102, 223, 20));
lnlcdoutinf3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
lnlcdoutinf3.setBounds(new Rectangle(301, 102, 223, 20));
lnlcdoutinf2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
lnlcdoutinf2.setText("");
lnlcdoutinf2.setBounds(new Rectangle(301, 80, 223, 20));
backpic.setBounds(new Rectangle(0, 0, 796, 476));
pnlout.setBackground(new Color(236, 233, 228));
pnlout.add(jLabel2);
pnlout.add(txfcdoutcardid);
pnlout.add(lnlcdoutinf1);
pnlout.add(btncdoutok);
pnlout.add(btncdoutclear);
pnlout.add(txfcdoutcardpwd);
pnlout.add(jLabel1);
pnlout.add(jLabel5);
pnlout.add(txfcdoutcdid);
pnlout.add(lnlcdoutinf3);
pnlout.add(lnlcdoutinf2);
pnlout.add(lblcdoutpic);
pnlin.add(btncdinclear);
pnlin.add(btncdinok);
pnlin.add(txfcdincdid);
pnlin.add(txfcdincardid);
pnlin.add(jLabel4);
pnlin.add(jLabel3);
cdtab.add(pnlout, "光碟借出");
cdtab.add(pnlin, "光碟归还");
this.add(cdtab);
this.add(backpic);
pnlin.add(lnlcdininf1);
pnlin.add(jTextField1);
pnlin.add(txfcdinusername);
pnlin.add(jLabel6);
pnlin.add(lnlcdininf3);
pnlin.add(lnlcdininf2);
pnlin.add(lblcdinpic);
}
//cdout重置按钮动作
public void btncdoutclear_actionPerformed(ActionEvent e) {
txfcdoutcardid.setText("");
txfcdoutcardpwd.setText("");
txfcdoutcdid.setText("");
lnlcdoutinf1.setText("请填写卡号和密码。");
lnlcdoutinf2.setText("");
lnlcdoutinf3.setText("");
}
//cdout确定按钮动作
public void btncdoutok_actionPerformed(ActionEvent e) {
//初始化信息
lnlcdoutinf1.setText("");
lnlcdoutinf2.setText("");
lnlcdoutinf3.setText("");
//健壮性检查
if(txfcdoutcardid.getText().equals("") || new String(txfcdoutcardpwd.getPassword()).equals("")|| txfcdoutcdid.getText().equals(""))
{
lnlcdoutinf1.setText("请填写完整信息!");}
else
{
//得到必要的信息
Card card=new Card();
card.setcardid(txfcdoutcardid.getText());
card.setcardpwd(new String(txfcdoutcardpwd.getPassword()));
Cd cd=new Cd();
cd.setcdid(txfcdoutcdid.getText());
//调用借出业务
int cdout=BusinessAction.cdout(card,cd);
switch(cdout)
{
case 1:
//客户帐户或密码无效
lnlcdoutinf1.setText("客户名或密码无效!");
break;
case 2:
//光碟编号无效
lnlcdoutinf1.setText("光碟编号无效!");
break;
case 3:
//客户帐户借出数量达到上限
lnlcdoutinf1.setText("客户借阅的碟片数量已经达到上限。");
break;
case 4:
//客户剩余的可借碟数为0
lnlcdoutinf1.setText("客户不能再借阅碟片,请充值!");
break;
case 5:
//碟片不在铺
lnlcdoutinf1.setText("该碟片已借出,请换其他碟片!");
break;
case 6:
//碟片借出操作
Vector veccdoutinf=BusinessAction.showcdoutinf(cd);
lnlcdoutinf2.setText("《"+veccdoutinf.elementAt(0)+"》");
lnlcdoutinf3.setText("类型:"+veccdoutinf.elementAt(1)+" 分类:"+veccdoutinf.elementAt(2));
lnlcdoutinf1.setText("客户"+veccdoutinf.elementAt(3)+"借出碟片:");
break;
}
}
}
//cdin重置按钮动作
public void btncdinclear_actionPerformed(ActionEvent e) {
txfcdincdid.setText("");
txfcdincardid.setText("");
txfcdinusername.setText("");
lnlcdininf1.setText("");
lnlcdininf2.setText("");
lnlcdininf3.setText("");
}
//cdin确定按钮动作
public void btncdinok_actionPerformed(ActionEvent e) {
//初始化信息
lnlcdininf1.setText("");
lnlcdininf2.setText("");
lnlcdininf3.setText("");
txfcdincardid.setText("");
txfcdinusername.setText("");
Vector vecinf=new Vector();
//健壮性检查
if(txfcdincdid.getText().equals(""))
{
lnlcdininf1.setText("请输入碟片编号!");}
else
{
//得到必要的信息
Cd cd=new Cd();
cd.setcdid(txfcdincdid.getText());
//调用归还业务
int cdin=BusinessAction.cdin(cd);
switch (cdin)
{
case 1:
//碟片编号的无效
lnlcdininf1.setText("没有该碟片编号,请重新输入!");
break;
case 2:
//碟片未曾借出
lnlcdininf1.setText("碟片未曾借出,请检查!");
break;
case 3:
//碟片借出超期,显示相关信息
vecinf=BusinessAction.showcdininf(cd,1);
lnlcdininf1.setText("碟片超期,请交罚款"+vecinf.elementAt(5)+"元!");
lnlcdininf2.setText("碟片《"+vecinf.elementAt(0)+"》");
lnlcdininf3.setText("类型:"+vecinf.elementAt(1)+" 分类:"+vecinf.elementAt(2));
txfcdincardid.setText(vecinf.elementAt(3).toString());
txfcdinusername.setText(vecinf.elementAt(4).toString());
break;
case 4:
//碟片归还操作
lnlcdininf1.setText("碟片归还完毕,谢谢观赏!");
//显示相关信息
vecinf=BusinessAction.showcdininf(cd,0);
lnlcdininf2.setText("碟片《"+vecinf.elementAt(0)+"》");
lnlcdininf3.setText("类型:"+vecinf.elementAt(1)+" 分类:"+vecinf.elementAt(2));
txfcdincardid.setText(vecinf.elementAt(3).toString());
txfcdinusername.setText(vecinf.elementAt(4).toString());
}
}
}
}
class Cdmanage_btncdinok_actionAdapter implements ActionListener {
private Cdmanage adaptee;
Cdmanage_btncdinok_actionAdapter(Cdmanage adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.btncdinok_actionPerformed(e);
}
}
class Cdmanage_btncdinclear_actionAdapter implements ActionListener {
private Cdmanage adaptee;
Cdmanage_btncdinclear_actionAdapter(Cdmanage adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.btncdinclear_actionPerformed(e);
}
}
class Cdmanage_btncdoutok_actionAdapter implements ActionListener {
private Cdmanage adaptee;
Cdmanage_btncdoutok_actionAdapter(Cdmanage adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.btncdoutok_actionPerformed(e);
}
}
class Cdmanage_btncdoutclear_actionAdapter implements ActionListener {
private Cdmanage adaptee;
Cdmanage_btncdoutclear_actionAdapter(Cdmanage adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.btncdoutclear_actionPerformed(e);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -