frame10.java~42~

大二做的实训. 纯Java程序

package bookmanagesystem;

import java.awt.*;
import java.sql.*;
import javax.swing.*;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.Font;
import java.awt.event.ContainerEvent;
import java.awt.event.ContainerAdapter;

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

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        this.setTitle("修改书籍出借信息");
        this.setVisible(true);
        jLabel1.setForeground(Color.white);
        jLabel2.setForeground(Color.white);
        jLabel2.setText("备注：");
        jLabel3.setForeground(Color.white);
        jTextField1.setBounds(new Rectangle(120, 65, 246, 21));
        jLabel4.setForeground(Color.white);
        jLabel5.setForeground(Color.white);
        jLabel5.setText("日期：");
        jButton1.setBounds(new Rectangle(243, 234, 60, 25));
        jButton1.setText("更新");
        jButton1.addActionListener(new Frame10_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(120, 234, 59, 25));
        jButton2.setText("重置");
        jButton2.addActionListener(new Frame10_jButton2_actionAdapter(this));
        jButton3.setBounds(new Rectangle(306, 234, 60, 25));
        jButton3.setText("退出");
        jButton3.addActionListener(new Frame10_jButton3_actionAdapter(this));
        jButton4.setBounds(new Rectangle(181, 234, 60, 25));
        jButton4.setText("确定");
        jButton4.addActionListener(new Frame10_jButton4_actionAdapter(this));
        jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel6.setForeground(Color.red);
        jLabel6.setText("*");
        jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel7.setForeground(Color.red);
        jLabel7.setText("*");
        jLabel8.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel8.setForeground(Color.red);
        jLabel8.setText("*");
        jLabel8.setBounds(new Rectangle(369, 72, 12, 15));
        this.getContentPane().setBackground(new Color(0, 66, 92));
        jLabel1.setBounds(new Rectangle(58, 14, 330, 27));
        jLabel4.setText("用户名：");
        jLabel4.setBounds(new Rectangle(55, 65, 52, 21));
        jTextField2.setBounds(new Rectangle(120, 90, 246, 21));
        jLabel3.setBounds(new Rectangle(55, 90, 42, 21));
        jLabel7.setBounds(new Rectangle(369, 96, 12, 15));
        jTextField3.setBounds(new Rectangle(121, 117, 246, 21));
        jTextField4.setBounds(new Rectangle(120, 144, 246, 21));
        jLabel6.setBounds(new Rectangle(369, 123, 12, 15));
        jLabel5.setBounds(new Rectangle(55, 119, 42, 19));
        jLabel2.setBounds(new Rectangle(55, 144, 42, 21));
        jLabel3.setText("ISBN：");
        jLabel1.setText("输入借阅者姓名与ISBN号点击确定，将调出此书的相关信息");
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jButton4);
        this.getContentPane().add(jButton1);
        jButton1.setEnabled(false);
        this.getContentPane().add(jButton3);
        this.getContentPane().add(jLabel8);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jTextField2);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jLabel7);
        this.getContentPane().add(jTextField3);
        this.getContentPane().add(jTextField4);
        this.getContentPane().add(jLabel6);
        this.getContentPane().add(jLabel5);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jTextField6);
        this.getContentPane().add(jLabel11);
        this.getContentPane().add(jLabel10);
    }

    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JTextField jTextField2 = new JTextField();
    JTextField jTextField3 = new JTextField();
    JTextField jTextField4 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    String str1="",str2="",str3="",str4="";
    JLabel jLabel10 = new JLabel();
    JTextField jTextField6 = new JTextField();
    JLabel jLabel11 = new JLabel();
    String str200;
    public void jButton3_actionPerformed(ActionEvent e) {
dispose();
    }

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

    public void jButton4_actionPerformed(ActionEvent e)
    {
String str8="";
DataBaseManager dbm = new DataBaseManager();
ResultSet rs;
if(jTextField1.getText().equals(""))
{JOptionPane.showMessageDialog(this,"借书者姓名不能为空！","警告对话框",JOptionPane.WARNING_MESSAGE);}
else if(jTextField2.getText().equals(""))
{JOptionPane.showMessageDialog(this,"ISBN号不能为空！","警告对话框",JOptionPane.WARNING_MESSAGE);}
else
{
    str1=jTextField1.getText();
    str2=jTextField2.getText();
    str200=str2;
    str8="SELECT * FROM bookBrowse WHERE StudentName ="+"'"+str1+"'"+"AND ISBN ="+"'"+str2+"'";
try
{
   rs=dbm.getResult(str8);
if(rs.next())
{
   jTextField1.setText(rs.getString(2));
   jLabel3.setText("书名：");
jTextField2.setText(rs.getString(3));
jTextField3.setText(rs.getString(5));
jTextField4.setText(rs.getString(6));
}
else
{
   JOptionPane.showMessageDialog(this,"借书者姓名或ISBN号输入错误！请重新输入","警告对话框",JOptionPane.WARNING_MESSAGE);
   jTextField1.setText(null);
  jTextField2.setText(null);
}
}
catch(Exception eee){}
    dbm.closeConnection();
}
    }
    public void jButton1_actionPerformed(ActionEvent e) {
        String str8="";
        DataBaseManager dbm = new DataBaseManager();
if(jTextField1.getText().equals(""))
        {JOptionPane.showMessageDialog(this,"借书者姓名不能为空！","警告对话框",JOptionPane.WARNING_MESSAGE);}
        else if(jTextField2.getText().equals(""))
        {JOptionPane.showMessageDialog(this,"书名不能为空！","警告对话框",JOptionPane.WARNING_MESSAGE);}
        else if(jTextField3.getText().equals(""))
        {JOptionPane.showMessageDialog(this,"借出日期不能为空！","警告对话框",JOptionPane.WARNING_MESSAGE);}
        else
        {
            str1=jTextField1.getText();
            str2=jTextField2.getText();
            str3=jTextField3.getText();
            str4=jTextField4.getText();
            str8="UPDATE bookBrowse SET StudentName="+"'"+str1+"'"+",BookName="+"'"+str2+"'"+",BorrowDate="+"'"+str3+"'"+",Com="+"'"+str4+"' WHERE StudentName='"+str1+"' AND BookName='"+str2+"' AND ISBN='"+str200+"'";
            dbm.updateSql(str8);
            JOptionPane.showMessageDialog(this,"更新成功！","提示信息",JOptionPane.INFORMATION_MESSAGE);
            dispose();
        }
       dbm.closeConnection();
    }
}
class Frame10_jButton4_actionAdapter implements ActionListener {
    private Frame10 adaptee;
    Frame10_jButton4_actionAdapter(Frame10 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton4_actionPerformed(e);
    }
}
class Frame10_jButton2_actionAdapter implements ActionListener {
    private Frame10 adaptee;
    Frame10_jButton2_actionAdapter(Frame10 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame10_jButton3_actionAdapter implements ActionListener {
    private Frame10 adaptee;
    Frame10_jButton3_actionAdapter(Frame10 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame10_jButton1_actionAdapter implements ActionListener {
    private Frame10 adaptee;
    Frame10_jButton1_actionAdapter(Frame10 adaptee) {
        this.adaptee = adaptee;
    }

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


/*class Frame10_jButton4_actionAdapter implements ActionListener {
    private Frame10 adaptee;
    Frame10_jButton4_actionAdapter(Frame10 adaptee) {
        this.adaptee = adaptee;
    }

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