insert

package makedb;

 

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

 

public class insert {

 

    Connection dbx;   

Statement stx;   

String sqx; 

ResultSet  rsx; 

    String str;

    int season,number;

    double rate;

    String title,actor;

 

    String url;   

String usr;   

String pwd ; 

String host,port;    

 

public void makedata(String db,String tab,String message){

 

 

try {   

 

     Class.forName("com.mysql.jdbc.Driver").newInstance();

 

       url="jdbc:mysql://"+host+":"+port+"/"+db;

 

            dbx = DriverManager.getConnection(url, usr,pwd);

 

} catch (Exception ex) { ex.printStackTrace();} 

 

 

 

try {     

 

    int s;

    

for(s=1;s<100;s++){    

sqx="insert into "+tab+" values"+"("+change(message)+")"; 

 

stx = dbx.createStatement(); 

stx.executeUpdate(sqx); 

stx.close();   

 

}

 

} catch (Exception ex) { ex.printStackTrace();} 

 

 

 

 

 

 

 

    }

 

 

String change(String word){

String e;

e="'"+word+"'";

return e;    

}    

 

 

 

}