import javax.servlet.*;
import javax.servlet.http.*;
import java.io.PrintWriter;
import java.sql.*;
public class squery 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 :: General Query ");
/* style */
out.println("");
out.println("\n");
out.println("");
/* title */
out.println("");
out.println("\nJDBC examples
MySQL magement using servlets
\n");
/* links */
out.println("
");
/* main */
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();
DatabaseMetaData dmd = con.getMetaData();
ResultSet rs1 = dmd.getCatalogs();
String driver = dmd.getDriverName();
out.println("
Driver : "+driver+"
");
String version = dmd.getDriverVersion();
out.println("Version : "+version+"
");
out.println("\n");
out.println("| Databases | Tables | |
");
out.println("");
while (rs1.next()) {
String cat = rs1.getString(1);
out.println("| "+cat+" | ");
try {
ResultSet rs2 = dmd.getTables(cat, null, null, null);
while (rs2.next()) {
String tab = rs2.getString("TABLE_NAME");
out.println("
");
out.println(" | ");
}
out.println(" |
");
}catch(Exception e) {
out.println("no permission |
");
}
}
//esultSet rs = stmt.executeQuery(query);
//stmt.close();
con.close();
}catch(SQLException e) {
out.println("SQLException: " + e.getMessage() +"
");
}
out.println("");
out.println("
\n
\n\n");
}
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, java.io.IOException {
resp.setContentType("text/html");
PrintWriter out = resp.getWriter();
out.println("\nMySql client :: General Query \n");
out.println("");
String tabname = req.getParameter("drop");
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();
stmt.execute("DROP TABLE "+tabname+";");
con.close();
stmt.close();
resp.sendRedirect("Query");
}catch(SQLException e) {
out.println("SQLException: " + e.getMessage() +"
");
}
}
}