File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Fetching value from database and add some rows and save in another table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Fetching value from database and add some rows and save in another table" Watch "Fetching value from database and add some rows and save in another table" New topic
Author

Fetching value from database and add some rows and save in another table

mehta soham
Greenhorn

Joined: May 27, 2009
Posts: 8
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>


<----------------------


Regards,
Dare Devil
Satya Maheshwari
Ranch Hand

Joined: Jan 01, 2007
Posts: 368
JSP is not the recommended place for doing DB operations. It is better to separate the model and view.
Anyway, if that is not an option for you, you can post the data to a servlet on hitting save and the servlet should take care for committing it to the DB.


Thanks and Regards
mehta soham
Greenhorn

Joined: May 27, 2009
Posts: 8
Thanks...
can you tell me in detail about how can i do using servlet...??
can you give bit focus on it....
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60782
    
  65

Moved to the JDBC forum.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Satya Maheshwari
Ranch Hand

Joined: Jan 01, 2007
Posts: 368
Mehta Soham wrote:Thanks...
can you tell me in detail about how can i do using servlet...??
can you give bit focus on it....

What sort of help you are looking for? If you want to know more about servlets, you can go through: http://java.sun.com/j2ee/tutorial/1_3-fcs/doc/Servlets.html
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Fetching value from database and add some rows and save in another table
 
Similar Threads
Error coming 500 please an code is
rs.getstring not working.
Fetching value from database and add some rows and save in another table
SqlException accured at processing Jsp
not fetching values