frame7.java~58~

大二做的实训. 纯Java程序

package bookmanagesystem;

import java.awt.BorderLayout;
import java.util.*;
import javax.swing.JFrame;
import java.awt.Color;
import javax.swing.JLabel;
import java.awt.Rectangle;
import java.awt.Font;
import javax.swing.JTextField;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
import java.sql.SQLException;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import javax.swing.JComboBox;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Frame7 extends JFrame {
    public Frame7() {
        try {
            setBounds(300,250,400,300);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        Calendar calendar=Calendar.getInstance();
        calendar.setTime(new Date());
        getContentPane().setLayout(null);
        this.getContentPane().setBackground(new Color(0, 66, 92));
        this.setResizable(false);
        this.setTitle("修改书籍");
        this.setVisible(true);
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel1.setForeground(Color.red);
        jLabel1.setText("*");
        jLabel1.setBounds(new Rectangle(361, 55, 12, 15));
        jTextField6.setToolTipText("");
        jButton4.setText("确定");
        jButton4.addActionListener(new Frame7_jButton4_actionAdapter(this));
        jLabel8.setForeground(Color.white);
        jButton3.setText("退出");
        jButton3.addActionListener(new Frame7_jButton3_actionAdapter(this));
        jLabel7.setForeground(Color.white);
        jLabel7.setBounds(new Rectangle(57, 180, 42, 15));
        jButton2.setText("重置");
        jButton2.addActionListener(new Frame7_jButton2_actionAdapter(this));
        jButton1.setEnabled(false);
        jLabel6.setForeground(Color.white);
        jLabel5.setForeground(Color.white);
        jLabel4.setForeground(Color.white);
        jLabel4.setBounds(new Rectangle(57, 105, 42, 15));
        jLabel3.setForeground(Color.white);
        jLabel3.setBounds(new Rectangle(57, 55, 42, 15));
        jLabel2.setForeground(Color.white);
        jLabel2.setBounds(new Rectangle(57, 130, 75, 15));
        jLabel9.setForeground(Color.white);
        jButton1.addActionListener(new Frame7_jButton1_actionAdapter(this));
        jButton1.setText("更新");
        jButton2.setBounds(new Rectangle(57, 235, 70, 25));
        jButton4.setBounds(new Rectangle(134, 235, 70, 25));
        jButton1.setBounds(new Rectangle(210, 235, 70, 25));
        jButton3.setBounds(new Rectangle(284, 235, 70, 25));
        jLabel3.setText("ISBN：");
        jLabel6.setText("出版社：");
        jLabel4.setText("作者：");
        jLabel2.setText("地址：");
        jLabel8.setText("日期：");
        jLabel7.setText("价钱：");
        jLabel5.setText("评论：");
        jLabel6.setBounds(new Rectangle(57, 80, 65, 15));
        jLabel9.setText("输入ISBN号点确定，将调出此书相关信息，更改后点更新");
        jLabel9.setBounds(new Rectangle(45, 16, 312, 23));
        jLabel5.setBounds(new Rectangle(57, 155, 42, 15));
        jLabel8.setBounds(new Rectangle(57, 205, 63, 15));
        jButton4.addMouseListener(new Frame7_jButton4_mouseAdapter(this));
        jTextField1.setBounds(new Rectangle(138, 49, 216, 21));
        jTextField2.setBounds(new Rectangle(138, 74, 216, 21));
        jTextField3.setBounds(new Rectangle(138, 99, 216, 21));
        jTextField4.setBounds(new Rectangle(138, 124, 216, 21));
        jTextField7.setBounds(new Rectangle(138, 149, 216, 21));
        jTextField6.setBounds(new Rectangle(138, 174, 216, 21));
        jComboBox1.setBounds(new Rectangle(138, 197, 50, 23));
        jComboBox2.setBounds(new Rectangle(211, 197, 50, 23));
        jComboBox3.setBounds(new Rectangle(284, 197, 50, 23));
        jLabel10.setText("年");
        jLabel10.setBounds(new Rectangle(192, 205, 15, 15));
        jLabel11.setText("月");
        jLabel11.setBounds(new Rectangle(264, 205, 16, 15));
        jLabel12.setText("日");
        jLabel12.setBounds(new Rectangle(336, 205, 17, 15));
        jLabel10.setForeground(Color.white);
        jLabel11.setForeground(Color.white);
        jLabel12.setForeground(Color.white);
        jComboBox2.addActionListener(new Frame7_jComboBox2_actionAdapter(this));
        this.getContentPane().add(jTextField6);
        this.getContentPane().add(jTextField4);
        this.getContentPane().add(jTextField3);
        this.getContentPane().add(jTextField2);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jLabel7);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jLabel6);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jLabel9);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jButton4);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jButton3);
        this.getContentPane().add(jTextField7);
        this.getContentPane().add(jLabel8);
        this.getContentPane().add(jLabel5);
        this.getContentPane().add(jComboBox3);
        this.getContentPane().add(jComboBox1);
        this.getContentPane().add(jComboBox2);
        this.getContentPane().add(jLabel10);
        this.getContentPane().add(jLabel11);
        this.getContentPane().add(jLabel12);
        for(int i=1900;i<2009;i++)
        {jComboBox1.addItem(""+i);}
        for(int i=1;i<13;i++)
        {jComboBox2.addItem(""+i);}
    }

    JLabel jLabel1 = new JLabel();
    JTextField jTextField6 = new JTextField();
    JLabel jLabel2 = new JLabel();
    JButton jButton1 = new JButton();
    JTextField jTextField7 = new JTextField();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JTextField jTextField3 = new JTextField();
    JLabel jLabel6 = new JLabel();
    JTextField jTextField2 = new JTextField();
    JButton jButton2 = new JButton();
    JLabel jLabel7 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JButton jButton3 = new JButton();
    JTextField jTextField4 = new JTextField();
    JLabel jLabel8 = new JLabel();
    JButton jButton4 = new JButton();
    JLabel jLabel9 = new JLabel();
    JComboBox jComboBox1 = new JComboBox();
    JComboBox jComboBox2 = new JComboBox();
    JComboBox jComboBox3 = new JComboBox();
    JLabel jLabel10 = new JLabel();
    JLabel jLabel11 = new JLabel();
    JLabel jLabel12 = new JLabel();
    String str1,str2,str3,str4,str5,str6,str7, str100="";
    public void jButton2_actionPerformed(ActionEvent e) {
        jTextField1.setText(null);
                jTextField2.setText(null);
                jTextField3.setText(null);
                jTextField4.setText(null);
        jTextField6.setText(null);
        jTextField7.setText(null);
    }

    public void jButton3_actionPerformed(ActionEvent e) {
dispose();
    }

    public void jButton4_actionPerformed(ActionEvent e) {
        DataBaseManager dbm = new DataBaseManager();
                ResultSet rs;
        String str0="",str8="";
        if(jTextField1.getText().equals(""))
        {JOptionPane.showMessageDialog(this,"ISBN号码不能为空！","警告对话框",JOptionPane.WARNING_MESSAGE);}
        else
        {
            str1=jTextField1.getText();
            str100=str1;
            str0="SELECT * FROM books WHERE ISBN ="+"'"+str1+"'";
            try
            {
                rs=dbm.getResult(str0);
                if(rs.next())
                {
                    jLabel3.setText("书名：");
                    jTextField1.setText(rs.getString(2));
                    jTextField2.setText(rs.getString(3));
                    jTextField3.setText(rs.getString(4));
                    jTextField4.setText(rs.getString(5));
                    jTextField6.setText(rs.getString(7));
                    jTextField7.setText(rs.getString(8));
                }
                else
                {
                    JOptionPane.showMessageDialog(this,"书籍记录不存在或者ISBN号码输入错误！","信息提示",JOptionPane.INFORMATION_MESSAGE);
                    jTextField1.setText(null);
                }
            }
            catch(SQLException e7){}
            dbm.closeConnection();
        }
        if(jLabel3.getText().equals("书名："))//jLabel3.setIcon(new ImageIcon(""));
        { jButton1.setEnabled(true);
        }
    }
    public void jButton1_actionPerformed(ActionEvent e) {
        DataBaseManager dbm = new DataBaseManager();
        String str0="";
        str1=jTextField1.getText();
        str2=jTextField2.getText();
        str3=jTextField3.getText();
        str4=jTextField4.getText();
        str5=(String)jComboBox1.getSelectedItem()+"-"+(String)jComboBox2.getSelectedItem()+"-"+(String)jComboBox3.getSelectedItem();
        str6=jTextField6.getText();
        str7=jTextField7.getText();
        if(str1.equals(""))
        {JOptionPane.showMessageDialog(this,"书名不能为空！","警告对话框",JOptionPane.WARNING_MESSAGE);}
        else
        {
            str0="UPDATE books SET BookName = '"+str1+"',Press ='"+str2+"',Author='"+str3+"',Address='"+str4+"',PressDate='"+str5+"',Price='"+str6+"',Com='"+str7+"'WHERE ISBN='"+str100+"'";
            dbm.updateSql(str0);
            JOptionPane.showMessageDialog(this,"修改成功！","信息提示",JOptionPane.INFORMATION_MESSAGE);
            dispose();
            dbm.closeConnection();

        }
    }

    public void jButton4_mouseReleased(MouseEvent e) {
        if(jLabel3.getText().equals("书名："))
        {  jButton4.setEnabled(false);}

    }

    public void jComboBox2_actionPerformed(ActionEvent e) {
int i,j;
        i=jComboBox1.getSelectedIndex()+1900;
        j=jComboBox2.getSelectedIndex();
        if(j==1)
        {
            if ((i % 4 == 0 && i % 100 != 0) || (i % 400 == 0)) {
                for (int m = 1; m < 30; m++) {
                    jComboBox3.addItem("" + m);
                }
            }
            else
            {
                for(int m=1;m<29;m++)
                 {
                     jComboBox3.addItem(""+m);
                 }
             }
         }
        else if((j==3)||(j==5)||(j==8)||(j==10))
        {
            for (int m = 1; m < 31; m++) {
                jComboBox3.addItem("" + m);
            }
        }
        else
        {
            for(int m=1;m<32;m++)
           {jComboBox3.addItem(""+m);}
         }
        }
}
class Frame7_jComboBox2_actionAdapter implements ActionListener {
    private Frame7 adaptee;
    Frame7_jComboBox2_actionAdapter(Frame7 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame7_jButton1_actionAdapter implements ActionListener {
    private Frame7 adaptee;
    Frame7_jButton1_actionAdapter(Frame7 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame7_jButton4_actionAdapter implements ActionListener {
    private Frame7 adaptee;
    Frame7_jButton4_actionAdapter(Frame7 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame7_jButton4_mouseAdapter extends MouseAdapter {
    private Frame7 adaptee;
    Frame7_jButton4_mouseAdapter(Frame7 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseReleased(MouseEvent e) {
        adaptee.jButton4_mouseReleased(e);
    }
}


class Frame7_jButton3_actionAdapter implements ActionListener {
    private Frame7 adaptee;
    Frame7_jButton3_actionAdapter(Frame7 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame7_jButton2_actionAdapter implements ActionListener {
    private Frame7 adaptee;
    Frame7_jButton2_actionAdapter(Frame7 adaptee) {
        this.adaptee = adaptee;
    }

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