Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="UTF-8">
- <title>Insert title here</title>
- </head>
- <body>
- <form name="myform" action="http://localhost:8080/connectivity/databaseconn" method="post">
- Username<input type = "text" name="username">
- Password<input type = "text" name="password">
- <input type = "submit" name="action" value="Insert">
- <input type = "submit" name="action" value="Update">
- <input type = "submit" name="action" value="Delete">
- <input type = "submit" name="action" value="Select">
- </form>
- </body>
- </html>
- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- import java.io.IOException;
- import java.io.PrintWriter;
- import java.sql.*;
- import javax.servlet.ServletException;
- import javax.servlet.annotation.WebServlet;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- /**
- * Servlet implementation class databaseconn
- */
- @WebServlet("/databaseconn")
- public class databaseconn extends HttpServlet {
- private static final long serialVersionUID = 1L;
- //String url1="jdbc:mysql://localhost:3306";
- String url="jdbc:mysql://localhost:3306/a1";
- String username1="root";
- String password1="mysql";
- /**
- * @see HttpServlet#HttpServlet()
- */
- public databaseconn() {
- super();
- // TODO Auto-generated constructor stub
- }
- /**
- * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
- */
- protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- // TODO Auto-generated method stub
- PrintWriter out = response.getWriter();
- String input=request.getParameter("action");
- String name=request.getParameter("username");
- String password=request.getParameter("password");
- try
- {
- Class.forName("com.mysql.jdbc.Driver");
- /*
- java.sql.Connection con1=DriverManager.getConnection(url1,username1,password1);
- out.println("Connection successful");
- Statement st1=con1.createStatement();
- int k=st1.executeUpdate("create table vwt(username varchar(20),password varchar(20));");
- if(k>0)
- {
- out.println("Database Created Successful");
- }
- */
- java.sql.Connection con=DriverManager.getConnection(url,username1,password1);
- out.println("Connection successful");
- Statement st=con.createStatement();
- if(input.equals("Insert"))
- {
- int i=st.executeUpdate("insert into vwt values('"+name+"','"+password+"')");
- if(i>0)
- {
- out.println("inserted successfully");
- }
- }
- else if(input.equals("Select"))
- {
- ResultSet rs = st.executeQuery("select * from vwt ;");
- while(rs.next()){
- //Retrieve by column name
- String username1 = rs.getString("username");
- String password1 = rs.getString("password");
- //Display values
- //System.out.print(", Username: " + username);
- //System.out.println(", Password: " + password1);
- out.println(username1);
- out.println(password1);
- }
- rs.close();
- }
- }catch(Exception e)
- {
- }
- }
- }
Add Comment
Please, Sign In to add comment