Simple GIS

GISプログラムの練習

MySql

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();
    }   
  }   
}