Update Data Using JSP MySql

updateRecords.jsp

<%@ page language = "java" contentType="text/html; charset=ISO-8859-1"

pageEncoding="ISO-8859-1"%>

<%@ page import = "java.sql.*"%>

<%@page import="java.util.*"%>

<%! boolean success = false; %>

<%

int id = Integer.parseInt(request.getParameter("tid"));

int eid = Integer.parseInt(request.getParameter("employeeID"));

String empName = request.getParameter("employeeName");

String sql= "UPDATE EMP_DETAIL SET emp_id = '"+eid+"', emp_name = '"+empName+"' WHERE id = '" +id+ "'";

Connection con = null;

PreparedStatement psmt = null;

String url = "jdbc:mysql://localhost:3306/test_db";

String driver = "com.mysql.jdbc.Driver";

String userName = "root";

String password = "";

Class.forName(driver).newInstance();

con = DriverManager.getConnection(url,userName,password);

psmt = con.prepareStatement(sql);

//psmt.setInt(2, eid);

//psmt.setString(3, empName);

int nRows = psmt.executeUpdate();

if(nRows == 0){

success = false;

}

else{

success = true;

}

psmt.close(); con.close();

%>

<%

if(success = true){

%>

Record updated

View Records

<%

}

else {

%>

Error - can not be updated

View Records

<%

}

%>

Free Career Predictions