· 9 years ago · Feb 09, 2017, 08:20 AM
1/*
2 * To change this license header, choose License Headers in Project Properties.
3 * To change this template file, choose Tools | Templates
4 * and open the template in the editor.
5 */
6
7import java.io.IOException;
8import java.io.PrintWriter;
9import java.sql.Connection;
10import java.sql.DriverManager;
11import java.sql.ResultSet;
12import java.sql.SQLException;
13import java.sql.Statement;
14import javax.servlet.ServletException;
15import javax.servlet.annotation.WebServlet;
16import javax.servlet.http.HttpServlet;
17import javax.servlet.http.HttpServletRequest;
18import javax.servlet.http.HttpServletResponse;
19
20/**
21 *
22 * @author Administrator
23 */
24@WebServlet(urlPatterns = {"/NewServlet"})
25public class NewServlet extends HttpServlet {
26
27 /**
28 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
29 * methods.
30 *
31 * @param request servlet request
32 * @param response servlet response
33 * @throws ServletException if a servlet-specific error occurs
34 * @throws IOException if an I/O error occurs
35 */
36 protected void processRequest(HttpServletRequest request, HttpServletResponse response)
37 throws ServletException, IOException {
38 response.setContentType("text/html;charset=UTF-8");
39 try (PrintWriter out = response.getWriter()) {
40
41 String DBName = request.getParameter("dbname");
42
43 String myDriver = "com.mysql.jdbc.Driver";
44 String DriverUrl = "jdbc:mysql://localhost/";
45 Class.forName(myDriver);
46 System.out.println("\nDriver loaded successfully");
47
48 Connection conn = (Connection) DriverManager.getConnection(DriverUrl, "root","");
49 System.out.println("\nConnection is established");
50 Statement st = conn.createStatement();
51 String CreateDB;
52 CreateDB = "CREATE DATABASE IF NOT EXISTS " + DBName;
53 st.execute(CreateDB);
54 String SelectDB = "use "+DBName.toLowerCase();
55 System.out.println("DBNAME" + SelectDB);
56 st.execute(SelectDB);
57 String createTable="CREATE TABLE IF NOT EXISTS STUDENT(SName VARCHAR(50), Department VARCHAR(50), Result VARCHAR(50), Sem int(20) )";
58 st.execute(createTable);
59 System.out.println("Table created:");
60
61 String row[]=new String[5];
62
63 row[0]="INSERT INTO STUDENT(SName,Department,Result,Sem) VALUES (\"mitun\",\"computer\",\"pass \",6)";
64 row[1]="INSERT INTO STUDENT(SName,Department,Result,Sem) VALUES (\"jay\",\"computer \",\"pass \",6)";
65 row[2]="INSERT INTO STUDENT(SName,Department,Result,Sem) VALUES (\"aakash\",\"computer \",\"pass \",6)";
66 row[3]="INSERT INTO STUDENT(SName,Department,Result,Sem) VALUES (\"pranav\",\"computer \",\"fail \",6)";
67 row[4]="INSERT INTO STUDENT(SName,Department,Result,Sem) VALUES (\"naitik\",\"computer \",\"pass \",6)";
68
69 for(int i=0;i<5;i++){
70 st.execute(row[i]);
71 }
72 System.out.println("values inserted:");
73 String showTable="SELECT * FROM STUDENT";
74 ResultSet rs=st.executeQuery(showTable);
75 rs.beforeFirst();
76
77 while(rs.next())
78 {
79 out.println("SName:"+rs.getString("SName")+"\t"+"<br>");
80 out.println("Department:"+rs.getString("Department")+"\t"+"<br>");
81 out.println("Result:"+rs.getString("Result")+"\t"+"<br>");
82 out.println("Sem:"+rs.getString("Sem")+"\t"+"<br>");
83
84 }
85 }catch(ClassNotFoundException | SQLException se){se.printStackTrace();}
86 }
87
88 // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
89 /**
90 * Handles the HTTP <code>GET</code> method.
91 *
92 * @param request servlet request
93 * @param response servlet response
94 * @throws ServletException if a servlet-specific error occurs
95 * @throws IOException if an I/O error occurs
96 */
97 @Override
98 protected void doGet(HttpServletRequest request, HttpServletResponse response)
99 throws ServletException, IOException {
100 processRequest(request, response);
101 }
102
103 /**
104 * Handles the HTTP <code>POST</code> method.
105 *
106 * @param request servlet request
107 * @param response servlet response
108 * @throws ServletException if a servlet-specific error occurs
109 * @throws IOException if an I/O error occurs
110 */
111 @Override
112 protected void doPost(HttpServletRequest request, HttpServletResponse response)
113 throws ServletException, IOException {
114 processRequest(request, response);
115 }
116
117 /**
118 * Returns a short description of the servlet.
119 *
120 * @return a String containing servlet description
121 */
122 @Override
123 public String getServletInfo() {
124 return "Short description";
125 }// </editor-fold>
126
127}
128
129
130
131
132---------------------------------------------------------------------------------
133
134
135<!DOCTYPE html>
136<!--
137To change this license header, choose License Headers in Project Properties.
138To change this template file, choose Tools | Templates
139and open the template in the editor.
140-->
141<html>
142 <head>
143 <title>TODO supply a title</title>
144 <meta charset="UTF-8">
145 <meta name="viewport" content="width=device-width, initial-scale=1.0">
146 </head>
147 <body>
148 <form action="NewServlet" method="get">
149 Database Name :<input type="text" name="dbname" />
150 <input type="submit" value="submit" />
151 </form>
152 </body>
153</html>