Jsp/Servlet

开发平台：

VBScript

update_stumessage.jsp~6~：源码内容

							<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import = "java.sql.*"%>
<%@ page language = "java"%>
<%@ page import = "proj112.ISOtoGb2312"%>
<HTML>
<HEAD>
<TITLE>update</TITLE>
</HEAD>
<body text="#808080" link="#FF99CC" vlink="#FF8080" alink="#FF99CC" topmargin="0" leftmargin="0"><style>
<!--
BODY {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; }
-->
</style>
<%
String stu_id=ISOtoGb2312.convert(request.getParameter("stu_id"));
String name=ISOtoGb2312.convert(request.getParameter("name"));
String sex=ISOtoGb2312.convert(request.getParameter("sex"));
String age=ISOtoGb2312.convert(request.getParameter("age"));
String dept=ISOtoGb2312.convert(request.getParameter("dept"));
String ruxdate=ISOtoGb2312.convert(request.getParameter("ruxdate"));
String tel=ISOtoGb2312.convert(request.getParameter("tel"));
String address=ISOtoGb2312.convert(request.getParameter("address"));
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //载入驱动程序类别
Connection con = DriverManager.getConnection("jdbc:odbc:dsn112"); //建立数据库链接
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
						ResultSet.CONCUR_READ_ONLY);
String strsql;
strsql="update Info set name ='"+name+"',sex ='"+sex+"',age ='"+age+"',dept ='"+dept+"',ruxdate ='"+ruxdate+"',tel ='"+tel+"',address ='"+address+"' where stu_id ='"+stu_id+"'";
stmt.executeUpdate(strsql);
%>
<br><br><br><br>
 <table  width="100%" cellspacing="0" cellpadding="4" rules="all" bordercolor="#CC9966" border="1" id="dg_rxkb" style="background-color:White;border-color:#CC9966;border-width:1px;border-style:None;width:99%;border-collapse:collapse;">
  <tr>
    <td bgcolor="#EcEcff" align="center"><h3>你修改了的信息如下：</td>
  </tr>
  <tr>
    <td height="30">&nbsp;&nbsp;&nbsp;&nbsp;学 号：<%=stu_id%></td>
  </tr>
 <tr>
    <td height="30">&nbsp;&nbsp;&nbsp;&nbsp;用户名：<%=name%></td>
  </tr>
  <tr>
    <td>&nbsp;&nbsp;&nbsp;&nbsp;性别：<%=sex%></td>
  </tr>
  <tr>
    <td>&nbsp;&nbsp;&nbsp;&nbsp;年龄：<%=age%></td>
  </tr>
  <tr>
    <td>&nbsp;&nbsp;&nbsp;&nbsp;专业：<%=dept%></td>
  </tr>
  <tr>
    <td>&nbsp;&nbsp;&nbsp;&nbsp;入学时间:<%=ruxdate%></td>
  </tr>
  <tr>
    <td>&nbsp;&nbsp;&nbsp;&nbsp;联系方式：<%=address%></td>
  </tr>
  <tr>
    <td  align="center">&nbsp;&nbsp;&nbsp;&nbsp;<a href="change.jsp">返回</a></td>
  </tr>
</table>
<TABLE border="0" width="90%" align="center">
       <tr>
         <td height="10"></td>
       </tr>
       <tr>
         <td align="center"></td>
       </tr>
       <tr>
         <td height="10"></td>
       </tr>
</table>
</BODY>
</HTML>

						