📄 tinsert2.jsp

📁 一个很详细的考试管理系统。有源文件。还有毕业论文。大家可以仔细参考。
💻 JSP
字号:
<html>
<head> 
<title>注册结果</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<BODY BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif">
<%@page language="java" import="java.sql.*"%>
<%@page contentType="text/html; charset=gb2312"%>
<jsp:useBean id="regBean" scope="page" class="exam.exam"/>
<%
int num=0;
String wpsed;
String wnum= new String(request.getParameter("wnum").getBytes("8859_1"));
String tname=new String(request.getParameter("tname").getBytes("8859_1"));
String tsex=request.getParameter("tsex");
String tdep=request.getParameter("give");
String stpri=request.getParameter("tpri");
int    tpri=Integer.parseInt(stpri);
String sql1="select * from administrators where wnum='"+wnum+"'";
ResultSet rs1=regBean.executeQuery(sql1);
System.out.println(sql1);/*   1  */
if(rs1.next())
{
	 rs1.close();
	%>
<!--	/************************************************/ -->
		<br>
<br>
<TABLE WIDTH=750 BORDER=0 CELLPADDING=0 CELLSPACING=0 align="center">
  <TR>
      <TD>
			<IMG SRC="images/spacer.gif" WIDTH=231 HEIGHT=1></TD>
		<TD>
			<IMG SRC="images/spacer.gif" WIDTH=4 HEIGHT=1></TD>
		<TD>
			<IMG SRC="images/spacer.gif" WIDTH=75 HEIGHT=1></TD>
		<TD>
			<IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
		<TD>
			<IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
		<TD>
			<IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
		<TD>
			<IMG SRC="images/spacer.gif" WIDTH=105 HEIGHT=1></TD>
		<TD>
			<IMG SRC="images/spacer.gif" WIDTH=5 HEIGHT=1></TD>
	</TR>
	<TR>
		<TD COLSPAN=4>
			<IMG SRC="images/temp_01.jpg" WIDTH=420 HEIGHT=15></TD>
		<TD COLSPAN=4>
			<IMG SRC="images/temp_02.jpg" WIDTH=330 HEIGHT=15></TD>
	</TR>
	<TR>
		<TD COLSPAN=8>
			<IMG SRC="images/temp_03.jpg" WIDTH=750 HEIGHT=5></TD>
	</TR>
	<TR>
		
    <TD> 
      <table width="231" border="0" cellspacing="0" cellpadding="0" height="226" background="images/left_top.jpg">
        <tr>
          <td width="231">
            <div align="center">
              <p>&nbsp;</p>
              <p>&nbsp;</p>
              <p>&nbsp;</p>
              <p><font color="#2DFFFF" size="5"><strong>
                <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="133" height="35">
                  <param name="movie" value="back2.swf">
                  <param name="quality" value="high"><param name="BGCOLOR" value="#99CCCC">
                  <embed src="back2.swf" width="133" height="35" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" bgcolor="#99CCCC"></embed></object>
                </strong></font></p>
              <p><a href="tadd.jsp">添加资源</a></p>
              </div>
          </td>
        </tr>
      </table>
    </TD>
		<TD ROWSPAN=2>
			<IMG SRC="images/temp_05.jpg" WIDTH=4 HEIGHT=455></TD>
		
    <TD COLSPAN=5 ROWSPAN=2> 
      <table width="510" border="0" cellspacing="0" cellpadding="0" height="455" background="images/main_bg.jpg">
        <tr>
          <td width="510">
            <table width="510" border="0" cellspacing="0" cellpadding="0" height="455">
              <tr> 
                <td width="510" height="78"> 
                  <div align="center"><img src="images/blank_banner.gif" width="468" height="60"></div>
                </td>
              </tr>
              <tr> 
                <td>
                  <div align="center">
                    <table width="346" height="113" border="0" cellpadding="0" cellspacing="0">
                      <tr> 
                        <td align="center" class="bbb">管理员[<font color="#ff00ff"><%=tname%></font>],已经存在啦!  <b> <font color="#ffff00" size="4">出错了</font> </b>
						<br>
						<br>
						<font color="r" size="2"><a href ="insert1.jsp">返回</font></a>
						</td>
                      </tr>
                    </table>
                  </div>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </TD>
		<TD ROWSPAN=2>
			<IMG SRC="images/temp_07.jpg" WIDTH=5 HEIGHT=455></TD>
	</TR>
	<TR>
		
    <TD> 
      <table width="231" border="0" cellspacing="0" cellpadding="0" height="229" background="images/left_bottom.jpg">
        <tr> 
          <td width="231"><div align="center"> 
              <p> <a href="tinsert1.jsp">添加管理员</a></p>
              <p> <a href="tdelete1.jsp">删除管理员</a></p>
              <p>&nbsp; </p>
              <p class="bbb">&nbsp; </p>
            </div></td>
        </tr>
      </table>
    </TD>
	</TR>
	<TR>
		<TD COLSPAN=8>
			<IMG SRC="images/temp_09.jpg" WIDTH=750 HEIGHT=5></TD>
	</TR>
	<TR>
		<TD COLSPAN=8><IMG SRC="images/temp_10.jpg" WIDTH=750 HEIGHT=20></TD>
		
    
	</TR>
</TABLE>
<!--	/************************************************/ -->
<%}
else
{
	/**************测试权限**********/
			String strSQL4="insert into administrators(wnum,wpswd,tname,tsex,tdep,tpri)values ('"+wnum+"','"+wnum+"','"+tname+"','"+tsex+"','"+tdep+"','"+tpri+"')";
			System.out.println("5 "+strSQL4);  /*      5     */
			regBean.executeUpdate(strSQL4);
		/*****************测试权限*****************************/
		%><br>
<br>
<TABLE WIDTH=750 BORDER=0 CELLPADDING=0 CELLSPACING=0 align="center">
  <TR>
      <TD>
			<IMG SRC="images/spacer.gif" WIDTH=231 HEIGHT=1></TD>
		<TD>
			<IMG SRC="images/spacer.gif" WIDTH=4 HEIGHT=1></TD>
		<TD>
			<IMG SRC="images/spacer.gif" WIDTH=75 HEIGHT=1></TD>
		<TD>
			<IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
		<TD>
			<IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
		<TD>
			<IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
		<TD>
			<IMG SRC="images/spacer.gif" WIDTH=105 HEIGHT=1></TD>
		<TD>
			<IMG SRC="images/spacer.gif" WIDTH=5 HEIGHT=1></TD>
	</TR>
	<TR>
		<TD COLSPAN=4>
			<IMG SRC="images/temp_01.jpg" WIDTH=420 HEIGHT=15></TD>
		<TD COLSPAN=4>
			<IMG SRC="images/temp_02.jpg" WIDTH=330 HEIGHT=15></TD>
	</TR>
	<TR>
		<TD COLSPAN=8>
			<IMG SRC="images/temp_03.jpg" WIDTH=750 HEIGHT=5></TD>
	</TR>
	<TR>
		
    <TD> 
      <table width="231" border="0" cellspacing="0" cellpadding="0" height="226" background="images/left_top.jpg">
        <tr>
          <td width="231">
            <div align="center">
              <p>&nbsp;</p>
              <p>&nbsp;</p>
              <p>&nbsp;</p>
              <p><font color="#2DFFFF" size="5"><strong>
                <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="133" height="35">
                  <param name="movie" value="back2.swf">
                  <param name="quality" value="high"><param name="BGCOLOR" value="#99CCCC">
                  <embed src="back2.swf" width="133" height="35" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" bgcolor="#99CCCC"></embed></object>
                </strong></font></p>
              <p><a href="add.jsp">添加资源</a></p>
              </div>
          </td>
        </tr>
      </table>
    </TD>
		<TD ROWSPAN=2>
			<IMG SRC="images/temp_05.jpg" WIDTH=4 HEIGHT=455></TD>
		
    <TD COLSPAN=5 ROWSPAN=2> 
      <table width="510" border="0" cellspacing="0" cellpadding="0" height="455" background="images/main_bg.jpg">
        <tr>
          <td width="510">
            <table width="510" border="0" cellspacing="0" cellpadding="0" height="455">
              <tr> 
                <td width="510" height="78"> 
                  <div align="center"><img src="images/blank_banner.gif" width="468" height="60"></div>
                </td>
              </tr>
              <tr> 
                <td>
                  <div align="center">
                    <table width="346" height="113" border="0" cellpadding="0" cellspacing="0">
                      <tr> 
                        <td align="center" class="bbb">[<font color="#ff00ff"><%=tname%></font>]管理员  <b><font color="#ffff00">添加成功 </font></b> </td>
                      </tr>
                    </table>
                  </div>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </TD>
		<TD ROWSPAN=2>
			<IMG SRC="images/temp_07.jpg" WIDTH=5 HEIGHT=455></TD>
	</TR>
	<TR>
		
    <TD> 
      <table width="231" border="0" cellspacing="0" cellpadding="0" height="229" background="images/left_bottom.jpg">
        <tr> 
          <td width="231"><div align="center"> 
              <p> <a href="insert1.jsp">添加管理员</a></p>
              <p> 删除管理员</p>
              <p>&nbsp; </p>
              <p class="bbb">&nbsp; </p>
            </div></td>
        </tr>
      </table>
    </TD>
	</TR>
	<TR>
		<TD COLSPAN=8>
			<IMG SRC="images/temp_09.jpg" WIDTH=750 HEIGHT=5></TD>
	</TR>
	<TR>
		<TD COLSPAN=8><IMG SRC="images/temp_10.jpg" WIDTH=750 HEIGHT=20></TD>
		
    
	</TR>
</TABLE><%
	
}
%>

<!--/*********************************************/-->

<!--/*********************************************/-->

</body>
</html>
💿 文件大小 4841 K
👤 上传用户 chengshengwu123
📂 所属分类 Java编程
🏷️ 相关标签

#管理系统 #有源 #家 #毕业论文
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -