Contact Us
   
   
 
   
   
 
     
 
 
JSP Tutorial
JDBC Tutorial
 
Book Must Read
 
 

JDBC Update Records

 
 
Print   Email
 
     
 

To update in table, we have to use UPDATE sql command.

Update records in table

In this form, we will update records in staff_register table. First make database connection and fetch records which we have to update and display on the form.

Example of Update record in database through JSP

updateRecord.jsp form get records from database and populates on this form for further updation according to requirement.  

Database Table

CREATE TABLE  staff_register (
  `iEmpID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sStaffName` varchar(60) DEFAULT NULL,
  `sStaffDept` varchar(45) DEFAULT NULL,
  `iStaffPhone` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`iEmpID`),
  UNIQUE KEY `sStaffName` (`sStaffName`)
)

updateRecord.jsp

HTML Code Example

<%@ page language="java" import="java.sql.*" errorPage="" %>
<%
        Connection conn = null;
        
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        String jdbcURL="jdbc:mysql://localhost:3306/databaseName";
        conn = DriverManager.getConnection(jdbcURL,"userName", "password");
        
        PreparedStatement psUpdateRecord=null;
        String sqlUpdateRecord=null;
        
        int empID=5;
        String staffName="yoh";
        int staffPhone=45454545; 
        //// if this come blank and aphla number it will throw
        /// parse int NumberFormatException exception, only number
        
        try
        {
            sqlUpdateRecord="update staff_register set sStaffName=?, iStaffPhone=? where iEmpID=?";
            psUpdateRecord=conn.prepareStatement(sqlUpdateRecord);
            psUpdateRecord.setString(1,staffName);
            psUpdateRecord.setInt(2,staffPhone);
            psUpdateRecord.setInt(3,empID);
            
            psUpdateRecord.executeUpdate();
        }
        catch(Exception e)
        {
          response.sendRedirect("updateRecord.jsp");
           //// On error it will send back to addRecord.jsp page
        }
        
        try{
          if(psUpdateRecord!=null)
          {
           psUpdateRecord.close();
          }
          
          if(conn!=null)
          {
           conn.close();
          }
        }
        catch(Exception e)
        {
          e.printStackTrace(); 
        }
%>
<html>
<body>
  Data is updated successfully.
</body>
</html>

JDBC update advance example

 

 

 

     
 
If You Like this Article, share this

 
 
     
   
 
     
     
     
 
  Privacy Policy