How to update a image using servlet?

[Rd Dari]

Hi all,

I am new in image uploading and updating I uploaded an images in my project and want to update a image usingservlet using id which is PK in society table.
But I am not able to get it. Please help me.

this is my code for uploading image:

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package src;

import java.util.logging.Level;
import java.util.logging.Logger;
import java.io.*;
import java.sql.*;
import java.util.*;
import java.util.regex.*;
import org.apache.commons.fileupload.servlet.ServletFileUpload;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.*;
import javax.servlet.*;
import javax.servlet.http.*;

/**
 *
 * @author Marketting
 */
public class UploadImage_servlet extends HttpServlet {
    // String query=null;

    HttpSession session;
    String image_id = null;
    JdbcConnection jdbc;
    Connection con;
    Statement st;
    PreparedStatement pst;
    ResultSet rs;

    /**
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        //PrintWriter out = response.getWriter();
        
        session = request.getSession(true);
        id_generation obj = new id_generation();
        jdbc = new JdbcConnection();
        con = jdbc.getConnection();
        String ab = null;
        String filename = "na";
        String  path = null;
        ArrayList itmNme = new ArrayList();

        boolean isMultipart = ServletFileUpload.isMultipartContent(request);
        System.out.println("request: " + request);
        if (!isMultipart) {
            System.out.println("File Not Uploaded");
        } else {
            FileItemFactory factory = new DiskFileItemFactory();
            ServletFileUpload upload = new ServletFileUpload(factory);
            List items = null;
            ArrayList final_image1 = null;
            try {
                // Random generator = new Random();
                //int r = Math.abs(generator.nextInt());
                 image_id = obj.facility_id();
               // System.out.println("the r is =="+r);
               // image_id="PIC"+r;
                session.setAttribute("image_id", image_id);
                  File dir = new File(getServletContext().getRealPath("/") + "exampleimages\\"+"\\" + File.separator);
                  //File dir1 = new File(getServletContext().getRealPath("/") + "exampleimages\\"+image_id + File.separator);
                 // System.out.println("dir=" + dir);
                 // String image_folder= dir1.getName();
                  //int r = image_folder.indexOf("_");
                  //String folder = filename.substring(0, r);
                  String[] children = dir.list();
                  if (children == null) {
                  } else {
                      for (int i = 0; i < children.length; i++) {
                          // Get filename of file or directory
                          if ("Thumbs.db".equalsIgnoreCase(children[i])) {
                          } else {
                              filename = children[i];
                             // int r1 = filename.indexOf("_");
                              String na = filename;//.substring(0, r1);
                              if (na.equalsIgnoreCase(image_id)) {
                                  System.out.println("image id is:"+na+" image id is:::"+image_id);
                                  File dir1 = new File(getServletContext().getRealPath("/") + "exampleimages\\"+image_id);
                                  String[] children1 = dir1.list();
                                  if(children1==null){}else{
                                  for(int j = 0; j < children1.length; j++) {
                                      File dir11 = new File(getServletContext().getRealPath("/") + "exampleimages\\"+image_id+"\\"+children1[j]);
                                      dir11.delete();
                                     }
                                  }
                                   dir1.delete();
                              }
                          }
                      }
                  }
                  final_image1 = new ArrayList();
                  items = upload.parseRequest(request);
                 //final_image1.add(items);
                // st=(Statement)con.createStatement();
                //System.out.println("items: " + final_image1);
                Iterator itr = items.iterator();
                while (itr.hasNext()) {
                    //List li=(ArrayList) itr.next();
                    //Iterator it =li.iterator();
                    //while (it.hasNext()) {
                    FileItem item = (FileItem) itr.next();
                    System.out.println("itemName "+item);
                    if (item.isFormField()) {
                         //String name = item.getFieldName();
                        // System.out.println("name: " + name);
                        // String value = item.getString();
                        //System.out.println("value: " + value);
                    } else {
                        String itemName = item.getName();

                        itmNme.add(itemName);
                        if(itemName.trim().equalsIgnoreCase(""))
                        {}
                        else
                        {
                            //Random generator = new Random();
                            //int r = Math.abs(generator.nextInt());
                            itemName=itemName.replace("\\", "_");
                            ArrayList itemName1 = new ArrayList();
                            String[] item11=itemName.split("_");
                            for(int i=0;i<item11.length;i++){
                                itemName1.add(item11[i]);
                        }
                        int j=itemName1.size();
                        itemName=itemName1.get(j-1).toString();
                        String reg = "[.*]";
                        String replacingtext = "";
                        // System.out.println("Text before replacing is:-" + replacingtext);
                        Pattern pattern = Pattern.compile(reg);
                        Matcher matcher = pattern.matcher(itemName);
                        StringBuffer buffer = new StringBuffer();


                        while (matcher.find()) {
                            matcher.appendReplacement(buffer, replacingtext);
                        }
                        int IndexOf = itemName.indexOf(".");
                        String domainName = itemName.substring(IndexOf);

                        System.out.println("domainName: " + domainName);
                        String finalimage =image_id +"_"+buffer.toString()+domainName;
                       // String finalimage = image_id.toString() + "_" + buffer + domainName;
                        System.out.println(" final_image1 is:::"+finalimage);
                        //System.out.println("Temp File Location "+System.getProperty("java.io.tmpdir"));
                       // File savedFile1 = File.createTempFile(finalimage, domainName).getParentFile();
                         //String final_img = File.createTempFile(finalimage,"1").getParent();

                      // savedFile1.mkdir();
                      // System.out.println(" savedFile1.mkdir():::"+final_img);
                        final_image1.add(finalimage);

                        //String finalimage = image_id + domainName;
                        //System.out.println("Final Image===" + finalimage);
                        File savedFile1 = new File(getServletContext().getRealPath("/") + "/example" + "images\\" + image_id.toString());
                        if(savedFile1.exists()) {
                            File savedFile = new File(getServletContext().getRealPath("/") + "/example" + "images\\" + image_id.toString()+"\\"+ finalimage);
                            boolean b = savedFile.createNewFile();
                           path = savedFile.getPath();
                            item.write(savedFile);
                        } else {
                            boolean b1 = savedFile1.mkdir();
                            File savedFile = new File(getServletContext().getRealPath("/") + "/example" + "images\\" + image_id.toString()+"\\"+ finalimage);
                            boolean b = savedFile.createNewFile();
                            path = savedFile.getPath();
                            item.write(savedFile);
                          }
                        }
                      }
                     }
                session.setAttribute("itmNme", itmNme);
                session.setAttribute("final_image1", final_image1);
                session.setAttribute("path", path);
                RequestDispatcher rd = request.getRequestDispatcher("Create_Society2.jsp");
                rd.forward(request, response);

            } catch (FileUploadException e) {
                e.printStackTrace();
            } catch (Exception ex) {
                Logger.getLogger(UploadImage_servlet.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>
}

thanks in advanc.

[jeya velan]

Do not understand what your problem is.
If getting the generated PK is the problem, than you can use the below code if you are using Prepared Statement and
your database supports identity columns

PreparedStatement pstmt = con.prepareStatement(YourQueryGoesHere,
          Statement.RETURN_GENERATED_KEYS);
pstmt.executeUpdate();
ResultSet keys = pstmt.getGeneratedKeys();
keys.next();
int key = keys.getInt(1);

[Rd Dari]

Hi,

I want to say that this above code for image uploading when I create a society (means residential or commercial area)form but when I want to update this form then what is the process use for updating the only images.

I updated all the form field in one servlet and want to update two images in a seprate servlet because I am using two forms in one jsp........
this is my project task flow when I searching societies then it will show a Update button onclick this button will go on edit_society based on society id e.g. SOC000001 and so on after then this page action will go for UpdateImageSociety servlet which is below after this jsp.

this is the jsp page...

<%-- 
    Document   : edit_society
    Created on : Sep 16, 2011, 4:54:07 PM
    Author     : Reshma
--%>

<%@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 language="java" import="java.sql.*, src.*,java.util.Date,java.util.*,java.text.SimpleDateFormat,java.text.DecimalFormat"
    session="true" %>
    <jsp:include page="header.jsp"/>
    <%
  String username=(String)session.getAttribute("user");
  System.out.println("username is==="+username);
  if(username==null)
      {
      response.sendRedirect("error.jsp");
  }else{
                    String id=request.getParameter("soc_id");
                    System.out.println("id in edit_society.jsp....... "+id);
  %>
<html>
    <head>
        <%String CNFM="CNFM";%>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Society</title>
        <LINK rel=stylesheet href="stylesheet/fac_css.css">
         <link href="stylsheet/facility_stl.css" rel="stylesheet" type="text/css"/>
            <script type="text/javascript" language="javascript">
                 function Checked()
            {
                if(document.getElementById('rad1').checked)
                    {
                       document.getElementById('tr1').style.display="";
                       document.getElementById('ser').style.display="";
                    }
                  else
                        {
                            document.getElementById('tr1').style.display="none";
                            document.getElementById('ser').style.display="none";
                        }
            }
                 function addRow(pays)
                {
                var table = document.getElementById(pays);
                var rowCount = table.rows.length;
                var row = table.insertRow(rowCount);
                row.id = 'rw'+rowCount;
              //  row.className='text2';

                var cell2 = row.insertCell(0);
                var element2 = document.createElement("input");
                element2.type="text";
                element2.name ="info_no";
                element2.size = "17";
                element2.id = 'pcn'+rowCount;
                cell2.appendChild(element2);
                var col='pcn';
                document.getElementById(col+rowCount).focus();

                var cell3 = row.insertCell(1);
                var element3 = document.createElement("input");
                element3.type="text";
                element3.name ="info_type";
                element3.size = "17";
                element3.id = 'bd'+rowCount;
                cell3.appendChild(element3);
                var col='bd';

                var cell4 = row.insertCell(2);
                var element = document.createElement("input");
                element.type="text";
                element.name ="info_area";
                element.size = "17";
                element.id='bath'+rowCount;
                cell4.appendChild(element);

                var cell6 = row.insertCell(3);
                var element6 = document.createElement("input");
                element6.type="text";
                element6.name ="info_bhk_villa";
                element6.size = "17";
                element6.id='mnth'+rowCount;
                cell6.appendChild(element6);

                var cell7 = row.insertCell(4);
                var element7 = document.createElement("input");
                element7.type="text";
                element7.name ="info_flats";
                element7.size = "17";
                element7.id='depo'+rowCount;
                cell7.appendChild(element7);

                var cell8 = row.insertCell(5);
                var element8 = document.createElement("input");
                element8.type="text";
                element8.name ="info_penta_house";
                element8.size = "17";
                element8.id='depo'+rowCount;
                cell8.appendChild(element8);

                var cell4 = row.insertCell(6);
                var element4 = document.createElement("input");
                element4.type = "button";
                element4.value = "Add";
                element4.className='button';
                element4.onclick = function(){addRow('pays');}
                cell4.appendChild(element4);

                var cell5 = row.insertCell(7);
                var element5 = document.createElement("input");
                element5.type = "button";
                element5.value = "Del";
                element5.id='del';
                element5.className='button';
                cell5.appendChild(element5);
                element5.onclick = function(){removeRowFromTable('pays');}
            }
            function removeRowFromTable(pays)
            {
                var tbl = document.getElementById(pays);
                var lastRow = tbl.rows.length;
                if (lastRow > 2){
                    tbl.deleteRow(lastRow - 1);
                }
                else{
                    alert("sorry!! this row can not be deleted");
                }
            }

             function addRowfacs(facs)
                {
                var table = document.getElementById(facs);
                var rowCount = table.rows.length;
                var row = table.insertRow(rowCount);
                row.id = 'rw'+rowCount;
               // row.className='text2';


                var cell6 = row.insertCell(0);
                var element6 = document.createElement("input");
                element6.type="text";
                element6.name ="faci_facility_name";
                element6.size = "17";
                element6.id='mnth'+rowCount;
                cell6.appendChild(element6);

                var cell3 = row.insertCell(1);
                // var element3 = document.createElement(
                //"<select name='info_type' id='pcn"+rowCount+"'><option></option></select><a HREF='javascript:void(0)' onclick='window.open('society_type.jsp?CNFM=<%//=CNFM%>')'><img src='images/bullet.gif' height='20' id='facimg'  style='border: none; vertical-align: bottom'></a>");
                 var element3 = document.createElement(
                "<select name='info_type' id='pcn"+rowCount+"'><option></option></select>");
                 cell3.appendChild(element3);
                 acc("pcn"+rowCount);
               


                var cell2 = row.insertCell(2);
                var element2 = document.createElement("input");
                element2.type="text";
                element2.name ="faci_no";
                element2.size = "17";
                element2.id = 'pcn'+rowCount;
                cell2.appendChild(element2);
                var col='pcn';
                document.getElementById(col+rowCount).focus();



                var cell4 = row.insertCell(3);
                var element = document.createElement("input");
                element.type="text";
                element.name ="faci_area";
                element.size = "17";
                element.id='bath'+rowCount;
                cell4.appendChild(element);



                 var cell7 = row.insertCell(4);
                var element7 = document.createElement("input");
                element7.type="text";
                element7.name ="faci_description";
                element7.size ="17";
                element7.id='mnth'+rowCount;
                cell7.appendChild(element7);

                var cell8 = row.insertCell(5);
                var element4 = document.createElement("input");
                element4.type = "button";
                element4.value = "Add";
                element4.className='button';
                element4.onclick = function(){addRowfacs('facs');}
                cell8.appendChild(element4);

                var cell9 = row.insertCell(6);
                var element5 = document.createElement("input");
                element5.type = "button";
                element5.value = "Del";
                element5.id='del';
                element5.className='button';
                cell9.appendChild(element5);
                element5.onclick = function(){removeRowfacs('facs');}
            }
            function removeRowfacs(facs)
            {
                var tbl = document.getElementById(facs);
                var lastRow = tbl.rows.length;
                if (lastRow > 2){
                    tbl.deleteRow(lastRow - 1);
                } else{
                    alert("sorry!! this row can not be deleted");
                }
            }


            function uploadimg()
            {
                Alert.fnAlert("Please Upload Pictutes First!!!");
            }
        function validation()
        {
            if(document.getElementById("pic").value=="")
                {
                    alert("Please browse the picture!!!");
                    document.getElementById("pic").focus();
                    return false;
                }
                if(document.getElementById("google").value=="")
                {
                    alert("Please browse the google map!!!");
                    document.getElementById("google").focus();
                    return false;
                }
                return true;
        }

   </script>
          <script language="javascript" type="text/javascript">
        var tk;
        function acc(pcn)
          {
              tk=pcn;

            var randomnumber=Math.floor(Math.random()*999999);
            var url="facility_type_servlet?randomnum=" + randomnumber;
            if (window.XMLHttpRequest)
                {
                    // code for Mozilla, Safari, etc
                    http=new XMLHttpRequest();
                    if (http.overrideMimeType)
                        {
                            http.overrideMimeType('text/xml');
                        }
                        http.open("GET", url, true);
                    }//If close
                    else if (window.ActiveXObject)
                        {
                            http=new ActiveXObject('Microsoft.XMLHTTP');
                            if (http)
                                {
                                    http.open("GET", url, false);
                                }
                            }
                            http.onreadystatechange = hleHttpResponse44;
                            http.send(null);
            }
             function trim(string)
                {
                    var LENGTH = string.length;
                    var beginIndex = 0;
                    while (beginIndex != LENGTH && string.charAt(beginIndex) <=' ')
                    {
                        beginIndex++;
                    }
                    /* If all characters are whitespace then return the empty String. */
                    if (beginIndex == LENGTH)
                    {
                        return "";
                    }
                    /* Find the last character that is not whitespace. */
                    var endIndex = LENGTH;
                    while (endIndex != beginIndex && string.charAt(endIndex - 1) <= ' ')
                    {
                        endIndex--;
                    }
                    return ((beginIndex == 0) && (endIndex == LENGTH)) ?
                    string : string.substring(beginIndex, endIndex);
                }
                        function hleHttpResponse44() {
                            if (http.readyState == 4)
                            {
                                    //var as=http.responseText;
                                     var inner =http.responseText;

                                     select_innerHTML(document.getElementById(tk),inner);
                            }
                        }

        /*var timeoutID=0;
            function submitforms()
            {

                document.addsociety.submit();
                 document.upload.submit();
               // setTimeout("slowAlert()", 10000);

            }
            function slowAlert()
            {
                alert("hiii");
                document.upload.submit();

            }  */
   function uploadimg()
            {
                Alert.fnAlert("You have Uploaded Pictutes!!!");
            }
  /*function afterupload()
    {
      Alert.fnAlert("Your pictures uploaded successfully!!!");
    }*/




  function societyagain()
    {
       var randomnumber=Math.floor(Math.random()*999999);

        var url="societyagain_servlet?randomnum="+randomnumber;
        if (window.XMLHttpRequest)
        {
            // code for Mozilla, Safari, etc
            http=new XMLHttpRequest();
            if (http.overrideMimeType)
            {
                http.overrideMimeType('text/xml');
            }
            http.open("GET", url, true);

        }//If close
        else if (window.ActiveXObject)
        {
            http=new ActiveXObject('Microsoft.XMLHTTP');
            if (http)
            {
                http.open("GET", url, false);
            }
        }
        http.onreadystatechange = hleHttpResponse_state;
        http.send(null);
    }
   
    function hleHttpResponse_state() {
    if (http.readyState == 4)
        {
        select_innerHTML(document.getElementById("typsty"), http.responseText);
        }
        }
 function select_innerHTML(objeto,innerHTML)
{
   objeto.innerHTML = ""
    var selTemp = document.createElement("micoxselect")
    var opt;
    selTemp.id="micoxselect1"
    document.body.appendChild(selTemp)
    selTemp = document.getElementById("micoxselect1")
    selTemp.style.display="none"
    if(innerHTML.indexOf("<option")<0){//se não é option eu converto
        innerHTML = "<option>" + innerHTML + "</option>"
    }
    innerHTML = innerHTML.replace(/<option/g,"<span").replace(/<\/option/g,"</span")
    selTemp.innerHTML = innerHTML


    for(var i=0;i<selTemp.childNodes.length;i++){
  var spantemp = selTemp.childNodes[i];

        if(spantemp.tagName){
            opt = document.createElement("OPTION")

   if(document.all){ //IE
    objeto.add(opt)
   }else{
    objeto.appendChild(opt)
   }

   //getting attributes
   for(var j=0; j<spantemp.attributes.length ; j++){
    var attrName = spantemp.attributes[j].nodeName;
    var attrVal = spantemp.attributes[j].nodeValue;
    if(attrVal){
     try{
      opt.setAttribute(attrName,attrVal);
      opt.setAttributeNode(spantemp.attributes[j].cloneNode(true));
     }catch(e){}
    }
   }
   //getting styles
   if(spantemp.style){
    for(var y in spantemp.style){
     try{opt.style[y] = spantemp.style[y];}catch(e){}
    }
   }
   //value and text
   opt.value = spantemp.getAttribute("value")
   opt.text = spantemp.innerHTML
   //IE
   opt.selected = spantemp.getAttribute('selected');
   opt.className = spantemp.className;
  }
 }
 document.body.removeChild(selTemp)
 selTemp = null
}
function statechange()
            {
                if(document.getElementById("ch1").checked)
                    {
                            document.getElementById("text1").disabled=false;
                    }else
                         {
                            document.getElementById("text1").disabled=true;
                         }
                if(document.getElementById("ch2").checked)
                    {
                            document.getElementById("text2").disabled=false;
                    }else
                         {
                            document.getElementById("text2").disabled=true;
                         }
                if(document.getElementById("ch3").checked)
                    {
                            document.getElementById("text3").disabled=false;
                    }else
                         {
                            document.getElementById("text3").disabled=true;
                         }
                if(document.getElementById("ch4").checked)
                    {
                            document.getElementById("text4").disabled=false;
                    }else
                         {
                            document.getElementById("text4").disabled=true;
                         }
            }
        function Addition(form)
            {
                //add value of more than two text fields in javascript
                var a=+form.document.getElementById("text1").value;
                var b=+form.document.getElementById("text2").value;
                var c=+form.document.getElementById("text3").value;
                var d=+form.document.getElementById("text4").value;
                var e=parseInt(a+b+c+d);
                form.total_amount.value=e;

            }
             function statechangeDGPowerBackup()
            {
                if(document.getElementById("adgpb").checked)
                    {
                            document.getElementById("dg").disabled=false;
                    }else
                         {
                            document.getElementById("dg").disabled=true;
                         }
            }
            function Checked123()
            {
                if(document.getElementById("yes").checked)
                    {
                        document.getElementById("tr2").style.display="";
                        document.getElementById("per").style.display="";
                        document.getElementById("fix").style.display="";
                    }
                    else
                        {
                        document.getElementById("tr2").style.display="none";
                        document.getElementById("per").style.display="none";
                        document.getElementById("fix").style.display="none";
                        }
            }


   </script>
    <link rel="stylesheet" type="text/css" href="alert.css" />
    <script type="text/javascript" src="js-core.js"></script>
     <script type="text/javascript" src="alert.js"></script>
    </head>
      <%
      
  String qrt=null;
  JdbcConnection obj=new JdbcConnection();
  DecimalFormat fm=new DecimalFormat("0.0");
  Connection con=null;
  Statement stmt=null;
  ResultSet rs=null;
%>
<body>

        <div id="welcome">
           <div id="welcome_in">
            <div id="welcome_in_left">Create Society</div>
            <div id="welcome_in_right">
                <% 
                     String login_user = (String)session.getAttribute("user");
                %>
            <div id="welcome_in_right_right">Welcome: <%=login_user%></div>
            <div id="welcome_in_right_left"><img src="images/afterlogintop_icon.jpg" width="42" height="30"></div>
            </div>
         </div>
        </div>
        <div id="container1" >
        <div style="height:3px; "></div>

        <table width="900" border="0" cellspacing="0" cellpadding="0" rules="rows" style="border:1px solid #cccccc;">
            <form name="upload" action="UpdateImageSociety?soc_id=<%=id%>"  method="post" >
                <tr>
                   <td width="130">
                       <table width="88%" align="left" cellpadding="0" cellspacing="0" >
                          <tr >
                              <td width="480" class="centerfont" >Society Picture</td>
                              <td class="centerfont"><input type="file"  id="pic" name="society_picture" value=""></td>
                        </tr>
                        <tr >
                           <td class="centerfont" >Google Map</td>
                           <td class="centerfont"><input type="file"  id="google" name="google_map" value=""></td>
                        </tr>
                        </table>
                        </td>
                          <td >
                              <table width="90%" align="center" cellpadding="0" cellspacing="0" >
                                  <tr >
                            <td></td>
                            <td class="centerfont"><input type="submit"  class="button" value="Upload" onclick="//return uploadimg();"></td>
                        </tr>
                              </table>
                          </td>
                    </tr>
              </form>
              <tr>
                  <td colspan="2">
                   <table width="900" border="0" cellspacing="0" cellpadding="0" rules="rows" style="border:1px solid #cccccc;">
                         <form name="updatesociety" action=""  method="post" onsubmit="return validate();">
                        <tr >
                           <td class="centerfont" width="264">Society Name</td>
                           <td class="centerfont"><input type="text" name="society_name" value=""></td>
                        </tr>
                        <tr >
                           <td class="centerfont" width="264">Society Address</td>
                           <td class="centerfont"><input type="text" name="society_address" value=""></td>
                        </tr>

                        <tr>
                           <td class="centerfont" width="264">Types Of Society</td>
                           <td class="centerfont">
                               <select name="type_of_society" id="typsty">
                                  <option value="">Select Society Type</option>
                                 <%
                                  con=obj.getConnection();
                                  stmt=(Statement)con.createStatement();
                                  qrt="select * from society_types";
                                 // System.out.println("qry is::"+qrt);
                                  rs=stmt.executeQuery(qrt);
                                  if(rs.next()==false){}
                                  else{rs=stmt.executeQuery(qrt);
                                  while (rs.next())
                                 {  %>
                         <option value="<%=rs.getString(2)%>"><%=rs.getString(2)%></option>
                                <%}}%>
                             </select>
                                <a HREF="javascript:void(0)" onclick="window.open('society_type.jsp?CNFM=<%=CNFM%>')"><img src="images/bullet.gif" height="20" id="facimg"  style="border: none; vertical-align: bottom"></a></td>
                        </tr>
                         <tr>
                           <td class="centerfont" width="264">Location</td>
                           <td class="centerfont"><input type="text" name="society_location" value=""></td>
                        </tr>
                           <tr>
                           <td class="centerfont" width="264">Direction</td>
                           <td class="centerfont"><input type="text" name="society_direction" value=""></td>
                        </tr>
                          <tr>
                           <td class="centerfont" width="264">Total Area</td>
                           <td class="centerfont"><input type="text" name="society_totalarea" value=""></td>
                        </tr>
                          <tr >
                           <td class="centerfont" width="264">No. Of Towers</td>
                           <td class="centerfont"><input type="text" name="noof_towers" value=""></td>
                        </tr>
                        <tr>
                            <td class="centerfont" >Society Area</td>
                            <td class="centerfont"><input type="text" name="society_area" value=""></td>
                        </tr>
                        <tr>
                            <td class="centerfont" >Parking Space</td>
                            <td class="centerfont"><input type="text" name="parking_space" value=""></td>
                        </tr>

                        <tr>
                            <td class="centerfont" >Distance From Airport</td>
                            <td class="centerfont"><input type="text" name="air_distance" value=""></td>
                        </tr>

                        <tr>
                            <td class="centerfont" >Distance From Railway Station</td>
                            <td class="centerfont"><input type="text" name="rail_distance" value=""></td>
                        </tr>

                        <tr>
                            <td class="centerfont" >Distance From Hospital</td>
                            <td class="centerfont"><input type="text" name="hospital_distance" value=""></td>
                        </tr>

                        <tr>
                            <td class="centerfont" >Distance From Market</td>
                            <td class="centerfont"><input type="text" name="market_distance" value=""></td>
                        </tr>
                         <tr>
                            <td class="centerfont">Maintenance Type
                                 <label style="float: right; padding-top: 2px;">Fixed</label><input style="float: right;"  type="radio" checked name="maintainance_type" value="Fixed" id="restat" ></td>
                             <td class="centerfont" ><input style="float: left;" type="radio" name="maintainance_type" value="Per Squar Feet" id="restat1" ><label style="float: left; padding-top: 2px;">Per Square Foot </label>
                                            <input style="float: left; padding-left: 10px;" type="radio" name="maintainance_type" value="Monthly" id="restat1" ><label style="float: left; padding-top: 2px;">Monthly</label></td>
                        </tr>
                        <tr>
                            <td class="centerfont">Grid Power Charges</td>
                            <td class="centerfont"><input type="text" name="grid_power_charges" value="" id="grid">(per unit)</td>
                        </tr>
                        <tr>
                            <td class="centerheading">
                                <input type="checkbox" name="dg_applicability" id="adgpb" onClick="return statechangeDGPowerBackup();">Applicability of DG Power Back-up</td>
                            <td> </td>
                        </tr>
                        <tr>
                            <td class="centerfont">DG Power Charges</td>
                            <td class="centerfont"><input type="text" disabled name="dg_power_charges" value="" id="dg">(per unit)</td>
                        </tr>
                        <tr>
                            <td class="centerfont">Applicability of Service Tax on DG Power</td>
                            <td class="centerfont"><input type="radio" name="rad" value="Yes" id="rad1" onclick="return Checked();">Yes
                                <input type="radio" name="rad" id="rad2" checked value="No" onclick="return Checked();">No
                            </td>
                        </tr>
                        <tr style="display: none;" id="tr1">
                            <td> </td>
                            <td class="centerfont" colspan="4"><input size="7" type="text" name="service_tax" value="" id="ser" style="display: none;">%</td>
                        </tr>
                         <!--  -->
                        <!-- <tr>
                            <td class="centerfont">Last OutStanding Amount(Arrears)</td>
                            <td class="centerfont"><input type="text" name="arreas" value="" id="dg"></td>
                        </tr>
                       <tr>
                            <td class="centerfont">Last Grid Units</td>
                            <td class="centerfont"><input type="text" name="last_grid_units" value="" id="dg"></td>
                        </tr>
                        <tr>
                            <td class="centerfont">Last DG Units</td>
                            <td class="centerfont"><input type="text" name="last_dg_units" value="" id="dg"></td>
                        </tr>
                        <tr>
                            <td class="centerfont">Last Bill Date</td>
                            <td class="centerfont"><input type="text" name="last_bill_date" value="<%//=sys_dt%>" id="dg1"><span><a href="JavaScript:;" onClick="toggleCalendar('dg1')"><img src="images/calendar.png" border="0"></a></span></td>
                        </tr>
                        <tr>
                            <td class="centerfont">Payment Due Date</td>
                            <td class="centerfont"><input type="text" name="payment_due_date" value="<%//=sys_dt%>" id="dg2"><span><a href="JavaScript:;" onClick="toggleCalendar('dg2')"><img src="images/calendar.png" border="0"></a></span></td>
                        </tr>
                        <tr>
                            <td class="centerfont">Applicability of Late Payment Charge</td>
                            <td class="centerfont"><input type="radio" name="payment_status" value="yes" id="yes" onclick="return Checked123();">Yes
                            <input type="radio" name="payment_status" id="no" value="no" onclick="return Checked123();">No
                            </td>
                        </tr>
                        <tr style="display: none;" id="tr2">
                            <td> </td>
                            <td class="centerfont"><input size="7" type="text" name="late_payment" value="" id="per" style="display: none;">%
                            <input size="7" type="text" name="late_payment" value="" id="fix" style="display: none;">Rs.</td>
                        </tr>-->
                        <tr>
                  <td class="centerheading" colspan="4">Information of Billing Penality</td>
                   <td> </td>
             </tr>
             <tr>
                 <td class="centerfont"><input type="checkbox" name="window_glass" id="ch1" onclick=" return statechange();">
                 Broken Window Glass</td>
                 <td class="centerfont"><input disabled type="text" name="glass_amount" id="text1" onkeyup="Addition(this.form);">Rs.</td>
             </tr>
             <tr>
                 <td class="centerfont"><input type="checkbox" name="street_light" id="ch2" onclick=" return statechange();">
                 Broken Street Light</td>
                 <td class="centerfont"><input disabled type="text" name="light_amount" id="text2" onkeyup="Addition(this.form);">Rs.</td>
             </tr>
             <tr>
                 <td class="centerfont"><input type="checkbox" name="lift_button" id="ch3" onclick=" return statechange();">
                     Disturb Lift Buttons</td>
                 <td class="centerfont"><input disabled type="text" name="lift_amount" id="text3" onkeyup="Addition(this.form);">Rs.</td>
             </tr>
             <tr>
                 <td class="centerfont"><input type="checkbox" name="other_penality" id="ch4" onclick=" return statechange();">
                     Other</td>
                 <td class="centerfont"><input disabled type="text" name="other_amount" id="text4" onkeyup="Addition(this.form);">Rs.</td>
             </tr>
             <tr>
                 <td class="centerfont">Nett Total Amount</td>
                <td class="centerfont"><input type="text" name="total_amount" id="text5" readonly>Rs.</td>

             </tr>
             <tr>
                 <td class="centerfont">Do you wish to add this Penality amount with maintenance bill
                     <input type="radio" name="penality_amount_status" checked value="Yes">Yes
                     <input type="radio" name="penality_amount_status" value="No">No</td>
             </tr>
                         <tr><td colspan="2"  class="centerheading">Facility Description</td>
                            </tr>
                               <tr>
                                    <td colspan="2">
                                 <table id="facs" width="900" border="0" cellspacing="0" cellpadding="0" rules="all" style="border:0px solid #cccccc;">
                                 <tbody>
                                <tr >
                                      <td class="centerfont">Facility Name</td>
                                      <td class="centerfont">Type</td>
                                     <td class="centerfont">No.</td>
                                     <td class="centerfont">Area</td>
                                    <td class="centerfont">Description</td>
                                     <td class="centerfont">Add</td>
                                    <td class="centerfont">Del</td>
                                 </tr>

                                <tr >
                                   <td class="centerfont"><input type="text" name="faci_facility_name" value="" id="bath" size="17"></td>
                                   <!--td><input type="text" name="faci_type" value="" id="pcn" size="17"></td-->
                                   <td class="centerfont" width="165">
                                  <select name="faci_type" id="pcn">
                                  <option value="">Select Facility Type</option>
                                 <%
                                  con=obj.getConnection();
                                  stmt=(Statement)con.createStatement();
                                  String qrt1="select facility_type from facility_types";
                                 // System.out.println("qry is::"+qrt);
                                  rs=stmt.executeQuery(qrt1);
                                  if(rs.next()==false){}
                                  else{rs=stmt.executeQuery(qrt1);
                                  while (rs.next())
                                 {  %>
                            <option value="<%=rs.getString(1)%>"><%=rs.getString(1)%></option>
                                <%}}%>
                             </select>
                                    </td>
                                   <td><input type="text" name="faci_no" value="" id="nno" size="17"></td>
                                   <td><input type="text" name="faci_area" value="" id="bd" size="17"></td>
                                   <td><input type="text" name="faci_description" value="" id="mnth" size="17"></td>
                                   <td ><input name="" class="button" onclick="addRowfacs('facs');" disabled value="Add" type="button"></td>
                                   <td ><input name="" class="button" onclick=" removeRowfacs('facs');" disabled value="Del" type="button"></td>
                                </tr>
                                 </tbody>
                                 </table>
                                 </td>
                               </tr>
                         <!--tr class="Text"><td colspan="2"  style="color: navy">Facility Information</td>
                            </tr>
                               <tr class="Text">
                                    <td colspan="2">
                                 <table id="pays" width="100%" align="center" border="1"cellpadding="3" cellspacing="2">
                                 <tbody>
                                 <tr class="Text">
                                     <td>No.</td>
                                     <td>Type</td>
                                     <td>Area</td>
                                     <td>BHK of Vills</td>
                                     <td>Flats</td>
                                     <td>Penta House</td>
                                     <td>Add</td>
                                     <td>Del</td>
                                 </tr>
                                <tr class="Text">
                                   <td><input type="text" name="info_no" value="" id="nno" size="17"></td>
                                   <td><input type="text" name="info_type" value="" id="pcn" size="17"></td>
                                   <td><input type="text" name="info_area" value="" id="bd" size="17"></td>
                                   <td><input type="text" name="info_bhk_villa" value="" id="bath" size="17"></td>
                                   <td><input type="text" name="info_flats" value="" id="mnth" size="17"></td>
                                   <td><input type="text" name="info_penta_house" value="" id="depo" size="17"></td>
                                   <td ><input name="" class="bold" onclick="addRow('pays');" value="Add" type="button"></td>
                                   <td ><input name="" class="bold" onclick=" removeRowFromTable('pays');" value="Del" type="button"></td>
                                </tr>
                            </table>
                        </td>
                    </tr-->
                    <tr >
                    <td></td>
                    <td height="30"><input name="button" type="submit" value="Submit" class="button" align="bottom"></td>
                </tr>
                 </form>
            </table>
            </td>
           </tr>
         </table>
        </div>
  <jsp:include page="footer.jsp"/>
      </body>
    </html>
<%}%>

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package src;

import com.oreilly.servlet.MultipartRequest;
import java.util.logging.Level;
import java.util.logging.Logger;
import java.io.*;
import java.sql.*;
import java.util.*;
import java.util.regex.*;
import org.apache.commons.fileupload.servlet.ServletFileUpload;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.*;
import javax.servlet.*;
import javax.servlet.http.*;

/**
 *
 * @author Marketting
 */
public class UpdateImageSociety extends HttpServlet {
    // String query=null;

    HttpSession session;
    JdbcConnection conn;
    Connection con=null;
    Statement st=null;
    PreparedStatement pst=null;
    ResultSet rs=null;

    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException 
    {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        String image_id=request.getParameter("soc_id");
        System.out.println("image id is in servlet... "+image_id);
        String society_image=request.getParameter("society_picture");
        String google_map=request.getParameter("google_map");
        System.out.println("image..... "+society_image);
        System.out.println("map.... " + google_map);
        
        try
        {
          //  File fin=new File(getRequestContext);
        session = request.getSession(true);
        conn= new JdbcConnection();
        con = conn.getConnection();
        pst=con.prepareStatement("update society SET society_picture=?,google_map=? where facility_id='"+image_id+"'");
        
       
                RequestDispatcher rd = request.getRequestDispatcher("edit_society2.jsp");
                rd.forward(request, response);
    }
             catch (Exception ex) {
                Logger.getLogger(UploadImage_servlet.class.getName()).log(Level.SEVERE, null, ex);
            }
    //  }
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>
}

and now the edit_society2.jsp

<%-- 
    Document   : edit_society
    Created on : Sep 16, 2011, 4:25:19 PM
    Author     : Reshma
--%>
<%@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 language="java" import="java.sql.*, src.*,java.util.Date,java.util.*,java.text.SimpleDateFormat,java.text.DecimalFormat" session="true"%>
   
     <%
  String username=(String)session.getAttribute("user");
  System.out.println("username is-----  "+username);
  if(username==null)
      {
      response.sendRedirect("error.jsp");
  }else{ 
                  JdbcConnection obj=new JdbcConnection();
                  DecimalFormat fm=new DecimalFormat("0.0");
                  Connection con=null;
                  Statement stmt=null;
                  Statement stmt1=null;
                  ResultSet rs=null;
                  ResultSet rs1=null;
                  String qrt=null;
                  String CNFM = null;
        String society_name=null;
        String society_address=null;
        String type_of_society=null;
        String society_location=null;
        String society_direction=null;
        String society_totalarea=null;
        String noof_towers=null;
        String society_area=null;
        String parking_space=null;
        String air_distance=null;
        String rail_distance=null;
        String hospital_distance=null;
        String market_distance=null;
        String maintainance_type=null;
        String grid_charge=null;
        String dg_charge=null;
        String service_tax_status=null;
        String service_tax=null;
        String glass_charge=null;
        String street_light_charge=null;
        String lift_charge=null;
        String other=null;
        String total=null;
        String penaility_status=null;
        
      //  String path=(String)session.getAttribute("path");
      //  System.out.println("in jsp.... "+path);
        String facility_id=request. getParameter("soc_id");
        System.out.println("facility id is in update society servlet... "+facility_id);
        con=obj.getConnection();
    stmt=con.createStatement();
    String sql="select * from society where facility_id='"+facility_id+"'";
    rs=stmt.executeQuery(sql);
    if(rs.next())
    {
        society_name=rs.getString(3);
        society_address=rs.getString(4);
        type_of_society=rs.getString(5);
        society_location=rs.getString(8);
        society_direction=rs.getString(9);;
        society_totalarea=rs.getString(10);
        noof_towers=rs.getString(11);
        society_area=rs.getString(15);
        parking_space=rs.getString(16);
        air_distance=rs.getString(17);
        rail_distance=rs.getString(18);
        hospital_distance=rs.getString(19);
        market_distance=rs.getString(20);
        maintainance_type=rs.getString(21);
        grid_charge=rs.getString(22);
        dg_charge=rs.getString(23);
        service_tax_status=rs.getString(24);
        service_tax=rs.getString(25);
        glass_charge=rs.getString(26);
        street_light_charge=rs.getString(27);
        lift_charge=rs.getString(28);
        other=rs.getString(29);
        total=rs.getString(30);
        penaility_status=rs.getString(31);
        } 
       %>
  
<html>
    <head>
         <jsp:include page="header.jsp"/>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Society</title>
        <link href="stylesheet/fac_css.css" rel="stylesheet" type="text/css"/>
       <script type="text/javascript" language="javascript">
            function Checked()
            {
                if(document.getElementById('rad1').checked)
                    {
                       document.getElementById('tr1').style.display="";
                       document.getElementById('ser').style.display="";
                    }
                  else
                        {
                            document.getElementById('tr1').style.display="none";
                            document.getElementById('ser').style.display="none";
                        }
            }
        
                
            function uploadimg()
            {
                Alert.fnAlert("Please Upload Pictutes First!!!");
            }
        function validation()
        {
            if(document.getElementById("pic").value=="")
                {
                    alert("Please browse the picture!!!");
                    document.getElementById("pic").focus();
                    return false;
                }
                if(document.getElementById("google").value=="")
                {
                    alert("Please browse the google map!!!");
                    document.getElementById("google").focus();
                    return false;
                }
                return true;
        }

   </script>
          <script language="javascript" type="text/javascript">
        var tk;
        function acc(pcn)
          { 
            tk=pcn;
            var randomnumber=Math.floor(Math.random()*999999);
            var url="facility_type_servlet?randomnum=" + randomnumber;
            if (window.XMLHttpRequest)
                {
                    // code for Mozilla, Safari, etc
                    http=new XMLHttpRequest();
                    if (http.overrideMimeType)
                        {
                            http.overrideMimeType('text/xml');
                        }
                        http.open("GET", url, true);
                    }//If close
                    else if (window.ActiveXObject)
                        {
                            http=new ActiveXObject('Microsoft.XMLHTTP');
                            if (http)
                                {
                                    http.open("GET", url, false);
                                }
                            }
                            http.onreadystatechange = hleHttpResponse44;
                            http.send(null);
            }
             function trim(string)
                {
                    var LENGTH = string.length;
                    var beginIndex = 0;
                    while (beginIndex != LENGTH && string.charAt(beginIndex) <=' ')
                    {
                        beginIndex++;
                    }
                    /* If all characters are whitespace then return the empty String. */
                    if (beginIndex == LENGTH)
                    {
                        return "";
                    }
                    /* Find the last character that is not whitespace. */
                    var endIndexx = LENGTH;
                    while (endIndex != beginIndex && string.charAt(endIndex - 1) <= ' ')
                    {
                        endIndex--;
                    }
                    return ((beginIndex == 0) && (endIndex == LENGTH)) ?
                    string : string.substring(beginIndex, endIndex);
                }
                        function hleHttpResponse44() {
                            if (http.readyState == 4)
                            {
                                    //var as=http.responseText;
                                     var inner =http.responseText;

                                     select_innerHTML(document.getElementById(tk),inner);
                            }
                        }

  function select_innerHTML(objeto,innerHTML)
  {
    objeto.innerHTML = ""
    var selTemp = document.createElement("micoxselect")
    var opt;
    selTemp.id="micoxselect1"
    document.body.appendChild(selTemp)
    selTemp = document.getElementById("micoxselect1")
    selTemp.style.display="none"
    if(innerHTML.indexOf("<option")<0){//se não é option eu converto
        innerHTML = "<option>" + innerHTML + "</option>"
        
    }
    innerHTML = innerHTML.replace(/<option/g,"<span").replace(/<\/option/g,"</span")
    selTemp.innerHTML = innerHTML

    for(var i=0;i<selTemp.childNodes.length;i++){
        var spantemp = selTemp.childNodes[i];

        if(spantemp.tagName){
            opt = document.createElement("OPTION")

            if(document.all){ //IE
                objeto.add(opt)
            }else{
                objeto.appendChild(opt)
            }

            //getting attributes
            for(var j=0; j<spantemp.attributes.length ; j++){
                var attrName = spantemp.attributes[j].nodeName;
                var attrVal = spantemp.attributes[j].nodeValue;
                if(attrVal){
                    try{
                        opt.setAttribute(attrName,attrVal);
                        opt.setAttributeNode(spantemp.attributes[j].cloneNode(true));
                    }catch(e){}
                }
            }
            //getting styles
            if(spantemp.style){
                for(var y in spantemp.style){
                    try{
                        opt.style[y] = spantemp.style[y];
                    }catch(e){}
                }
            }
            //value and text
            opt.value = spantemp.getAttribute("value")
            opt.text = spantemp.innerHTML
            //IE
            opt.selected = spantemp.getAttribute('selected');
            opt.className = spantemp.className;
        }
    }
    document.body.removeChild(selTemp)
    selTemp = null
}
function statechange()
            {
                if(document.getElementById("ch1").checked)
                    {
                            document.getElementById("text1").disabled=false;
                    }else
                         {
                            document.getElementById("text1").disabled=true;
                         }
                if(document.getElementById("ch2").checked)
                    {
                            document.getElementById("text2").disabled=false;
                    }else
                         {
                            document.getElementById("text2").disabled=true;
                         }
                if(document.getElementById("ch3").checked)
                    {
                            document.getElementById("text3").disabled=false;
                    }else
                         {
                            document.getElementById("text3").disabled=true;
                         }
                if(document.getElementById("ch4").checked)
                    {
                            document.getElementById("text4").disabled=false;
                    }else
                         {
                            document.getElementById("text4").disabled=true;
                         }
            }
        function Addition(form)
            {
                //add value of more than two text fields in javascript
                var a=+form.document.getElementById("text1").value;
                var b=+form.document.getElementById("text2").value;
                var c=+form.document.getElementById("text3").value;
                var d=+form.document.getElementById("text4").value;
                var e=parseInt(a+b+c+d);
                form.total_amount.value=e;

            }
            function statechangeDGPowerBackup()
            {
                if(document.getElementById("adgpb").checked)
                    {
                            document.getElementById("dg").disabled=false;
                    }else
                         {
                            document.getElementById("dg").disabled=true;
                         }
            }
            
    </script>
    <link rel="stylesheet" type="text/css" href="alert.css" />
    <script type="text/javascript" src="js-core.js"></script>
     <script type="text/javascript" src="alert.js"></script>
    </head>
                
<body>
 <div id="welcome">
           <div id="welcome_in">
            <div id="welcome_in_left">Create Society</div>
            <div id="welcome_in_right">
                <%  String login_user = (String)session.getAttribute("user");%>
            <div id="welcome_in_right_right">Welcome: <%=login_user%></div>
            <div id="welcome_in_right_left"><img src="images/afterlogintop_icon.jpg" width="42" height="30"></div>
            </div>
         </div>
        </div>
        <div id="container1" >
        <div style="height:3px; "></div>

        <table width="900" border="0" cellspacing="0" cellpadding="0" rules="rows" style="border:1px solid #cccccc;">
            <form name="upload" action="" enctype="multipart/form-data" method="post" onsubmit="return validation();">
                <tr>
                    <td width="250">
                        <table width="92%" align="left" border="0" cellpadding="0" cellspacing="0" >
                          <tr>
                              <td width="530" class="centerfont" >Society Picture</td>
                              <td class="centerfont" ><input type="text" id="pic" name="society_picture" value="<%//=path%>"></td>
                        </tr>
                        <tr>
                           <td class="centerfont">Google Map</td>
                           <td class="centerfont"><input type="text" id="google" name="google_map" value="<%//=path%>"></td>
                        </tr>
                        </table>
                        </td>
                        <td>
                              <table width="100%" align="center" border="0" cellpadding="0" cellspacing="2" >
                                  <tr>
                                <td class="centerfont" ><input type="submit"  class="button" value="Upload"></td>
                          </tr>
                              </table>
                          </td>
                    </tr>
              </form>
              <tr>
                  <td colspan="2">
                    <table width="900" border="0" cellspacing="0" cellpadding="0" rules="rows" style="border:1px solid #cccccc;">
                        <form name="updatesociety" action="UpdateSociety"  method="post"><!-- onsubmit="return uploadimg();">-->
                            <input type="hidden" name="soc_id" value="<%=facility_id%>">
                        <tr >
                           <td width="248" class="centerfont" >Society Name</td>
                           <td class="centerfont"><input type="text" name="society_name" value="<%=society_name%>"></td>
                        </tr>
                        <tr>
                           <td width="240" class="centerfont" >Society Address</td>
                           <td class="centerfont"><input type="text" name="society_address" value="<%=society_address%>"></td>
                        </tr>

                        <tr>
                           <td width="240" class="centerfont" >Types Of Society</td>
                           <td class="centerfont">
                             <select name="type_of_society">
                                  <option value="<%=type_of_society%>"><%=type_of_society%></option>
                                 <%int i=0;
                                  con=obj.getConnection();
                                  stmt=(Statement)con.createStatement();
                                  qrt="select * from society_types";
                                 // System.out.println("qry is::"+qrt);
                                  rs=stmt.executeQuery(qrt);
                                  if(rs.next()==false){}
                                  else{rs=stmt.executeQuery(qrt);
                                  while (rs.next())
                                 {  %>
                         <option value="<%=rs.getString(2)%>"><%=rs.getString(2)%></option>
                                <%}}%>
                             </select>
                           <a HREF="javascript:void(0)" onclick="window.open('society_type.jsp?CNFM=<%=CNFM%>')" title="add society type"><img src="images/add_so.jpg" height="20"  style="border: none; vertical-align: bottom"></a></td>
                        </tr>
                         <tr>
                           <td width="240" class="centerfont" >Location</td>
                           <td class="centerfont"><input type="text" name="society_location" value="<%=society_location%>"></td>
                        </tr>
                           <tr>
                           <td width="240" class="centerfont" >Direction</td>
                           <td class="centerfont"><input type="text" name="society_direction" value="<%=society_direction%>"></td>
                        </tr>
                          <tr>
                           <td width="240" class="centerfont" >Total Area</td>
                           <td class="centerfont"><input type="text" name="society_totalarea" value="<%=society_area%>"></td>
                        </tr>
                          <tr>
                           <td width="240" class="centerfont" >No. Of Towers</td>
                           <td class="centerfont"><input type="text" name="noof_towers" value="<%=noof_towers%>"></td>
                        </tr>

                        <tr>
                            <td class="centerfont">Society Area</td>
                            <td class="centerfont"><input type="text" name="society_area" value="<%=society_area%>"></td>
                        </tr>
                        <tr>
                            <td class="centerfont">Parking Space</td>
                            <td class="centerfont"><input type="text" name="parking_space" value="<%=parking_space%>"></td>
                        </tr>

                        <tr>
                            <td class="centerfont">Distance From Airport</td>
                            <td class="centerfont"><input type="text" name="air_distance" value="<%=air_distance%>"></td>
                        </tr>

                        <tr>
                            <td class="centerfont">Distance From Railway Station</td>
                            <td class="centerfont"><input type="text" name="rail_distance" value="<%=rail_distance%>"></td>
                        </tr>

                        <tr>
                            <td class="centerfont">Distance From Hospital</td>
                            <td class="centerfont"><input type="text" name="hospital_distance" value="<%=hospital_distance%>"></td>
                        </tr>

                        <tr>
                            <td class="centerfont">Distance From Market</td>
                            <td class="centerfont"><input type="text" name="market_distance" value="<%=market_distance%>"></td>
                        </tr>
                         <tr>
                            <td class="centerfont">Maintenance Type
                                 <label style="float: right; padding-top: 2px;">Fixed</label><input style="float: right;"  type="radio" name="maintainance_type" value="Fixed" <%if("Fixed".equals(maintainance_type)){%>checked<%}%> id="restat" ></td>
                             <td class="centerfont" ><input style="float: left;" type="radio" name="maintainance_type" value="Per Squar Feet" <%if("Per Squar Feet".equals(maintainance_type)){%>checked<%}%> id="restat1" ><label style="float: left; padding-top: 2px;">Per Squar Feet</label>
                                            <input style="float: left; padding-left: 10px;" type="radio" name="maintainance_type" value="Monthly" <%if("Monthly".equals(maintainance_type)){%>checked<%}%>  id="restat1" >
                                 <label style="float: left; padding-top: 2px;">Monthly</label></td>
                        </tr >
                        <tr>
                            <td class="centerfont">Grid Power Charges</td>
                            <td class="centerfont"><input type="text" name="grid_power_charges" value="<%=grid_charge%>" id="grid">(per unit)</td>
                        </tr>
                        <tr>
                            <td class="centerheading">
                                <input type="checkbox" name="dg_applicability" id="adgpb" onClick="return statechangeDGPowerBackup();">Applicability of DG Power Back-up</td>
                            <td> </td>
                        </tr>
                        <tr>
                            <td class="centerfont">DG Power Charges</td>
                            <td class="centerfont"><input type="text" disabled name="dg_power_charges" value="<%=dg_charge%>" id="dg">(per unit)</td>
                        </tr>
                        <tr>
                            <td class="centerfont">Applicability of Service Tax on DG Power</td>
                            <td class="centerfont"><input type="radio" name="rad<%=i%>" value="Yes" <%if("Yes".equals(service_tax_status)){%>checked<%}%> id="rad1"  onclick="return Checked();">Yes
                                <input type="radio" name="rad<%=i%>" id="rad2" value="No" <%if("No".equals(service_tax_status)){%>checked<%}%> onclick="return Checked();">No
                            </td>
                        </tr>
                        <tr style="display: none;" id="tr1">
                            <td> </td>
                            <td class="centerfont" colspan="4"><input size="7" type="text" name="service_tax" value="<%=service_tax%>" id="ser" style="display: none;">%</td>
                        </tr>
                        <tr>
                  <td class="centerheading" colspan="4">Information of Billing Penality</td>
                   <td> </td>
             </tr>
            <tr>
                 <td class="centerfont"><input type="checkbox" name="window_glass" id="ch1" onclick=" return statechange();">
                 Broken Window Glass</td>
                 <td class="centerfont"><input disabled type="text" name="glass_amount" value="<%=glass_charge%>" id="text1" onkeyup="Addition(this.form);">Rs.</td>
             </tr>
             <tr>
                 <td class="centerfont"><input type="checkbox" name="street_light" id="ch2" onclick=" return statechange();">
                 Broken Street Light</td>
                 <td class="centerfont"><input disabled type="text" name="light_amount" value="<%=street_light_charge%>" id="text2" onkeyup="Addition(this.form);">Rs.</td>
             </tr>
             <tr>
                 <td class="centerfont"><input type="checkbox" name="lift_button" id="ch3" onclick=" return statechange();">
                     Disturb Lift Buttons</td>
                 <td class="centerfont"><input disabled type="text" name="lift_amount" value="<%=lift_charge%>" id="text3" onkeyup="Addition(this.form);">Rs.</td>
             </tr>
             <tr>
                 <td class="centerfont"><input type="checkbox" name="other_penality" id="ch4" onclick=" return statechange();">
                     Other</td>
                 <td class="centerfont"><input disabled type="text" name="other_amount" value="<%=other%>" id="text4" onkeyup="Addition(this.form);">Rs.</td>
             </tr>
             <tr>
                 <td class="centerfont">Nett Total Amount</td>
                 <td class="centerfont"><input type="text" name="total_amount" value="<%=total%> "id="text5" readonly onkeyup="Addition(this.form);">Rs.</td>

             </tr>
             <tr>
                 <td class="centerfont">Do you wish to add this Penality amount with maintenance bill
                     <input type="radio" name="penality_amount_status" value="Yes" <%if("Yes".equals(penaility_status)){%>checked<%}%> >Yes
                     <input type="radio" name="penality_amount_status" value="No" <%if("No".equals(penaility_status)){%>checked<%}%> >No</td>
             </tr>
                         <tr><td colspan="2"  class="centerheading">Facility Description</td>
                            </tr>
                               <tr >
                               <td colspan="2">
                                 <table id="facs" width="900" border="0" cellspacing="0" cellpadding="0" rules="all" style="border:0px solid #cccccc;">
                                 <tr>
                                      <td class="centerfont">Facility Name</td>
                                     <td class="centerfont">Type</td>
                                     <td class="centerfont">No.</td>
                                     <td class="centerfont">Area</td>
                                     <td class="centerfont">Description</td>
                                     <td class="centerfont">Add</td>
                                     <td class="centerfont">Del</td>
                                 </tr>
    <%
    String id=null;
    stmt1=con.createStatement();
    qrt="select * from society_ref1 where facility_id='"+facility_id+"'";
    rs1=stmt1.executeQuery(qrt);
    System.out.println("society_ref1 table... "+qrt);
    while(rs1.next())
    {
        
        
    %>
    <tr>
                                    <td><input type="text" name="faci_facility_name" value="<%=rs1.getString(6)%>" id="bath" size="17"></td>
    <input type="hidden" name="id" value="<%=rs1.getString(1)%>">
                                   <td>
                                  <select name="faci_type" id="pcn">
                                  <option value="<%=rs1.getString(4)%>"><%=rs1.getString(4)%></option>
                                 <%
                                  con=obj.getConnection();
                                  stmt=(Statement)con.createStatement();
                                  String qrt1="select facility_type from facility_types";
                                 // System.out.println("qry is::"+qrt);
                                  rs=stmt.executeQuery(qrt1);
                                  if(rs.next()==false){}
                                  else{rs=stmt.executeQuery(qrt1);
                                  while (rs.next())
                                 {  %>
                            <option value="<%=rs.getString(1)%>"><%=rs.getString(1)%></option>
                                <%}}%>
                             </select>
                                    </td>
                                    
                                    <td><input type="text" name="faci_no" value="<%=rs1.getString(3)%>" id="nno" size="17"></td>
                                   <td><input type="text" name="faci_area" value="<%=rs1.getString(5)%>" id="bd" size="17"></td>
                                   <td><input type="text" name="faci_description" value="<%=rs1.getString(7)%>" id="mnth" size="17"></td>
                                   <td ><input name="" class="button" value="Add" disabled type="button"></td>
                                   <td ><input name="" class="button" value="Del" disabled type="button"></td>
                                </tr>
                                <%}%>
                                 </table>
                                 </td>
                               </tr>
                                 
                         <!--tr class="Text"><td colspan="2"  style="color: navy">Facility Information</td>
                            </tr>
                               <tr class="Text">
                                    <td colspan="2">
                                 <table id="pays" width="100%" align="center" border="1"cellpadding="3" cellspacing="2">
                                 <tbody>
                                 <tr class="Text">
                                     <td>No.</td>
                                     <td>Type</td>
                                     <td>Area</td>
                                     <td>BHK of Vills</td>
                                     <td>Flats</td>
                                     <td>Penta House</td>
                                     <td>Add</td>
                                     <td>Del</td>
                                 </tr>
                                <tr class="Text">
                                   <td><input type="text" name="info_no" value="" id="nno" size="17"></td>
                                   <td><input type="text" name="info_type" value="" id="pcn" size="17"></td>
                                   <td><input type="text" name="info_area" value="" id="bd" size="17"></td>
                                   <td><input type="text" name="info_bhk_villa" value="" id="bath" size="17"></td>
                                   <td><input type="text" name="info_flats" value="" id="mnth" size="17"></td>
                                   <td><input type="text" name="info_penta_house" value="" id="depo" size="17"></td>
                                   <td ><input name="" class="bold" onclick="addRow('pays');" value="Add" type="button"></td>
                                   <td ><input name="" class="bold" onclick=" removeRowFromTable('pays');" value="Del" type="button"></td>
                                </tr>
                            </table>
                        </td>
                    </tr-->
                    <tr>
                    <td></td>
                    <td height="30"><input name="button" type="submit" value="Submit" class="button"  align="bottom"  onclick="return uploadimg();"></td>
                    <!--td><input type="button"  class="bluebutton2" value="Submit" onclick="return uploadimg();"></td-->
                </tr>
               
                 </form>
            </table>
            </td>
           </tr>
         </table>
        </div>
       <jsp:include page="footer.jsp"/>
      </body>
      <%}%>
    </html>

This is the servlet for all text field updation..

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package src;

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
/**
 *
 * @author Administrator
 */
public class UpdateSociety extends HttpServlet 
{
    HttpSession session;
    JdbcConnection conn;
    Connection con=null;
    PreparedStatement pst=null;
    PreparedStatement pst1=null;
    int count=0;
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        String facility_id=request.getParameter("soc_id");
        System.out.println("facility id is in update society servlet... "+facility_id);
        try 
        {
            session=request.getSession(true);
            System.out.println("welcome in update society servlet...");
        String path = (String)session.getAttribute("path");  
        System.out.println("path is in servlet... "+path);
        String society_name = request.getParameter("society_name");
        String society_address = request.getParameter("society_address");
        String type_of_society = request.getParameter("type_of_society");
        String society_location = request.getParameter("society_location");
        String society_direction = request.getParameter("society_direction");
        String society_totalarea = request.getParameter("society_totalarea");
        String noof_towers = request.getParameter("noof_towers");
        String society_area = request.getParameter("society_area");
        String parking_space = request.getParameter("parking_space");
        String air_distance = request.getParameter("air_distance");
        String rail_distance = request.getParameter("rail_distance");
        String hospital_distance = request.getParameter("hospital_distance");
        String market_distance = request.getParameter("market_distance");
        String maintainance_type = request.getParameter("maintainance_type");
        String grid_charge=request.getParameter("grid_power_charges");
        String dg_charge=request.getParameter("dg_power_charges");
        String service_tax_status=request.getParameter("rad");
        String service_tax=request.getParameter("service_tax");


        String glass_amount=request.getParameter("glass_amount");
        String light_amount=request.getParameter("light_amount");
        String lift_amount=request.getParameter("lift_amount");
        String other_amount=request.getParameter("other_amount");
        String total_amount=request.getParameter("total_amount");
        String amount_status=request.getParameter("penality_amount_status");


        String[] faci_facility_name = request.getParameterValues("faci_facility_name");
        String[] faci_no = request.getParameterValues("faci_no");
        String[] faci_type = request.getParameterValues("faci_type");
        String[] faci_area = request.getParameterValues("faci_area");
        String[] faci_description = request.getParameterValues("faci_description");
        
         if(service_tax==null ||"".equalsIgnoreCase(service_tax)){
        service_tax="0";
        }
    if(dg_charge==null || "".equalsIgnoreCase(dg_charge)){
        dg_charge="0";
        }

    if(glass_amount=="" || glass_amount==null)
        {
        glass_amount="NA";
        }
    if(light_amount=="" || light_amount==null)
        {
         light_amount="NA";
         }
    if(lift_amount=="" || lift_amount==null)
        {
        lift_amount="NA";
        }
    if(other_amount=="" || other_amount==null)
        {
        other_amount="NA";
        }
    if(total_amount=="" || total_amount==null)
        {
        total_amount="NA";
        }
        

        conn=new JdbcConnection();
        con=conn.getConnection();
        pst=con.prepareStatement("update society SET society_name=?,society_address=?,type_of_society=?,society_location=?,society_direction=?,society_totalarea=?,noof_towers=?,society_area=?,parking_space=?,air_distance=?,rail_distance=?,hospital_distance=?,market_distance=?,maintainance_type=?,grid_power_charge=?,dg_power_charge=?,service_tax_status=?,service_tax =?,glass_amount=?,light_amount=?,lift_amount=?,other_amount=?,total_amount=?,penality_bill_status=? where facility_id='"+facility_id+"'");
        pst.setString(1,society_name);
        pst.setString(2,society_address);
        pst.setString(3,type_of_society);
        pst.setString(4,society_location);
        pst.setString(5,society_direction);
        pst.setString(6,society_totalarea);
        pst.setString(7,noof_towers);
        pst.setString(8,society_area);
        pst.setString(9,parking_space);
        pst.setString(10,air_distance);
        pst.setString(11,rail_distance);
        pst.setString(12,hospital_distance);
        pst.setString(13,market_distance);
        pst.setString(14,maintainance_type);
        pst.setString(15,grid_charge);
        pst.setString(16,dg_charge);
        pst.setString(17,service_tax_status);
        pst.setString(18,service_tax);
        pst.setString(19,glass_amount);
        pst.setString(20,light_amount);
        pst.setString(21,lift_amount);
        pst.setString(22,other_amount);
        pst.setString(23,total_amount);
        pst.setString(24,amount_status);
        pst.executeUpdate();
        System.out.println("first query is updated... " + pst);
        
        String[] id=request.getParameterValues("id");
              
        
        for(int i=0;i<faci_facility_name.length && i<faci_type.length && i<faci_no.length && i<faci_area.length && i<faci_description.length;i++)
        {
            pst1=con.prepareStatement("update society_ref1 SET facility_name=?,faci_type=?,faci_no =?,faci_area =?,faci_description=? where id='"+id[i]+"'");//and facility_id='"+facility_id+"'");
            System.out.println("id is in servlet..,,,,,  "+id[i]);
        pst1.setString(1,faci_facility_name[i]);
        pst1.setString(2,faci_type[i]);
        pst1.setString(3,faci_no[i]);
        pst1.setString(4,faci_area[i]);
        pst1.setString(5,faci_description[i]);
        pst1.executeUpdate();
        System.out.println("second query is updated......  "+pst1);
        }
        count++;
        if(count>0)
            {
                out.println("<html>");
            out.println("<head>");
            out.println("<title>Edit Society</title>");  
            out.println("</head><body><script type='text/javascript'>"
                    +"onload=fun();"
                    + "function fun()"
                    + "{"
                    + "alert('data updation is success');"
                    +"self.location='search_society.jsp';"
                    + "}"
                    + "</script>");
            out.println("</body>");
            out.println("</html>");

            }
    }catch(Exception e)
        {
            e.getMessage();
        }finally {            
            out.close();
        }
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /** 
     * Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>
}

table is here...

CREATE TABLE `society` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `facility_id` varchar(200) DEFAULT NULL,
  `society_name` varchar(200) DEFAULT NULL,
  `society_address` varchar(200) DEFAULT NULL,
  `type_of_society` varchar(200) DEFAULT NULL,
  `society_picture` varchar(200) DEFAULT NULL,
  `google_map` varchar(200) DEFAULT NULL,
  `society_location` varchar(200) DEFAULT NULL,
  `society_direction` varchar(200) DEFAULT NULL,
  `society_totalarea` varchar(200) DEFAULT NULL,
  `noof_towers` varchar(200) DEFAULT NULL,
  `username` varchar(200) DEFAULT NULL,
  `password` varchar(200) DEFAULT NULL,
  `current_date_time` datetime DEFAULT NULL,
  `society_area` varchar(200) DEFAULT NULL,
  `parking_space` varchar(200) DEFAULT NULL,
  `air_distance` varchar(200) DEFAULT NULL,
  `rail_distance` varchar(200) DEFAULT NULL,
  `hospital_distance` varchar(200) DEFAULT NULL,
  `market_distance` varchar(200) DEFAULT NULL,
  `maintainance_type` varchar(200) DEFAULT NULL,
  `grid_power_charge` varchar(200) DEFAULT NULL,
  `dg_power_charge` varchar(200) DEFAULT NULL,
  `service_tax_status` varchar(200) DEFAULT NULL,
  `service_tax` varchar(200) DEFAULT NULL,
  `glass_amount` varchar(200) DEFAULT NULL,
  `light_amount` varchar(200) DEFAULT NULL,
  `lift_amount` varchar(200) DEFAULT NULL,
  `other_amount` varchar(200) DEFAULT NULL,
  `total_amount` varchar(200) DEFAULT NULL,
  `penality_bill_status` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

/*Data for the table `society` */

insert  into `society`(`id`,`facility_id`,`society_name`,`society_address`,`type_of_society`,`society_picture`,`google_map`,`society_location`,`society_direction`,`society_totalarea`,`noof_towers`,`username`,`password`,`current_date_time`,`society_area`,`parking_space`,`air_distance`,`rail_distance`,`hospital_distance`,`market_distance`,`maintainance_type`,`grid_power_charge`,`dg_power_charge`,`service_tax_status`,`service_tax`,`glass_amount`,`light_amount`,`lift_amount`,`other_amount`,`total_amount`,`penality_bill_status`) values (1,'FAC000001','Orchid Petals','A block, Sector 49, Gurgaon, Haryana, India','Residential','C:\\Documents and Settings\\Administrator\\Desktop\\FacilitySupervisor\\build\\web\\exampleimages\\FAC000001\\FAC000001_GOOLE ORCHID.bmp','C:\\Documents and Settings\\Administrator\\Desktop\\FacilitySupervisor\\build\\web\\exampleimages\\FAC000001\\FAC000001_GOOLE ORCHID.bmp','Gurgaon','East Delhi','37 acre','50','admin','admin123','2011-06-17 11:46:43','37 acre','100 cars parking space','5 KM','4 KM','MAX HOSPITAL - 5 KM','2 KM','Fixed','5.40','0','No','0','NA','NA','NA','NA','0  ','No'),(2,'FAC000002','Tulip','rwer','Residential','E:\\FacilitySupervisor\\build\\web\\exampleimages\\FAC000002\\FAC000002_orchid petals gurgaon.jpg','E:\\FacilitySupervisor\\build\\web\\exampleimages\\FAC000002\\FAC000002_orchid petals gurgaon.jpg','erew','rwer','we','rwe','admin','admin123','2011-07-12 12:33:38','rwer','werwe','rew','wer','werwe','werwe','Per Squar Feet','4.20','0','Yes','10','0','0','0','0','0','Yes'),(3,'FAC000003','qrewr','wqwrwer','Commercial','E:\\FacilitySupervisor\\build\\web\\exampleimages\\FAC000003\\FAC000003_minus.gif','E:\\FacilitySupervisor\\build\\web\\exampleimages\\FAC000003\\FAC000003_minus.gif','wrwer','qwwerw','qwrwer','wwer','admin','admin123','2011-09-12 11:54:43','qwwerwe','ertewer','ertwerw','rtewerw','rteerwer','ertewer','Fixed','9.90','6.70','Yes','10','200','200','100','120','620','No'),(4,'FAC000004','fdfd','fsdf','Commercial','D:\\FacilitySupervisor\\build\\web\\exampleimages\\FAC000004\\FAC000004_logo.jpg','D:\\FacilitySupervisor\\build\\web\\exampleimages\\FAC000004\\FAC000004_logo.jpg','dsf','sdf','sdf','sdf','admin','admin123','2011-09-16 15:51:29','sdf','sdfs','dfsd','sdf','sdf','sdf','Fixed','sdfsd','0','No','0','0','0','0','0','0','Yes'),(5,'FAC000005','dddd1','dfsdf1','terter','D:\\FacilitySupervisor\\build\\web\\exampleimages\\FAC000005\\FAC000005_nextlabel.gif','D:\\FacilitySupervisor\\build\\web\\exampleimages\\FAC000005\\FAC000005_nextlabel.gif','fsd1','sdf1','fsdf1','fsd1','admin','admin123','2011-09-16 16:40:22','fsdf1','sdfsdf1','sdf1','sdfs1','dfsd1','sdfsd1','Fixed','sdfsd1','0',NULL,'0','NA','NA','NA','NA','0 ','No'),(6,'FAC000006','ddd2222','sdfs','dfgd','D:\\FacilitySupervisor\\build\\web\\exampleimages\\FAC000006\\FAC000006_bg.jpg','D:\\FacilitySupervisor\\build\\web\\exampleimages\\FAC000006\\FAC000006_bg.jpg','sdf','dsf','sdf','sdf','admin','admin123','2011-09-17 18:21:09','sdf','sdfsd','fsdf','sdf','sdfsd','fs','Fixed','34','0',NULL,'0','NA','NA','NA','NA','0  ','Yes');

/*Table structure for table `society_ref1` */

DROP TABLE IF EXISTS `society_ref1`;

CREATE TABLE `society_ref1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `facility_id` varchar(200) DEFAULT NULL,
  `faci_no` varchar(200) DEFAULT NULL,
  `faci_type` varchar(200) DEFAULT NULL,
  `faci_area` varchar(200) DEFAULT NULL,
  `facility_name` varchar(200) DEFAULT NULL,
  `faci_description` varchar(200) DEFAULT NULL,
  `current_date_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

/*Data for the table `society_ref1` */

insert  into `society_ref1`(`id`,`facility_id`,`faci_no`,`faci_type`,`faci_area`,`facility_name`,`faci_description`,`current_date_time`) values (1,'FAC000001','454','Grocery Shop','3 acrererwe','Gardenwerwe','The garden is so good.','2011-06-17 11:46:44'),(2,'FAC000002','dfg','Vegetable and fruit Shop','dfg','sdf','df','2011-07-12 12:33:38'),(3,'FAC000003','ggg22','Grocery Shop','ggg11','ggg22','ggg33','2011-09-12 11:54:43'),(4,'FAC000004','6456','Grocery Shop','4645','45645','654','2011-09-16 15:51:29'),(5,'FAC000005','hkhtert','Pool','khjkgdg','vbgd','ryuidfgdf','2011-09-16 16:40:23'),(6,'FAC000006','dfgdfssssss','Grocery Shop','dfgdf','gfd','fdgd','2011-09-17 18:21:09');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

So this the flow but I am not able to update only images

[Bear Bibeault]

Ram Dev chandran,
Your post was moved to a new topic.