yonghuzhuce.java

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

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



public class YonghuZhuce extends JFrame implements ActionListener
{
//	static YonghuZhuce YonghuZhuce1;
	JLabel lb1=new JLabel();
	JLabel lb2=new JLabel();
	JLabel lb3=new JLabel();
	JTextField jt1;
	JPasswordField jt2;
	JPasswordField jt3;
	JPanel p1,p2,p3,p4,p5;
	JButton jb1,jb2;
	Statement s;
	ResultSet rs;
	
	
	public YonghuZhuce()
	{
		super("用户注册");
		lb1.setText("   用户名:      ");
		lb2.setText("     密码:        ");
		lb3.setText("确认密码:    ");
		
		
		Container  con=getContentPane();
		con.setLayout(new GridLayout(5,1));
		p1=new JPanel();
        jt1=new JTextField(15);
	    jt2=new JPasswordField(15);
	    jt3=new JPasswordField(15);
		
		p2=new JPanel();
		p2.add(lb1);
		p2.add(jt1);
		
		p3=new JPanel();
		p3.add(lb2);
		p3.add(jt2);
		p4=new JPanel();
		p4.add(lb3);
		p4.add(jt3);
		
		jb1=new JButton("确定");
		jb2=new JButton("取消");
		p5=new JPanel();
		p5.add(jb1);
		p5.add(jb2);
		jb1.addActionListener(this);
		jb2.addActionListener(this);
		
	    con.add(p1);
		con.add(p2);
		con.add(p3);
		con.add(p4);
		con.add(p5);
		
		p1.setBackground(new Color(189,196,196));
		p2.setBackground(new Color(189,196,196));
		p4.setBackground(new Color(189,196,196));
		p3.setBackground(new Color(189,196,196));
		p5.setBackground(new Color(189,196,196));
		jb1.setSize(100,30);
		jb1.setSize(80,30);
		super.setSize(400,350);
		super.setVisible(true);
		super.setLocation(200,200);
		super.setResizable(false);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==jb2)
		{
		   jt1.setText("");
		   jt2.setText("");
		   jt3.setText("");
		   
		   
		   
		}
		else if(e.getSource()==jb1)
		{
			try
			{
		//	String url="jdbc:odbc:Test";
	    //  	Connection con=DriverManager.getConnection(url);
		 //   s=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
			String s1=null;
			String s2=null;
			String s3=null;
			s1=jt1.getText();
			s2=jt2.getText();
			s3=jt3.getText();
			
			
			//////首先密码为空的情况
			if(jt1.getText().equals(""))
			{
				JOptionPane.showMessageDialog(null,"用户名不能为空","提示",JOptionPane.ERROR_MESSAGE);
			}
			//////设置两次密码输入不一样的错误
			else if(!s2.equals(s3))
			{
				JOptionPane.showMessageDialog(null,"两次输入的密码不一致，请重新输入","提示",JOptionPane.ERROR_MESSAGE);
			   	jt2.setText("");
				jt3.setText("");
			}
			//正确输入
			else
			{
			
			String url="jdbc:odbc:Test";
	      	Connection con=DriverManager.getConnection(url);
		    s=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		    
			String  sql="insert into name1(name,password,qx) values ('"+s1+"','"+s3+"','0')";
			
			s.executeUpdate(sql);
			JOptionPane.showMessageDialog(null,"输入成功，可以使用这个帐号","提示",JOptionPane.INFORMATION_MESSAGE);
		//	new ZiliaoWanshan(s1);
			}
			}catch(Exception we)
			{
				JOptionPane.showMessageDialog(null,"您输入的帐号已经有人使用，请更改","提示",JOptionPane.WARNING_MESSAGE);
				jt1.setText("");
				jt2.setText("");
				jt3.setText("");
			}

		}
	}
	
//	public static void main(String args[])
//	{
//	 new YonghuZhuce();
//	}

 
}