updatepeople.jsp

教师办公管理系统

          <td width="53">&nbsp;</td>
        </tr>
             <tr>
          <td width="165">&nbsp;</td>
          <td align="center" width="239">所在学院：</td>
          <td width="328">
          <select name="CollegeID">
          <%
                ResultSet rsc=null;
                PeopleBean pbc=new PeopleBean();
                rsc=pbc.getAllCollege();
                while(rsc.next())
                {
                  int CollegeID=rsc.getInt("CollegeID");
                  String CollegeName=rsc.getString("CollegeName");
                  if(CollegeID==pi.getCollegeID())
                  {
                    %>
                      <option value="<%=CollegeID%>" selected="selected"><%=CollegeName%></option>
                    <%
                  }
                  else
                  {
                    %>
                      <option value="<%=CollegeID%>"><%=CollegeName%></option>
                    <%
                  }            
                }
            %>
            </select>
          </td>
          <td width="53">&nbsp;</td>
        </tr>
             <tr>
          <td width="165">&nbsp;</td>
          <td align="center" width="239">所在科室： </td>
          <td width="328">
            <select name="DepartmentID">
            <%
                ResultSet rsd=null;
                PeopleBean pbd=new PeopleBean();
                rsd=pbd.getAllDeparement();
                while(rsd.next())
                {
                  int DepartmentID=rsd.getInt("DepartmentID");
                  String DepartmentName=rsd.getString("DepartmentName");
                  if(DepartmentID==pi.getDepartmentID())
                  {
                    %>
                      <option value="<%=DepartmentID%>" selected="selected"><%=DepartmentName%></option>
                    <%
                  }
                  else
                  {
                    %>
                      <option value="<%=DepartmentID%>"><%=DepartmentName%></option>
                    <%
                  }
                }
            %>
            </select>
          </td>
          <td width="53">&nbsp;</td>
        </tr>
             <tr>
          <td width="165">&nbsp;</td>
          <td align="center" width="239">角&nbsp;&nbsp;&nbsp;&nbsp;色：</td>
          <td width="328">
            <select name="RoleID">
            <%
                ResultSet rsr=null;
                PeopleBean pbr=new PeopleBean();
                rsr=pbr.getAllRole();
                while(rsr.next())
                {
                  int RoleID=rsr.getInt("RoleID");
                  String RoleName=rsr.getString("RoleName");
                  if(RoleID==pi.getRoleID())
                  {
                    %>
                      <option value="<%=RoleID%>" selected="selected"><%=RoleName%></option>
                    <%
                  }
                  else
                  {
                    %>
                      <option value="<%=RoleID%>"><%=RoleName%></option>
                    <%
                  }
                }
            %>
            </select>
          </td>
          <td width="53">&nbsp;</td>
        </tr>
             <tr>
          <td width="165">&nbsp;</td>
          <td align="center" width="239">所学专业：</td>
          <td width="328">
            <select name="SpecialityID">
            <%
                ResultSet rss=null;
                PeopleBean pbs=new PeopleBean();
                rss=pbs.getAllSpeciality();
                while(rss.next())
                {
                  int SpecialityID=rss.getInt("SpecialityID");
                  String SpecialityName=rss.getString("SpecialityName");
                  if(SpecialityID==pi.getSpecialityID())
                  {
                     %>
                        <option value="<%=SpecialityID%>" selected="selected"><%=SpecialityName%></option>
                      <%
                  }
                  else
                  {
                     %>
                        <option value="<%=SpecialityID%>"><%=SpecialityName%></option>
                      <%
                  }           
                }
            %>
            </select>
          </td>
          <td width="53">&nbsp;</td>
        </tr>
             <tr>
          <td width="165">&nbsp;</td>
          <td align="center" width="239">学&nbsp;&nbsp;&nbsp;&nbsp;历：</td>
          <td width="328">
            <select name="EducationID">
            <%
                ResultSet rse=null;
                PeopleBean pbe=new PeopleBean();
                rse=pbe.getAllEducation();
                while(rse.next())
                {
                  int EducationID=rse.getInt("EducationID");
                  String EducationName=rse.getString("EducationName");
                  if(EducationID==pi.getEducationID())
                  {
                    %>
                      <option value="<%=EducationID%>" selected="selected"><%=EducationName%></option>
                    <%
                  }
                  else
                  {
                    %>
                      <option value="<%=EducationID%>"><%=EducationName%></option>
                    <%
                  }   
                }
            %>
            </select>
          </td>
          <td width="53">&nbsp;</td>
        </tr>
             <tr>
          <td width="165">&nbsp;</td>
          <td align="center" width="239">政治面貌：</td>
          <td width="328">
            <select name="PoliticsID">
            <%
                ResultSet rsp=null;
                PeopleBean pbp=new PeopleBean();
                rsp=pbp.getAllPolitics();
                while(rsp.next())
                {
                  int PoliticsID=rsp.getInt("PoliticsID");
                  String PoliticsName=rsp.getString("PoliticsName");
                  if(PoliticsID==pi.getPoliticsID())
                  {
                     %>
                      <option value="<%=PoliticsID%>" selected="selected"><%=PoliticsName%></option>
                    <%
                  }
                  else
                  {
                     %>
                      <option value="<%=PoliticsID%>"><%=PoliticsName%></option>
                    <%
                  }
                }
            %>
            </select>
          </td>
          <td width="53">&nbsp;</td>
        </tr>
             <tr>
          <td width="165">&nbsp;</td>
          <td align="center" width="239">毕业学校：

          </td>
          <td width="328">
            <input type="text" name="Fromschool" value="<%=pi.getFromschool()%>"/>
          </td>
          <td width="53">&nbsp;</td>
        </tr>
             <tr>
          <td width="165">&nbsp;</td>
          <td align="center" width="239">毕业时间：</td>
          <td width="328">
            <input type="text" name="Schooltime" value="<%=pi.getSchooltime().trim()%>"/>
          </td>
          <td width="53">&nbsp;</td>
        </tr>
        <tr>
          <td width="165">&nbsp;</td>
          <td width="239">&nbsp;</td>
          <td width="328">&nbsp;
          </td>
          <td width="53">&nbsp;</td>
        </tr>
        <tr>
          <td width="165">&nbsp;</td>
          <td width="239" align="right">
            <input type="submit" value="提交"/>
          </td>
          <td width="328">
            <input type="reset" value="重置"/>
          </td>
          <td width="53">&nbsp;</td>
        </tr>
        <tr>
          <td width="165" colspan="4">&nbsp;</td>
         
        </tr>
      </table>
    </form>
  </body>
</html>