import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.Map;

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 EditUser

*/

@WebServlet("/EditUser")

public class EditUser extends HttpServlet {

private static final long serialVersionUID = 1L;

/**

* @see HttpServlet#HttpServlet()

*/

public EditUser() {

super();

// TODO Auto-generated constructor stub

}

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

*/

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

response.setContentType("text/html");

PrintWriter out = response.getWriter();

out.println("Edit user");

Map<String, String[]> parameterMap = request.getParameterMap();

String ID = parameterMap.get("ID")[0].toString();

//out.println(ID);

try {

Connection con = null;

con = openConnection();

ResultSet rs = loadUser(ID, con);

rs.next();

out.append("<p align=center>Update User: </p>");

out.append("</br>" );

out.append("<form name='Per' action='./UpdateUser' method='post'>"

+ "<table>"

+ "<tbody>"

+ "<tr><td>Name: </td>"

+ "<td><input type='text' name='Name' value='"+ rs.getString(2)+"' />"

+ "</tr><tr><td>Email: </td>"

+ "<td><input type='text' name='Email' value='"+ rs.getString(3)+"' />"

+ "</tr>"

+ "<tr><td>Phone: </td>"

+ "<td><input type='text' name='Phone' value='"+ rs.getString(4)+"' />"

+ "</tr><tr><td>&nbsp;</td>"

+ "<td>"

+ "<input type='hidden' name='action' value='update'/>"

+ "<input type='hidden'name='ID' value='"+rs.getInt(1)+"'/>"

/*+ "<input type='hidden'name='name' value='"+rs.getInt(2)+"'/>"

+ "<input type='hidden'name='email' value='"+rs.getInt(3)+"'/>"

+ "<input type='hidden'name='phone' value='"+rs.getInt(4)+"'/>"*/

+ "<input type='submit' value='update'/>"

+ "</tr></tbody>"

+ "</table>");

//printEditUserdetailsLink(out,rs);

} catch (Exception e) {

e.printStackTrace();

}

}

private ResultSet loadUser(String ID,Connection con) throws SQLException {

String qry = "SELECT * FROM empdb.userdata where ID=?";

PreparedStatement ps = con.prepareStatement(qry);

ps.setString(1, ID);

ResultSet rs = ps.executeQuery();

return rs;

}

private Connection openConnection() throws ClassNotFoundException, SQLException {

Connection con;

Class.forName("com.mysql.jdbc.Driver");

con = DriverManager.getConnection("jdbc:mysql://localhost:3306/empdb", "root", "root");

System.out.println("connection success");

return con;

}

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

*/

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

// TODO Auto-generated method stub

doGet(request, response);

}

}