loginframe.java

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

package cg;

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

public class LoginFrame extends JFrame implements ActionListener{
	private javax.swing.JButton btnOk,btnCad;
	private javax.swing.JLabel lab1,lab2,lab3,lab4;
	private javax.swing.JTextField txtName;
	private javax.swing.JPasswordField txtPaw;	
 	private Connection con;
	
	public LoginFrame(){
		java.awt.Container me = this.getContentPane();
		me.setLayout(null);

		
		btnOk = new JButton("登陆");
		btnOk.setBounds(new Rectangle(101, 217, 65, 28));
		
		btnCad = new JButton("退出");
		btnCad.setBounds(new Rectangle(187, 217, 65, 28));
		
		lab1 = new JLabel("某大酒家欢迎您");
		lab1.setForeground(Color.red);
		lab1.setFont(new java.awt.Font("Dialog", Font.BOLD, 20));
		lab1.setHorizontalAlignment(SwingConstants.CENTER);
		lab1.setBounds(new Rectangle(100, 10, 185, 29));
		//lab1.setEnabled(false);	
	
		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));
		
		lab3 = new JLabel("用户密码:");
		lab3.setForeground(Color.blue);
		lab3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
		lab3.setBounds(new Rectangle(50, 138, 78, 31));
		
		lab4 = new JLabel("输入时,不必区分大小写！");		
		lab4.setHorizontalAlignment(SwingConstants.CENTER);
		lab4.setFont(new java.awt.Font("Dialog",Font.PLAIN,12));
		lab4.setBounds(new Rectangle(68,40,250,35));
		
		txtName = new JTextField();
		txtName.setBounds(new Rectangle(163, 81, 114, 31));
		
		txtPaw = new JPasswordField();
		txtPaw.setBounds(new Rectangle(163, 138, 114, 31));
		
		me.add(btnOk);
		me.add(btnCad);
		me.add(lab1);
		me.add(lab2);
		me.add(lab3);
		me.add(lab4);
		me.add(txtName);
		me.add(txtPaw);
		btnOk.addActionListener(this);
		btnCad.addActionListener(this);		
		btnOk.setActionCommand("ok");
		btnCad.setActionCommand("cander");
		
		this.setTitle("湖南长沙某大酒家");
		this.setSize(400,300);
		this.setDefaultCloseOperation(this.EXIT_ON_CLOSE);//默认关闭程序类似"System.exit(0);"语句
		this.setResizable(false);
		this.setLocationRelativeTo(this);//居中显示
		this.setVisible(true);
	}
	public void actionPerformed(ActionEvent e){
		String strcmd = e.getActionCommand();
		if(strcmd.equals("ok")){
			login();
		}
		 if(strcmd.equals("cander")){		 	
			System.exit(0);
		}

	}
	public void login(){
		String name = txtName.getText().trim();
		String paw = txtPaw.getText();
		int c= 0;
		int d = 0;
				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 = "select count(*) as nubler FROM [user] WHERE 用户名= '"+ name +"' and 密码= '"+paw+"'+and 类型 = '超级用户'";
					//System.out.println(strSql);
					String strsql = "select count(*) as nubler FROM [user] WHERE 用户名= '"+ name +"' and 密码= '"+paw+"'+and 类型 = '普通用户'";
					
					Statement sta = con.createStatement();
	
					ResultSet rs=sta.executeQuery(strSql);
					while (rs.next()){
						 c =rs.getInt("nubler");
					}

					Statement sta1 = con.createStatement();
					ResultSet rs1=sta.executeQuery(strsql);
					while (rs1.next()){
						 d =rs1.getInt("nubler");
					}

					if(c<1)
					{
						javax.swing.JOptionPane.showMessageDialog(this,"您的帐号或密码错误!","提示",JOptionPane.ERROR_MESSAGE);
						txtName.requestFocus(true);
					}
					else if(d<1)
					{
						javax.swing.JOptionPane.showMessageDialog(this,"您的帐号或密码错误!","提示",JOptionPane.ERROR_MESSAGE);
						txtName.requestFocus(true);

					}
					else
					{
						JOptionPane.showMessageDialog(null, "登陆成功");
						new MainFrame();
						this.dispose();//弹出主窗体后登陆窗体自动关闭
					}
					sta.close();
					con.close();
				}
				catch(SQLException sqle)
				{
					sqle.printStackTrace();
				}	
		}	
		
}