<%@ page import="java.net.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
}
catch (Exception E) {
out.println("Unable to load driver.");
E.printStackTrace();
}
try{
out.println("Getting Connection ...");
Connection C = DriverManager.getConnection("jdbc:mysql://IP_ADDRESS:3306/test");
out.println("
Connected: " + !C.isClosed() + "
\n");
out.println("Catalog: " + C.getCatalog() + "
\n");
Statement S = C.createStatement();
ResultSet rs = S.executeQuery("SELECT * FROM foo");
ResultSetMetaData rsStruc = rs.getMetaData();
out.println("Table: " + rsStruc.getTableName(1) + "
");
out.println("");
out.println("");
int colCount = rsStruc.getColumnCount();
String colName = "";
for(int i=1;i <= colCount; i++){
colName = rsStruc.getColumnName(i) ;
out.println("| " + colName + " | \n");
}
out.println("
");
while (rs.next()) {
out.println("");
for(int i=1;i <= colCount; i++){
colName = rsStruc.getColumnName(i) ;
String fld = rs.getString(colName);
out.println("| " + fld + " | ");
}
out.println("
");
}
out.println("
");
rs.close();
C.close();
}
catch (Exception E) {
out.println("SQLException: " + E.getMessage());
}
%>