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>&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp;<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

Popular posts from this blog

ios - iPhone/iPad different view orientations in different views , and apple approval process -

java Extracting Zip file -

C# WinForm - loading screen -