login.java

完成课程设计

package 客房管理;

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

public class Login extends JFrame implements ActionListener
{
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	//定义
	JLabel lbUser,lbPass,lbTitle;
	JTextField tUser;
	JPasswordField password;
	JButton bLogin,bCancel;
	JPanel panelMain,panel1,panel2,panel3,panel4;
	
  public Login()
	{
	    //主面板
		super("登陆");
		//Font titleFont=new Font("宋体",Font.BOLD,30);
		panelMain=new JPanel();
		this.setContentPane(panelMain);
		//标题
		panel1=new JPanel();
		//lbTitle=new JLabel("WELCOME");
		lbTitle=new JLabel(new ImageIcon(客房管理.Login.class.getResource("login.jpg")));
		//lbTitle.setFont(titleFont);
		panel1.add(lbTitle);
		//用户名
		panel2=new JPanel();
		lbUser=new JLabel("用户名:");
		tUser=new JTextField(12);
		panel2.add(lbUser);
		panel2.add(tUser);
		//密码
		panel3=new JPanel();
		lbPass=new JLabel("密    码:");
		password=new JPasswordField(12);
		panel3.add(lbPass);
		panel3.add(password);
		//按钮
		panel4=new JPanel();
		bLogin=new JButton("登陆");
		bLogin.addActionListener(this);
		bCancel=new JButton("取消");
		bCancel.addActionListener(this);
		panel4.add(bLogin);
		panel4.add(bCancel);
		//子面板添加
		panelMain.add(panel1);
		panelMain.add(panel2);
		panelMain.add(panel3);
		panelMain.add(panel4);
		//窗体属性
		setBounds(400,250,320,330);
		setVisible(false);
		setResizable(false);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	}
  
    //按钮事件
	public void actionPerformed(ActionEvent ae)
	{
		//登陆按钮
		if(ae.getSource()==bLogin)
		{
			if(tUser.getText().equals("") || password.getPassword().equals(""))
			{
				JOptionPane.showMessageDialog(null,"请输入");
			}
			else
			{
				Connection conn;
				Statement stat;
				ResultSet rs;
				try
				{
					//数据库连接
					Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
					conn=DriverManager.getConnection("jdbc:odbc:客房管理","sa","");
					stat=conn.createStatement();
					rs=stat.executeQuery("select * from 管理人员 where 编号="+"'"+tUser.getText()+"' and 密码="+"'"+String.valueOf(password.getPassword())+"'");
					if(rs.next())
					{
						this.dispose();
						Mainwindow mw=new Mainwindow();
						mw.jmiCancel.setEnabled(true);
						mw.jmiSearchFullRoom.setEnabled(true);
						mw.jmiSearchVoidRoom.setEnabled(true);
						mw.jmiSearchName.setEnabled(true);
						mw.jmiCalculate.setEnabled(true);
						mw.jmiAdd.setEnabled(true);
						mw.jmiDelete.setEnabled(true);
						mw.jmiCircumstances.setEnabled(true);
						mw.jmiRate.setEnabled(true);
						mw.jmiIncome.setEnabled(true);
						rs.close();
						JOptionPane.showMessageDialog(null,"Wellcome to our manage!","提示",JOptionPane.INFORMATION_MESSAGE);
					}
					
					else
						JOptionPane.showMessageDialog(null,"用户或密码错误","提示",JOptionPane.ERROR_MESSAGE);
					
			     }
				catch(Exception e)
				{
					JOptionPane.showMessageDialog(null,"连接失败!","提示",JOptionPane.ERROR_MESSAGE);
				}
			}
		}
		//取消按钮
		if(ae.getSource()==bCancel)
		{	
			this.dispose();
		}	
	}
	/*public static void main(String[] args) 
	{
			new Login();
	}*/

}