Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <body>
- <form method="post" action="process.jsp">
- First name:<br>
- <input type="text" name="first_name">
- <br>
- Last name:<br>
- <input type="text" name="last_name">
- <br>
- City name:<br>
- <input type="text" name="city">
- <br>
- Email Id:<br>
- <input type="email" name="email">
- <br><br>
- <input type="submit" value="submit">
- </form>
- </body>
- </html>
- ___________________________________________________________________________________
- <%--
- Document : process
- Created on : 31-Jan-2019, 13:31:31
- Author : CSC10
- --%>
- <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
- pageEncoding="ISO-8859-1"%>
- <%@page import="java.sql.*,java.util.*"%>
- <%
- String first_name=request.getParameter("first_name");
- String last_name=request.getParameter("last_name");
- String city=request.getParameter("city");
- String email=request.getParameter("email");
- try
- {
- Class.forName("com.mysql.jdbc.Driver");
- Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/tybca", "root", "");
- Statement st=conn.createStatement();
- int i=st.executeUpdate("insert into users(first_name,last_name,city,email)values('"+first_name+"','"+last_name+"','"+city+"','"+email+"')");
- out.println("Data is successfully inserted!");
- }
- catch(Exception e)
- {
- System.out.print(e);
- e.printStackTrace();
- }
- %>
Add Comment
Please, Sign In to add comment