frame9.java~45~

大二做的实训. 纯Java程序

package bookmanagesystem;

import java.awt.*;
import javax.swing.JOptionPane;
import javax.swing.*;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.awt.Font;
import java.util.*;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Frame9 extends JFrame {
    public Frame9() {
        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.setTitle("书籍借出");
        this.setVisible(true);
        jButton1.setBounds(new Rectangle(114, 194, 75, 25));
        jButton1.setText("重置");
        jButton1.addActionListener(new Frame9_jButton1_actionAdapter(this));
        jButton3.setBounds(new Rectangle(272, 194, 75, 25));
        jButton3.setText("退出");
        jButton3.addActionListener(new Frame9_jButton3_actionAdapter(this));
        jTextField4.setBounds(new Rectangle(116, 162, 231, 21));
        jTextField3.setBounds(new Rectangle(116, 130, 231, 21));
        jTextField2.setBounds(new Rectangle(116, 69, 231, 21));
        jTextField1.setBounds(new Rectangle(116, 35, 231, 21));
        jLabel4.setForeground(Color.white);
        jLabel4.setText("备注：");
        jLabel4.setBounds(new Rectangle(51, 162, 42, 21));
        jLabel3.setForeground(Color.white);
        jLabel3.setText("日期：");
        jLabel3.setBounds(new Rectangle(51, 132, 42, 19));
        jLabel2.setForeground(Color.white);
        jLabel2.setText("书名：");
        jLabel2.setBounds(new Rectangle(51, 69, 42, 21));
        jLabel1.setForeground(Color.white);
        jLabel1.setText("用户名：");
        jLabel1.setBounds(new Rectangle(51, 35, 53, 21));
        jButton2.addActionListener(new Frame9_jButton2_actionAdapter(this));
        jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel5.setForeground(Color.red);
        jLabel5.setText("*");
        jLabel5.setBounds(new Rectangle(352, 41, 12, 15));
        jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel6.setForeground(Color.red);
        jLabel6.setText("*");
        jLabel6.setBounds(new Rectangle(352, 75, 12, 15));
        jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel7.setForeground(Color.red);
        jLabel7.setText("*");
        jLabel7.setBounds(new Rectangle(350, 105, 12, 15));
        jTextField5.setBounds(new Rectangle(116, 100, 231, 20));
        jLabel8.setForeground(Color.white);
        jLabel8.setText("ISBN：");
        jLabel8.setBounds(new Rectangle(51, 105, 42, 15));
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jTextField2);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jButton3);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jLabel6);
        this.getContentPane().add(jLabel5);
        this.getContentPane().add(jTextField4);
        this.getContentPane().add(jTextField3);
        jTextField3.setText(String.valueOf(calendar.get(Calendar.YEAR))+"-"+String.valueOf(calendar.get(Calendar.MONTH)+1)+"-"+String.valueOf(calendar.get(Calendar.DAY_OF_MONTH)));
       jTextField3.setEnabled(false);
        this.getContentPane().add(jTextField5);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jLabel8);
        this.getContentPane().add(jLabel7);
        jButton2.setBounds(new Rectangle(192, 194, 75, 25));
        jButton2.setText("录入");
    }

    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JTextField jTextField3 = new JTextField();
    JTextField jTextField4 = new JTextField();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JTextField jTextField5 = new JTextField();
    JLabel jLabel8 = new JLabel();
    public void jButton3_actionPerformed(ActionEvent e) {
dispose();
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        jTextField1.setText(null);
        jTextField2.setText(null);
        jTextField4.setText(null);
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        String str1="",str2="",str3="",str4="",str5="";
        String str6="",str7="",str8="",str9="",str10="";
        DataBaseManager dbm = new DataBaseManager();
        ResultSet rs;
if(jTextField1.getText().equals(""))
        {JOptionPane.showMessageDialog(this,"用户名不能为空！","警告对话框",JOptionPane.WARNING_MESSAGE);}
        else if(jTextField2.getText().equals(""))
        {JOptionPane.showMessageDialog(this,"书名不能为空！","警告对话框",JOptionPane.WARNING_MESSAGE);}
        else if(jTextField5.getText().equals(""))
        {JOptionPane.showMessageDialog(this,"ISBN号不能为空！","警告对话框",JOptionPane.WARNING_MESSAGE);}
        else
        {
            int r=0;
            try
            {str1=jTextField1.getText();
            str2=jTextField2.getText();
            str3=jTextField3.getText();
            str4=jTextField4.getText();
            str5=jTextField5.getText();
            str6="SELECT * FROM books WHERE BookName='"+str2+"' AND ISBN='"+str5+"'";
            str7="SELECT * FROM UserTable WHERE UserName="+"'"+str1+"'";
            str8="INSERT INTO bookBrowse (StudentName,BookName,BorrowDate,Com,Is_Returned,ISBN) VALUES("+"'"+str1+"',"+"'"+str2+"',"+"'"+str3+"',"+"'"+str4+"','否','"+str5+"')";
            str9="UPDATE books SET Books_count=Books_count-1 WHERE BookName="+"'"+str2+"' AND ISBN='"+str5+"'";
            str10="SELECT * FROM bookBrowse WHERE StudentName="+"'"+str1+"'"+"AND BookName ="+"'"+str2+"' AND Is_Returned ='否'"+"AND ISBN='"+str5+"'";
            r=Integer.parseInt(str5);
            try
            {
                rs=dbm.getResult(str6);
                if(rs.next())
                {
                    rs=dbm.getResult(str7);
                    if(rs.next())
                    {
                        rs=dbm.getResult(str10);
                        if(rs.next())
                           {
                             JOptionPane.showMessageDialog(this,"该用户已经借过同样的书籍，并且尚未归还，不能重复借出！","警告对话框",JOptionPane.WARNING_MESSAGE);
                             jTextField1.setText(null);
                             jTextField2.setText(null);
                             jTextField3.setText(null);
                             jTextField4.setText(null);
                           }
                      else
                         {
                             dbm.updateSql(str8);
                             dbm.updateSql(str9);
                             JOptionPane.showMessageDialog(this,"录入成功！","提示信息",JOptionPane.INFORMATION_MESSAGE);
                             dispose();
                         }
                }
                else
                {JOptionPane.showMessageDialog(this,"该用户未注册不能借书！","警告对话框",JOptionPane.WARNING_MESSAGE);
                jTextField1.setText(null);
                jTextField2.setText(null);
                jTextField3.setText(null);
                jTextField4.setText(null);
                }

                }
                else
                {JOptionPane.showMessageDialog(this,"书名或者ISBN号输入错误！","警告对话框",JOptionPane.WARNING_MESSAGE);
                    jTextField1.setText(null);
            jTextField2.setText(null);
            jTextField5.setText(null);
            jTextField4.setText(null);

                }

            }
            catch(SQLException e3){}
            dbm.closeConnection();

            }
            catch(NumberFormatException e52)
            {JOptionPane.showMessageDialog(this,"ISBN号只能由数字组成！","警告对话框",JOptionPane.WARNING_MESSAGE);}
        }
    }
}
class Frame9_jButton2_actionAdapter implements ActionListener {
    private Frame9 adaptee;
    Frame9_jButton2_actionAdapter(Frame9 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame9_jButton1_actionAdapter implements ActionListener {
    private Frame9 adaptee;
    Frame9_jButton1_actionAdapter(Frame9 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame9_jButton3_actionAdapter implements ActionListener {
    private Frame9 adaptee;
    Frame9_jButton3_actionAdapter(Frame9 adaptee) {
        this.adaptee = adaptee;
    }

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