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

源码开发语言/平台
当前位置：首页 > 源码/资料 > 数据库系统 > 其他数据库 > 查看源码
adminstudent3.jsp
资源名称：08155209833.rar　[点击查看]
上传用户：mkymky1985
上传日期：2014-06-23
资源大小：754k
文件大小：11k
源码类别：

其他数据库

开发平台：

Java

adminstudent3.jsp：源码内容
  1. <%@ page language = "java" contentType = "text/html;charset=gb2312"%>
  2. <%@ page import = "java.sql.*, java.io.*" %>
  3. <jsp:useBean id="subject" scope="page" class="wsxk.ConDB"/>
  4. <%! String trans(String chi)
  5. {
  6.                String result = null;
  7.                byte temp [];
  8.                try
  9.                 {
  10.                       temp=chi.getBytes("iso-8859-1");
  11.                       result = new String(temp, "gb2312");
  12.                 }
  13.                 catch(UnsupportedEncodingException e)
  14.                 {
  15.                         System.out.println (e.toString());
  16.                 }
  17.                 return result;
  18. }
  19. %>
  22. <%
  23. //String strSQL = "select id ,title from news order by id desc";
  24. //ResultSet rs = sts.executeQuery(strSQL);
  26. String temstuname = new String();
  27. temstuname = request.getParameter("select");
  28. temstuname = temstuname.trim();
  29. temstuname = trans(temstuname);
  30. String temstuid = new String();
  31. String temstuno = new String();
  32. String temstupsw = new String();
  33. String temstugrade = new String();
  34. String strSQL = "select stuid ,stuno,stupsw,stugrade from student where stuname = '"+temstuname+"'";
  35. ResultSet rs = subject.executeQuery(strSQL);
  36. while(rs.next())
  37. {
  38. temstuid = rs.getString("stuid");
  39.             temstuno = rs.getString("stuno");
  40. temstupsw=  rs.getString("stupsw");
  41. temstugrade = rs.getString("stugrade");
  42. }
  44. rs.close();
  46. //String strSQL2 = "delete from news where id =" + k;
  47.      //sts.executeUpdate(strSQL2);
  52. %>
  54. <html>
  55. <head>
  56. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  57. <link href="_notes/aaa.css" rel="stylesheet" type="text/css">
  58. <style type="text/css">
  59. <!--
  60. @import url("_notes/ccc");
  61. body,td,th {
  62. color: #FFFFFF;
  63. font-weight: bold;
  64. font-size: 12px;
  65. }
  66. a:link {
  67. color: #FFFFFF;
  68. }
  69. a:visited {
  70. color: #FFFFFF;
  71. }
  72. -->
  73. </style>
  75. </HEAD>
  76. <BODY BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" >
  78. <br>
  79. <br>
  80. <TABLE WIDTH=750 height="494" BORDER=0 align="center" CELLPADDING=0 CELLSPACING=0>
  81.   <TR>
  82.     <TD> <IMG SRC="images/spacer.gif" WIDTH=231 HEIGHT=1></TD>
  83.     <TD> <IMG SRC="images/spacer.gif" WIDTH=4 HEIGHT=1></TD>
  84.     <TD> <IMG SRC="images/spacer.gif" WIDTH=75 HEIGHT=1></TD>
  85.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  86.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  87.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  88.     <TD> <IMG SRC="images/spacer.gif" WIDTH=105 HEIGHT=1></TD>
  89.     <TD> <IMG SRC="images/spacer.gif" WIDTH=5 HEIGHT=1></TD>
  90.   </TR>
  91.   <TR>
  92.     <TD COLSPAN=4> <IMG SRC="images/temp_01.jpg" WIDTH=420 HEIGHT=15></TD>
  93.     <TD COLSPAN=4> <IMG SRC="images/temp_02.jpg" WIDTH=330 HEIGHT=15></TD>
  94.   </TR>
  95.   <TR>
  96.     <TD COLSPAN=8> <IMG SRC="images/temp_03.jpg" WIDTH=750 HEIGHT=5></TD>
  97.   </TR>
  98.   <TR>
  99.     <TD>
  100.       <table width="231" border="0" cellspacing="0" cellpadding="0" height="226" background="images/left_top.jpg">
  101.         <tr>
  102.           <td width="231" valign="bottom">
  103.             <div align="center">
  104.               <p><br>
  105.               </p>
  106.               <p>【学生管理】</p>
  107.               <p align="center"> 再这里您可以注册<br>
  108.               或删除学生的信息 <br>
  109.               <br>
  110.               <br>
  111.               </p>
  112.               <table width="200" border="1">
  113.                 <tr>
  114.                   <td><div align="center"><a href="adminteacher.jsp">【教师<strong>管理</strong>】</a></div></td>
  115.                 </tr>
  116.                 <tr>
  117.                   <td><div align="center"><a href="admincourse.jsp">【课程<strong>管理</strong>】</a></div></td>
  118.                 </tr>
  119.               </table>
  120.               <p>  <strong><font color="#2DFFFF" size="5"> </font></strong></p>
  121.           </div>          </td>
  122.         </tr>
  123.       </table>
  124.     </TD>
  125.     <TD ROWSPAN=2> <IMG SRC="images/temp_05.jpg" WIDTH=4 HEIGHT=455></TD>
  126.     <TD COLSPAN=5 ROWSPAN=2>
  127.       <table width="510" border="0" cellspacing="0" cellpadding="0" height="455" background="images/main_bg.jpg">
  128.         <tr>
  129.           <td width="510">
  130.             <table width="510" border="0" cellspacing="0" cellpadding="0" height="455">
  131.               <tr>
  132.                 <td width="510" height="78">
  133.                   <div align="center"><img src="images/blank_banner.gif" width="468" height="60"></div>
  134.                 </td>
  135.               </tr>
  136.               <tr>
  137.                 <td valign="top">                  <div align="left"><a href="index1.htm">首页</a>&gt;<a href="index3.jsp">后台管理</a>&gt;<a href="adminstudent.jsp">学生管理</a>&gt;删改学生信息<br>
  138.                   <br>
  139.                   <br>
  140.                   <br>
  141.                   <table width="500" border="1" bordercolor="#006666">
  142.                     <tr>
  143.                       <td><div align="center">修改学生信息</div>                        <div align="center"></div></td>
  144.                       </tr>
  145.                     <tr>
  146.                       <td height="248"><div align="center">
  147.                         <form name="form1" method="post" action="adminstudent4.jsp">
  148.                           <table width="274" border="0" bordercolor="#006666">
  149.                             <tr bordercolor="#006666">
  150.                               <td width="65" height="28" background="images/bg.gif" class="bbb">
  151.                                 <div align="right">学生编号</div></td>
  152.                               <td colspan="2" background="images/bg.gif">
  153.                                 <div align="left">
  154.                                   <% out.print("<input name="stuid" type="hidden" id="stuid" value = ""+temstuid+"">" ); %>
  155.    <% out.print(temstuid);%>
  156.                               </div></td>
  157.                             </tr>
  158.                             <tr bordercolor="#006666">
  159.                               <td height="28" background="images/bg.gif" class="bbb">
  160.                                 <div align="right">学生姓名</div></td>
  161.                               <td colspan="2" background="images/bg.gif">
  162.                                 <!--<input name="stuname" type="text" id="stuname2">-->
  163. <% out.print("<input name="stuname" type="text" id="stuname2" value = ""+temstuname+"">" ); %>
  164.                               </td>
  165.                             </tr>
  166.                             <tr bordercolor="#006666">
  167.                               <td height="28" background="images/bg.gif" class="bbb">
  168.                                 <div align="right">学号</div></td>
  169.                               <td colspan="2" background="images/bg.gif">
  170.                                 <table width="195" height="28" border="0" cellpadding="0" cellspacing="0">
  171.                                   <tr>
  172.                                     <td width="69">
  173.                                       <div align="left">
  174.                                        <!-- <input name="stuno" type="text" id="stuno" size="8">-->
  175. <% out.print("<input name="stuno" type="text" size="8" id="stuno" value = ""+temstuno+"">" ); %>
  177.                                       </div>
  178.                                       <div align="right"> </div></td>
  179.                                     <td width="30" class="bbb"><div align="right">年级</div></td>
  180.                                     <td width="96" class="bbb"><select name="stugrade" id="stugrade">
  181.                                         <% String tem[] = new String[4];
  182. tem[0]= new String("大一");
  183. tem[1]= new String("大二");
  184. tem[2]= new String("大三");
  185. tem[3]= new String("大四");
  186.  for (int i = 0; i < 4; i++){
  187. if(i== Integer.parseInt(temstugrade)-1)
  188.                                                                          {out.print("<option selected>" + tem[i].trim() + "</option>");
  189. System.out.println("qqqqqqqqqqqqqqqq");}
  190. else
  191.    out.print("<option>" + tem[i].trim() + "</option>");
  192.   }
  194.                                         %>
  197.                                       </select></td>
  198.                                   </tr>
  199.                               </table></td>
  200.                             </tr>
  201.                             <tr bordercolor="#006666">
  202.                               <td height="28" background="images/bg.gif" class="bbb">
  203.                                 <div align="right">初始密码</div></td>
  204.                               <td colspan="2" bordercolor="#006666" background="images/bg.gif">
  205.                                <!-- <input name="stupsw" type="text" id="stupsw" value="123">-->
  206. <% out.print("<input name="stupsw" type="text" id="stupsw" value = ""+temstupsw+"">" ); %>
  207.                               </td>
  208.                             </tr>
  209.                             <tr>
  210.                               <td>&nbsp;</td>
  211.                               <td width="83">
  212.                                   <div align="center">
  213.                                     <input name="tijiao" type="submit" id="tijiao" value="修改">
  214. </div></td>
  215.                               <td width="112" valign="baseline" bordercolor="#006666">                              <div align="left"><%out.print("<a href='adminstudent5.jsp?delpage=" +temstuid + "'>删除信息</a>");%></div></td>
  216.                             
  217. </tr>
  218.                           </table>
  219.                         </form>
  220.                         </div></td>
  221.                       </tr>
  222.                   </table>
  223.                   <br>
  224.                 </div></td>
  225.               </tr>
  226.             </table>
  227.           </td>
  228.         </tr>
  229.       </table>
  230.     </TD>
  231.     <TD ROWSPAN=2> <IMG SRC="images/temp_07.jpg" WIDTH=5 HEIGHT=455></TD>
  232.   </TR>
  233.   <TR>
  234.     <TD>
  235.       <table width="231" border="0" cellspacing="0" cellpadding="0" height="229" background="images/left_bottom.jpg">
  236.         <tr>
  237.           <td width="231" height="222" valign="top"><div align="center">
  238.             <p><font color="#2DFFFF" size="5"> </font></p>
  239.               <table width="200" border="1">
  240.                 <tr>
  241.                   <td><div align="center"><a href="admincourse.jsp">【课程分配】</a></div></td>
  242.                 </tr>
  243.                 <tr>
  244.                   <td><div align="center"><a href="adminscore.jsp">【成绩录入】</a></div></td>
  245.                 </tr>
  246.                
  247.               </table>
  248.               <br>
  249.               <br>
  250.               <table width="200" border="0">
  251.                 <tr>
  252.                   <td><div align="center"><a href="adminlyb.jsp">查看留言</a></div></td>
  253.                 </tr>
  254.               </table>
  255.               <p align="center"><br>
  256.               <a href="index1.htm" class="ccc">[退出系统]</a></p>
  257.               </div>
  258.           </td>
  259.         </tr>
  260.       </table>
  261.     </TD>
  262.   </TR>
  263.   <TR>
  264.     <TD COLSPAN=8> <IMG SRC="images/temp_09.jpg" WIDTH=750 HEIGHT=5></TD>
  265.   </TR>
  266.   <TR>
  267.     <TD COLSPAN=8> <img src="images/temp_10.jpg" width=752 height=20></TD>
  268.   </TR>
  269. </TABLE>
  270. </BODY>
  271. </HTML>