modify.jsp

“JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。 注意： 1. 本书中的案例提供的数据库环境不同

				+" where a.id=b.role "
				+"   and b.id="+uid2;
				java.util.Vector vect5 = myBean.getDataBySql(sql5);
				  if(vect5.toString().indexOf("系统维护管理员")==-1){%>
			  <%=strthisrole_name%><input type=hidden name=role id="role" value="<%=strthisrole%>">
			  <%}
			  else{
				  %>

			<select name="role">
				<%
				for(int i=0;i<vectrole.size();i++){
					Hashtable hashrole = (Hashtable)vectrole.get(i);
					String strtempid = ds.toString((String)hashrole.get("id"));
					String strtempname = ds.toString((String)hashrole.get("name"));
				%>
                <option value="<%=strtempid%>" <%if(strthisrole.equals(strtempid)){%>selected<%}%>><%=strtempname%></option>
                <%}
			  }%>
           </select></td>
          </tr>
          <tr>
            <td height="20" class="title_s"><div align="center">性 &nbsp;&nbsp;&nbsp;别：</div></td>
            <td height="20">
              <div align="left">
                  <select name="sex" id="sex">
                    <option value="3" <%if(strthissex.equals("3")){%> selected<%}%>>请选择</option>
                    <option value="1"  <%if(strthissex.equals("1")){%> selected<%}%>>男</option>
                    <option value="0"  <%if(strthissex.equals("0")){%> selected<%}%>>女</option>
                  </select>
              </div></td></tr>
          <tr>
            <td height="20" class="title_s"><div align="center">民&nbsp;&nbsp;&nbsp; 族：</div></td>
            <td height="20">
              <div align="left">
                <input name="nation" type="text" id="nation" value="<%=strthisnation%>">
              </div></td></tr>
          <tr>
            <td height="20" class="title_s"><div align="center">政治面貌：</div></td>
            <td height="20">
              <div align="left">
                  <select name="politics" id="politics">
                    <option value="0"  <%if(strthispolitics.equals("0")){%>selected<%}%> >请选择</option>
                    <option value="1" <%if(strthispolitics.equals("1")){%>selected<%}%>>中共党员</option>
                    <option value="2" <%if(strthispolitics.equals("2")){%>selected<%}%>>共青团员</option>
                    <option value="3" <%if(strthispolitics.equals("3")){%>selected<%}%>>民主党派</option>
                    <option value="4" <%if(strthispolitics.equals("4")){%>selected<%}%>>无党派人士</option>
                    <option value="5" <%if(strthispolitics.equals("5")){%>selected<%}%>>群众</option>
                  </select>
              </div></td></tr>
          <tr>
            <td height="20" class="title_s"><div align="center">身份证号：</div></td>
            <td height="20">
              <div align="left">
                <input name="certid" type="text" id="certid" value="<%=strthiscertid%>">
              </div></td></tr>
          <tr>
            <td height="20" class="title_s"><div align="center">毕业学校：</div></td>
            <td height="20">
              <div align="left">
                <input name="fromschool" type="text" id="fromschool" value="<%=strthisfromschool%>">
              </div></td></tr>
          <tr>
            <td height="20" class="title_s"><div align="center">毕业时间：</div></td>
            <td height="20">
              <div align="left">
                <input name="schooltime" type="text" id="schooltime" readonly value="<%=strthisschooltime%>">
               <script src="../SelectDate/calendar.js"></script>
                <a onClick="fPopUpDlg('../SelectDate/calendar.htm',document.all.schooltime, 'winpop', 172, 210);"><img src="../SelectDate/datetime.gif" border=0 width="16" height="16" style="cursor:hand"></a></div></td></tr>
          <tr>
            <td height="20" class="title_s"><div align="center">出生日期：</div></td>
            <td height="20">
              <div align="left">
                <input name="birth" type="text" id="birth" readonly value="<%=strthisbirth%>">
                
               <script src="../SelectDate/calendar.js"></script>
                <a onClick="fPopUpDlg('../SelectDate/calendar.htm',document.all.birth, 'winpop', 172, 210);"><img src="../SelectDate/datetime.gif" border=0 width="16" height="16" style="cursor:hand"></a></div></td></tr>
          <tr>
            <td height="20" class="title_s"><div align="center">籍&nbsp; &nbsp;&nbsp;贯：</div></td>
            <td height="20">
              <div align="left">
                <input name="addr" type="text" id="addr" value="<%=strthisaddr%>">
              </div></td></tr>
          <tr>
            <td height="20" class="title_s"><div align="center">所学专业：</div></td>
            <td height="20">
              <div align="left">
                <input name="speciality" type="text" id="speciality" value="<%=strthisspeciality%>">
              </div></td></tr>
          <tr>
            <td height="20" class="title_s"><div align="center">学&nbsp;&nbsp;&nbsp;历：</div></td>
            <td height="20">
              <div align="left">
                <input name="education" type="text" id="education" value="<%=strthiseducation%>">
              </div></td></tr>
          <tr>
            <td height="20" class="title_s"><div align="center">职&nbsp;&nbsp;&nbsp;称：</div></td>
            <td height="20">
              <div align="left">
                <input name="post" type="text" id="post" value="<%=strthispost%>">
              </div></td></tr>
          <tr>
            <td height="20" class="title_s"><div align="center">办公电话：</div></td>
            <td height="20">
              <div align="left">
                <input name="officetel" type="text" id="officetel" value="<%=strthisofficetel%>">
              </div></td></tr>
          <tr>
            <td height="20" class="title_s"><div align="center">移动电话：</div></td>
            <td height="20">
              <div align="left">
                <input name="mobile" type="text" id="mobile" value="<%=strthismobile%>">
              </div></td></tr>
          <tr>
            <td height="20" class="title_s"><div align="center">家庭电话：</div></td>
            <td height="20">
              <div align="left">
                <input name="hometel" type="text" id="hometel" value="<%=strthishometel%>">
              </div></td></tr>
          <tr>
            <td height="20" class="title_s"><div align="center">电子邮件：</div></td>
            <td height="20">
              <div align="left">
                <input name="email" type="text" id="email" value="<%=strthisemail%>">
              </div></td></tr>
          <tr>
            <td height="20" class="title_s"><div align="center">所在学院：</div></td>
            <td height="20">
              <div align="left">
			  <select name="college" id="college" onchange="gochange()">
			  <option value="0">请选择</option>
			  <%for(int i=0;i<vectcollege.size();i++){
					Hashtable hashcollege = (Hashtable)vectcollege.get(i);
					String strtempid = ds.toString((String)hashcollege.get("id"));
					String strtempname = ds.toString((String)hashcollege.get("name"));
				%>
                <option value="<%=strtempid%>" <%if(strthiscollege.equals(strtempid)){%>selected<%}%>><%=strtempname%></option>
			 <%}%>
			  </select> *
              </div>
			</td>
		</tr>

          <tr>
            <td height="20" class="title_s"><div align="center">所在梯队：</div></td>
            <td height="20">
              <div align="left">
                  <select name="group" id="group">
				  <option value="0">请选择</option>
					  <%for(int i=0;i<vectgroup.size();i++){
							Hashtable hashgroup = (Hashtable)vectgroup.get(i);
							String strtempid = ds.toString((String)hashgroup.get("id"));
							String strtempname = ds.toString((String)hashgroup.get("name"));
						%>
						<option value="<%=strtempid%>" <%if(strthisgroup.equals(strtempid)){%>selected<%}%>><%=strtempname%></option>
					 <%}%>
                  </select> *
              </div>
			 </td>
		  </tr>
          <tr>
            <td height="20" class="title_s"><div align="center">所在科室：</div></td>
            <td height="20">
              <div align="left">
                  <select name="department" id="department">
				  <option value="0">请选择</option>
					  <%for(int i=0;i<vectdepartment.size();i++){
							Hashtable hashdepartment = (Hashtable)vectdepartment.get(i);
							String strtempid = ds.toString((String)hashdepartment.get("id"));
							String strtempname = ds.toString((String)hashdepartment.get("name"));
						%>
						<option value="<%=strtempid%>" <%if(strthisdepartment.equals(strtempid)){%>selected<%}%>><%=strtempname%></option>
					 <%}%>
                  </select> *
              </div>
			  </td>
		  </tr>
       <tr>
            <td height="20" class="title_s"><div align="center">科研方向：</div></td>
            <td height="20">              <div align="left">
              <input type=text name=txt_fxmc size=20 readonly value="<%=strthistxt_fxmc%>">
              <input class="text" type="hidden" name="orient" size="20" readonly value="<%=strthisorient%>" >
              <input name="button" type="button" style="background-color:#2969b5;color:#ffffff;border-style:solid;border-color:#2969b5;cursor:hand" onclick="window.open('../SelectOrient/stepMemRight.jsp?txt_rybh=orient&txt_rymc=txt_fxmc','mem','height=400,width=400,toolbar=no,menubar=no,location=no,resizable=no,directories=no,status=yes,scrollbars=yes,dependent=no,left=200,top=200');" value="选择科研方向">
		</div></td></tr>
          <tr>
            <td height="20" class="title_s"><div align="center">纵向项目：</div></td>
            <td height="20"><div align="left"><%=strthisprojectmc%>
                <input name="project" type="hidden" id="project" value="<%=strthisproject%>">
                <input type="button" name="Submit4" value="修改">
              </div></td></tr>
          <tr>
            <td height="20" class="title_s"><div align="center">横向课题：</div></td>
            <td height="20">              <div align="left">  <%=strthistasks%>
                <input name="tasks" type="hidden" id="tasks" value="<%=strthistasks%>">
                <input type="button" name="Submit5" value="修改">
		</div></td></tr>
          <tr>
            <td height="20" class="title_s"><div align="center">获奖情况：</div></td>
            <td height="20">
              <div align="left">
                  <textarea name="prize" cols="45" rows="8" id="prize"><%=strthisprize%></textarea>
              </div></td></tr>
          <tr>
            <td height="20" class="title_s"><div align="center">备&nbsp;&nbsp;&nbsp;注：</div></td>
            <td height="20">
              <div align="left">
                  <textarea name="descs" cols="45" rows="8" id="descs"><%=strthisdescs%></textarea>
              </div></td></tr>
          <tr>
            <td height="20" colspan="2" class="title_s">
              <div align="center">
                <button onclick="javascript:go();">提交</button>
                <input type="reset" name="Submit2" value="重置">
              </div></td>
          </tr>
      </table></td>
      <td width="50">&nbsp;</td>
    </tr>
  </table>
</form>
</body>
</html>
<%
myBean.closeConn ( ) ;
%>