Database modification Using JSp

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

 
<%!
Connection con;
PreparedStatement pst;
ResultSet rs;
String reg1=null;
String nm=null;
String add=null;


%>

<%

try
{

Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","root","ims");


}
catch(SQLException e)
{

e.printStackTrace();
}


String sb=request.getParameter("s1");



if(sb.equals("Update"))

{
int id1=Integer.parseInt(request.getParameter("id"));
String user=request.getParameter("user");
String add=request.getParameter("add");
     String email=request.getParameter("email");
String   contact=request.getParameter("contact");



try
{

String query="update customer set name=?,address=?,email=?,contact=? where customer_id=?";
pst=con.prepareStatement(query);



 pst.setString(1,user);
 pst.setString(2,add);
 pst.setString(3,email);
 pst.setString(4,contact);
 pst.setInt(5,id1);

 int i=pst.executeUpdate();

 if(i>0)
 {
%>
<h1>Updated</h1>
<%

 }
 else
 {
%>
<h1>Not Updated</h1>
<%
 }




}
catch(Exception ex)
{

}
}


//for delete
 if(sb.equals("Delete"))
{
try
{
int id1=Integer.parseInt(request.getParameter("id"));
pst=con.prepareStatement("delete from  customer where  customer_id=?");

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

out.println(id1);

pst.setInt(1,id1);
int i=pst.executeUpdate();


if(i>0)
{
out.println(i+ "Record Deleted");
}
else
{
out.println("problem");
}


}
catch(Exception ex)
{

}
}
else
{}
%>Aryantech India Pune

Best IT Traning Institute