开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Java编程 > Jsp/Servlet > 查看源码
update_0005fstu_0002ejsp_jsp.java
资源名称：JSP02.rar　[点击查看]
上传用户：top0756
上传日期：2022-08-11
资源大小：6501k
文件大小：9k
源码类别：

Jsp/Servlet

开发平台：

VBScript

update_0005fstu_0002ejsp_jsp.java：源码内容
  1. import java.sql.*;
  2. import proj112.ISOtoGb2312;
  3. import javax.servlet.*;
  4. import javax.servlet.http.*;
  5. import javax.servlet.jsp.*;
  6. import org.apache.jasper.runtime.*;
  9. public class update_0005fstu_0002ejsp_jsp extends HttpJspBase {
  12.     static {
  13.     }
  14.     public update_0005fstu_0002ejsp_jsp( ) {
  15.     }
  17.     private static boolean _jspx_inited = false;
  19.     public final void _jspx_init() throws org.apache.jasper.runtime.JspException {
  20.     }
  22.     public void _jspService(HttpServletRequest request, HttpServletResponse  response)
  23.         throws java.io.IOException, ServletException {
  25.         JspFactory _jspxFactory = null;
  26.         PageContext pageContext = null;
  27.         HttpSession session = null;
  28.         ServletContext application = null;
  29.         ServletConfig config = null;
  30.         JspWriter out = null;
  31.         Object page = this;
  32.         String  _value = null;
  33.         try {
  35.             if (_jspx_inited == false) {
  36.                 synchronized (this) {
  37.                     if (_jspx_inited == false) {
  38.                         _jspx_init();
  39.                         _jspx_inited = true;
  40.                     }
  41.                 }
  42.             }
  43.             _jspxFactory = JspFactory.getDefaultFactory();
  44.             response.setContentType("text/html; charset=GBK");
  45.             pageContext = _jspxFactory.getPageContext(this, request, response,
  46.              "", true, 8192, true);
  48.             application = pageContext.getServletContext();
  49.             config = pageContext.getServletConfig();
  50.             session = pageContext.getSession();
  51.             out = pageContext.getOut();
  53.             // HTML // begin [file="/update_stu.jsp";from=(0,48);to=(1,0)]
  54.                 out.write("rn");
  56.             // end
  57.             // HTML // begin [file="/update_stu.jsp";from=(1,31);to=(2,0)]
  58.                 out.write("rn");
  60.             // end
  61.             // HTML // begin [file="/update_stu.jsp";from=(2,27);to=(3,0)]
  62.                 out.write("rn");
  64.             // end
  65.             // HTML // begin [file="/update_stu.jsp";from=(3,41);to=(33,0)]
  66.                 out.write("rn<HTML>rn<HEAD>rn<TITLE>update_form</TITLE>rn</HEAD>rn<body text="#808080" link="#FF99CC" vlink="#FF8080" alink="#FF99CC" topmargin="0" leftmargin="0"><style>rn<!--rnBODY {SCROLLBAR-FACE-COLOR: #FFFFFF; SCROLLBAR-HIGHLIGHT-COLOR: #FFFFFF; SCROLLBAR-SHADOW-COLOR: #FFFFFF; SCROLLBAR-3DLIGHT-COLOR: #FFFFFF; SCROLLBAR-ARROW-COLOR:  #FFAAAA; SCROLLBAR-TRACK-COLOR: #FFFFFF; SCROLLBAR-DARKSHADOW-COLOR: #FFFFFF; }rn-->rn</style>rn<table width="90%" align="center">rn   <tr>rn    <td height="10"></td>rn  </tr>rn  <tr>rn    <td align="center"><font color="green" size="5">请修改你的信息</font></td>rn  </tr>rn   <tr>rn    <td height="10"></td>rn  </tr>rn  <tr>rn    <td align="center"></td>rn  </tr>rn   <tr>rn    <td height="10"></td>rn  </tr>rn</table>rnrnrn<CENTER>rn");
  68.             // end
  69.             // begin [file="/update_stu.jsp";from=(33,2);to=(39,0)]
  70.                 
  71.                 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //载入驱动程序类别
  72.                 Connection con = DriverManager.getConnection("jdbc:odbc:dsn112"); //建立数据库链接
  73.                 Statement stmt = con.createStatement(); //建立Statement对象
  74.                 ResultSet rs; //建立ResultSet(结果集)对象
  75.                 rs = stmt.executeQuery("SELECT * FROM Info WHERE stu_id='"+ISOtoGb2312.convert( request.getParameter("stu_id")) +"' and stu_password='"+ISOtoGb2312.convert( request.getParameter("stu_password")) +"'"); //执行SQL语句
  76.             // end
  77.             // HTML // begin [file="/update_stu.jsp";from=(39,2);to=(41,1)]
  78.                 out.write("rn<TABLE   width="80%" border="1" bordercolor="#CC9966">rnt");
  80.             // end
  81.             // begin [file="/update_stu.jsp";from=(41,3);to=(45,2)]
  82.                 
  83.                  //利用while循环将数据表中的记录列出
  84.                  while (rs.next())
  85.                  {
  86.                 
  87.             // end
  88.             // HTML // begin [file="/update_stu.jsp";from=(45,4);to=(50,114)]
  89.                 out.write("rn                <form method="post" action="update_stumessage.jsp" name="form1">rnrnrnt  <tr>rnt         <td height="20">&nbsp;&nbsp;&nbsp;&nbsp;学  号：</td><td><input type="text" name="stu_id" size="20" value="");
  91.             // end
  92.             // begin [file="/update_stu.jsp";from=(50,117);to=(50,132)]
  93.                 out.print(rs.getString(1));
  94.             // end
  95.             // HTML // begin [file="/update_stu.jsp";from=(50,134);to=(53,112)]
  96.                 out.write(""></td>rnt   </tr>rn          <tr>rnt         <td height="20">&nbsp;&nbsp;&nbsp;&nbsp;姓  名：</td><td><input type="text" name="name" size="20" value="");
  98.             // end
  99.             // begin [file="/update_stu.jsp";from=(53,115);to=(53,130)]
  100.                 out.print(rs.getString(2));
  101.             // end
  102.             // HTML // begin [file="/update_stu.jsp";from=(53,132);to=(56,111)]
  103.                 out.write(""></td>rnt   </tr>rn           <tr>rnt         <td height="20">&nbsp;&nbsp;&nbsp;&nbsp;性  别：</td><td><input type="text" name="sex" size="20" value="");
  105.             // end
  106.             // begin [file="/update_stu.jsp";from=(56,114);to=(56,129)]
  107.                 out.print(rs.getString(3));
  108.             // end
  109.             // HTML // begin [file="/update_stu.jsp";from=(56,131);to=(59,111)]
  110.                 out.write(""></td>rnt   </tr>rn           <tr>rnt         <td height="20">&nbsp;&nbsp;&nbsp;&nbsp;年  龄：</td><td><input type="text" name="age" size="20" value="");
  112.             // end
  113.             // begin [file="/update_stu.jsp";from=(59,114);to=(59,129)]
  114.                 out.print(rs.getString(4));
  115.             // end
  116.             // HTML // begin [file="/update_stu.jsp";from=(59,131);to=(62,112)]
  117.                 out.write(""></td>rnt   </tr>rn           <tr>rnt         <td height="20">&nbsp;&nbsp;&nbsp;&nbsp;专  业：</td><td><input type="text" name="dept" size="20" value="");
  119.             // end
  120.             // begin [file="/update_stu.jsp";from=(62,115);to=(62,130)]
  121.                 out.print(rs.getString(5));
  122.             // end
  123.             // HTML // begin [file="/update_stu.jsp";from=(62,132);to=(65,115)]
  124.                 out.write(""></td>rnt   </tr>rn           <tr>rnt         <td height="20">&nbsp;&nbsp;&nbsp;&nbsp;入学时间：</td><td><input type="text" name="ruxdate" size="20" value="");
  126.             // end
  127.             // begin [file="/update_stu.jsp";from=(65,118);to=(65,133)]
  128.                 out.print(rs.getString(6));
  129.             // end
  130.             // HTML // begin [file="/update_stu.jsp";from=(65,135);to=(68,111)]
  131.                 out.write(""></td>rnt   </tr>rn      t   <tr>rnt         <td height="20">&nbsp;&nbsp;&nbsp;&nbsp;联系方式：</td><td><input type="text" name="tel" size="40" value="");
  133.             // end
  134.             // begin [file="/update_stu.jsp";from=(68,114);to=(68,130)]
  135.                 out.print(rs.getString(7) );
  136.             // end
  137.             // HTML // begin [file="/update_stu.jsp";from=(68,132);to=(71,115)]
  138.                 out.write(""></td>rnt   </tr>rn           <tr>rnt         <td height="20">&nbsp;&nbsp;&nbsp;&nbsp;住  址：</td><td><input type="text" name="address" size="20" value="");
  140.             // end
  141.             // begin [file="/update_stu.jsp";from=(71,118);to=(71,133)]
  142.                 out.print(rs.getString(8));
  143.             // end
  144.             // HTML // begin [file="/update_stu.jsp";from=(71,135);to=(80,2)]
  145.                 out.write(""></td>rnt   </tr>rnrnt   <tr>rnt         <td></td><td><input type="submit" value="确定" onclick="return a()">&nbsp;&nbsp;&nbsp;&nbsp;rntt             </td>rnt   </tr>rn           <tr><td height="10"></td></tr>rn</form>rntt");
  147.             // end
  148.             // begin [file="/update_stu.jsp";from=(80,4);to=(85,1)]
  149.                 
  150.                  }
  151.                  rs.close(); //关闭ResultSet对象
  152.                  stmt.close(); //关闭Statement对象
  153.                  con.close();  //关闭Connection对象
  154.                 
  155.             // end
  156.             // HTML // begin [file="/update_stu.jsp";from=(85,3);to=(91,0)]
  157.                 out.write("rn</table>rnrn</CENTER>rn</BODY>rn</HTML>rn");
  159.             // end
  161.         } catch (Throwable t) {
  162.             if (out != null && out.getBufferSize() != 0)
  163.                 out.clearBuffer();
  164.             if (pageContext != null) pageContext.handlePageException(t);
  165.         } finally {
  166.             if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
  167.         }
  168.     }
  169. }