loginfrm.java

我们学完java后的一个综合作业

import java.awt.*;
//import java.io.*;
//import java.net.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.*;
class Loginfrm implements ActionListener
{
	String sname,spass;
	JTextField user;
	JPasswordField passWd;
	JButton b1,b2;
	Container dialogPane;
	JDialog d;
	JFrame f;
	ResultSet rs;
	int sunit;
	address lbox;
public Loginfrm(JFrame f)
{
	d=new JDialog();
	d.setTitle("请输入用户名和密码");
	dialogPane=d.getContentPane();
	dialogPane.setLayout(new GridLayout(3,2));
	dialogPane.add(new JLabel("用户名",SwingConstants.CENTER));
	user=new JTextField();
	dialogPane.add(user);
	dialogPane.add(new JLabel("密 码",SwingConstants.CENTER));
	passWd=new JPasswordField();
	dialogPane.add(passWd);
	b1=new JButton("确定");
	b2=new JButton("退出");
	dialogPane.add(b1);
	dialogPane.add(b2);
	b1.addActionListener(this);
	b2.addActionListener(this);
	d.setBounds(200,150,400,130);
	d.getRootPane().setDefaultButton(b1);
	d.setVisible(true);
	this.f=f;
}
public void actionPerformed(ActionEvent e)
{
	String cmd=e.getActionCommand();
	if(cmd.equals("确定"))
	{
		String name=user.getText();
		String passWord=passWd.getText();
		if((name.equals(""))||(passWord.equals("")))
		{
			JOptionPane.showMessageDialog(d,"用户名或密码不能为空");
		}else
		{
			try{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				Connection con=
					DriverManager.getConnection("jdbc:odbc:notebook","zxp","121");
				Statement stmt=con.createStatement();
				rs=stmt.executeQuery("SELECT * FROM users where username="+"'"+name+"'");
				while(rs.next())
				{
					sname=rs.getString(1);  spass=rs.getString(2);sunit=Integer.parseInt(rs.getString(3));
					if(passWord.equals(spass))
					{
						switch(sunit)
						{
						case 1:
						{
							lbox=new address();
							lbox.add.setEnabled(true);
							  lbox.reach.setEnabled(true);
    						d.setVisible(true);
    						d.dispose();
    						
						}break;
						case 2:
						{
							lbox=new address();
							lbox.add.setEnabled(false);
							lbox.reach.setEnabled(true);
							d.setVisible(true);
							d.dispose();
							
						}break;
						}
					}
					else
					{
						
						JOptionPane.showMessageDialog(d,"用户名或密码错误!");
					}
				}
				
			}catch(Exception ex){}
		}
		
	}else if(cmd.equals("退出"))
	{
		d.dispose();
	}
}
}