Jsp/Servlet

Development Platform:

VBScript

update.jsp~26~：Code Content

							<%@ 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 name=ISOtoGb2312.convert(request.getParameter("name"));
String ad_password=ISOtoGb2312.convert(request.getParameter("ad_password"));
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 admin set ad_password ='"+ad_password+"' where name ='"+name+"'";
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 align="center"><h3>你修改了的密码如下：</td>
  </tr>
 <tr>
    <td height="30">&nbsp;&nbsp;&nbsp;&nbsp;用户名：<%=name%></td>
  </tr>
  <tr>
    <td height="30">&nbsp;&nbsp;&nbsp;&nbsp;密  码：<%=ad_password%></td>
  </tr>
  <tr>
    <td  align="center">&nbsp;&nbsp;&nbsp;&nbsp;<a href="update_ad_pwd.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>

						