Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- java
- package com.servlet;
- import java.io.IOException;
- import java.io.PrintWriter;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.Statement;
- import javax.servlet.ServletException;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- public class Insertion extends HttpServlet
- {
- protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- }
- protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- String regno=request.getParameter("regno");
- String name=request.getParameter("name");
- String age=request.getParameter("age");
- String gender=request.getParameter("gender");
- PrintWriter out=response.getWriter();
- out.println("sdfad");
- try{
- Class.forName("com.mysql.jdbc.Driver");
- Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/std","root","");
- Statement stmt=con.createStatement();
- int a=stmt.executeUpdate("insert into stdinto values('"+regno+"','"+name+"','"+age+"','"+gender+"')");
- out.println("value inserted");
- }
- catch(Exception e)
- {
- out.println("error"+e);
- }
- }
- }
- html
- <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
- <title>Insert title here</title>
- </head>
- <body>
- <form action="Insertion" method="post">
- <center><h1>student info</h1><br></center>
- <center>
- <table border="1">
- <tr>
- <td>REG_NO:</td>
- <td><input type="text" name="regno"></td>
- </tr>
- <tr>
- <td>Name:</td>
- <td><Input type="text" name="name"> </td>
- </tr>
- <tr>
- <td>Age:</td>
- <td><Input type="text" name="age"> </td>
- </tr>
- <tr>
- <td>Gender:</td>
- <td><Input type="text" name="gender"> </td>
- </tr>
- <tr>
- <td></td><td><input type="submit" value="submit"></td>
- </tr>
- </table>
- </center>
- </form>
- </body>
- </html>
Add Comment
Please, Sign In to add comment