alllogin.java

本系统是鞋厂管理系统

import java.awt.*;
import java.awt.event.*;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.*;

//员工和厂长的登录界面
public class AllLogin extends JFrame implements ActionListener
{
	//调用类DBConnection获取Connection实例以方便操作数据库
	DBConnection conn=new DBConnection();
	Connection con=conn.getConn();
	
	JTextField jt1=new JTextField(10);
	JPasswordField jt2=new JPasswordField(10);
	
	public  AllLogin()
	{
		super("登录界面");
		setVisible(true);
		setLocation(370,280);
		setSize(300,200);
		
		JLabel lb=new JLabel("欢迎登录");
		
		JLabel lb1=new JLabel("请输入帐号");
		JLabel lb2=new JLabel("请输入密码");
		
		
		JButton b1=new JButton("厂长登录");
		JButton b2=new JButton("员工登录");
		
		JPanel p1=new JPanel();
		JPanel p2=new JPanel();
		JPanel p3=new JPanel();
		JPanel p4=new JPanel();
		JPanel p5=new JPanel();
		JPanel p6=new JPanel();
		
		
		Container c=getContentPane();
		
		p1.setLayout(new FlowLayout());
		p1.add(lb1);
		p1.add(jt1);;
		
		p2.setLayout(new FlowLayout());
		p2.add(lb2);
		p2.add(jt2);;
		
		p3.setLayout(new FlowLayout());
		p3.add(b1);
		p3.add(b2);
		
		p4.setLayout(new GridLayout(3,1));
		p4.add(p1);
		p4.add(p2);
		p4.add(p3);
		
		p5.add(lb);
		
		c.setLayout(new BorderLayout());
		
		c.add(p5,BorderLayout.NORTH);
		c.add(p4,BorderLayout.CENTER);
		c.add(p6,BorderLayout.SOUTH);
		
		b1.addActionListener(this);
		b2.addActionListener(this);
	}
	

	public void actionPerformed(ActionEvent e)
	{
		if("厂长登录".equals(e.getActionCommand()))
		{
			try
			{
				//manager作为存储厂长帐户密码的数据表
				String sql="select * from manager where" +
				" name='"+jt1.getText()+"'and pass='"+jt2.getText()+"'";
				Statement stmt=con.createStatement(
				ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
				//rs获取结果集
				ResultSet rs=stmt.executeQuery(sql);
				//获取第一条记录,也是唯一一条记录
				if(rs.first())
			    {
					setVisible(false);
					Message msg=new Message();
			        msg.setVisible(true);
					msg.setDefaultCloseOperation(Message.EXIT_ON_CLOSE);	
				}
				
				else//弹出对话框
				{
					String str1="对不起!";
					String str2="您输入的信息不正确,请从新输入!";
					Alert alert=new Alert(str1,str2);
					alert.setVisible(true);
				}
			}
			
			 catch(SQLException ex){} 
			 
		}
		
		
		if("员工登录".equals(e.getActionCommand()))
		{
			try
			{  
				//manager作为存储员工帐户密码的数据表
				String sql="select * from staff where" +
				" name='"+jt1.getText()+"'and pass='"+jt2.getText()+"'";
				Statement stmt=con.createStatement(
				ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
			    ResultSet rs=stmt.executeQuery(sql);
			    
				if(!rs.first())
				{  
					String str1="对不起!";
					String str2="您输入的信息不正确,请从新输入!";
					Alert alert=new Alert(str1,str2);
					alert.setVisible(true);
				}
				
				else //弹出对话框
				{
					Staff staff=new Staff(jt1.getText());
					staff.setVisible(true);
					setVisible(false);
				}
				  
			}
			
            catch(SQLException ex){}    
			  
			
		}
	}
	
	
	public static void main(String args[])
	{
		
		AllLogin mg=new AllLogin();
	}

}