userdelframe.java

酒店管理系统（单机版）,根据酒店的日常业务运作而设计

package cg;

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


public class UserdelFrame extends JFrame implements ActionListener{
	JLabel lab2;
	JButton btnOk,btnCad;
	JComboBox jcb;
	public DatabaseUser dbo;
	Connection con;
	
	public UserdelFrame(){
		
		Container me = this.getContentPane();
		me.setLayout(null);
		
		dbo=new DatabaseUser();
		
		btnOk = new JButton("确定");
		btnOk.setBounds(new Rectangle(101, 217, 65, 28));
		
		btnCad = new JButton("退出");
		btnCad.setBounds(new Rectangle(187, 217, 65, 28));
		
		lab2 = new JLabel("用户名:");
		lab2.setForeground(Color.blue);
		lab2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
		lab2.setBounds(new Rectangle(50, 81, 78, 31));
		
		jcb = new JComboBox(dbo.getAllTabelName());
		jcb.setBounds(new Rectangle(163, 81, 114, 31));
		
		me.add(lab2);
		me.add(btnOk);
		me.add(btnCad);
		me.add(jcb);
		
		this.setTitle("");
		this.setSize(400,300);
		this.setResizable(false);
		this.setLocationRelativeTo(this);
		this.setVisible(true);
		
		btnOk.setActionCommand("ok");
		btnCad.setActionCommand("exit");
		
		btnOk.addActionListener(this);
		btnCad.addActionListener(this);
	}
	
	
	public void actionPerformed(ActionEvent e){
		
		String str=e.getActionCommand();
		String str1=(String)jcb.getSelectedItem();

		
		if(str.equals("ok"))
		{
			try
	        {
	            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	            con = DriverManager.getConnection("jdbc:odbc:myOdbc", "sa", "");
	        }
	        catch (ClassNotFoundException cnfe)
	        {
	            cnfe.printStackTrace();
	        }
	        catch (SQLException sqle)
	        {
	            sqle.printStackTrace();
	        }
			try
			{
				
				String strSql = "DELETE FROM [user] WHERE 用户名=?";
				PreparedStatement ps = con.prepareStatement(strSql);
				
				ps.setString(1,str1);
				int count=ps.executeUpdate();
				if(count<1)
				{
				}
				else
				{
					JOptionPane.showMessageDialog(null, "成功删除");
				}
				ps.close();
				con.close();
			}
			catch(SQLException sqle)
			{
				sqle.printStackTrace();
			}	
		}
		if(str.equals("exit"))
		{
			this.setVisible(false);
		}
		
	}
}