Category

Development Platform
Home > SourceCode/Document > Java Develop > Jsp/Servlet > View Code
QueryByStudentAccount.jsp
Package: JSP.rar　[view]
Upload User: tian320582
Upload Date: 2007-08-23
Package Size: 173k
Code Size: 19k
Category:

Jsp/Servlet

Development Platform:

Java

QueryByStudentAccount.jsp：Code Content
  1. <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
  2. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  3. <html>
  4. <head>
  5. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  6. <title>南京工程高等职业学校网上报名系统</title>
  7. <style type="text/css">
  8. <!--
  9. .style5 {font-weight: bold; font-size: 36px; }
  10. .style7 {font-size: 18px}
  11. .style8 {font-size: 12px}
  12. body {
  13. background-color: #F0F0F0;
  14. background-attachment: fixed;
  15. background-image: url();
  16. background-repeat: no-repeat;
  17. background-position: center 0px;
  18. }
  19. -->
  20. </style>
  21. </head>
  22. <script language="javascript">
  23. function check(f)
  24. {
  25. if(f.userName.value==""){alert("用户名不能为空！");f.userName.focus();return false;}
  26. else if(/[^x00-xff]/g.test(f.userName.value)){alert("用户名只能为字母和数字的组合");f.userName.focus();return false;}
  27. else if(f.userName.value.length<6||f.userName.value.length>15){alert("用户名长度不能小于6位或大于15位!");f.userName.focus();return false;}
  28. else if(f.sname.value==""){alert("姓名不能为空!");f.sname.focus();return false;}
  29. else if(f.nation.value==""){alert("民族不能为空!");f.nation.focus();return false;}
  30. else if(f.birthday.value==""){alert("出生年月不能为空!");f.birthday.focus();return false;}
  31. else if(f.identityNo.value.length!=15&&f.identityNo.value.length!=18&&f.identityNo.value.length!=0){alert("身份证号码只能为15或18位!");f.identityNo.focus();return false;}
  32. else if(f.ownAddress.value==""){alert("户口地址不能为空");f.ownAddress.focus();return false;}
  33. else if(f.address.value==""){alert("家庭地址不能为空!");f.address.focus();return false;}
  34. else if(f.mailNo.value==""){alert("邮政编码不能为空!");f.mailNo.focus();return false;}
  35. else if(f.mailNo.value.length!=6){alert("请填写正确的邮政编码!");f.mailNo.focus();return false;}
  36. else if(f.graduateSchool.value==""){alert("毕业学校不能为空!");f.graduateSchool.focus();return false;}
  37. else if(f.speciality.value==""){alert("报考专业不能为空!");f.speciality.focus();return false;}
  38. }
  39. </script>
  40. <%
  41. request.setCharacterEncoding("gb2312");
  42. String studentAccount=(String)request.getParameter("studentAccount");
  43. %>
  44. <jsp:useBean id="csi" class="internetsignup.ManagerCollegeStudentInfo" scope="page"></jsp:useBean>
  45. <jsp:setProperty name="csi" property="userName" value="<%=studentAccount%>" />
  46. <%
  47. int i=csi.selectUserNameMessage();
  48. %>
  49. <script language="javascript">
  50. function checkSelectSex()
  51. {
  52. var s="<%=csi.getSex()%>";
  53. if(s=="男") document.form1.sex[0].checked=true;
  54. else document.form1.sex[1].checked=true;
  55. }
  56. function checkSelectIfMember()
  57. {
  58. var s="<%=csi.getIfMember()%>";
  59. if(s=="是") document.form1.ifMember[0].selected=true;
  60. else document.form1.ifMember[1].selected=true;
  61. }
  62. function checkCultureExtent()
  63. {
  64. var s="<%=csi.getCultureExtent()%>";
  65. if(s=="初中") document.form1.cultureExtent[0].selected=true;
  66. else document.form1.cultureExtent[1].selected=true;
  67. }
  68. function checkSignType()
  69. {
  70. var s="<%=csi.getSignType()%>";
  71. if(s=="城镇应届毕业") document.form1.signType[0].selected=true;
  72. else if(s=="城镇往届毕业") document.form1.signType[1].selected=true;
  73. else if(s=="农村应届毕业") document.form1.signType[2].selected=true;
  74. else if(s=="农村往届毕业") document.form1.signType[3].selected=true;
  75. }
  76. function checkSignSelect()
  77. {
  78. var s="<%=csi.getSignSelect()%>";
  79. if(s=="三年制普通中专") document.form1.signSelect[0].selected=true;
  80. else if(s=="三年制高级技工") document.form1.signSelect[1].selected=true;
  81. else if(s=="五年制高级技工") document.form1.signSelect[2].selected=true;
  82. else if(s=="七年制技师") document.form1.signSelect[3].selected=true;
  83. else if(s=="五年制专科") document.form1.signSelect[4].selected=true;
  84. }
  85. function checkExist()
  86. {
  87. var total="<%=i%>";
  88. if(total==0){alert("该记录不存在!");window.location.href("ManagerOperation.jsp");}
  89. }
  90. </script>
  91. <% 
  92. String identityNo=csi.getIdentityNo();
  93. if(csi.getIdentityNo().equals("null")) identityNo="";
  94. String housePhone=csi.getHousePhone();
  95. if(csi.getHousePhone().equals("null")) housePhone="";
  96. String mobile=csi.getMobile();
  97. if(csi.getMobile().equals("null")) mobile="";
  98. String score=csi.getScore();
  99. if(csi.getScore().equals("null")) score="";
  100. String fatherName=csi.getFatherName();
  101. if(csi.getFatherName().equals("null")) fatherName="";
  102. String fatherJob=csi.getFatherJob();
  103. if(csi.getFatherJob().equals("null")) fatherJob="";
  104. String fatherPhone=csi.getFatherPhone();
  105. if(csi.getFatherPhone().equals("null")) fatherPhone="";
  106. String motherName=csi.getMotherName();
  107. if(csi.getMotherName().equals("null")) motherName="";
  108. String motherJob=csi.getMotherJob();
  109. if(csi.getMotherJob().equals("null")) motherJob="";
  110. String motherPhone=csi.getMotherPhone();
  111. if(csi.getMotherPhone().equals("null")) motherPhone="";
  112. String remark=csi.getRemark();
  113. if(csi.getRemark().equals("null")) remark="";
  114. String schoolOpinion=csi.getSchoolOpinion();
  115. if(csi.getSchoolOpinion().equals("null")) schoolOpinion="";
  116. %>
  117. <body onLoad="checkSelectSex();checkSelectIfMember();checkCultureExtent();checkSignType();checkSignSelect();checkExist()">
  118. <form name="form1" onSubmit="return check(this)" method="post" action="ChangeByStudentAccount.jsp">
  119.   <p align="center"><img src="gif/11111.jpg" width="800" height="102" align="absmiddle"></p>
  120.   <table width="651" border="1" align="center" cellspacing="0" bordercolor="#9ebbd8" bgcolor="#f0f0f0">
  121.     <tr bordercolor="#9ebbd8">
  122.       <td height="30" colspan="3"><p align="left" class="style5"><span class="style7">报考学校：南京工程高等职业学校　 招生代码：2229、6229</span></p></td>
  123.     </tr>
  124.     <tr>
  125.       <td bordercolor="#9ebbd8" ><div align="right" class="style8"> *用户名:</div></td>
  126.       <td bordercolor="#9ebbd8" ><div align="left">
  127.           <div align="left">
  128.             <input name="userName" type="text" id="userName2" value="<%=studentAccount%>">
  129.           </div>
  130.       </div></td>
  131.       <td width="244" bordercolor="#9ebbd8" bgcolor="#f0f0f0" >
  132.       <div align="left" class="style8">英文和数字，限制6位以上，15位以内。</div></td>
  133.     </tr>
  134.     <tr bordercolor="#9EBBD8">
  135.       <td width="100" bordercolor="#9ebbd8"><div align="right" class="style8">*姓名:</div></td>
  136.       <td width="293" bordercolor="#9ebbd8">
  137.         <div align="left" class="style8">
  138.           <input name="sname" type="text" id="sname3" value="<%=csi.getSname()%>">
  139.       </div></td>
  140.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><div align="left" class="style8">必须填写真实姓名，和身份证上姓名一致。</div></td>
  141.     </tr>
  142.     <tr bordercolor="#9EBBD8">
  143.       <td bordercolor="#9ebbd8"><div align="right" class="style8">*性别:</div></td>
  144.       <td bordercolor="#9ebbd8">
  145.         <div align="left" class="style8">
  146.           <input name="sex" type="radio" value="男" checked>
  147.         男
  148.         <input type="radio" name="sex" value="女">
  149.       女</div></td>
  150.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><div align="left"><span class="style8"></span>&nbsp; </div></td>
  151.     </tr>
  152.     <tr bordercolor="#9EBBD8">
  153.       <td bordercolor="#9ebbd8"><div align="right" class="style8">*民族:</div></td>
  154.       <td bordercolor="#9ebbd8">
  155.         <div align="left" class="style8">
  156.           <input name="nation" type="text" id="nation3" value="<%=csi.getNation()%>">
  157.       </div></td>
  158.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><div align="left"><span class="style8"></span>&nbsp;&nbsp; </div></td>
  159.     </tr>
  160.     <tr bordercolor="#9EBBD8">
  161.       <td bordercolor="#9ebbd8"><div align="right" class="style8">*出生年月:</div></td>
  162.       <td bordercolor="#9ebbd8">
  163.         <div align="left" class="style8">
  164.           <input name="birthday" type="text" id="birthday3" value="<%=csi.getBirthday()%>">
  165.       </div></td>
  166.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><div align="left" class="style8">必须和身份证上一致。(格式：1981-10-23）</div></td>
  167.     </tr>
  168.     <tr bordercolor="#9EBBD8">
  169.       <td bordercolor="#9ebbd8"><div align="right" class="style8">身份证号:</div></td>
  170.       <td bordercolor="#9ebbd8">
  171.         <div align="left" class="style8">
  172.           <input name="identityNo" type="text" id="identityNo3" value="<%=identityNo%>">
  173.       </div></td>
  174.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><div align="left" class="style8">高考生必须填写，中考生可不填。</div></td>
  175.     </tr>
  176.     <tr bordercolor="#9EBBD8">
  177.       <td bordercolor="#9ebbd8"><div align="right" class="style8">*是否团员:</div></td>
  178.       <td bordercolor="#9ebbd8">
  179.         <div align="left" class="style8">
  180.           <select name="ifMember" id="select5">
  181.             <option selected>是</option>
  182.             <option>否</option>
  183.           </select>
  184.       </div></td>
  185.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><div align="left"><span class="style8"></span></div></td>
  186.     </tr>
  187.     <tr bordercolor="#9EBBD8">
  188.       <td bordercolor="#9ebbd8"><div align="right" class="style8">*户口地址:</div></td>
  189.       <td bordercolor="#9ebbd8">
  190.         <div align="left" class="style8">
  191.           <input name="ownAddress" type="text" id="ownAddress3" value="<%=csi.getOwnAddress()%>">
  192.       </div></td>
  193.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><div align="left" class="style8">必须与身份证或户籍卡上一致。</div></td>
  194.     </tr>
  195.     <tr bordercolor="#9EBBD8">
  196.       <td bordercolor="#9ebbd8"><div align="right" class="style8">*家庭住址:</div></td>
  197.       <td bordercolor="#9ebbd8">
  198.         <div align="left" class="style8">
  199.           <input name="address" type="text" id="address3" value="<%=csi.getAddress()%>">
  200.       </div></td>
  201.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><div align="left" class="style8">务必填写详细，填写至乡镇、街道、村。</div></td>
  202.     </tr>
  203.     <tr bordercolor="#9EBBD8">
  204.       <td bordercolor="#9ebbd8"><div align="right" class="style8">*邮政编码:</div></td>
  205.       <td bordercolor="#9ebbd8">
  206.         <div align="left" class="style8">
  207.           <input name="mailNo" type="text" id="mailNo3" value="<%=csi.getMailNo()%>">
  208.       </div></td>
  209.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><div align="left"><span class="style8"></span></div></td>
  210.     </tr>
  211.     <tr bordercolor="#9EBBD8">
  212.       <td height="21" bordercolor="#9ebbd8"><div align="right" class="style8">住宅电话:</div></td>
  213.       <td bordercolor="#9ebbd8">
  214.         <div align="left" class="style8">
  215.           <input name="housePhone" type="text" id="housePhone4" value="<%=housePhone%>">
  216.       </div></td>
  217.       <td rowspan="2" bordercolor="#9ebbd8" bgcolor="#f0f0f0"><div align="left" class="style8">请至少填写一个确保能够联系到的电话。</div></td>
  218.     </tr>
  219.     <tr bordercolor="#9EBBD8">
  220.       <td bordercolor="#9ebbd8"><div align="right" class="style8">移动电话:</div></td>
  221.       <td bordercolor="#9ebbd8">
  222.         <div align="left" class="style8">
  223.           <input name="mobile" type="text" id="mobile3" value="<%=mobile%>">
  224.       </div></td>
  225.     </tr>
  226.     <tr bordercolor="#9EBBD8">
  227.       <td bordercolor="#9ebbd8"><div align="right" class="style8">*毕业学校:</div></td>
  228.       <td bordercolor="#9ebbd8">
  229.         <div align="left" class="style8">
  230.           <input name="graduateSchool" type="text" id="graduateSchool3" value="<%=csi.getGraduateSchool()%>">
  231.       </div></td>
  232.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><span class="style8"> &nbsp;&nbsp;&nbsp;&nbsp; </span></td>
  233.     </tr>
  234.     <tr bordercolor="#9EBBD8">
  235.       <td bordercolor="#9ebbd8"><div align="right" class="style8">*文化程度:</div></td>
  236.       <td bordercolor="#9ebbd8">
  237.         <div align="left" class="style8">
  238.           <select name="cultureExtent" id="select6">
  239.             <option selected>初中</option>
  240.             <option>高中</option>
  241.           </select>
  242.       </div></td>
  243.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><span class="style8"> &nbsp; </span></td>
  244.     </tr>
  245.     <tr bordercolor="#9EBBD8">
  246.       <td bordercolor="#9ebbd8"><div align="right" class="style8">中考(高考)成绩:</div></td>
  247.       <td bordercolor="#9ebbd8">
  248.         <div align="left" class="style8">
  249.           <input name="score" type="text" id="score3" value="<%=score%>">
  250.       </div></td>
  251.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><span class="style8"> &nbsp;&nbsp; </span></td>
  252.     </tr>
  253.     <tr bordercolor="#9EBBD8">
  254.       <td bordercolor="#9ebbd8"><div align="right" class="style8">*报考类型:</div></td>
  255.       <td bordercolor="#9ebbd8">
  256.         <div align="left" class="style8">
  257.           <select name="signType" id="select7">
  258.             <option selected>城镇应届毕业</option>
  259.             <option>城镇往届毕业</option>
  260.             <option>农村应届毕业</option>
  261.             <option>农村往届毕业</option>
  262.           </select>
  263.       </div></td>
  264.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><span class="style8"> &nbsp;&nbsp; </span></td>
  265.     </tr>
  266.     <tr bordercolor="#9EBBD8">
  267.       <td bordercolor="#9ebbd8"><div align="right" class="style8">*报考类别:</div></td>
  268.       <td bordercolor="#9ebbd8"><p align="left" class="style8">
  269.           <select name="signSelect" id="signSelect" onChange="vbscript:test signSelect,speciality">
  270.             >
  271.             <option value="三年制普通中专" selected>三年制普通中专</option>
  272.             <option value="三年制高级技工">三年制高级技工</option>
  273.             <option value="五年制高级技工">五年制高级技工</option>
  274.             <option value="七年制技师">七年制技师</option>
  275.             <option value="五年制专科">五年制专科</option>
  276.           </select>
  277.       </p>
  278.       </td>
  279.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><span class="style8"> &nbsp;</span></td>
  280.     </tr>
  281.     <tr bordercolor="#9EBBD8">
  282.       <td bordercolor="#9ebbd8"><div align="right" class="style8">*报考专业:</div></td>
  283.       <td bordercolor="#9ebbd8">
  284.         <div align="left" class="style8">
  285.           <input name="speciality" type="text" id="speciality" value="<%=csi.getSpeciality()%>">
  286. </div></td>
  287.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><span class="style8"> &nbsp; </span></td>
  288.     </tr>
  289.     <tr bordercolor="#9EBBD8">
  290.       <td bordercolor="#9ebbd8"><div align="right" class="style8">父亲姓名:</div></td>
  291.       <td bordercolor="#9ebbd8">
  292.         <div align="left" class="style8">
  293.           <input name="fatherName" type="text" id="fatherName3" value="<%=fatherName%>">
  294.       </div></td>
  295.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><span class="style8"> &nbsp; </span></td>
  296.     </tr>
  297.     <tr bordercolor="#9EBBD8">
  298.       <td bordercolor="#9ebbd8"><div align="right" class="style8">父亲工作单位:</div></td>
  299.       <td bordercolor="#9ebbd8">
  300.         <div align="left" class="style8">
  301.           <input name="fatherJob" type="text" id="fatherJob3" value="<%=fatherJob%>">
  302.       </div></td>
  303.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><span class="style8"> &nbsp;&nbsp;&nbsp; </span></td>
  304.     </tr>
  305.     <tr bordercolor="#9EBBD8">
  306.       <td bordercolor="#9ebbd8"><div align="right" class="style8">父亲联系电话:</div></td>
  307.       <td bordercolor="#9ebbd8">
  308.         <div align="left" class="style8">
  309.           <input name="fatherPhone" type="text" id="fatherPhone3" value="<%=fatherPhone%>">
  310.       </div></td>
  311.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><span class="style8"> &nbsp; </span></td>
  312.     </tr>
  313.     <tr bordercolor="#9EBBD8">
  314.       <td bordercolor="#9ebbd8"><div align="right" class="style8">母亲姓名:</div></td>
  315.       <td bordercolor="#9ebbd8">
  316.         <div align="left" class="style8">
  317.           <input name="motherName" type="text" id="motherName3" value="<%=motherName%>">
  318.       </div></td>
  319.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><span class="style8"> &nbsp;</span></td>
  320.     </tr>
  321.     <tr bordercolor="#9EBBD8">
  322.       <td bordercolor="#9ebbd8"><div align="right" class="style8">母亲工作单位:</div></td>
  323.       <td bordercolor="#9ebbd8">
  324.         <div align="left" class="style8">
  325.           <input name="motherJob" type="text" id="motherJob3" value="<%=motherJob%>">
  326.       </div></td>
  327.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><span class="style8"> &nbsp;</span></td>
  328.     </tr>
  329.     <tr bordercolor="#9EBBD8">
  330.       <td bordercolor="#9ebbd8"><div align="right" class="style8">母亲联系电话:</div></td>
  331.       <td bordercolor="#9ebbd8">
  332.         <div align="left" class="style8">
  333.           <input name="motherPhone" type="text" id="motherPhone3" value="<%=motherPhone%>">
  334.       </div></td>
  335.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><span class="style8"> &nbsp;</span></td>
  336.     </tr>
  337.     <tr bordercolor="#9EBBD8">
  338.       <td bordercolor="#9ebbd8"><div align="right" class="style8">&nbsp;&nbsp; 备注：</div></td>
  339.       <td bordercolor="#9ebbd8">
  340.         <div align="left" class="style8">
  341.           <textarea name="remark" cols="40" rows="6" id="textarea3"><%=remark%></textarea>
  342.       </div></td>
  343.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><div align="left" class="style8">可填关于自我介绍的信息，如自身特长、兴趣爱好、学习情况等。也可用于跟学校进行互动交流。</div></td>
  344.     </tr>
  345.     <tr bordercolor="#9EBBD8">
  346.       <td bordercolor="#9ebbd8"><div align="right" class="style8">学校意见:</div></td>
  347.       <td bordercolor="#9ebbd8">
  348.         <div align="left" class="style8">
  349.           <textarea name="schoolOpinion" cols="40" rows="6" id="textarea4"><%=schoolOpinion%></textarea>
  350.       </div></td>
  351.       <td bordercolor="#9ebbd8" bgcolor="#f0f0f0"><div align="left" class="style8">由学校填写。</div></td>
  352.     </tr>
  353.     <tr bordercolor="#9EBBD8">
  354.       <td bordercolor="#9ebbd8">  <div align="right" class="style8">报名日期:</div></td>
  355.       <td colspan="2" bordercolor="#9ebbd8"><div align="left">
  356.         <input name="signDate" type="text" id="signDate3" value="<%=csi.getSignupDate()%>" readonly="true">
  357.       </div></td>
  358.     </tr>
  359.     <tr bordercolor="#9ebbd8">
  360.       <td colspan="3"><div align="center" class="style8">
  361.           <input name="Submit4" type="submit"  value="修改">
  362.         　
  363.         <input type="button" name="Submit" value="删除" onClick="location.href('DeleteByAccount.jsp')">
  364.         　　
  365.         <input type="button" name="Submit2" value="生成表格" onClick="window.open('ConvertToTable.jsp')">
  366.         　
  367.         <input type="button" name="Submit3" value="返回" onClick="location.href('ManagerOperation.jsp')">　 
  368.       </div></td>
  369.     </tr>
  370.   </table>
  371.   <p>&nbsp;</p>
  372.   <TABLE cellSpacing=0 cellPadding=0 width=750 align=center bgColor=#ffffff 
  373. border=0>
  374.     <TBODY>
  375.       <TR>
  376.         <TD><TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
  377.             <TBODY>
  378.               <TR>
  379.                 <TD height=1><IMG height=1 src="" width=1></TD>
  380.               </TR>
  381.               <TR>
  382.                 <TD bgColor=#c6d6de height=4><IMG height=1 src="" width=1></TD>
  383.               </TR>
  384.               <TR>
  385.                 <TD height=1><IMG height=1 src="" width=1></TD>
  386.               </TR>
  387.             </TBODY>
  388.           </TABLE>
  389.             <TABLE cellSpacing=0 cellPadding=3 width=760 align=center border=0>
  390.               <TBODY>
  391.                 <TR>
  392.                   <TD height=25 align=middle vAlign=bottom bgcolor="#F0F0F0"><div align="center"><FONT 
  393.             color=#336699>南京工程高等职业学校招生办公室版权所有</FONT></div></TD>
  394.                 </TR>
  395.               </TBODY>
  396.           </TABLE></TD>
  397.       </TR>
  398.     </TBODY>
  399.   </TABLE>
  400.   <p>&nbsp;</p>
  401. </form>
  402. <p>&nbsp;</p>
  403. </body>
  404. <%
  405. session.setAttribute("studentAccount",studentAccount);
  406. %>
  407. </html>