delete.java

完成课程设计

package 客房管理;

import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

public class Delete extends JFrame implements ActionListener
{
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	JLabel lNO;
	JTextField tNO;
	JButton bDelete,bBack;
	JPanel panelMain,panel1,panel2;
	
	public Delete()
	{
		super("删除");
		panelMain=new JPanel();
		this.setContentPane(panelMain);
		
		panel1=new JPanel();
		lNO=new JLabel("客房号:");
		tNO=new JTextField(6);
		panel1.add(lNO);
		panel1.add(tNO);
		
		panel2=new JPanel();
		bDelete=new JButton("删除");
		bDelete.addActionListener(this);
		bBack=new JButton("返回");
		bBack.addActionListener(this);
		panel2.add(bDelete);
		panel2.add(bBack);
		
		panelMain.add(panel1);
		panelMain.add(panel2);
		
		setBounds(500,300,250,150);
		setResizable(false);
		setVisible(false);
	}
	
	public void actionPerformed(ActionEvent ae)
	{
		if(ae.getActionCommand()=="返回")
		{
			this.dispose();
		}
		else if(ae.getActionCommand()=="删除")
		{
			Connection con;
			PreparedStatement stat;
			String b="delete from 客人信息 where 客房编号="+"'"+tNO.getText()+"'"+"";
			//int r;
			try
			{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				con=DriverManager.getConnection("jdbc:odbc:客房管理","sa","");
				stat=con.prepareStatement(b);
				stat.executeUpdate();
				JOptionPane.showMessageDialog(null,"删除成功!","提示",JOptionPane.INFORMATION_MESSAGE);
			}
			catch(Exception e)
			{
				e.printStackTrace();
			}
		}
	}
	
	/*public static void main(String[] args) 
	{
			new Delete();
	}*/

}