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

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

Jsp/Servlet

开发平台：

VBScript

login1_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 login1_0002ejsp_jsp extends HttpJspBase {
  12.     static {
  13.     }
  14.     public login1_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="/login1.jsp";from=(0,48);to=(1,0)]
  54.                 out.write("rn");
  56.             // end
  57.             // HTML // begin [file="/login1.jsp";from=(1,31);to=(2,0)]
  58.                 out.write("rn");
  60.             // end
  61.             // HTML // begin [file="/login1.jsp";from=(2,27);to=(3,0)]
  62.                 out.write("rn");
  64.             // end
  65.             // HTML // begin [file="/login1.jsp";from=(3,41);to=(34,0)]
  66.                 out.write("rnrn<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>rnrnrn<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>rn<CENTER>rn");
  68.             // end
  69.             // begin [file="/login1.jsp";from=(34,2);to=(41,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.                 
  77.             // end
  78.             // HTML // begin [file="/login1.jsp";from=(41,2);to=(43,1)]
  79.                 out.write("rn<TABLE  height="350" width="80%" border="1" bordercolor="#CC9966">rnt");
  81.             // end
  82.             // begin [file="/login1.jsp";from=(43,3);to=(47,2)]
  83.                 
  84.                  //利用while循环将数据表中的记录列出
  85.                  while (rs.next())
  86.                  {
  87.                 
  88.             // end
  89.             // HTML // begin [file="/login1.jsp";from=(47,4);to=(51,100)]
  90.                 out.write("rnrn           <tr><td height="10"></td></tr>rn            <tr>rnt         <td>&nbsp;&nbsp;&nbsp;&nbsp;学号：</td><td><input type="text" name="stu_id" size="20" value="");
  92.             // end
  93.             // begin [file="/login1.jsp";from=(51,103);to=(51,118)]
  94.                 out.print(rs.getString(1));
  95.             // end
  96.             // HTML // begin [file="/login1.jsp";from=(51,120);to=(54,98)]
  97.                 out.write(""></td>rnt   </tr>rnt  <tr>rnt         <td>&nbsp;&nbsp;&nbsp;&nbsp;姓名：</td><td><input type="text" name="name" size="20" value="");
  99.             // end
  100.             // begin [file="/login1.jsp";from=(54,101);to=(54,116)]
  101.                 out.print(rs.getString(2));
  102.             // end
  103.             // HTML // begin [file="/login1.jsp";from=(54,118);to=(57,98)]
  104.                 out.write(""></td>rnt   </tr>rnt   <tr>rnt         <td>&nbsp;&nbsp;&nbsp;&nbsp;性别：</td><td><input type="text" name="sex"  size="10" value="");
  106.             // end
  107.             // begin [file="/login1.jsp";from=(57,101);to=(57,117)]
  108.                 out.print(rs.getString(3) );
  109.             // end
  110.             // HTML // begin [file="/login1.jsp";from=(57,119);to=(60,99)]
  111.                 out.write(""></td>rnt   </tr>rnt   <tr>rnt         <td>&nbsp;&nbsp;&nbsp;&nbsp;出生年月：</td><td><input type="text" name="age" size="10" value="");
  113.             // end
  114.             // begin [file="/login1.jsp";from=(60,102);to=(60,117)]
  115.                 out.print(rs.getString(4));
  116.             // end
  117.             // HTML // begin [file="/login1.jsp";from=(60,119);to=(63,100)]
  118.                 out.write(""></td>rnt   </tr>rnt   <tr>rnt         <td>&nbsp;&nbsp;&nbsp;&nbsp;所学专业：</td><td><input type="text" name="dept" size="20" value="");
  120.             // end
  121.             // begin [file="/login1.jsp";from=(63,103);to=(63,118)]
  122.                 out.print(rs.getString(5));
  123.             // end
  124.             // HTML // begin [file="/login1.jsp";from=(63,120);to=(66,103)]
  125.                 out.write(""></td>rnt   </tr>rnt   <tr>rnt         <td>&nbsp;&nbsp;&nbsp;&nbsp;入学时间：</td><td><input type="text" name="ruxdate" size="40" value="");
  127.             // end
  128.             // begin [file="/login1.jsp";from=(66,106);to=(66,122)]
  129.                 out.print(rs.getString(6) );
  130.             // end
  131.             // HTML // begin [file="/login1.jsp";from=(66,124);to=(69,99)]
  132.                 out.write(""></td>rnt   </tr>rn           <tr>rnt         <td>&nbsp;&nbsp;&nbsp;&nbsp;联系方式：</td><td><input type="text" name="tel" size="40" value="");
  134.             // end
  135.             // begin [file="/login1.jsp";from=(69,102);to=(69,118)]
  136.                 out.print(rs.getString(7) );
  137.             // end
  138.             // HTML // begin [file="/login1.jsp";from=(69,120);to=(72,101)]
  139.                 out.write(""></td>rnt   </tr>rnt   <tr>rnt         <td>&nbsp;&nbsp;&nbsp;&nbsp;住址：</td><td><input type="text" name="address" size="40" value="");
  141.             // end
  142.             // begin [file="/login1.jsp";from=(72,104);to=(72,120)]
  143.                 out.print(rs.getString(8) );
  144.             // end
  145.             // HTML // begin [file="/login1.jsp";from=(72,122);to=(79,2)]
  146.                 out.write(""></td>rnt   </tr>rnrn           <tr><td height="10"></td></tr>rnrn           <tr><td height="10"></td></tr>rnrntt");
  148.             // end
  149.             // begin [file="/login1.jsp";from=(79,4);to=(84,1)]
  150.                 
  151.                  }
  152.                  rs.close(); //关闭ResultSet对象
  153.                  stmt.close(); //关闭Statement对象
  154.                  con.close();  //关闭Connection对象
  155.                 
  156.             // end
  157.             // HTML // begin [file="/login1.jsp";from=(84,3);to=(90,0)]
  158.                 out.write("rn</table>rnrn</CENTER>rn</BODY>rn</HTML>rn");
  160.             // end
  162.         } catch (Throwable t) {
  163.             if (out != null && out.getBufferSize() != 0)
  164.                 out.clearBuffer();
  165.             if (pageContext != null) pageContext.handlePageException(t);
  166.         } finally {
  167.             if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
  168.         }
  169.     }
  170. }