Insert specific fields into table dynamically for each row.

There is a table containing 20 fields and 2 of those are empty. The administrator will enter those details in a webpage. So that the field values will insert into the table. For this all the rows displayed and two rows with empty text boxes, he insert there for each row and for each row there is a button "done".if he click on done the values will be inserted into database.Then he enter values for next row. How to do this problem?

but it should not go to another page. he enter one details and just click done on first row and immediately he enters second row details. And now the first row details should appear in the text boxes.

View Answers

May 20, 2011 at 5:05 PM

Modify the code:

1)admin.jsp:

<%@ page import="java.sql.*" %>
<html>
<head>
<script language="javascript">
function editRecord(){
    var f=document.form;
    f.method="post";
    f.action='done.jsp';
    f.submit();
  }
</script>
</head>
<body>
<br><br>
<form method="post" name="form">
<table border="1">
<tr><th></th><th>Name</th><th>Address</th><th>Contact No</th><th>Email</th></tr>
<%
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";
String db = "test";
String driver = "com.mysql.jdbc.Driver";
String userName ="root";
String password="root";

Statement st;
try{
Class.forName(driver).newInstance();
con = DriverManager.getConnection(url+db,userName,password);
String query = "select * from employee";
st = con.createStatement();
ResultSet rs = st.executeQuery(query);
%>
<%
while(rs.next()){
%>
<tr>
<td><input type="hidden" name="id" value="<%=rs.getString(1)%>"></td>
<td><input type="text" name="name" value="<%=rs.getString(2)%>"></td>
<td><input type="text" name="address" value="<%=rs.getString(3)%>"></td>
<td><input type="text" name="contact" value="<%=rs.getString(4)%>"></td>
<td><input type="text" name="email" value="<%=rs.getString(5)%>"></td>
<td><input type="button" name="button" value="Done" style="background-color:green;font-weight:bold;color:white;" onclick="editRecord();" ></td>
</tr>
<%

}
%>
<%
}
catch(Exception e){
e.printStackTrace();
}
%>
</table>
</form>
</body>
</html>

2)done.jsp:

<%@page import="java.sql.*"%>
<%
String ide[]=request.getParameterValues("id");
String name[]=request.getParameterValues("name");
String address[]=request.getParameterValues("address");
String contact[]=request.getParameterValues("contact");
String email[]=request.getParameterValues("email");

try{
Connection conn = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root", "root");
Statement st=null;
st=conn.createStatement();
for(int i=0;i<ide.length;i++){
int id=Integer.parseInt(ide[i]);
String n=name[i];
String add=address[i];
int ct=Integer.parseInt(contact[i]);
String e=email[i];
st.executeUpdate("update employee set name='"+n+"',address='"+add+"',contactNo="+ct+",email='"+e+"' where id='"+id+"'");
}
}
catch(Exception e){
System.out.println(e);
}
response.sendRedirect("/examples/jsp/admin.jsp");

%>

May 20, 2011 at 5:55 PM

Thanks for your answer. It is very much useful to me.