/* *  * Copyright 2003,2004 The Watermill Team * * This file is part of Watermill. * *    Watermill is free software; you can redistribute it and/or modify *    it under the terms of the GNU General Public License as published by *    the Free Software Foundation; either version 2 of the License, or *    (at your option) any later version. * *    Watermill is distributed in the hope that it will be useful, *    but WITHOUT ANY WARRANTY; without even the implied warranty of *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the *    GNU General Public License for more details. * *    You should have received a copy of the GNU General Public License *    along with Watermill; if not, write to the Free Software *    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA * */package Watermill.rmill;import java.util.*;import Watermill.kernel.*;import Watermill.relational.*;import java.sql.*;public class SurgeryCommand extends Command {    public String dbName;    public String tableName;    public int percent;    public SurgeryCommand(String dbName,String tableName,int percent){	this.dbName=dbName;	this.tableName=tableName;	this.percent=percent;    }        public void execute(Manager m){	DB document=(DB)m.getDocument(dbName,Constant.masterDBuser,Constant.masterDBpassword);		Random r=new Random();	Statement s=null;	String query=null;	try {	    Connection con=document.getConnection();	    s=con.createStatement();	    	    	    for(int i=1;i<=percent;i++){		int j=r.nextInt(100);				query="delete from "+tableName+" where idp='product"+j+"'";		s.executeUpdate(query);		Msg.debug("Destroying tuple product"+j); 	    }	    query="select count(*) from "+tableName;	    ResultSet rs=s.executeQuery(query);	    rs.next();	    int res=rs.getInt(1);	    	    Msg.println("SURGERIES, REMAIN "+res);	}	catch (Exception e){	    Msg.fatal(e);	}    }	    public String toString(){	return "SurgeryCommand from "+dbName;    }}