set values in a table from other

Hi,

I have a jsp page in this page I have one static text field for current date and below this in dynamic table having one text box
and two radio buttons for present and absent. The main work of this page is that I am retriving staff_name from a table and want to be insert every perticular text field value(Staff name) in second table with their status absent OR present

so my question is how it is possible.. because I am facing an a problem the only one(first text field value) adding in the table ..

please give me some suggestion.............

Thanks!

Hey,

Without the code of how you are adding things to the table, there isn't really much we can say. Could you post it (remember and use the code tags).
Sean

This is my first jsp page ............

<%--
    Document   : attendance_Managememt
    Created on : Apr 27, 2011, 10:32:25 AM
    Author     : user03
--%>

<%@page import="javax.print.attribute.Size2DSyntax"%>
<%@page contentType="text/html" pageEncoding="UTF-8" import="java.sql.*,src.*,java.util.Enumeration,java.util.ArrayList,java.text.SimpleDateFormat,java.util.Date" session="true"%>
<jsp:include page="header.jsp"/>

<html>
    <%
String username=(String)session.getAttribute("user");
System.out.println("Username is " +username);
if(username==null)
    {
    response.sendRedirect("error.jsp");
    }
else{
                JdbcConnection conn=new JdbcConnection();
                Connection con=null;
                Statement stmt=null;
                ResultSet rs=null;
                String sql;
                boolean bn=false;

ArrayList a1=new ArrayList();
    %>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Attendance Management</title>
         <LINK rel=stylesheet href="stylesheet/fac_css.css">
         <script type="text/javascript">
             function setValue()
             {
                 if(document.getElementById('att').checked)
                     {
                         document.getElementById('pre').disabled=false;
                         document.getElementById('abs').disabled=true;
                     }
          }

</script>
      </head>
    <body>
        <form name="form" method="post" action="add_attendance_sheet.jsp">
          <div id="welcome">
           <div id="welcome_in">
            <div id="welcome_in_left">Attendance Management</div>
            <div id="welcome_in_right">
                <%
                String login_user = (String)session.getAttribute("user");
                Date dt=new Date();
                SimpleDateFormat sd=new SimpleDateFormat("dd-MM-yyyy");
                String sys_dt=sd.format(dt);
                %>
            <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="280" align="center" border="0" cellspacing="0" cellpadding="0" rules="rows" style="border:1px solid #cccccc;">
            <tr>
                <td><input type="hidden" name="rec" value="staff_id"></td>
            </tr>
            <tr>
                <td class="centerfont">Current Date</td>
                <td><input size="10" type="text" name="attendance_date" value="<%=sys_dt%>" id="aa"></td>
                <td> </td>
             </tr>
            <tr>
                <td colspan="3"><table id="attendance" width="100%" cellpadding="" cellspacing="" rules="all" style="border:0px solid #cccccc">
                <tbody>
                    <tr>
                         <td class="centerfont" width="75">Staff Name</td>
                         <td class="centerfont" width="10" >Present </td>
                         <td class="centerfont" width="10">Absent</td>
                    </tr>
                  <tr>
                   <%
                    try
                    {
                    con=conn.getConnection();
                    stmt=(Statement)con.createStatement();
                    sql="Select staff_name from staff_manager";
                    rs=stmt.executeQuery(sql);
                    while(rs.next())
                        {
                   /** a1.add(rs.getString("staff_name"));
                        }
                    con=conn.getConnection();
                    stmt=(Statement)con.createStatement();
                    int size=a1.size();
                    for(int i=0;i<size;i++)
                       {
                    String name=request.getParameter("staff_name");
                    
                    sql="Select staff_name from staff_manager where staff_name ='"+name+"'";
                    rs=stmt.executeQuery(sql);
                    System.out.println(name);
                    while(rs.next())
                        {
                        //bn=true;*/
                        
                       %>
                       <td id="att"><input type="text" id="nm" name="staff_name" value="<%=rs.getString(1)%>" readonly onclick="return setValue();"></td>
                       <td><input type="radio" name="present" id="pre" value="present"></td>
                   <td><input type="radio" name="absent" id="pre" value="absent"></td>
                   </tr><%}//}%>
                </tbody>
                 </table>
                  <%
                    }
                catch(Exception e)
                    {
                    System.out.println("Sql exception  " + e.getMessage());
                    }
                %>
                <tr>
                 <td> </td>
                 <td><input type="image" name="Submit" value="Submit" class="button" src="images/submit_butt.jpg" align="bottom" style="margin-left:5px;"></td>
                 <td> </td>
                </tr>
               </table>
           </div>
        </form>
        <jsp:include page="footer.jsp"/>
    </body>
</html>
 <%}%>

This is second jsp.........

<%-- 
    Document   : add_attendance_sheet
    Created on : Apr 30, 2011, 11:30:04 AM
    Author     : user03
--%>

<%@page contentType="text/html" pageEncoding="UTF-8" %>
<jsp:useBean id="bn" scope="request" class="src.requestForm_bean"/>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Add Attendance Sheet</title>
    </head>
    <%
    String date=request.getParameter("attendance_date");
    String name=request.getParameter("staff_name");
    String present=request.getParameter("present");
    String absent=request.getParameter("absent");

bn.setAttendance_date(date);
   /**if(name.equals(present) && name.equals(absent))
        {
    System.out.println("Your query is done  "+name);
    }
    else
        {
        System.out.println("Your query is not done  "+name);
        }*/
    bn.setAttendance_name(name);
    if(present=="" || present==null)
        {
        present="NA";
        }
    else 
        {
        present="P";
        }
    
    bn.setPresent(present);
    if (absent=="" || absent==null)
        {
        absent="NA";
        }
    else
        {
        absent="A";
        }
    
    bn.setAbsent(absent);

String b=bn.attendance_Sheet();
    if(b.equalsIgnoreCase("Ok"))
        {
    %>
    <body>
        <script type="text/javascript">
            onload=fun();
            function fun()
            {
                alert("Data insertion is success ");
                self.location="attendance_Managememt.jsp";
            }
        </script>
        <%}else{%>
        <script type="text/javascript">
            onload=fun();
            function fun()
            {
                alert("data insertion is failed!");
                self.location="attendance_Managememt.jsp"
            }
        </script>
        <%}%>
    </body>
</html>

This is bean where I am inserting values ...

private String attendance_date;
private String attendance_name;
private String present;
private String absent;

public String getAbsent() {
        return absent;
    }

public void setAbsent(String absent) {
        this.absent = absent;
    }

public String getAttendance_date() {
        return attendance_date;
    }

public void setAttendance_date(String attendance_date) {
        this.attendance_date = attendance_date;
    }

public String getAttendance_name() {
        return attendance_name;
    }

public void setAttendance_name(String attendance_name) {
        this.attendance_name = attendance_name;
    }

public String getPresent() {
        return present;
    }

public void setPresent(String present) {
        this.present = present;
    }

public String attendance_Sheet()
    {
        int count=0;
        con=new JdbcHelper1();
        try
        {
            conn=(Connection) con.getConnection();
            pst=conn.prepareStatement("insert into attendance_sheet values(0,?,?,?,?,sysdate())");
          //  for(int i=0; i<attendance_name.length;i++)
           // {
           // pst.setString(1,s_id);
            pst.setString(1,attendance_date);
            pst.setString(2,attendance_name);
            pst.setString(3,present);
            pst.setString(4,absent);
            pst.executeUpdate();
          //  }
            count++;
            if(count>0)
            {
                rtn="Ok";
                System.out.println("Data insertion is success !!");
            }
            else
            {
                rtn="Not ok";
                System.out.println("data insertion is failed");
            }
        }
        catch(Exception e)
        {
            System.out.println("Sql exception  " + e.getMessage());
        }
        finally{}
        return rtn;
    }

One thing staff_manager bean is also use in jsp for one field where i am getting staff_names

database is here....

please reply................

Hey, I think in your JSP you are starting a <tr> outside the loop therefore only the first row has a <tr> and </tr>. View the source and you should be able to see this.

Also it has to be said, in this day and age java code in JSP's is a big NO. For a start not having the java code there tidies up the HTML in your page in which case you would have been able to find your problem much easier as you can indent it as it should be!

Also doing this allows you to consolidate all your database access so you don't have to set up connections all over the place! There are so many good reasons for doing it, to not is a mistake.

Sean

I ave cheked but not working..........

"It's not working" does not help, please can you post the source as it appears in your browser...

Sean

How I can send You my browser page .....................
Please tell me.........

In IE, go to your page click View -> Source and copy that.

Sean

This is source.............

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
 
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
 
   <!LINK rel=stylesheet href="stylesheet/fac_css.css">
<link href="ddsmoothmenu.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="jquery.js"></script>
<script language="javascript" type="text/javascript" src="ddsmoothmenu.js"></script>
 <LINK rel=stylesheet href="stylesheet/facility_stl.css"/>
<script type="text/javascript"> 
 
ddsmoothmenu.init({
	mainmenuid: "main-nav", //menu DIV id
	orientation: 'h', //Horizontal or vertical menu: Set to "h" or "v"
	classname: 'ddsmoothmenu', //class added to menu's outer DIV
	//customtheme: ["#1c5a80", "#18374a"],
	contentsource: "markup" //"markup" or ["container_id", "path_to_menu_file"]
})
 
</script>
 
 <script type="text/javascript" src="css/mootools-smoothscroll.js"></script>
 
</head>
</head>
 
<body>

 
 
  
     <div id="heade">
        <div id="heade_left"><img src="images/heade_top.jpg" width="301"
        height="116"></div>
        <div id="heade_right">
        <div id="heade_right_top"><ul>  <li><a
        href="#">Events</a> </li>  <li><a href="#">Start Poll</a> </li>  <li><a
        href="#">Gate Pass</a> </li><li><a href="#">Broadcast</a> </li><li><a href="#">Document Repository</a>
        </li>
        </ul></div>
        <div id="heade_right_botoom"><ul> <li><a href="home_page.jsp">Home</a> </li>  <li><a
        href="logout.jsp" style="border:none; ">Logout</a></li> </ul></div></div>
 
        </div>
 
        <div id="menu">
 
       <div id="main-nav" class="ddsmoothmenu">
                <ul>
 
                <li style="z-index: 100;"><a class="" style="padding-right: 20px;" href="#" title="About Us">Resident Profile</a>
                <ul class="iside">
                <li><a href="appartment.jsp">Create new profile</a></li>
                <li><a href="search_owner_profile.jsp">Update existing profile</a></li>
                </ul>
 
                </li>
 
                
                <li style="z-index: 100;"><a class="" style="padding-right: 20px;" href="#" title="About Us">RWA</a>
                <ul class="iside">
                <li><a href="#">Update Office Bearer Profile</a></li>
                <li><a href="#">Member Database</a></li>
                </ul>
 
                </li>
 
                
 
                <li style="z-index: 100;"><a class="" style="padding-right: 20px;" href="#" title="About Us">Complaints</a>
                <ul class="iside">
                <li><a href="complent.jsp">Create Complaint</a></li>
                <li><a href="search_complaint.jsp">View Complaint</a></li>
                </ul>
 
                </li>
 
                
 
                <li style="z-index: 100;"><a class="" style="padding-right: 20px;" href="#" title="About Us">Billing </a>
                <ul class="iside">
                 <li><a href="electricity_bill.jsp">Electricity</a></li>
                <li><a href="#">Generate Bill</a></li>
                <li><a href="search_electricity_bill.jsp">View Bill </a></li>
                <li><a href="#.jsp">Generate Receipt</a></li>
                <li><a href="#">View Receipts</a></li>
                <li><a href="receipt.jsp">Maintenance Bills</a></li>
                 <li><a href="Create_Billing_Penality.jsp">Penality</a></li>
                </ul>
 
                </li>
 
                
 
                <li style="z-index: 100;"><a class="" style="padding-right: 20px;" href="#" title="About Us">Notice Board</a>
                <ul class="iside">
                <li><a href="notice_board.jsp">Post Notice</a></li>
                <li><a href="search_notice_board.jsp">View Notice</a></li>
                <li><a href="#">Archives</a></li>
 
                </ul>
 
                </li>
 
                
 
                <li style="z-index: 100;"><a class="" style="padding-right: 20px;" href="#" title="About Us">Facility Booking</a>
                <ul class="iside">
                <li><a href="FacilityBooking.jsp">Book Facility</a></li>
                <li><a href="search_facility_Booking.jsp">View Booking Request</a></li>
                <li><a href="#">Archives</a></li>
 
                </ul>
 
                </li>
 
                
 
                <li style="z-index: 100;"><a class="" style="padding-right: 20px;" href="#" title="About Us">Event</a>
                <ul class="iside">
                <li><a href="event.jsp">Create Event</a></li>
                <li><a href="search_event.jsp">View Event</a></li>
                <li><a href="#">Archives</a></li>
 
                </ul>
 
                </li>
 
                
 
                <li style="z-index: 100;"><a class="" style="padding-right: 20px;" href="#" title="About Us">Gate Pass</a>
                <ul class="iside">
                <li><a href="gate_Pass.jsp">Create Gate Pass</a></li>
                <li><a href="search_gate_pass.jsp">View Gate Pass</a></li>
                <li><a href="#">Renew Gate Pass</a></li>
                <li><a href="#">Archives</a></li>
                </ul>
 
                </li>
 
                
 
                <li style="z-index: 100;"><a class="" style="padding-right: 20px;" href="#" title="About Us">Instant Poll</a>
                <ul class="iside">
                <li><a href="create_poll.jsp">Create Poll</a></li>
                <li><a href="#">View Responses</a></li>
                <li><a href="#">Archives</a></li>
                </ul>
 
                </li>
 
                
 
                <li style="z-index: 100;"><a class="" style="padding-right: 20px;" href="#" title="About Us">Manager</a>
                <ul class="iside">
                <li><a href="#">Asset Manager</a>
                <ul class="iside">
                 <li><a href="#">Asset</a>
                     <ul class="iside">
                 <li><a href="Create_Asset.jsp">Create New Asset</a></li>
                 <li><a href="search_Asset.jsp">View Assets</a></li>
                     </ul>
                 </li>
                 <li><a href="#">Main Asset</a>
                     <ul class="iside">
                 <li><a href="Asset_Master.jsp">Main Asset</a></li>
                 <li><a href="search_master_asset.jsp">View Main Assets</a></li>
                     </ul>
                 </li>
                 <li><a href="#">Asset Category</a>
                     <ul class="iside">
                 <li><a href="Asset_Category.jsp">Create Asset Category</a></li>
                 <li><a href="search_asset_category.jsp">View Assets Category</a></li>
                     </ul>
                 </li>
                 
                </ul>
 
                </li>
                <li><a href="#">Store Manager</a>
 
                <ul class="iside">
                    <li><a href="material_Receipt.jsp">Create Receive Material</a></li>
                    <li><a href="search_Material_Receipt.jsp">View Receive Material</a></li>
                   
                    <li><a href="material_Issue.jsp">Issue Material</a></li>
                    <li><a href="search_material_Issue.jsp">View Receive Issue</a></li>
                               
                <li><a href="#">View Current Inventory</a></li>
                <li><a href="#">Archives</a></li>
 
                </ul>
 
                </li>
                <li><a href="#">Staff Manager</a>
 
                <ul class="iside">
                <li><a href="Create_staff_Manager.jsp">Create Staff Profile</a></li>
                <li><a href="search_staff_member.jsp">View Staff Profile</a></li>
                <li><a href="attendance_Managememt.jsp">Staff Attendance</a></li>
                <li><a href="leave_payment.jsp">Staff Leave</a></li>
                <li><a href="#">Staff Payroll </a></li>
                <li><a href="#">Archives</a></li>
                </ul>
 
                </li>
                <li><a href="#">Money Manager</a>
 
                <ul class="iside">
                <li><a href="#">Make payments</a></li>
                <li><a href="#">Receive payments</a></li>
                <li><a href="#">Archives</a></li>
                </ul>
 
                </li>
                <li><a href="#">Meeting Manager</a>
                <ul class="iside">
                <li><a href="Meeting_Request.jsp">Create Meeting Request</a></li>
                <li><a href="#">Upload Minutes</a></li>
                <li><a href="#">Archives</a></li>
                </ul>
                </li>
                <li><a href="#">Visitor Manager</a>
 
                <ul class="iside">
                <li><a href="visitor_log.jsp">Add Visitor Log</a></li>
 
                </ul>
 
                </li>
 
                </ul>
 
                </li>
 
                
 
                <li style="z-index: 100;"><a class="" style="padding-right: 20px;" href="#" title="About Us">Generate MIS</a>
                <ul class="iside">
                <li><a href="#">Resident Master</a></li>
                <li><a href="#">Tenant Master</a></li>
                <li><a href="#">Vendor Master</a>
                <ul class="iside">
                <li><a href="vendor.jsp">Create Vendor</a></li>
                <li><a href="vendor_purchase_order.jsp">Create Purchase Order</a></li>
                <li><a href="#">Archives</a></li>
                </ul>
                </li>
                <li><a href="#">Outstanding Payables</a></li>
                <li><a href="#">Outstanding Receivables</a></li>
                <li><a href="#">Staff Master</a></li>
                <li><a href="#">Financial Statement</a></li>
                <li><a href="#">View Visitor Log</a></li>
                <li><a href="#">Bill Payment Defaulters</a></li>
                <li><a href="#">Complaint Dashboard</a></li>
                <li><a href="#">Maid Database</a></li>
 
                </ul>
 
                </li>
 
                
       
                
                         
                </ul>
 
                </div>
 
</div>
     
 
        
     
        
 
<div style="clear:both;"></div>
 
</body>
</html>
 
 
<html>
    
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Attendance Management</title>
         <LINK rel=stylesheet href="stylesheet/fac_css.css">
         <script type="text/javascript">
             function setValue()
             {
                 if(document.getElementById('att').checked)
                     {
                         document.getElementById('pre').disabled=false;
                         document.getElementById('abs').disabled=true;
                     }
          }
         </script>
      </head>
    <body>
        <form name="form" method="post" action="add_attendance_sheet.jsp">
          <div id="welcome">
           <div id="welcome_in">
            <div id="welcome_in_left">Attendance Management</div>
            <div id="welcome_in_right">
                
            <div id="welcome_in_right_right">Welcome: pradeep</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="280" align="center" border="0" cellspacing="0" cellpadding="0" rules="rows" style="border:1px solid #cccccc;">
            <tr>
                <td><input type="hidden" name="rec" value="staff_id"></td>
            </tr>
            <tr>
                <td class="centerfont">Current Date</td>
                <td><input size="10" type="text" name="attendance_date" value="13-05-2011" id="aa"></td>
                <td> </td>
             </tr>
            <tr>
                <td colspan="3"><table id="attendance" width="100%" cellpadding="" cellspacing="" rules="all" style="border:0px solid #cccccc">
                <tbody>
                    <tr>
                         <td class="centerfont" width="75">Staff Name</td>
                         <td class="centerfont" width="10" >Present </td>
                         <td class="centerfont" width="10">Absent</td>
                    </tr>
                  <tr>
                   
                       <td id="att"><input type="text" id="nm" name="staff_name" value="Sweepar" readonly onclick="return setValue();"></td>
                       <td><input type="radio" name="present" id="pre" value="present"></td>
                   <td><input type="radio" name="absent" id="pre" value="absent"></td>
                   </tr>
                </tbody>
                 </table>
                  
                <tr>
                 <td> </td>
                 <td><input type="image" name="Submit" value="Submit" class="button" src="images/submit_butt.jpg" align="bottom" style="margin-left:5px;"></td>
                 <td> </td>
                </tr>
               </table>
           </div>
        </form>
        
 
 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">
 
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Footer</title>
         <link href="stylsheet/facility_stl.css" rel="stylesheet" type="text/css"/>
 
    </head>
    <body>
        
<div id="futter">
<div id="futter_in">Copy © 2011 Idea Craft Group. All right reserved Design & Developed by <a href="http://www.adnig.com/" target="blank">Adnig Technologies Pvt. Ltd.</a></div>
</div>
    </body>
</html>
 
    </body>
</html>

Ok, I can't see any problems with that... but like I said I think it is because you are putting your <tr> start tag before getting the data from the database rather than on each row.

Sean

I think all <tr> and <td>s are set at own place....................

please suggest me.........

<tbody>   
                    <tr>   
                         <td class="centerfont" width="75">Staff Name</td>   
                         <td class="centerfont" width="10" >Present </td>   
                         <td class="centerfont" width="10">Absent</td>   
                    </tr>   
                  <tr>   // this is outside the loop so only one row is created
                   <%   
                    try  
                    {   
                    con=conn.getConnection();   
                    stmt=(Statement)con.createStatement();   
                    sql="Select staff_name from staff_manager";   
                    rs=stmt.executeQuery(sql);   
                    while(rs.next())   
                        {     
                       %>   
                       <td id="att"><input type="text" id="nm" name="staff_name" value="<%=rs.getString(1)%>" readonly onclick="return setValue();"></td>   
                       <td><input type="radio" name="present" id="pre" value="present"></td>   
                   <td><input type="radio" name="absent" id="pre" value="absent"></td>   
                   </tr><%}//}%>   
                </tbody>

look at your code, on line 7 you create the row before you start looping so only 1 row is ever created.

Sean

Hi Sean ,

Thanks for reply but my code as it is as you posted but only first value is inserting in the table I could not understanding the problem...
please read all latest code I am posting and suggest me what should in this.......

Thanks!!!

This is bean file....

private String s_id;
    private String photo;
    private String s_name;
    private String s_dob;
    private String s_address;
    private String s_contact_no;
    private String job_description;
    private String designation;
    private String last_company;
    private String experience;
    private String varification_status;
    private String id_proof;
    private String salary;
    private String leveas_eligibility;
    private String pf_no;
    private String pf_amount;
    private String bonus;

public String getBonus() {
        return bonus;
    }

public void setBonus(String bonus) {
        this.bonus = bonus;
    }

public String getDesignation() {
        return designation;
    }

public void setDesignation(String designation) {
        this.designation = designation;
    }

public String getExperience() {
        return experience;
    }

public void setExperience(String experience) {
        this.experience = experience;
    }

public String getId_proof() {
        return id_proof;
    }

public void setId_proof(String id_proof) {
        this.id_proof = id_proof;
    }

public String getJob_description() {
        return job_description;
    }

public void setJob_description(String job_description) {
        this.job_description = job_description;
    }

public String getLast_company() {
        return last_company;
    }

public void setLast_company(String last_company) {
        this.last_company = last_company;
    }

public String getLeveas_eligibility() {
        return leveas_eligibility;
    }

public void setLeveas_eligibility(String leveas_eligibility) {
        this.leveas_eligibility = leveas_eligibility;
    }

public String getPf_amount() {
        return pf_amount;
    }

public void setPf_amount(String pf_amount) {
        this.pf_amount = pf_amount;
    }

public String getPf_no() {
        return pf_no;
    }

public void setPf_no(String pf_no) {
        this.pf_no = pf_no;
    }

public String getPhoto() {
        return photo;
    }

public void setPhoto(String photo) {
        this.photo = photo;
    }

public String getS_address() {
        return s_address;
    }

public void setS_address(String s_address) {
        this.s_address = s_address;
    }

public String getS_contact_no() {
        return s_contact_no;
    }

public void setS_contact_no(String s_contact_no) {
        this.s_contact_no = s_contact_no;
    }

public String getS_dob() {
        return s_dob;
    }

public void setS_dob(String s_dob) {
        this.s_dob = s_dob;
    }

public String getS_id() {
        return s_id;
    }

public void setS_id(String s_id) {
        this.s_id = s_id;
    }

public String getS_name() {
        return s_name;
    }

public void setS_name(String s_name) {
        this.s_name = s_name;
    }

public String getSalary() {
        return salary;
    }

public void setSalary(String salary) {
        this.salary = salary;
    }

public String getVarification_status() {
        return varification_status;
    }

public void setVarification_status(String varification_status) {
        this.varification_status = varification_status;
    }

public String insert_staff_manager()
{
    int count=0;
    con=new JdbcHelper1();
    try
    {
        conn=(Connection)con.getConnection();
        pst=conn.prepareStatement("insert into staff_manager values(0,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,sysdate())");
        pst.setString(1,s_id);
        pst.setString(2,society_name);
        pst.setString(3,photo);
        pst.setString(4,s_name);
        pst.setString(5,dob);
        pst.setString(6,s_address);
        pst.setString(7,s_contact_no);
        pst.setString(8,job_description);
        pst.setString(9,designation);
        pst.setString(10,last_company);
        pst.setString(11,experience);
        pst.setString(12,varification_status);
        pst.setString(13,id_proof);
        pst.setString(14,salary);
        pst.setString(15,leveas_eligibility);
        pst.setString(16,pf_no);
        pst.setString(17,pf_amount);
        pst.setString(18,bonus);
        pst.executeUpdate();
        System.out.println("Query executing   "+pst);
        count++;
        if(count>0)
        {
            rtn="Ok";
            System.out.println("Data inserted successfully!");
        }
        else
        {
            rtn="not ok";
            System.out.println("Data insertion is failed!");
        }
    }
    catch(Exception e)
    {
        System.out.println("Sql exception........ " + e.getMessage());
    }
    finally{}
    return rtn;
}
private String attendance_date;
private String[] attendance_name;
private String[] present;
private String[] absent;

public String[] getAbsent() {
        return absent;
    }

public void setAbsent(String[] absent) {
        this.absent = absent;
    }

public String getAttendance_date() {
        return attendance_date;
    }

public void setAttendance_date(String attendance_date) {
        this.attendance_date = attendance_date;
    }

public String[] getAttendance_name() {
        return attendance_name;
    }

public void setAttendance_name(String[] attendance_name) {
        this.attendance_name = attendance_name;
    }

public String[] getPresent() {
        return present;
    }

public void setPresent(String[] present) {
        this.present = present;
    }
    
    public String attendance_Sheet()
    {
        PreparedStatement pst=null;
        String sql;
        int count=0;
        con=new JdbcHelper1();
        try
        {
            conn=(Connection)con.getConnection();
            pst=this.conn.prepareStatement("insert into attendance_sheet values(0,?,?,?,?,sysdate())");
            for(int i=0;i<attendance_name.length && i<present.length && i<absent.length;i++)
            {
            //pst=conn.prepareStatement("insert into attendance_sheet values(0,?,?,?,?,sysdate())");
            pst.setString(1,attendance_date);
            pst.setString(2,attendance_name[i].trim());
            pst.setString(3,present[i].trim());
            pst.setString(4,absent[i].trim());
            pst.executeUpdate();
            System.out.println("Query is....=   " + pst);
            }
            count++;
            if(count>0)
            {
                rtn="Ok";
                System.out.println("Data insertion is success !!");
            }
            else
            {
                rtn="Not ok";
                System.out.println("data insertion is failed");
            }
        }
        catch(Exception e)
        {
            System.out.println("Query is executing......   " + pst);
            System.out.println("Sql exception  " + e.getMessage());
        }
        finally{}
        return rtn;
    }

This is jsp page...

<%--
    Document   : attendance_Managememt
    Created on : Apr 27, 2011, 10:32:25 AM
    Author     : user03
--%>
<%@page import="javax.print.attribute.Size2DSyntax"%>
<%@page contentType="text/html" pageEncoding="UTF-8" import="java.sql.*,src.*,java.util.Enumeration,java.util.ArrayList,java.text.SimpleDateFormat,java.util.Date" session="true"%>
<jsp:include page="header.jsp"/>

<html>
    <%
                String username=(String)session.getAttribute("user");
                System.out.println("Username is " +username);
                if(username==null)
                    {
                    response.sendRedirect("error.jsp");
                    }
                else{
                JdbcConnection conn=new JdbcConnection();
                Connection con=null;
                Statement stmt=null;
                ResultSet rs=null;
                String sql=null;
                boolean bn=false;
                ArrayList a1=new ArrayList();
    %>
<head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Attendance Management</title>
        <LINK rel=stylesheet href="stylesheet/fac_css.css">
        <script type="text/javascript">
             function chkRadioButton()
             {
                 var i=document.myForm.element['pre'];
                 
                  for( i=0;i<pre.length;i++)
                  if(pre[i].checked)
                   return pre[i].value;
                  
             }
                   
          /**   if(document.getElementById)
                 {
                   if(a !="")
                       {
                           document.getElementById('pre').checked="false";
                           document.getElementById('abs').checked="true";
                       }

else if(b !="")
                       {
                           document.getElementById('pre').checked="true";
                           document.getElementById('abs').checked="false";
                       }
                 }
             function chkRadio(f,n)
             {
                 f=f.document.forms[f].elements;
                 for(var i=i<f.length;i>-1;--i)
                    if(i[f].name==n && f[i].checked)
                        return f[i].value;
                return 'undefined';
             }
             function zoo()
             {
                alert(chkRadio('form','radio1'));
             }*/
             
         </script>
      </head>
    <body>
        <form name="myForm" method="post" action="add_attendance_sheet.jsp">
          <div id="welcome">
           <div id="welcome_in">
            <div id="welcome_in_left">Attendance Management</div>
            <div id="welcome_in_right">
                <%
                String login_user = (String)session.getAttribute("user");
                Date dt=new Date();
                SimpleDateFormat sd=new SimpleDateFormat("dd-MM-yyyy");
                String sys_dt=sd.format(dt);
                %>
            <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="280" align="center" border="0" cellspacing="0" cellpadding="0" rules="rows" style="border:1px solid #cccccc;">
            <tr>
                <td><input type="hidden" name="rec" value="staff_id"></td>
            </tr>
            <tr>
                <td class="centerfont">Current Date</td>
                <td><input size="10" type="text" name="attendance_date" value="<%=sys_dt%>" id="aa"></td>
                <td> </td>
             </tr>
            <tr>
                <td colspan="3"><table id="attendance" width="100%" cellpadding="" cellspacing="" rules="all" style="border:0px solid #cccccc">
                <tbody>
                    <tr>
                         <td class="centerfont" width="75">Staff Name</td>
                         <td class="centerfont" width="10" >Present </td>
                         <td class="centerfont" width="10">Absent</td>
                    </tr>
                  
                   <%
                    try
                    {
                    int i=0;
                    con=(Connection)conn.getConnection();
                    stmt=(Statement)con.createStatement();
                    sql="Select staff_name from staff_manager";
                    rs=stmt.executeQuery(sql);
                    while(rs.next())
                        {
                        i++;
                       // System.out.println("lskfs   " + i);
                       // do
                          //  {
                   /** a1.add(rs.getString("staff_name"));
                        }
                    con=conn.getConnection();
                    stmt=(Statement)con.createStatement();
                    int size=a1.size();
                    for(int i=0;i<size;i++)
                       {
                    String name=request.getParameter("staff_name");
                    
                    sql="Select staff_name from staff_manager where staff_name ='"+name+"'";
                    rs=stmt.executeQuery(sql);
                    System.out.println(name);
                    while(rs.next())
                        {
                        bn=true;*/
                        
                       %>
                   <tr>
                       <td id="att"><input type="text" id="sname" name="staff_name" value="<%=rs.getString(1)%>" readonly ></td>
                       <td><input type="radio" name="radio" id="pre<%//=i%>" value="present" onclick="chkRadioButton();"></td>
                      <td><input type="radio" name="radio" id="abs<%//=i%>" value="absent" onclick="chkRadioButton();"></td>
                   </tr><%
                    //}while(rs.next());
                            }//System.out.println("Query after while loop  " + sql);//}%>
                </tbody>
                 </table>
                  <%
                    }
                catch(Exception e)
                    {
                    System.out.println("query in catch   " + sql);
                    System.out.println("Sql exception  " + e.getMessage());
                    }
                %>
                <tr>
                 <td> </td>
                 <td><input type="image" name="Submit" value="Submit" class="button" src="images/submit_butt.jpg" align="bottom" style="margin-left:5px;"></td>
                 <td> </td>
                </tr>
               </table>
           </div>
        </form>
        <jsp:include page="footer.jsp"/>
    </body>
</html>
 <%}%>

This is insertion page of jsp page

<%-- 
    Document   : add_attendance_sheet
    Created on : Apr 30, 2011, 11:30:04 AM
    Author     : user03
--%>

<%@page contentType="text/html" pageEncoding="UTF-8" %>
<jsp:useBean id="bn" scope="request" class="src.requestForm_bean"/>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Add Attendance Sheet</title>
    </head>
    <%
    String date=request.getParameter("attendance_date");
    String[] name=request.getParameterValues("staff_name");
    String[] present=request.getParameterValues("radio");
    String[] absent=request.getParameterValues("radio");

bn.setAttendance_date(date);
    System.out.println("date is "+date);
    //bn.setAttendance_name(name);
    for(int i=0;i<name.length;i++)
    {
      bn.setAttendance_name(name);
      System.out.println("name is "+name[i]);
    }

for(int j=0;j<present.length;j++)
    {
         if(present[j]=="" && present[j]==null)
             {
             present[j]="NA";
             }
         else
             {
             bn.setPresent(present);
             System.out.println("Present is "+present[j]);
             }
    }

for(int k=0;k<absent.length;k++)
    {
          if(absent[k]=="" && absent[k]==null)
             {
             absent[k]="NA";
             }
         else
             {
              bn.setAbsent(absent);
              System.out.println("Absent is "+absent[k]);
             }
    }

String b=bn.attendance_Sheet();
    if(b.equalsIgnoreCase("Ok"))
        {
    %>
    <body>
        <script type="text/javascript">
            onload=fun();
            function fun()
            {
                alert("Data insertion is success ");
                self.location="attendance_Managememt.jsp";
            }
        </script>
        <%}else{%>
        <script type="text/javascript">
            onload=fun();
            function fun()
            {
                alert("data insertion is failed!");
                self.location="attendance_Managememt.jsp"
            }
        </script>
        <%}%>
    </body>
</html>

and these are tables.....

id                   int(11)       (NULL)             NO      PRI     (NULL)   auto_increment  select,insert,update,references         
staff_id             varchar(100)  latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
society_name         varchar(100)  latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
photo                varchar(500)  latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
staff_name           varchar(100)  latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
dob                  varchar(100)  latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
address              varchar(100)  latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
contact_no           varchar(100)  latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
job_description      varchar(100)  latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
designation          varchar(100)  latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
last_company         varchar(100)  latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
experience           varchar(100)  latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
varification_status  varchar(100)  latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
id_proof             varchar(500)  latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
salary               varchar(100)  latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
leaves_eligibility   varchar(100)  latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
pf_no                varchar(100)  latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
pf_amount            varchar(100)  latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
bonus                varchar(100)  latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
current_date_time    datetime      (NULL)             YES             (NULL)                   select,insert,update,references