Notes

package com.highradius.controller;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class userdata extends HttpServlet{

/**
*
*/
private static final long serialVersionUID = 1L;

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.getWriter().append("Served at: ").append(request.getContextPath());
}
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

Connection dbCon=null;
PreparedStatement pstmt=null;
String url="jdbc:mysql://localhost:3306/076";
String username="devuser";
String password="Demo@123";
int id = Integer.parseInt(request.getParameter("id"));
int jobid = Integer.parseInt(request.getParameter("job_id"));
String shipto = request.getParameter("ship_to");
String query = "update acct_doc_header set jobid=?,shipto=? where id="+id;
try
{
Class.forName("com.mysql.jdbc.Driver");
dbCon=DriverManager.getConnection(url,username,password);
pstmt=dbCon.prepareStatement(query);
pstmt.setInt(1, jobid);
pstmt.setString(2, shipto);
pstmt.executeUpdate();
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
closeResource(pstmt);
closeResource(dbCon);
}

}
private void closeResource(Connection dbCon) {
try {
if(dbCon!=null)
{
dbCon.close();
}

}catch(Exception e)
{
System.out.println("Hello"+e);
}

}


private void closeResource(PreparedStatement pstmt) {
try {
if(pstmt!=null)
{
pstmt.close();
}

}catch(Exception e)
{
System.out.println(e);
}


}

}