What is the coding for update table in jsp?

Answer 1

In JSP, you can use a combination of HTML forms and JDBC to update a database table. First, create an HTML form to collect the data that needs to be updated. Then, in your JSP file, use a scriptlet to connect to the database, prepare an SQL UPDATE statement, and execute it based on the form input. Here's a simplified example:

<%@ page import="java.sql.*" %>
<%
    String id = request.getParameter("id");
    String newValue = request.getParameter("newValue");
    Class.forName("com.mysql.jdbc.Driver");
    Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname", "username", "password");
    PreparedStatement ps = con.prepareStatement("UPDATE tablename SET columnname=? WHERE id=?");
    ps.setString(1, newValue);
    ps.setString(2, id);
    ps.executeUpdate();
    ps.close();
    con.close();
%>

Make sure to handle exceptions and manage resources properly in a real application.