logindig.java

基于Java的仓库信息管理系统。本系统主要完成对超市仓库的库存管理

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


public class LoginDig extends JDialog implements ActionListener
{
	JPanel p1=new JPanel();
	
	JPanel p2=new JPanel();
	
	JPanel p3=new JPanel();
	//p3.setBackground(Color.BLACK);
	JPanel p4=new JPanel();

	JPanel p5=new JPanel();
    String q1=null;
    String q2=null;
    Statement s;
    ResultSet rs;
    int i=0;
    
	JTextField txtUserName=new JTextField(15);
	JPasswordField pswText=new JPasswordField(15);
	JButton b1=new JButton("确认");
	JButton b2=new JButton("取消");
	public LoginDig()
	{
		super.setTitle("登陆界面");
		
		Container containPane=this.getContentPane();
		containPane.setLayout(new GridLayout(5,1));
	//	containPane.setBackground(Color.DARK_GRAY);
		p2.setLayout(new FlowLayout());
		p2.add(new JLabel("用户名:"));
		p2.add(txtUserName);
		p3.add(new JLabel("密码:   "));
		p3.add(pswText);
		p4.add(b1);
		p4.add(b2);
	//	p1.setBackground(Color.DARK_GRAY);
	//	p2.setBackground(Color.BLACK);
		b1.addActionListener(this);
		b2.addActionListener(this);
		Dimension screen=Toolkit.getDefaultToolkit().getScreenSize();
		super.setLocation((screen.width-300)/2,(screen.height-220)/2);
		
		containPane.add(p1);
		containPane.add(p2);
		containPane.add(p3);
		containPane.add(p4);
		containPane.add(p5);
		super.setSize(300,220);
		super.setResizable(false);//设置的不能修改大小
		super.setVisible(true);
		
	}
	public void actionPerformed(ActionEvent e)
	{

	try
	{
		if(e.getSource()==b1)
		{
    	if(txtUserName.getText().equals(""))
			{
				JOptionPane.showMessageDialog(null,"用户名不能为空","提示",JOptionPane.ERROR_MESSAGE);
				return ;
			}
			//用户名为空解决！！！！！！！

	else
	{

	String url="jdbc:odbc:Test";
	Connection con=DriverManager.getConnection(url);
	s=con.createStatement
	 (ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
	 rs=s.executeQuery("select * from name1");	
	 rs.first();
	do
	 {
	 	if(rs.getString(2).equals(txtUserName.getText())&&rs.getString(3).equals(pswText.getText()))
	 	{
	 		i=1;
	 		q1=txtUserName.getText();
	 		q2=rs.getString(9);
	 	//	loadData();
	 		break;

	 	}
	 
	 
	 }while(rs.next());
	 if(i==1)
	 {
	 		JOptionPane.showMessageDialog(null,"登陆成功","提示",JOptionPane.WARNING_MESSAGE);
	 	i=0;
	 	this.dispose();
	 	new GuanliZongjiemian(q1,q2);
	 	
	 }
	 else
	 {
	 	
	 	JOptionPane.showMessageDialog(null,"用户名/密码错误","提示",JOptionPane.WARNING_MESSAGE);
	 	txtUserName.setText("");
	 	pswText.setText("");
	 }
	 
	
	 } 
		
	}
	}catch(Exception ee)
	{
		
	}

	}
	public void windowClosing(WindowEvent e)
	{
		System.exit(0);
	}
	public static void main(String args[])
	{
		new LoginDig();
	}
  	
}