Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!-- updateRecordForm -->
- <%@ page import="java.sql.*,java.sql.ResultSet, java.text.*" %>
- <html>
- <head>
- <title>Update Employee Form</title>
- </head>
- <body>
- <font size="5"><b>Update Member Record</b></font>
- <P>
- <%
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection connection = DriverManager.getConnection("jdbc:odbc:Address");
- String query = "SELECT * FROM PersonalInformation WHERE PersonID = ?";
- PreparedStatement statement = connection.prepareStatement(query);
- statement.setInt(1,Integer.parseInt(request.getParameter("id")));
- java.sql.ResultSet RS = statement.executeQuery();
- String ID = "";
- %>
- <%
- while(RS.next())
- {
- %>
- <form method="Post" action="ProcessUpdate.jsp">
- <%
- ID = RS.getString("PersonID");
- %>
- <table>
- <input type="hidden" name="PersonID" value=<%=ID%>>
- <tr></tr>
- <tr>
- <td>First Name: </td>
- <td><input type="text" name="FirstName" value=<%=RS.getString("FirstName") %>></td>
- </tr>
- <tr>
- <td>Last Name: </td>
- <td><input type="text" name="LastName" value="<%=RS.getString("LastName") %>"></td>
- </tr>
- <tr>
- <td>Nickname: </td>
- <td>
- <%
- String nickname = RS.getString("Nickname");
- if(nickname != null)
- {
- %>
- <input type="text" name="Nickname" value=<%= nickname %>>
- <%
- }
- else
- {
- %>
- <input type="text" name="Nickname" value="<Not Specified>">
- <%
- }
- %>
- </td>
- </tr>
- <tr>
- <td>Date of Birth: </td>
- <td>
- <table>
- <tr>
- <%
- String date = RS.getString("BirthDate");
- String month ="";
- String day = "";
- String year = "";
- if(date == null)
- {
- day = "--";
- month = "--";
- year = "----";
- }
- else
- {
- month = date.substring(5,7);
- day = date.substring(8,10);
- year = date.substring(0,4);
- }
- %>
- <td><input type="text" name="day" size="2" value=<%= day %>></td>
- <td>
- <select name="month">
- <%if(month.equals("--")) {%>
- <option label="--" selected="selected">--</option>
- <%}if(month.equals("01")) {%>
- <option label="01" selected="selected">Jan</option>
- <%}else{%>
- <option label="01">Jan</option>
- <%}if (month.equals("02")){%>
- <option label="02" selected="selected">Feb</option>
- <%}else{%>
- <option label="02">Feb</option>
- <%}if (month.equals("03")){%>
- <option label="03" selected="selected">Mar</option>
- <%}else{%>
- <option label="03">Mar</option>
- <%}if (month.equals("04")){%>
- <option label="04" selected="selected">Apr</option>
- <%}else{%>
- <option label="04">Apr</option>
- <%}if (month.equals("05")){%>
- <option label="05" selected="selected">May</option>
- <%}else{%>
- <option label="05">May</option>
- <%}if (month.equals("06")){%>
- <option label="06" selected="selected">Jun</option>
- <%}else{%>
- <option label="06">Jun</option>
- <%}if (month.equals("07")){%>
- <option label="07" selected="selected">Jul</option>
- <%}else{%>
- <option label="07">Jul</option>
- <%}if (month.equals("08")){%>
- <option label="08" selected="selected">Aug</option>
- <%}else{%>
- <option label="08">Aug</option>
- <%}if (month.equals("09")){%>
- <option label="09" selected="selected">Sep</option>
- <%}else{%>
- <option label="09">Sep</option>
- <%}if (month.equals("10")){%>
- <option label="10" selected="selected">Oct</option>
- <%}else{%>
- <option label="10">Oct</option>
- <%}if (month.equals("11")){%>
- <option label="11" selected="selected">Nov</option>
- <%}else{%>
- <option label="11">Nov</option>
- <%}if (month.equals("12")){%>
- <option label="12" selected="selected">Dec</option>
- <%}else{%>
- <option label="12" >Dec</option>
- <%}%>
- </select>
- </td>
- <td><input type="text" name="year" size="2" value=<%= year %>></td>
- </tr>
- </table>
- </td>
- </tr>
- <tr>
- <td>Email: </td>
- <td>
- <%
- String email = RS.getString("Email");
- if(email != null)
- {
- %>
- <input type="text" name="Email" value=<%= email %>>
- <%
- }
- else
- {
- %>
- <input type="text" name="Email" value="<Not Specified>">
- <%
- }
- %>
- </td>
- </tr>
- <tr>
- <td>Hobbies </td>
- <td>
- <%
- String hobbies = RS.getString("Hobbies");
- if(hobbies != null)
- {
- %>
- <textarea name="Hobbies" rows="3" cols="30"><%= hobbies %></textarea>
- <% }
- else
- {
- %>
- <textarea name="Hobbies" rows="3" cols="30">Not Specified</textarea></td>
- <%
- }
- %>
- </td>
- </tr>
- <tr>
- <td><input type="Submit" value="Modify" name="Modify Record"></td>
- </form>
- <form method="Post" action="ProcessDelete.jsp">
- <input type="hidden" name="PersonID" value=<%=ID%>>
- <td><input type="Submit" value="Delete" name="Delete Record"></td>
- </form>
- </tr>
- </table>
- <%
- }
- RS.close();
- connection.close();
- %>
- <p><a href="viewSummaryMember.jsp">View All Records</a></p>
- </body>
- </html>
- <!-- ProcessUpdate.jsp -->
- <%@ page import="java.sql.*,java.sql.ResultSet, java.text.*" %>
- <html>
- <head>
- <title>Personal Management System</title>
- </head>
- <body>
- <font size="5"><b>Updating Record</b></font>
- <P>
- <%
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection connection = DriverManager.getConnection("jdbc:odbc:Address");
- String query = "UPDATE PersonalInformation SET FirstName=?, LastName=?, Nickname=?, BirthDate=?, Email=?, Hobbies=? WHERE PersonID=?";
- PreparedStatement statement = connection.prepareStatement(query);
- statement.setString(1,request.getParameter("FirstName"));
- statement.setString(2,request.getParameter("LastName"));
- statement.setString(3,request.getParameter("Nickname"));
- statement.setString(4,request.getParameter("BirthDate"));
- statement.setString(5,request.getParameter("Email"));
- statement.setString(6,request.getParameter("Hobbies"));
- statement.setInt(7,Integer.parseInt(request.getParameter("PersonID")));
- statement.executeUpdate();
- connection.close();
- %>
- The Record has been updated.
- <p><a href="viewSummaryMember.jsp">View All Records</a></p>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement