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.ResultSetMetaData;

import java.sql.SQLException;

import java.sql.Statement;

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 UpdateUser

*/

@WebServlet("/UpdateUser")

public class UpdateUser extends HttpServlet {

private static final long serialVersionUID = 1L;

/**

* @see HttpServlet#HttpServlet()

*/

public UpdateUser() {

super();

// TODO Auto-generated constructor stub

}

/**

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

*/

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

// TODO Auto-generated method stub

response.setContentType("text/html");

PrintWriter out=response.getWriter();

Connection con = null;

out.println("UPDATE USER");

java.util.Map<String, String[]> parametermap= request.getParameterMap();

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

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

String Name=parametermap.get("Name")[0].toString();

String Email=parametermap.get("Email")[0].toString();

String Phone=parametermap.get("Phone")[0].toString();

out.println(ID);

out.println(Email);

out.println(Phone);

try {

con = openConnection();

//String sql="UPDATE EMPDB.USERDATA WHERE ID="+ ID +" ";

//System.out.println(ID);

updateUser(ID,Name,Email,Phone,con);

out.append("<br>"+" update success");

String qry = "SELECT * FROM empdb.userdata";

Statement st = con.createStatement();

ResultSet rs = st.executeQuery(qry);

out.append("<P ALIGN='center'><TABLE BORDER=1>");

ResultSetMetaData rsmd = rs.getMetaData();

int columnCount = rsmd.getColumnCount();

// table header

out.println("<TR>");

for (int i = 1; i <=columnCount; i++) {

out.append("<TH>" + rsmd.getColumnLabel(i));

}

out.println("<td align='center'><b>Edit/Delete</b></td></TH>");

out.println("</TR>");

// the data

while (rs.next()) {

out.println("<TR>");

for (int i = 1; i <=columnCount; i++) {

out.println("<TD>" + rs.getString(i) + "</TD>");

}

out.append("<td>");

out.print("<form name='edit' method='get' action='./EditUser'>"

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

+"<input type='submit' value='Edit'>"

+"</form>");

out.print("<form name='delete' method='get' action='./DeleteUser'>"

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

+"<input type='submit' value='Delete'>"

+"</form>");

out.println("</td>");

out.println("</TR>");

}

out.println("</TABLE></P>");

con.close();

}

catch (Exception e) {

e.printStackTrace();

}

}

private void updateUser(String ID, String name,String email,String phone,Connection con)

throws SQLException {

PreparedStatement ps;

String sql = "update empdb.userdata set name = ?, email = ?, phone = ? where ID ="+ ID +" ";

ps = con.prepareStatement(sql);

ps.setString(1, name);

ps.setString(2, email);

ps.setString(3, phone);

ps.executeUpdate();

System.out.println("user update!!!!!!!!!");

}

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);

}

}