how to edit data in html form after retrieving it from database -
i have created , added data database through jsp.now problem edit/update database should done through html form.in 1 select student rollno , form should display other fields , can edit , update database.
editcourse.jsp
<!doctype html> <html> <head> <link href="css/redmond/jquery-ui-1.10.2.custom.min.css" media="screen" rel="stylesheet"/> <link href="css/default.css" media="screen" rel="stylesheet"/> <link href="sidebarmenu.css" rel="stylesheet" type="text/css"> <script src="sidebarmenu.js"></script> <script src="scripts/jquery-1.9.1.min.js"></script> <script src="scripts/jquery-ui-1.10.2.custom.min.js"></script> </head> <body> <!--<form id="frmexamregistration" method="post" enctype="multipart/form-data" class="anu">--> <form name="f1" method="post" class="anu" action="edit_coursedetails.jsp"> <%@include file="adminheader.jsp"%> <%@include file="sidemenus.jsp" %> <div id="container"> <div style="float:right;width:10%;border:0;font-color:#163362"><a href=logout.jsp">log out</a></div><br> <div class="content"><center>edit course</center><br> <div class="formelements,rightcol" align="center"> <label>course code: <span><input type="text" id="txtcoursecode" name="txtcoursecode" ></span></label> </div><br> <div class="buttons"> <button type="submit" class="primaryaction">edit</button> <button type="reset" class="primaryaction">clear</button> </div> </div> </div> </form> </body> </html> edit_coursedetails.jsp
<!doctype html> <html> <head> <link href="css/redmond/jquery-ui-1.10.2.custom.min.css" media="screen" rel="stylesheet"/> <link href="css/default.css" media="screen" rel="stylesheet"/> <link href="sidebarmenu.css" rel="stylesheet" type="text/css"> <script src="sidebarmenu.js"></script> <script src="scripts/jquery-1.9.1.min.js"></script> <script src="scripts/jquery-ui-1.10.2.custom.min.js"></script> </head> <body> <!--<form id="frmexamregistration" method="post" enctype="multipart/form-data" class="anu">--> <% ccode=request.getparameter("txtcoursecode"); try { statement st = null; st=conn.createstatement(); resultset rs = st.executequery("select * courses course='"+txtcoursecode+"'"); if(rs.next()) { cname=rs.getstring("cname"); description=rs.getstring("description"); } %> edit courses <form name="f1" method="post" class="anu" action="add_coursedetails.jsp"> <%@include file="adminheader.jsp"%> <%@include file="sidemenus.jsp" %> <div id="container"> <div style="float:right;width:10%;border:0;font-color:#163362"><a href=logout.jsp">log out</a></div><br> <div class="content"><center>add course</center><br> <div class="formelements,rightcol" align="center"> <label>course code: <span><input type="text" id="txtcoursecode" name="txtcoursecode" value="<%=rs.ccode%>"></span></label> </div><br> <div class="formelements,rightcol" align="center"> <label>course name: <span><input type="text" id="txtcoursename" name="txtcoursename" value="<%=rs.cname%>"></span></label> </div><br> <div class="formelements,rightcol" align="center"> <label>duration: <span>        <input type="text" id="txtduration" name="txtduration" value="<%=rs.getstring("3")%>"></span></label> </div> <div class="buttons"> <button type="submit" class="primaryaction">update</button> <button type="reset" class="primaryaction">clear</button> </div> </div> </div> <% } } catch(exception e){} %> </form> </body> </html> in editcourse form giving ccode should display other field database thier value , can modify it
you can use either ajax or give url of jsp in form action attribute. in jsp txtrollno request, retrieve fields database rollno, populate data appropriate field , can edit , update database.
Comments
Post a Comment