reyuanshanchu.java

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

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



public class ReyuanShanchu 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,p5;
	JButton jb1,jb2;
	Statement s;
	ResultSet rs;
	int i=0;
	
	
	public ReyuanShanchu()
	{
		super("删除用户");
		lb1.setText("   用户名:      ");
		lb2.setText("     密码:        ");
	//	lb3.setText("确认密码:    ");
		
		
		Container  con=getContentPane();
		con.setLayout(new GridLayout(4,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(190,190,190));
		p2.setBackground(new Color(190,190,190));
	//	p4.setBackground(Color.pink);
		p3.setBackground(new Color(190,190,190));
		p5.setBackground(new Color(190,190,190));
		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
			{
			
			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()))
		    	{
		    		i=1;
		    		System.out.print(1);
		    		break;
		    	}
		    }while(rs.next());
		   if(i==1)
		   {
		   	String sql="delete from name1 where name ='"+jt1.getText()+"'";
		   	
		   	s.executeUpdate(sql);
		   	JOptionPane.showMessageDialog(null,"删除用户成功","提示",JOptionPane.INFORMATION_MESSAGE);
		   	
		   }
		   else
		   {
		   	JOptionPane.showMessageDialog(null,"用户名/密码错误，无法删除","提示",JOptionPane.ERROR_MESSAGE);
		   }
			
		//	s.executeUpdate(sql);
		//	JOptionPane.showMessageDialog(null,"输入成功，可以使用这个帐号","提示",JOptionPane.INFORMATION_MESSAGE);
			}
			}catch(Exception we)
			{
			//	JOptionPane.showMessageDialog(null,"您输入的帐号已经有人使用，请更改","提示",JOptionPane.WARNING_MESSAGE);
		//		jt1.setText("");
		//		jt2.setText("");
		//		jt3.setText("");
			}

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

 
}