bookdelete.java

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

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class BookDelete extends JFrame implements ActionListener
{
	Container c;
	JTextField BookDeleteTextField;
	JButton YesBtn,ExitBtn;
	JPanel panel1=new JPanel();
	public BookDelete()
	{
		super("删除图书信息");
	   Container c=getContentPane();
	   JPanel panel=new JPanel();
	   //创建读者编号标签与文本框
	   JLabel labelId=new JLabel("图书编号：");
	   BookDeleteTextField=new JTextField(15);
	   panel.add(labelId);
	   panel.add(BookDeleteTextField);
	   YesBtn=new JButton("确定");
		ExitBtn=new JButton("退出");
		YesBtn.addActionListener(this);
		ExitBtn.addActionListener(this);                   
	   panel.add(YesBtn); 
	   	panel.add(ExitBtn);  
	   c.add(panel);
		setVisible(true);
		setBounds(400,110,300,150);
	}
	public void actionPerformed(ActionEvent e)
	{
		Connection con;
        PreparedStatement sql,sql1;
        ResultSet rs;
        boolean boo=false;
		if(e.getSource()==ExitBtn)
		{
			this.dispose();
		}
		else if(e.getSource()==YesBtn)
		{
			try {  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
          }
     catch(ClassNotFoundException f){}
      try {  con=DriverManager.getConnection("jdbc:odbc:tushuguan");
             
              sql1=con.prepareStatement("SELECT * FROM book where bid=?");
             String bianhao;
             bianhao=BookDeleteTextField.getText();
             if(bianhao.equals(""))
             	JOptionPane.showMessageDialog(this,"图书编号不能为空！","提示对话框",JOptionPane.WARNING_MESSAGE);	
             else{
            
             sql1.setString(1,bianhao); 
             rs=sql1.executeQuery(); 
             if(rs.next())
             boo=true;
             con.close();
             if(boo) 
             { 
             	int n=JOptionPane.showConfirmDialog(this,"确认删除吗？","确认对话框",JOptionPane.YES_NO_OPTION );
             	if(n==JOptionPane.YES_OPTION){
             	 con=DriverManager.getConnection("jdbc:odbc:tushuguan");
             	sql=con.prepareStatement("delete from book where bid=?");
             	sql.setString(1,bianhao);
             sql.executeUpdate(); 
             	JOptionPane.showMessageDialog(this,"删除图书成功！","提示对话框",JOptionPane.INFORMATION_MESSAGE);
             	 } 
               else{
             	 	BookDeleteTextField.setText("");
             	 }
             }
            else  JOptionPane.showMessageDialog(this,"删除的图书不存在！","提示对话框",JOptionPane.WARNING_MESSAGE);	 	   
    	con.close();
         }    
    }
      catch(SQLException e2) 
           {  System.out.println(e2);
          }
		}
	}public static void main(String args[]){
		new BookDelete();
	}
	
}