MySql client :: Tables

import javax.servlet.*; import javax.servlet.http.*; import java.io.PrintWriter; import java.sql.*; public class stable extends HttpServlet { static String db_url = "jdbc:mysql://158.197.40.194:3306/test"; static String db_user = "test"; static String db_passw = "test"; protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, java.io.IOException { resp.setContentType("text/html"); PrintWriter out = resp.getWriter(); out.println("\nMySql client :: Tables \n"); /* style */ out.println("\n"); out.println(""); out.println(""); out.println("\n

JDBC examples

MySQL managment using servlets \n"); out.println("

"); out.println(""); out.println(""); out.println(""); out.println("

Main Info

Create New Table

Sources

"); String tabname = req.getParameter("name"); String deln = req.getParameter("deln"); String delv = req.getParameter("delv"); out.println(""); out.println("
Table details :
"); out.println("

"); try { Class.forName("com.mysql.jdbc.Driver"); }catch(Exception ex) { out.println("Can't find Database driver class: " + ex.getMessage()+ "
"); } try { Connection con = DriverManager.getConnection(db_url, db_user, db_passw); Statement stmt = con.createStatement(); if(deln!=null) stmt.executeUpdate("DELETE FROM "+tabname+" WHERE "+deln+"='"+delv+"';"); ResultSet rs = stmt.executeQuery("SELECT * FROM "+tabname+";"); ResultSetMetaData rsmd = rs.getMetaData(); int numberOfColumns = rsmd.getColumnCount(); /* write metadata about selected table */ for (int i=0; i"); } out.println("

"+tabname+"
"+rsmd.getColumnName(i+1)+"	"+rsmd.getColumnTypeName(i+1)+"

"); out.println("

Records :
"); out.println("\n"); /* write columns names */ for (int i=0; i"+rsmd.getColumnName(i+1)+""); } out.println(""); /* write records in selected table */ while (rs.next()) { out.println(""); for (int i=0; i"+rs.getString(rsmd.getColumnName(i+1))+""); } out.println(""); out.println(""); } out.println("

delete

"); out.println("\n\n"); String insert = req.getParameter("ins"); if (insert.equals("1")) { out.println(""); } else out.println("
\nInsert new record"); con.close(); stmt.close(); }catch(SQLException e) { out.println("SQLException: " + e.getMessage() +"
"); } out.println("\n"); } /* Process the parameters and insert it into table */ protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, java.io.IOException { resp.setContentType("text/html"); PrintWriter out = resp.getWriter(); String tabname = req.getParameter("name"); String query = "INSERT INTO "+tabname+" VALUES("; try { Class.forName("com.mysql.jdbc.Driver"); }catch(Exception ex) { out.println("Can't find Database driver class: " + ex.getMessage()+ "
"); } try { Connection con = DriverManager.getConnection(db_url, db_user, db_passw); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM "+tabname+";"); ResultSetMetaData rsmd = rs.getMetaData(); int numberOfColumns = rsmd.getColumnCount(); for (int i=0; iSuccesful\n"); }catch(SQLException e) { out.println("SQLException (doPost): " + e.getMessage() +"
"); } resp.sendRedirect("Table?name="+tabname+"&ins=0"); } }