bookdelete.java

图书馆系统

import java.awt.BorderLayout;
import javax.swing.JPanel;
import java.awt.GraphicsConfiguration;
import java.awt.HeadlessException;

import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;

import java.awt.Rectangle;
import javax.swing.JTextField;
import javax.swing.JButton;
import java.awt.Point;
import java.awt.Dimension;
import java.sql.*;

import javax.swing.JComboBox;

public class bookDelete extends JFrame {

	private static final long serialVersionUID = 1L;

	private JPanel jContentPane = null;

	private JLabel jLabel = null;

	private JButton jButtonOK = null;

	private JButton jButtonCancel = null;
	ResultSet rs;
	private DBManager db=new DBManager();

	private JComboBox jComboBoxname = null;

	public bookDelete() throws HeadlessException {
		// TODO 自动生成构造函数存根
		super();
		initialize();
	}

	public bookDelete(GraphicsConfiguration arg0) {
		super(arg0);
		// TODO 自动生成构造函数存根
		initialize();
	}

	public bookDelete(String arg0) throws HeadlessException {
		super(arg0);
		// TODO 自动生成构造函数存根
		initialize();
	}

	public bookDelete(String arg0, GraphicsConfiguration arg1) {
		super(arg0, arg1);
		// TODO 自动生成构造函数存根
		initialize();
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setSize(300, 200);
		this.setContentPane(getJContentPane());
		this.setTitle("删除书籍信息");
		this.addWindowListener(new java.awt.event.WindowAdapter() {
			public void windowOpened(java.awt.event.WindowEvent e) {
				System.out.println("windowOpened()"); // TODO Auto-generated Event stub windowOpened()
				String strSQL;				
				strSQL="select Bookname from Books";
				rs=db.getResult(strSQL);
				boolean isexist=false;
				try{
					isexist=rs.first();
				}
				catch(SQLException ex){
					
				}
				if(!isexist){
					JOptionPane.showMessageDialog(null, "书库中没有该书目，请确认", "错误", JOptionPane.ERROR_MESSAGE);
					return;
				}
				else{
					try{
						rs.beforeFirst();
						//循环遍历ｒｓ中的数据,将其加到jcomboboxbookname中
						while(rs.next()){
							jComboBoxname.addItem(rs.getString("Bookname"));
						}
					}
					catch(SQLException ex){
						
					}
				}
			}
		});
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jLabel = new JLabel();
			jLabel.setBounds(new Rectangle(14, 6, 169, 18));
			jLabel.setText("请输入您要删除的书籍名称");
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(jLabel, null);
			jContentPane.add(getJButtonOK(), null);
			jContentPane.add(getJButtonCancel(), null);
			jContentPane.add(getJComboBoxname(), null);
		}
		return jContentPane;
	}

	/**
	 * This method initializes jButtonOK	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButtonOK() {
		if (jButtonOK == null) {
			jButtonOK = new JButton();
			jButtonOK.setLocation(new Point(33, 110));
			jButtonOK.setText("确定");
			jButtonOK.setSize(new Dimension(60, 20));
			jButtonOK.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
					if(jComboBoxname.getSelectedItem().toString().trim().equals("")){
						JOptionPane.showMessageDialog(null, "书名不能为空", "错误", JOptionPane.ERROR_MESSAGE);
						return;
					}
					String strSQL;
					strSQL="select * from Books where Bookname='"+jComboBoxname.getSelectedItem().toString().trim()+
					      "'";
					rs=db.getResult(strSQL);
					boolean isexist=false;
					try{
						isexist = rs.first();
					}
					catch(SQLException ex){
						
					}
					if(!isexist){
						JOptionPane.showMessageDialog(null, "书名不存在", "错误", JOptionPane.ERROR_MESSAGE);
						
					}
					else{
						strSQL="delete from Books where Bookname='"+jComboBoxname.getSelectedItem().toString().trim()+"'";
						if(db.executeSql(strSQL)){
							JOptionPane.showMessageDialog(null, "操作成功", "成功", JOptionPane.INFORMATION_MESSAGE);
							buttonexit();
						}
						else{
							JOptionPane.showMessageDialog(null, "操作失败，请重新操作", "错误", JOptionPane.ERROR_MESSAGE);
							
						}
					}
				}
			});
		}
		return jButtonOK;
	}

	/**
	 * This method initializes jButtonCancel	
	 * 	
	 * @return javax.swing.JButton	
	 */
	public void buttonexit(){
		this.dispose();
	}
	private JButton getJButtonCancel() {
		if (jButtonCancel == null) {
			jButtonCancel = new JButton();
			jButtonCancel.setLocation(new Point(122, 110));
			jButtonCancel.setText("退出");
			jButtonCancel.setSize(new Dimension(60, 20));
			jButtonCancel.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
					buttonexit();
				}
			});
		}
		return jButtonCancel;
	}

	/**
	 * This method initializes jComboBoxname	
	 * 	
	 * @return javax.swing.JComboBox	
	 */
	private JComboBox getJComboBoxname() {
		if (jComboBoxname == null) {
			jComboBoxname = new JComboBox();
			jComboBoxname.setLocation(new Point(37, 65));
			jComboBoxname.setEditable(true);
			jComboBoxname.setSize(new Dimension(154, 22));
		}
		return jComboBoxname;
	}

}