delbook.java

基于目前许多中小型公司, 机关,中小学校,大学院系等都有自己的图书库, 供内部人员借阅。传统的手工登记办法

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package libsystem;

/**
 *  删除图书信息
 * @author admin
 */
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;



public class DelBook extends JFrame
{
	String strurl;
  	Connection conn;
  	Statement stmt;
  	ResultSet rs;
	private JPanel ContentPane;
	private JLabel jlabNum = new JLabel();
	private JLabel jlabChoice = new JLabel();
	private JTextField jtextfieldNum = new JTextField();
	private JButton jsure = new JButton();
	private JLabel jlab1 = new JLabel();
	private JLabel jlab2 = new JLabel();
	private JLabel jlab3 = new JLabel();
	private JLabel jlab4 = new JLabel();
	private JLabel jlab5 = new JLabel();
	private JLabel jlab6= new JLabel();
	private JLabel jlab7 = new JLabel();
	private JLabel jlab8 = new JLabel();
	private JLabel jlab9 = new JLabel();
	private JTextField jtextfield1 = new JTextField();
	private JTextField jtextfield2 = new JTextField();
	private JTextField jtextfield3 = new JTextField();
	private JTextField jtextfield4 = new JTextField();
	private JTextField jtextfield5 = new JTextField();
	private JComboBox jcombobox1 = new JComboBox();
	private JComboBox jcombobox2 = new JComboBox();
	private JComboBox jcombobox3 = new JComboBox();
	private JTextArea jtextarea = new JTextArea();
	private JButton jdelete = new JButton();

	public  DelBook()
	{
		ContentPane = (JPanel)this.getContentPane();
		ContentPane.setLayout(null);
		this.setTitle("删除图书信息");
		this.setBounds(320,160,400,350);
		ContentPane.setBackground(Color.black);
		/*设置查询界面的第一步*/
		jlabNum.setText("书号");
		jlabNum.setVisible(true);
		jlabNum.setBounds(new Rectangle(124, 130, 178, 24));
		jlabNum.setForeground(Color.white);

		jlabChoice.setText("输入要删除的书号");
		jlabChoice.setFont(new Font("Dialog", 1, 20));
		jlabChoice.setForeground(Color.white);
		jlabChoice.setVisible(true);
		jlabChoice.setBounds(new Rectangle(115, 60, 200, 30));

		jtextfieldNum.setText("");
		jtextfieldNum.setBounds(new Rectangle(178, 127, 83, 22));
		jtextfieldNum.setVisible(true);
		jsure.setText("确定");
		jsure.setVisible(true);
		jsure.setBounds(new Rectangle(178, 177, 73, 22));
		jsure.addActionListener(new button_actionPerformed());

		/*显示学生详细信息的界面*/
		jlab1.setText("书号");
		jlab1.setVisible(false);
		jlab1.setBounds(new Rectangle(30, 11, 51, 33));
		jlab1.setForeground(Color.white);
		jlab2.setText("书名");
		jlab2.setVisible(false);
		jlab2.setBounds(new Rectangle(162, 11, 28, 33));
		jlab2.setForeground(Color.white);
		jlab3.setText("借出");
		jlab3.setVisible(false);
		jlab3.setBounds(new Rectangle(241, 11, 28, 33));
		jlab3.setForeground(Color.white);
		jlab4.setText("出版日期");
		jlab4.setVisible(false);
		jlab4.setBounds(new Rectangle(31, 53, 55, 33));
		jlab4.setForeground(Color.white);
		jlab5.setText("图书分类");
		jlab5.setVisible(false);
		jlab5.setBounds(new Rectangle(241, 53, 55, 33));
		jlab5.setForeground(Color.white);
		jlab6.setText("作者");
		jlab6.setVisible(false);
		jlab6.setBounds(new Rectangle(163, 53, 26, 33));
		jlab6.setForeground(Color.white);
		jlab7.setText("系   别");
		jlab7.setVisible(false);
		jlab7.setBounds(new Rectangle(30, 94, 50, 33));
		jlab7.setForeground(Color.white);
		jlab8.setText("出版社");
		jlab8.setVisible(false);
		jlab8.setBounds(new Rectangle(163, 94, 66, 33));
		jlab8.setForeground(Color.white);
		jlab9.setText("备   注");
		jlab9.setVisible(false);
		jlab9.setBounds(new Rectangle(27, 132, 50, 33));
		jlab9.setForeground(Color.white);
		jdelete.setText("删除");
		jdelete.setVisible(false);
		jdelete.setBounds(new Rectangle(153, 242, 94, 22));
		jdelete.addActionListener(new button_actionPerformed());


		jtextfield1.setText("");//书号
		jtextfield1.setVisible(false);
		jtextfield1.setBounds(new Rectangle(86, 16, 74, 22));
		jtextfield2.setText("");//书名
		jtextfield2.setVisible(false);
		jtextfield2.setBounds(new Rectangle(192, 16, 44, 22));
		jtextfield3.setText("");//出版日期
		jtextfield3.setVisible(false);
		jtextfield3.setBounds(new Rectangle(86, 58, 74, 22));
		jtextfield4.setText("");//作者
		jtextfield4.setVisible(false);
		jtextfield4.setBounds(new Rectangle(191, 58, 44, 22));
		jtextfield5.setText("");//出版社
		jtextfield5.setVisible(false);
		jtextfield5.setBounds(new Rectangle(210, 99, 158, 22));

		/********************添加下拉菜单的选象**********************/
		jcombobox1.setBounds(new Rectangle(275, 15, 50, 25));
		jcombobox1.setVisible(false);
		jcombobox1.addItem("否");
		jcombobox1.addItem("是");

		/***************添加下拉菜单的选象***************/
		jcombobox2.setBounds(new Rectangle(296, 57, 72, 25));
		jcombobox2.setVisible(false);
		jcombobox2.addItem("科技");
		jcombobox2.addItem("文学");
		jcombobox2.addItem("其他");

		/************添加下拉菜单的选象******************/
		jcombobox3.setBounds(new Rectangle(86, 98, 75, 25));
		jcombobox3.setVisible(false);
		jcombobox3.addItem("信息系");
		jcombobox3.addItem("经济系");
		jcombobox3.addItem("机电系");
		jcombobox3.addItem("管理系");
		jcombobox3.addItem("旅游系");
		jcombobox3.addItem("外语系");
                jcombobox3.addItem("计机系");
		jtextarea.setText("");
		jtextarea.setVisible(false);
		jtextarea.setBounds(new Rectangle(84, 139, 285, 92));

		/***********将控件添加到面板中去********/
		ContentPane.add(jlabNum);
		ContentPane.add(jlabChoice);
		ContentPane.add(jtextfieldNum);
		ContentPane.add(jsure);


		/**************把各个控件加到面板中去************/
		ContentPane.add(jlab1);
		ContentPane.add(jlab2);
		ContentPane.add(jlab3);
		ContentPane.add(jlab4);
		ContentPane.add(jlab5);
		ContentPane.add(jlab6);
		ContentPane.add(jlab7);
		ContentPane.add(jlab8);
		ContentPane.add(jlab9);

		/**************将文本框加到面板中去***********/
		ContentPane.add(jtextfield1);
		ContentPane.add(jtextfield2);
		ContentPane.add(jtextfield3);
		ContentPane.add(jtextfield4);
		ContentPane.add(jtextfield5);

		/************将下拉框添加到面板中***********/
		ContentPane.add(jcombobox1);
		ContentPane.add(jcombobox2);
		ContentPane.add(jcombobox3);

		/**************将文本区域和命令按钮添加************/
		ContentPane.add(jtextarea);
		ContentPane.add(jdelete);

		this.setVisible(true);
	}
	class button_actionPerformed implements ActionListener
	{
		public void actionPerformed(ActionEvent e)
		{
			try
			{
                         Statement stmt = ConnDataBase.getConnection().createStatement();
                         if(e.getSource()==jsure)
				{
					rs = stmt.executeQuery("select * from Book where 书号 = '"+jtextfieldNum.getText()+"'");
					if(rs.next())
					{
                                           /******设置各个标签的可见性*****/
                                            jlabNum.setVisible(false);
                                            //jlabName.setVisible(false);
                                            jsure.setVisible(false);
                                            jlabChoice.setVisible(false);
                                            jtextfieldNum.setVisible(false);
                                           // jtextfieldName.setVisible(false);
                                            jlab1.setVisible(true);//书号
                                            jlab2.setVisible(true);//书名
                                            jlab3.setVisible(true);//借出
                                            jlab4.setVisible(true);//出版日期
					    jlab5.setVisible(true);//图书分类
					    jlab6.setVisible(true);//作者
					    jlab7.setVisible(true);//系别
					    jlab8.setVisible(true);//出版社
					    jlab9.setVisible(true);//备注
                                            jdelete.setVisible(true);
					    jtextfield1.setVisible(true);//书号
					    jtextfield1.setText(rs.getString("书号"));
					    jtextfield1.setEditable(false);
                                            jcombobox3.setVisible(true);//系别
					    jcombobox3.setSelectedItem(rs.getString("系别"));
					    jcombobox3.setEditable(false);
                                            jtextfield5.setVisible(true);//出版社
					    jtextfield5.setText(rs.getString("出版社"));
					    jtextfield2.setVisible(true);//书名
					    jtextfield2.setText(rs.getString("书名"));
                                            jcombobox1.setVisible(true);//借出
					    jcombobox1.setSelectedItem(rs.getString("借出"));
					    jtextfield3.setVisible(true);//出版日期
					    jtextfield3.setText((rs.getString("出版日期")).substring(0,10));
					    jtextfield4.setVisible(true);//作者
					    jtextfield4.setText(rs.getString("作者"));
					    jcombobox2.setVisible(true);//图书分类
					    jcombobox2.setSelectedItem(rs.getString("图书分类"));
					    jtextarea.setVisible(true);
					    jtextarea.setText(rs.getString("备注"));
					}
					else
						JOptionPane.showMessageDialog(null, "无此书号对应信息", "警告",
                                                                            JOptionPane.WARNING_MESSAGE);
				}
				else if(e.getSource()==jdelete)
                                    {
                                    try
					{
					if(JOptionPane.showConfirmDialog(null, "确实要删除该生信息吗?\n删除的信息将不能恢复,继续?","删除确定", JOptionPane.OK_CANCEL_OPTION, JOptionPane.QUESTION_MESSAGE) ==0)
						{
						stmt.executeUpdate("delete  from Book where 书号 = '"+jtextfieldNum.getText()+"'");
						JOptionPane.showMessageDialog(null, "删除信息成功!");
                                                dispose();
						BrBookinfo allinfo = new BrBookinfo();
						}
					}
					catch(Exception ee)
                                            {
						ee.printStackTrace();
                                            }
                                    }
			}
			catch(Exception ee)
			{
				ee.printStackTrace();
			}
		}
	}
}