Fedorax

import java.sql.*;

public class jsql {
public static void main(String args[]){

String query;

try{
Class.forName(“org.gjt.mm.mysql.Driver”);
String url = “jdbc:mysql://localhost/DATABASE?user=USERNAME&password=PASSWOED”;
Connection con = DriverManager.getConnection(url);

Statement stmt = con.createStatement();
query = “select * from TABLE Limit 0,10″;

ResultSet res = stmt.executeQuery(query);

while(res.next()){
ResultSetMetaData rsmd = res.getMetaData();//メタ情報を得ることでカラムを取得できる。

for(int i=1;i<=rsmd.getColumnCount();i++){
System.out.println(res.getString(i));
}
}
res.close();
stmt.close();
}catch(Exception e){
System.out.println(e.getMessage());
e.printStackTrace();
}
}

}