class  ScrollingResultSetTableModel  extends  DefaultTableModel {                        
	 private  ResultSet rs;                                                             
	 private   final  String[] columnNames = {"1", "2", "3", "4"};
	 public  ScrollingResultSetTableModel(ResultSet rs) {                               
		 this .rs = rs;                                                                 
	}                                                                                 
	 public  ResultSet getResultSet() {                                                 
		 return  rs;                                                                    
	}                                                                                 
	 public   void  setResultSet(ResultSet rs) {                                          
		 try  {                                                                         
			 this .rs.close();                                                          
		}  catch  (SQLException e) {                                                    
			e.printStackTrace();                                                      
		}                                                                             
		 this .rs = rs;                                                                 
	}                                                                                 
	 public  String getColumnName( int  c) {                                              
		 return  columnNames[c];                                                        
	}                                                                                 
	 public   int  getColumnCount() {                                                     
		 return  columnNames.length;                                                    
	}                                                                                 
	 public   int  getRowCount() {                                                        
		 try  {                                                                         
			 if  (rs !=  null ) {rs.last();  return  rs.getRow();}                          
			 else   return   0 ;							                                  
		}  catch  (Exception e) {                                                       
			e.printStackTrace();                                                      
			 return   0 ;                                                                 
		}                                                                             
	}                                                                                 
	 public   boolean  isCellEditable( int  r,  int  c) {                                     
		 return  false;
	}                                                                                 
	 public  Object getValueAt( int  r,  int  c) {                                          
		 try  {                                                                         
			rs.absolute(r +  1 );                                                       
			 return  rs.getObject(c +  1 );                                               
		}  catch  (Exception e) {                                                       
			e.printStackTrace();                                                      
			 return   null ;                                                              
		}                                                                             
	}                                                                                 
	 public   void  removeRow( int  r) {                                                    
		//delete from db                                                              
		 try  {                                                  
			rs.absolute(r +  1 );
			//delete current row from table                                           
			rs.deleteRow();                                                           
		}  catch  (SQLException e) {                                                    
			e.printStackTrace();                                                      
		}                                                                             
	}                                                                                 
}; // class  ScrollingResultSetTableModel

 try  {							                         
	scrollstat = conn.createStatement(                   
		ResultSet.TYPE_SCROLL_INSENSITIVE,               
		ResultSet.CONCUR_UPDATABLE);                     
	scrollRs = scrollstat.executeQuery(cmd);             
}  catch  (SQLException e) {                               
	e.printStackTrace();                                 
}                                                        
                                                         
tableModel =  new  ScrollingResultSetTableModel(scrollRs);	
table =  new  JTable(tableModel);
scroll =  new  JScrollPane(table);                         

 int [] selected = table.getSelectedRows();
tableModel.removeRow(selected[i]);

}; // class  ScrollingResultSetTableModel