@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Location</title>
</head>
<body>
<h1>Fill Up Your Details</h1>
<center> <form action="hit" method="POST">
<fieldset>
<b> iGnite Id:</b><input type="text" name="id" placeholder="Ignite Id"><br><br>
<b>Your Name:</b><input type="text" name="name" placeholder="Name"><br><br>
<b> Home Town:</b><input type="text" name="home" placeholder="Home"><br><br>
<b>Location:</b><input type="text" name="location" placeholder="Location"><br><br>
<b>Gender</b><input type="radio" name="sex" value="male">Male
<input type="radio" name="sex" value="female">Female<br><br>
<b>Choice</b><input type="checkbox" name="choice" value="Kolkata">Kolkata
<input type="checkbox" name="choice" value="Chennai">Chennai
<input type="checkbox" name="choice" value="Mumbai">Mumbai
<input type="checkbox" name="choice" value="Delhi">Delhi<br>
<input type="submit" name="submit" value="Submit">
</fieldset>
<center><a href="view.jsp"><h1>VIEW</h1></a></center>
</form></center>
</body>
</html>
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.ResultSet"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<center> <h1>View Your Location</h1>
<form action="view" method="POST">
<b> Enter Your Ignite Id:</b><input type="text" name="id" placeholder="IgniteId"><br><br>
<input type="submit" value="SUBMIT" name="submit"><br><br><br>
<table border="2">
<th>Name</th>
<th>home</th>
<th>Location</th>
<%
try {
ResultSet rs = (ResultSet) request.getAttribute("data");
while (rs.next()) {
%>
<tr>
<td><input type="text" value="<%=rs.getString("name")%>"</td>
<td><input type="text" value="<%=rs.getString("home")%>"</td>
<td><input type="text" value="<%=rs.getString("location")%>"</td>
</tr>
<% }
} catch (Exception e) {
}
%>
</table>
</form> </center> </body>
</html>
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
insert int data base
@@@@@@@@@
import com.mysql.jdbc.PreparedStatement;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
*
* @author ignite178
*/
public class hit 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");
PrintWriter out = response.getWriter();
try {
/*
* TODO output your page here. You may use following sample code.
*/
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet hit</title>");
out.println("</head>");
out.println("<body>");
out.println("<h1>Servlet hit at " + request.getContextPath() + "</h1>");
out.println("</body>");
out.println("</html>");
} finally {
out.close();
}
}
// <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 {
PrintWriter out=response.getWriter();
String Id=request.getParameter("id");
String Name=request.getParameter("name");
String Home=request.getParameter("home");
String Location=request.getParameter("location");
String Gender=request.getParameter("sex");
String Choice=request.getParameter("choice");
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/location", "root", "root");
String sql="INSERT INTO posting (ignite_id,name,home,location,gender,choice) VALUES('"+Id+"','"+Name+"','"+Home+"','"+Location+"','"+Gender+"','"+Choice+"')";
PreparedStatement ps=(PreparedStatement) con.prepareStatement(sql);
ps.executeUpdate();
ps.close();
con.close();
}
catch(Exception e)
{
out.print(e.toString());
}
finally{
out.print("Submit Successfully");
out.close();
}
}
/**
* Returns a short description of the servlet.
*
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return "Short description";
}// </editor-fold>
}
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@222
how to fetch
@@@@@@@@@@@@@@@
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.DriverManager;
import java.sql.ResultSet;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
*
* @author ignite178
*/
public class view extends HttpServlet {
private ServletResponse response;
/**
* 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");
PrintWriter out = response.getWriter();
try {
/*
* TODO output your page here. You may use following sample code.
*/
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet hit</title>");
out.println("</head>");
out.println("<body>");
out.println("<h1>Servlet hit at " + request.getContextPath() + "</h1>");
out.println("</body>");
out.println("</html>");
} finally {
out.close();
}
}
// <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 {
// try {
// try {
// Class.forName("com.mysql.jdbc.Driver").newInstance();
// } catch (InstantiationException ex) {
// Logger.getLogger(view.class.getName()).log(Level.SEVERE, null, ex);
// } catch (IllegalAccessException ex) {
// Logger.getLogger(view.class.getName()).log(Level.SEVERE, null, ex);
// }
// } catch (ClassNotFoundException ex) {
// Logger.getLogger(view.class.getName()).log(Level.SEVERE, null, ex);
// }
// Connection con = null;
// try {
// con = DriverManager.getConnection("jdbc:mysql://localhost:3306/location", "root", "root");
// } catch (SQLException ex) {
// Logger.getLogger(view.class.getName()).log(Level.SEVERE, null, ex);
// }
// String id=request.getParameter("id");
// String query = "select * from posting where ignite_id='"+id+"'";
// Statement s = null;
// try {
// s = con.createStatement();
// } catch (SQLException ex) {
// Logger.getLogger(view.class.getName()).log(Level.SEVERE, null, ex);
// }
// ResultSet rs = null;
// try {
// rs = s.executeQuery(query);
// } catch (SQLException ex) {
// Logger.getLogger(view.class.getName()).log(Level.SEVERE, null, ex);
// }
// request.setAttribute("data", rs);
// RequestDispatcher rd = request.getRequestDispatcher("view.jsp");
// rd.forward(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 {
PrintWriter out = response.getWriter();
String Id = request.getParameter("id");
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/location", "root", "root");
String id=request.getParameter("id");
String query = "select * from posting where ignite_id='"+id+"'";
Statement s = null;
s = (Statement) con.createStatement();
ResultSet rs = null;
rs = s.executeQuery(query);
request.setAttribute("data", rs);
RequestDispatcher rd = request.getRequestDispatcher("view.jsp");
rd.forward(request, response);
} catch (Exception e) {
out.print(e.toString());
} finally {
out.close();
}
}
/**
* Returns a short description of the servlet.
*
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return "Short description";
}// </editor-fold>
}
Ads
