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];
public int count;
String x=new String[500];
int[] y=new int[500];
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("w");
}
}
count=s;
rsx.close();
stx.close();
dbx.close();
} catch (Exception ex) {ex.printStackTrace();}
}
String change(String word){
String e;
e="'"+word+"'";
return e;
}
}