/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 *
 * @author Administrator
 */
@WebServlet(urlPatterns = {"/NewServlet"})
public class NewServlet extends HttpServlet {

    /**
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
     * methods.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        try (PrintWriter out = response.getWriter()) {

            String DBName = request.getParameter("dbname");

            String myDriver = "com.mysql.jdbc.Driver";
            String DriverUrl = "jdbc:mysql://localhost/";
            Class.forName(myDriver);
            System.out.println("\nDriver loaded successfully");

            Connection conn = (Connection) DriverManager.getConnection(DriverUrl, "root","");
            System.out.println("\nConnection is established");
            Statement st =  conn.createStatement();
            String CreateDB;
            CreateDB = "CREATE DATABASE IF NOT EXISTS " + DBName;
            st.execute(CreateDB);
            String SelectDB = "use "+DBName.toLowerCase();
            System.out.println("DBNAME" + SelectDB);
            st.execute(SelectDB);
            String createTable="CREATE TABLE IF NOT EXISTS STUDENT(SName VARCHAR(50), Department VARCHAR(50), Result VARCHAR(50), Sem int(20) )";
            st.execute(createTable);
            System.out.println("Table created:");

            String row[]=new String[5];

            row[0]="INSERT INTO  STUDENT(SName,Department,Result,Sem) VALUES (\"mitun\",\"computer\",\"pass \",6)";
            row[1]="INSERT INTO  STUDENT(SName,Department,Result,Sem) VALUES (\"jay\",\"computer \",\"pass \",6)";
            row[2]="INSERT INTO  STUDENT(SName,Department,Result,Sem) VALUES (\"aakash\",\"computer \",\"pass \",6)";
            row[3]="INSERT INTO  STUDENT(SName,Department,Result,Sem) VALUES (\"pranav\",\"computer \",\"fail \",6)";
            row[4]="INSERT INTO  STUDENT(SName,Department,Result,Sem) VALUES (\"naitik\",\"computer \",\"pass \",6)";

            for(int i=0;i<5;i++){
                st.execute(row[i]);
            }
            System.out.println("values inserted:");
            String showTable="SELECT * FROM STUDENT";
            ResultSet rs=st.executeQuery(showTable);
            rs.beforeFirst();

            while(rs.next())
            {
                out.println("SName:"+rs.getString("SName")+"\t"+"<br>");
                out.println("Department:"+rs.getString("Department")+"\t"+"<br>");
                out.println("Result:"+rs.getString("Result")+"\t"+"<br>");
                out.println("Sem:"+rs.getString("Sem")+"\t"+"<br>");

            }
        }catch(ClassNotFoundException | SQLException se){se.printStackTrace();}
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP <code>GET</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP <code>POST</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     *
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}




---------------------------------------------------------------------------------


<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<html>
    <head>
        <title>TODO supply a title</title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
    </head>
    <body>
        <form action="NewServlet" method="get">
        Database Name :<input type="text" name="dbname" />
        <input type="submit" value="submit" />
        </form>
    </body>
</html>