Jsp/Servlet

Development Platform:

VBScript

stu1.jsp~4~：Code Content

							<%@ page contentType="text/html; charset=GBK" %>
<%@ page	import="java.sql.*" %>
<%@ page language="java" %>
<%@ page import = "proj112.ISOtoGb2312"%>
<HTML>
<HEAD>
<TITLE>update_form</TITLE>
</HEAD>
<BODY >
<CENTER>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //载入驱动程序类别
Connection con = DriverManager.getConnection("jdbc:odbc:dsn112"); //建立数据库链接
Statement stmt = con.createStatement(); //建立Statement对象
ResultSet rs; //建立ResultSet(结果集)对象
rs = stmt.executeQuery("SELECT * FROM Info WHERE stu_name='"+ISOtoGb2312.convert( request.getParameter("stu_name")) +"'"); //执行SQL语句
%>
<TABLE  width="90%" bgcolor="#EcEcff">
	<%
	//利用while循环将数据表中的记录列出
	while (rs.next())
	{
		%>
	  <tr>
	         <td>&nbsp;&nbsp;&nbsp;&nbsp;姓名：</td><td><input type="text" name="stu_name" size="20" value="<%=rs.getString(2)%>"></td>
	   </tr>
	   <tr>
	         <td>&nbsp;&nbsp;&nbsp;&nbsp;性别：</td><td><input type="text" name="sex"  size="10" value="<%=rs.getString(3) %>"></td>
	   </tr>
	   <tr>
	         <td>&nbsp;&nbsp;&nbsp;&nbsp;班级：</td><td><input type="text" name="stu_class" size="10" value="<%=rs.getString(4)%>"></td>
	   </tr>
	   <tr>
	         <td>&nbsp;&nbsp;&nbsp;&nbsp;密码：</td><td><input type="text" name="stu_password" size="20" value="<%=rs.getString(5)%>"></td>
	   </tr>
		<%
	}
	rs.close(); //关闭ResultSet对象
	stmt.close(); //关闭Statement对象
	con.close();  //关闭Connection对象
	%>
</table>
<TABLE border="0" width="90%" align="center">
       <tr>
         <td height="20"></td>
       </tr>
       <tr>
         <td align="center"><hr /></td>
       </tr>
       <tr>
         <td height="20"></td>
       </tr>
       <tr>
         <td align="center"><font  color="green">创作人：童来萍</font></td>
       </tr>
    </table>
</CENTER>
</BODY>
</HTML>

						