Category

Development Platform
Home > SourceCode/Document > Java Develop > Jsp/Servlet > View Code
change.jsp
Package: JSP02.rar　[view]
Upload User: top0756
Upload Date: 2022-08-11
Package Size: 6501k
Code Size: 2k
Category:

Jsp/Servlet

Development Platform:

VBScript

change.jsp：Code Content
  1. <%@ page contentType="text/html; charset=GBK" %>
  2. <%@ page import="java.sql.*" %>
  3. <%@ page language="java" %>
  4. <%@ page import="java.util.*" %>
  5. <%@ page import="proj112.*" %>
  6. <jsp:useBean id="a" scope="page" class="proj112.dbconn"/>
  7. <html>
  8. <body>
  11.   <% request.setCharacterEncoding("GBK"); %>
  12. <head>
  13. <title>
  14. 修改学生信息
  15. </title>
  16. </head>
  18. <FORM Action="edit.jsp" Method="post" name="edit">
  20. <table align="center" border="2" width="100%" bordercolorlight="#CC99FF" cellpadding="2" bordercolordark="#FFFFFF" cellspacing="2">
  21.   <%
  22.   String id2=request.getParameter("id");
  24.   //out.print(id);
  25.   String sql="select * from student where stu_id='"+id2+"'";
  26.   ResultSet rs = a.executeQuery(sql);
  27.   while(rs.next()) { %>
  28.   <tr> <td align=center colspan=2><font color=blue size=5><b>修改学生信息</font></td>
  30.     <tr align=center><td>姓名：</td><td><INPUT TYPE="text" NAME="stu_name" value=<%=rs.getString(1)%>></td>
  31.   </tr>
  32.   </tr>
  33.   <tr align=center>
  34.   <td>学号：</td><td><INPUT TYPE="text" NAME="stu_id" value=<%=rs.getString(2)%>></td>
  35.  </tr>
  36. <tr align=center><td>
  37.   性别：</td><td><INPUT TYPE="text" NAME="sex" value=<%=rs.getString(4)%>></td>
  38.   </tr>
  39.   <tr align=center><td>
  40.   专业：</td><td><INPUT TYPE="text" NAME="dept" value=<%=rs.getString(5)%>></td>
  41.   </tr>
  42.   <tr align=center><td>
  43.   民族：</td><td><INPUT TYPE="text" NAME="mz" value=<%=rs.getString(6)%>></td>
  44.   </tr>
  45.   <tr align=center><td>
  46.   政治面貌：</td><td><INPUT TYPE="text" NAME="zzmm" value=<%=rs.getString(7)%>></td>
  47.   </tr>
  49.   <% } rs.close();%>
  52. <tr><td align=center  colspan=2>
  54. <INPUT align=center TYPE="submit" value="提交"> </td>
  55. </tr>
  56. </table>
  58. </form>
  60. <br>
  61. <br>
  62. <br>
  63. <br>
  64. <p align=center>
  65. <a href="std.jsp";>返回</a> </p>
  66. </body>
  67. </html>