<%@ page contentType="text/html; charset=UTF-8" language="java" import="java.sql.*" errorPage="" %> <%@ page import="java.sql.*,com.csc.library.database.ConnectDB"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <form name="cscform" method="post"> <p align="center">View Data</p> <table align="center"> <tr> <td width="104">DataBase :</td> <td width="317"><input type="text" size="15" name="db" value='<%=request.getParameter("db")%>'></td> </tr> <tr> <td height="130">SQL Command :</td> <td><textarea rows="8" cols="50" name="cmd" ></textarea></td> </tr> <tr> <td align="center" colspan="2"><input type="submit" name="submit"> <input type="reset" name="reset"></td> </tr> <% if(request.getParameter("submit") !=null) { String db = request.getParameter("db"); String sql = request.getParameter("cmd"); out.println(" Old SQL Command :: "+request.getParameter("cmd")+"<BR><BR>"); try{ ConnectDB cdb = new ConnectDB(db); Connection conn = cdb.getConnection(); Statement st = conn.createStatement(); ResultSet rs = st.executeQuery(sql); ResultSetMetaData mt = rs.getMetaData(); int column = mt.getColumnCount(); int row = rs.getRow(); out.println("<table align='center' border='1'>"); out.println("<tr><td colspan='2' align='center'>Column = "+column+"</td></tr>"); out.println("<tr>"); for (int i = 1;i<= column;i++){ // Column name out.println("<td align='center'>"+mt.getColumnName(i)+"</td>"); } out.println("</tr>"); while (rs.next()){ out.println("<tr>"); for (int i = 1;i<=column;i++){ // Data out.println("<td align='center'>"+rs.getString(i)+"</td>"); } out.println("</tr>"); } out.println("</table>"); }catch(Exception e){ out.println(" Error :: "+e); } } %> </table> </form> </body> </html>