Hii all,
I am new to JSP,
M fetching few column values from the table and add one column in which m entering value manually and save all the data in another table while clicking on "Save" Button.
But M not getting the proper output.Please help me out.
I am getting success to get data of Employee Code,Employee name and Dept code from emp_mst.
now I am adding LWP(Leave without Pay) field for all the fetched value.After adding LWP how to save all the data in another table "i.e. leave_mst " while clicking on Submit button..
Following had written my code how it work...Please give me the solution for this..
------------------>
<%
String empmst="select empcd,emp_name,dept_cd from emp_mst";
DBConnection db = new DBConnection();
db.getConnection();
java.sql.ResultSet rs;
rs = db2.getAllData(empmst);
%>
<table border="1">
<tr>
<td>Sr. No.</td>
<td>Employee Code:</td>
<td>Employee Name:</td>
<td>Department Code:</td>
</tr>
<%
while(rs2.next())
{
%>
<tr>
<td>
<%=rs.getRow()%>
</td>
<td>
<input type="text" name="txtempcd" value="<%=rs.getString("empcd")%>"></input>
</td>
<td>
<input type="text" name="txtempname"
value='<%=rs.getString("emp_name")%>'></input>
</td>
<td>
<input type="text" name="txtdeptcd" value="<%=rs.getString("dept_cd")%>"></input>
</td>
<td><input type="text" name="txtsslwp" ></td>
</tr>
<%
}
%>
<tr>
<td>
<input type="Submit" value="Save" name="BtnSubmit">
</td>
</tr>
</table>
<----------------------
I am new to JSP,
M fetching few column values from the table and add one column in which m entering value manually and save all the data in another table while clicking on "Save" Button.
But M not getting the proper output.Please help me out.
I am getting success to get data of Employee Code,Employee name and Dept code from emp_mst.
now I am adding LWP(Leave without Pay) field for all the fetched value.After adding LWP how to save all the data in another table "i.e. leave_mst " while clicking on Submit button..
Following had written my code how it work...Please give me the solution for this..
------------------>
<%
String empmst="select empcd,emp_name,dept_cd from emp_mst";
DBConnection db = new DBConnection();
db.getConnection();
java.sql.ResultSet rs;
rs = db2.getAllData(empmst);
%>
<table border="1">
<tr>
<td>Sr. No.</td>
<td>Employee Code:</td>
<td>Employee Name:</td>
<td>Department Code:</td>
</tr>
<%
while(rs2.next())
{
%>
<tr>
<td>
<%=rs.getRow()%>
</td>
<td>
<input type="text" name="txtempcd" value="<%=rs.getString("empcd")%>"></input>
</td>
<td>
<input type="text" name="txtempname"
value='<%=rs.getString("emp_name")%>'></input>
</td>
<td>
<input type="text" name="txtdeptcd" value="<%=rs.getString("dept_cd")%>"></input>
</td>
<td><input type="text" name="txtsslwp" ></td>
</tr>
<%
}
%>
<tr>
<td>
<input type="Submit" value="Save" name="BtnSubmit">
</td>
</tr>
</table>
<----------------------