displayrentback.java

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

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

public class DisPlayRentBack extends DisPlayRentWindow{
    String DiscString;
  	String UserString;
  	String TimeString;
  	String sqlStr;
    public DisPlayRentBack() {
    ButtonHandler handler=new ButtonHandler();
    ok.addActionListener(handler);	
    }
  private class ButtonHandler implements ActionListener{
   
    public void actionPerformed(ActionEvent e){
    if(e.getSource()==ok)
     {
      sqlStr="select * from rent";
        LinkBase link=new LinkBase(sqlStr,AppFrame.QUERY);
        ResultSet s=link.GetResult();
      try{  while(s.next())
        {
           Vector nextrow=new Vector();
        	UserString=s.getString(1);
        	DiscString=s.getString(2);
        	TimeString=s.getString(3);
        	nextrow.addElement(UserString);
        	nextrow.addElement(DiscString);
        	nextrow.addElement(TimeString);
        	rowdata.addElement(nextrow);
      }
      }
      catch(SQLException se)
         {}
        table.repaint();
        table.updateUI();
    		
    		
      }
    }
    }   
    
}