Introduction:
Sometimes we want to change the inserted data into the database.
If you want to update the student_name in our exam table, you’ll use a SQL statement like the one below:
mysql > update exam set student_name=’suresh’ where student_name=’sureshkumar’;
Problem:
Update data in mysql database.
We have to change student_name as kannanto kamalkannan.
Procedure:
Already How to import mysql-connector.jar and how to create database and how to create table and how to insert data into the table and how to select the inserted data in exam table.
Step 1:
Use update SQL statement to update data in our exam table.
We use update SQL statement to update data in mysql
Step 2:
Create jsp file I have used file name as updatePro.
Include following coding into updatePro
< %@page contentType="text/html" pageEncoding="UTF-8"% >
< !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
http://www.w3.org/TR/html4/loose.dtd >
< %@page import="java.sql.*" % >
< html >
< head >
< title > Java DataBase Connectivity Example-Update Query < /title >
< /head >
< body >
< %!
Connection con=null;
ResultSet rs=null;
Statement stmt=null;
% >
< %
try
{
Class.forName("com.mysql.jdbc.Driver");
}
catch(Exception e)
{
out.println(e.getMessage());
}
try
{
con=DriverManager.getConnection("jdbc:mysql://localhost/example","root","sure");
stmt=con.createStatement();
int i=stmt.executeUpdate("update exam set student_name='kamalkannan' where student_name='kannan'");
if(i==1)
{
out.println("Successfully Updated");
}
else
{
out.println("Error For Updated");
}
}
catch(Exception e)
{
out.println(e.getMessage());
}
finally
{
con.close();
stmt.close();
}
% >
< /body >
< /html >
Step 3:
Step 4:
