MySql client :: Create table

import javax.servlet.*; import javax.servlet.http.*; import java.io.PrintWriter; import java.sql.*; public class screate 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 :: Create table "); /* style */ out.println(""); out.println(""); /* title */ out.println(""); out.println("\n

JDBC examples

MySQL magement using servlets\n"); /* links */ out.println("

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

Main

Create New Table

Sources

"); /* main */ out.println(""); out.println("

"); out.print(""); out.println("Number of columns:"); out.println(""); out.println(""); out.println(""); out.println(""); out.println("\n

\n\n"); } protected void doErrorGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, java.io.IOException { resp.setContentType("text/html"); PrintWriter out = resp.getWriter(); out.println("\nMySql client :: Create table\n"); out.println(""); out.println("You do not set the number of columns in table you want to create."); out.println("Made-up your mind and try again:"); out.print(""); out.println("\n\n\n"); } protected void doGet2(HttpServletRequest req, HttpServletResponse resp) throws ServletException, java.io.IOException { resp.setContentType("text/html"); PrintWriter out = resp.getWriter(); out.println("\nMySql client :: General Query \n"); /* style */ out.println(""); out.println(""); out.println(""); out.println("\n

JDBC examples

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

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

Main

Create New Table

Sources

"); out.println("

"); String ncol = req.getParameter("coln"); int col = Integer.parseInt(ncol); out.print(""); out.println("\n\n\n"); } protected void doPostGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, java.io.IOException { resp.setContentType("text/html"); PrintWriter out = resp.getWriter(); out.println("\nMySql client :: General Query \n"); /* style */ out.println(""); out.println(""); /* title */ out.println(""); out.println("\n

JDBC examples

MySQL magement using servlets\n"); /*links */ out.println("

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

Main

Create New Table

Sources

"); out.println("

"); /* Construct a query from the request parameters values */ String query = "CREATE TABLE "+req.getParameter("tname")+"("; String ncol = req.getParameter("coln"); int coln = Integer.parseInt(ncol); for (int i=0; i"); } try { Connection con = DriverManager.getConnection(db_url, db_user, db_passw); Statement stmt = con.createStatement(); stmt.executeUpdate(query); out.println("Succesful
"); stmt.close(); con.close(); }catch(SQLException e) { out.println("SQLException: " + e.getMessage() +"
"); } out.println(""); out.println(""); out.println(""); } protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, java.io.IOException { String ncol = req.getParameter("coln"); String flag1 = req.getParameter("flag1"); if (ncol.equals("") && flag1.equals("0")) doErrorGet(req, resp); else { if (flag1.equals("-1")) doGet(req, resp); if (flag1.equals("0")) doGet2(req, resp); if (flag1.equals("1")) doPostGet(req, resp); } } }

Table name:
Field #"+String.valueOf(i+1)+" name:	Type :