pswxiugai.java

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

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



public class PswXiugai extends JFrame implements ActionListener
{
//	static YonghuZhuce YonghuZhuce1;
	JLabel lb1=new JLabel();
	JLabel lb2=new JLabel();
	JLabel lb3=new JLabel();
	JLabel lb4=new JLabel();
	JTextField jt1;
	JPasswordField jt2;
	JPasswordField jt3;
	JPasswordField jt4;
	JPanel p1,p2,p3,p4,p5,p6;
	JButton jb1,jb2;
	Statement s;
	ResultSet rs;
	int i=0;
	
	public PswXiugai()
	{
		super("用户密码修改");
		lb1.setText("   用户名:      ");
		
		lb2.setText("     密码:        ");
		lb3.setText("修改密码:    ");
		lb4.setText("确认密码:    ");
		
		
		Container  con=getContentPane();
		con.setLayout(new GridLayout(6,1));
		p1=new JPanel();
        jt1=new JTextField(15);
	    jt2=new JPasswordField(15);
	    jt3=new JPasswordField(15);
	    jt4=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);
		
		p6=new JPanel();
		p6.add(lb4);
		p6.add(jt4);
		p6.setBackground(new Color(189,196,196));
		
		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(p6);
		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(500,500);
		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 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);
		    rs=s.executeQuery("select * from name1");
		    rs.first();
		    do
		    {
		    	if(rs.getString(2).equals(jt1.getText())&&rs.getString(3).equals(jt2.getText()))
		    	{
		    	    String   	sql1="Update name1 set password ='"+jt3.getText()+"'where name ='"+jt1.getText()+"'";
		    	    if(jt3.getText().equals(jt4.getText()))
		    	    {
		    	    
		    	    s.executeUpdate(sql1);
		    	    JOptionPane.showMessageDialog(null,"密码修改成功，请牢记密码","提示",JOptionPane.INFORMATION_MESSAGE);
		    	    i=1;
		             jt1.setText("");
		    	     jt2.setText("");
		    	     jt3.setText("");
		    	     jt4.setText("");
		    	     this.dispose();
		    	    break;
		    	    }
		    	    else
		    	    {
		    	    	JOptionPane.showMessageDialog(null,"密码输入不一致,不能修改","提示",JOptionPane.ERROR_MESSAGE);
		    	        jt1.setText("");
		    	        jt2.setText("");
		    	        jt3.setText("");
		    	        jt4.setText("");
		    	        break;
		    	    }
		    	}
		    }while(rs.next());
		    if(i==0)
		    {
		    	JOptionPane.showMessageDialog(null,"修改密码没有成功，用户/密码有错误","提示 ",JOptionPane.ERROR_MESSAGE);
		        jt1.setText("");
		    	jt2.setText("");
		    	jt3.setText("");
		    	jt4.setText("");
		    }
			
		//	}//与上面的else一致的，还原得时候必须保留
			}catch(Exception we)
			{

			}

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

 
}