select

package makedb;

import java.sql.*; 
 
public class select{ 
 
Connection dbx;   
Statement stx;   
String sqx; 
ResultSet  rsx; 
 
int s,sx; 
public String artist=new String[5000];
int count;
 String x=new String[5000];
 int[] y=new int[5000];
 
String url;   
String usr;   
String pwd ; 
String host,port;
 
public void makedata(String db,String tab){ 
 
dbx = null;
  
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();} 
 
s=0;
try {   
stx = dbx.createStatement(); 
sqx="select * from "+tab;   
rsx = stx.executeQuery(sqx); 
if (rsx != null) { 
while (rsx.next()) { 
s=s+1;
x[s]=rsx.getString("NAME");
y[s]=rsx.getInt("POINT");
} 
} 
 
count=s;
 
rsx.close(); 
stx.close(); 
dbx.close(); 
 
} catch (Exception ex) {ex.printStackTrace();} 
 
 
 
 
} 
 
String change(String word){
String e;
e="'"+word+"'";
return e;    
}    
 
 
 
}