frame6.java~45~

大二做的实训. 纯Java程序

package bookmanagesystem;

import java.awt.BorderLayout;
import java.sql.*;
import javax.swing.JFrame;
import java.awt.Color;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JTextField;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.Font;
import javax.swing.JOptionPane;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.*;
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 Frame6 extends JFrame {
    public Frame6() {
        try {
            setBounds(300,250,400,300);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        Calendar calendar=Calendar.getInstance();
        getContentPane().setLayout(null);
        this.getContentPane().setBackground(new Color(0, 66, 92));
        this.setResizable(false);
        this.setTitle("添加书籍");
        this.setVisible(true);
        jLabel1.setForeground(Color.white);
        jLabel1.setText("书名：");
        jLabel1.setBounds(new Rectangle(57, 25, 42, 15));
        jButton3.addActionListener(new Frame6_jButton3_actionAdapter(this));
        jButton2.addActionListener(new Frame6_jButton2_actionAdapter(this));
        jLabel8.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel8.setForeground(Color.red);
        jLabel8.setText("*");
        jLabel8.setBounds(new Rectangle(355, 49, 12, 15));
        jLabel9.setForeground(Color.white);
        jLabel9.setText("ISBN：");
        jLabel9.setBounds(new Rectangle(57, 48, 42, 15));
        jTextField8.setBounds(new Rectangle(143, 45, 206, 20));
        jLabel10.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel10.setForeground(Color.red);
        jLabel10.setText("*");
        jLabel10.setBounds(new Rectangle(355, 25, 12, 15));
        jComboBox1.setBounds(new Rectangle(143, 143, 50, 23));
        jComboBox2.setBounds(new Rectangle(218, 143, 40, 23));
        jComboBox2.addActionListener(new Frame6_jComboBox2_actionAdapter(this));
        jComboBox3.setBounds(new Rectangle(284, 143, 40, 23));
        jLabel11.setForeground(Color.white);
        jLabel11.setText("年");
        jLabel11.setBounds(new Rectangle(194, 151, 18, 15));
        jLabel12.setForeground(Color.white);
        jLabel12.setText("月");
        jLabel12.setBounds(new Rectangle(261, 151, 14, 15));
        jLabel13.setForeground(Color.white);
        jLabel13.setText("日");
        jLabel13.setBounds(new Rectangle(327, 151, 17, 15));
        this.getContentPane().add(jLabel1);
        jButton3.setBounds(new Rectangle(284, 234, 65, 25));
        jButton3.setText("退出");
        jButton2.setBounds(new Rectangle(214, 234, 65, 25));
        jButton2.setText("录入");
        jButton1.setBounds(new Rectangle(143, 234, 65, 25));
        jButton1.setText("重置");
        jButton1.addActionListener(new Frame6_jButton1_actionAdapter(this));
        jTextField7.setBounds(new Rectangle(143, 197, 206, 21));
        jTextField6.setBounds(new Rectangle(143, 171, 206, 21));
        jTextField4.setBounds(new Rectangle(143, 119, 206, 21));
        jTextField3.setBounds(new Rectangle(143, 94, 206, 21));
        jTextField2.setBounds(new Rectangle(143, 69, 206, 21));
        jTextField1.setBounds(new Rectangle(143, 19, 206, 21));
        jLabel7.setForeground(Color.white);
        jLabel7.setText("评论：");
        jLabel7.setBounds(new Rectangle(57, 203, 42, 15));
        jLabel6.setForeground(Color.white);
        jLabel6.setText("价钱：");
        jLabel6.setBounds(new Rectangle(57, 177, 42, 15));
        jLabel5.setForeground(Color.white);
        jLabel5.setText("日期：");
        jLabel5.setBounds(new Rectangle(57, 150, 63, 15));
        jLabel4.setForeground(Color.white);
        jLabel4.setText("地址：");
        jLabel4.setBounds(new Rectangle(57, 126, 75, 15));
        jLabel3.setForeground(Color.white);
        jLabel3.setText("作者：");
        jLabel3.setBounds(new Rectangle(57, 100, 42, 15));
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jButton3);
        this.getContentPane().add(jLabel10);
        this.getContentPane().add(jTextField6);
        this.getContentPane().add(jLabel6);
        this.getContentPane().add(jTextField3);
        this.getContentPane().add(jTextField2);
        this.getContentPane().add(jLabel5);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jLabel9);
        this.getContentPane().add(jTextField8);
        this.getContentPane().add(jTextField7);
        this.getContentPane().add(jLabel7);
        this.getContentPane().add(jLabel8);
        this.getContentPane().add(jComboBox1);
        this.getContentPane().add(jTextField4);
        this.getContentPane().add(jComboBox2);
        this.getContentPane().add(jComboBox3);
        for(int i=1900;i<2009;i++)
        {jComboBox1.addItem(""+i);}
        for(int i=1;i<13;i++)
        {jComboBox2.addItem(""+i);}

        this.getContentPane().add(jLabel11);
        this.getContentPane().add(jLabel12);
        this.getContentPane().add(jLabel13);
        jLabel2.setForeground(Color.white);
        jLabel2.setText("出版社：");
        jLabel2.setBounds(new Rectangle(57, 75, 57, 15));
    }

    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();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JTextField jTextField3 = new JTextField();
    JTextField jTextField4 = new JTextField();
    JTextField jTextField6 = new JTextField();
    JTextField jTextField7 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JTextField jTextField8 = new JTextField();
    JLabel jLabel10 = new JLabel();
    JComboBox jComboBox1 = new JComboBox();
    JComboBox jComboBox2 = new JComboBox();
    JComboBox jComboBox3 = new JComboBox();
    JLabel jLabel11 = new JLabel();
    JLabel jLabel12 = new JLabel();
    JLabel jLabel13 = new JLabel();
    public void jButton1_actionPerformed(ActionEvent e) {
        jTextField1.setText(null);
        jTextField2.setText(null);
        jTextField3.setText(null);
        jTextField4.setText(null);
        jTextField6.setText(null);
        jTextField7.setText(null);
        jTextField8.setText(null);
    }

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

    public void jButton2_actionPerformed(ActionEvent e) {
        DataBaseManager dbm = new DataBaseManager();
        ResultSet rs;
        String str1,str2,str3,str4,str5,str6,str7,str9;
        String str0="",str8="";
if(jTextField1.getText().equals(""))
        {JOptionPane.showMessageDialog(this,"书名不能为空！","警告对话框",JOptionPane.WARNING_MESSAGE);}
        else if(jTextField8.getText().equals(""))
        {JOptionPane.showMessageDialog(this,"ISBN号不能为空！","警告对话框",JOptionPane.WARNING_MESSAGE);}
        else
        {
            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();
            str9=jTextField8.getText();
            str0="SELECT * FROM books WHERE BookName ="+"'"+str1+"' AND ISBN='"+str9+"'";
            int r=0;
            try
            {
                try
           {
               rs=dbm.getResult(str0);
               if(rs.next())
               {
                   str8="UPDATE books SET Books_count=Books_count+1 WHERE BookName ='"+str1+"' AND ISBN='"+str9+"'";
                   dbm.updateSql(str8);
               }
               else
               {
                   str8="INSERT INTO books (BookName,Press,Author,Address,PressDate,Price,Com,Books_count,ISBN) VALUES("+"'"+str1+"',"+"'"+str2+"',"+"'"+str3+"',"+"'"+str4+"','"+str5+"',"+"'"+str6+"','"+str7+"',1,'"+str9+"')";
                   dbm.updateSql(str8);
               }
               JOptionPane.showMessageDialog(this,"录入成功！","信息提示",JOptionPane.INFORMATION_MESSAGE);
               dispose();
           }
           catch(SQLException e7){}
           dbm.closeConnection();

            }
            catch(NumberFormatException e12)
            {JOptionPane.showMessageDialog(this,"ISBN号只能由数字组成！","警告对话框",JOptionPane.WARNING_MESSAGE);}
        }
    }

    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 Frame6_jComboBox2_actionAdapter implements ActionListener {
    private Frame6 adaptee;
    Frame6_jComboBox2_actionAdapter(Frame6 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame6_jButton2_actionAdapter implements ActionListener {
    private Frame6 adaptee;
    Frame6_jButton2_actionAdapter(Frame6 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame6_jButton3_actionAdapter implements ActionListener {
    private Frame6 adaptee;
    Frame6_jButton3_actionAdapter(Frame6 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame6_jButton1_actionAdapter implements ActionListener {
    private Frame6 adaptee;
    Frame6_jButton1_actionAdapter(Frame6 adaptee) {
        this.adaptee = adaptee;
    }

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