usermanageback.java

自己做的影碟碟出租管理系统

/**
 * @(#)UserManageBack.java
 *
 *
 * @author 
 * @version 1.00 2008/6/1
 */
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.awt.*; 
import java.util.*; 
import javax.swing.table.DefaultTableModel;

public class UserManageBack extends UserManageWindow{
    String UserName;
    String UserPassWord;
    String UserCredit;
    String sqlStr;
    float credit;
    String[] result=new String[3];
    public UserManageBack() {
    	
     ButtonHandler handler=new ButtonHandler();
     display.addActionListener(handler);
     change.addActionListener(handler);
     delete.addActionListener(handler);
     cancel.addActionListener(handler);	
    	
    }
    private class ButtonHandler implements ActionListener{
   
    public void actionPerformed(ActionEvent e){
      if (e.getSource()==display)
      {
      	sqlStr="select * from userinfo";
      	LinkBase link=new LinkBase(sqlStr,AppFrame.QUERY);
      	ResultSet s=link.GetResult();
      	
      	try{
      		rowdata.removeAllElements();
      		while(s.next())
      		{
      		 	Vector currentRow = new Vector(); 	
      			 result[0]=s.getString(1);
             	result[1]=s.getString(2);
                result[2]=s.getString(3);
                	for(int i=0;i<3;i++)
        	currentRow.addElement(result[i]);
            rowdata.addElement(currentRow); 
      		}
      		 table.repaint();
      		 table.updateUI();
      		}
      	catch(SQLException se){
        se.printStackTrace();

        	}
      	
      	}
      if(e.getSource()==change)	 
      { table.repaint();
      	boolean notchoose=true;
      	for(int i=0;i<rowdata.size();i++)
       	if(table.isRowSelected(i))
        	{
        	
         	 notchoose=false;	
        	 int select;
             select=table.getSelectedRow();
            
             UserName=String.valueOf(table.getValueAt(select,0))  ;
             UserPassWord=String.valueOf(table.getValueAt(select,1))  ;
             UserCredit=String.valueOf(table.getValueAt(select,2))  ;
             sqlStr="update userinfo set userpassword ='"+ UserPassWord+"'where userID='"+UserName+"'";
             LinkBase link1=new LinkBase(sqlStr,AppFrame.UPDATE); 
             sqlStr="update userinfo set usercredit ='"+ UserCredit+"'where userID='"+UserName+"'";
             LinkBase link2=new LinkBase(sqlStr,AppFrame.UPDATE); 
             JOptionPane.showMessageDialog(null,"帐户修改成功!");
        	 
        	 table.repaint();
      		 table.updateUI();
      
      	     break;
      	     }
        if(notchoose) JOptionPane.showMessageDialog(null,"请选择一行!");
      	table.removeRowSelectionInterval(0, 2);
      	
      	}
   
      if(e.getSource()==delete)	 
      {
      	 boolean notchoose=true;
      	for(int i=0;i<rowdata.size();i++)
       	if(table.isRowSelected(i))
        	{
        	 notchoose=false;
        	 int select;
             select=table.getSelectedRow();
             
         	 UserName=String.valueOf(table.getValueAt(select,0))  ;
         	 sqlStr="select * from rent where userID='"+UserName+"'";
         	 LinkBase link1=new LinkBase(sqlStr,AppFrame.QUERY);
         	 ResultSet s=link1.GetResult();
         	 try{
         	 	if(s.next())
         	 	JOptionPane.showMessageDialog(null,"无法删除!可能仍有在借碟片未还");	
         	 	else{
         	 	
        	     sqlStr="delete from userinfo where userID='"+UserName+"'";
        	 
             	 LinkBase link2=new LinkBase(sqlStr,AppFrame.UPDATE);
        	
      	        JOptionPane.showMessageDialog(null,"删除成功!");
        	    rowdata.removeElementAt(select) ;
        	    table.repaint();
      		    table.updateUI();
         	 	}
         	 }
         	 	catch(SQLException se2){}
      	     break;
      	     }
        if(notchoose) JOptionPane.showMessageDialog(null,"请选择一行!");
      	
    	}
      else if(e.getSource()==cancel)
    {	
    	StartWindow start=new StartWindow();
    	start.Level=Level;
    	dispose();
    }
  }
   		
}
  
}