logon.java

航空航天订票系统 是数据库的课程设计 单机版

package GraphicsUI;

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

public class LogOn implements ActionListener {

	JFrame jf;

	JLabel namel;

	JTextField namet;

	JLabel pwl;

	JPasswordField pwt;

	JPanel p1;

	JPanel p2;

	JPanel p3;

	JPanel p;

	JButton btn1;

	JButton btn2;

	JButton btn3;

	JLabel jl;

	JLabel nul;

	Toolkit kit;

	Dimension windowSize;

	Connection conn;

	Statement stmt;

	ResultSet rs;

	public LogOn() {
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		} catch (ClassNotFoundException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		jl = new JLabel();
		nul = new JLabel();
		jl.setIcon(new ImageIcon("Src/logon.jpg"));
		jf = new JFrame("登录");
		jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		namel = new JLabel("用户名:");
		namet = new JTextField(10);
		pwl = new JLabel("密码： ");
		pwt = new JPasswordField(10);
		p1 = new JPanel();
		p1.setLayout(new FlowLayout());
		p1.add(namel);
		p1.add(namet);
		p2 = new JPanel();
		p2.setLayout(new FlowLayout());
		p2.add(pwl);
		p2.add(pwt);
		p3 = new JPanel();
		btn1 = new JButton("系统登录");
		btn2 = new JButton("客户匿名登录");
		btn3 = new JButton("退出");
		p3.add(btn1);
		p3.add(btn2);
		p3.add(btn3);
		p = new JPanel();
		p.setLayout(new GridLayout(4, 1));
		p.add(nul);
		p.add(jl);
		p.add(p1);
		p.add(p2);
		jf.add(jl, BorderLayout.WEST);
		jf.add(p, BorderLayout.CENTER);
		jf.add(p3, BorderLayout.SOUTH);
		kit = Toolkit.getDefaultToolkit();
		windowSize = kit.getScreenSize();
		jf.setBounds(windowSize.width / 2 - 200, windowSize.height / 2 - 100,
				400, 200);
		jf.setResizable(false);
		jf.setVisible(true);
		btn1.addActionListener(this);
		btn2.addActionListener(this);
		btn3.addActionListener(this);
	}

	public void actionPerformed(ActionEvent e) {
		boolean amin = false;
		boolean service = false;
		if (e.getSource() == btn1) {
			try {
				conn = DriverManager.getConnection(
						"jdbc:microsoft:sqlserver://localhost:1433", "sa", "");
				stmt = conn.createStatement();
				rs = stmt.executeQuery("select * from administrator");
				while (rs.next()) {
					System.out.println(rs.getString(1) + rs.getString(5) + "\t"
							+ rs.getString(6));
					if (rs.getString(1).trim().equals(namet.getText().trim())
							&& rs.getString(6).trim().equals(
									pwt.getText().trim())) {
						if (rs.getString(5).equals("0")) {
							amin = true;
							break;
						} else {
							service = true;
							break;
						}
					}
				}
			} catch (SQLException e1) {
				// TODO 自动生成 catch 块
				e1.printStackTrace();
			}
			try {
				rs.close();
				stmt.close();
				conn.close();
			} catch (SQLException e1) {
				// TODO 自动生成 catch 块
				e1.printStackTrace();
			}
			if (amin) {
				jf.dispose();
				MainFrame mf = new MainFrame();
				mf.jm6.setEnabled(false);
				mf.jm7.setEnabled(false);
			} else if (service) {
				jf.dispose();
				MainFrame mf = new MainFrame();
				// mf.jm1.setEnabled(false);
				// mf.jm2.setEnabled(false);
				mf.jm3.setEnabled(false);
				mf.jm4.setEnabled(false);
				mf.jm7.setEnabled(false);
			} else {
				JOptionPane.showMessageDialog(null, "帐号或密码错误,请重新输入", "错误",
						JOptionPane.ERROR_MESSAGE);
			}
		}
		if (e.getSource() == btn2) {
			jf.dispose();
			MainFrame mf = new MainFrame();
			// mf.jm1.setEnabled(false);
			// mf.jm2.setEnabled(false);
			mf.jm3.setEnabled(false);
			mf.jm4.setEnabled(false);
			mf.jm6.setEnabled(false);
		}
		if (e.getSource() == btn3)
			System.exit(0);
	}
}