package mysql;
import java.sql.*;
public class pro {
public static void main(String args) {
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/db";
String user="root";
String pass ="1isaya";
Connection con = DriverManager.getConnection(url,user,pass);
int s;
Statement stx;
String sqx;
ResultSet rsx;
String artist=new String[500];
s=0;
stx = con.createStatement();
sqx="select * from ex01";
rsx = stx.executeQuery(sqx);
if (rsx != null) {
while (rsx.next()) {
s=s+1;
artist[s]=rsx.getString("name");
System.out.println(artist[s]);
}
}
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}