modifystuinfo_jsp.java

学生信息管理系统简单实现 可以简单得实现现阶段学生信息得增加 修改 删除 查看

package org.apache.jsp;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
import sms.db.*;
import sms.bean.*;
import java.util.*;

public final class modifyStuInfo_jsp extends org.apache.jasper.runtime.HttpJspBase
    implements org.apache.jasper.runtime.JspSourceDependent {

  private static java.util.Vector _jspx_dependants;

  public java.util.List getDependants() {
    return _jspx_dependants;
  }

  public void _jspService(HttpServletRequest request, HttpServletResponse response)
        throws java.io.IOException, ServletException {

    JspFactory _jspxFactory = null;
    PageContext pageContext = null;
    HttpSession session = null;
    ServletContext application = null;
    ServletConfig config = null;
    JspWriter out = null;
    Object page = this;
    JspWriter _jspx_out = null;
    PageContext _jspx_page_context = null;


    try {
      _jspxFactory = JspFactory.getDefaultFactory();
      response.setContentType("text/html; charset=gb2312");
      pageContext = _jspxFactory.getPageContext(this, request, response,
      			"", true, 8192, true);
      _jspx_page_context = pageContext;
      application = pageContext.getServletContext();
      config = pageContext.getServletConfig();
      session = pageContext.getSession();
      out = pageContext.getOut();
      _jspx_out = out;

      out.write("\r\n");
      out.write("\r\n");

  request.setCharacterEncoding("gb2312");
  //取得页面表单提交的参数
  System.out.println("test in stuDetailInfo.jsp 1"); /////////////////////////////
  String queryFlag = request.getParameter("queryButton");
  System.out.println("tset in modifyStuInfo.jsp queryFlag:" + queryFlag);
  String modifyFlag = request.getParameter("modifyButton");
  System.out.println("tset in modifyStuInfo.jsp modifyFlag:" + modifyFlag);
  StuDetailBean stuDetailBean = null;
  String flag = null;//控制修改按钮是否可见的标志
  String stuId = "";
  String password = "";
  String name = "";
  String sex = "";
  String age = "";
  String specialty = "";
  String nationality = "";
  String college = "";
  String character = "";
  String lenOfSchooling = "";
  String enrollTime = "";
  String address = "";
  String remark = "";
  String telephone = "";
  String eMail = "";
  if (queryFlag != null) {//如果单击查询按钮
    stuId = request.getParameter("studentId");
    if (stuId == null || stuId.equals("")) {

      out.write("\r\n");
      out.write("<script language=\"javascript\" type=\"\">\r\n");
      out.write("    alert('请输入学号号！');\r\n");
      out.write("    </script>\r\n");

    } else {
      StuDetailBean stuDBean = new StuDetailBean();
      stuDetailBean = stuDBean.queryStuDetail(stuId);//查询该学生详细信息
      if(stuDBean != null && stuDBean.getName() != null){
        name = stuDetailBean.getName();
        sex = stuDetailBean.getSex();
        age = stuDetailBean.getAge();
        nationality = stuDetailBean.getNationality();
        college = stuDetailBean.getCollegeName();
        character = stuDetailBean.getCharacter();
        lenOfSchooling = stuDetailBean.getLenOfSchooling();
        enrollTime = stuDetailBean.getEnrollTime();
        address = stuDetailBean.getAddress();
        telephone = stuDetailBean.getTelephone();
        eMail = stuDetailBean.getEMail();
        specialty = stuDetailBean.getSpecialty();
        flag = "visible";//查询成功设置修改按钮可见
      }else{
 
      out.write("\r\n");
      out.write("<script language=\"javascript\" type=\"\">\r\n");
      out.write("    alert('没有该学生信息！');\r\n");
      out.write("</script>\r\n");

      }
    }
  }
  if (modifyFlag != null ) {
    System.out.println("test in modifyStuInfo.jsp modifyFlag:" + modifyFlag);
    StudentBean stuBean = new StudentBean();
    stuId = request.getParameter("stuId2");
    age = request.getParameter("age");
    password = request.getParameter("pwd");
    character = request.getParameter("character");
    address = request.getParameter("address");
    remark = request.getParameter("remark");
    telephone = request.getParameter("telephone");
    eMail = request.getParameter("eMail");
    boolean checkPwdFlag = stuBean.checkPwd(stuId, password);//验证输入的密码是否正确
    if (checkPwdFlag == false) {
      flag = "visible";//

      out.write("\r\n");
      out.write("<script language=\"javascript\" type=\"\">\r\n");
      out.write("    alert('您输入的密码不正确！');\r\n");
      out.write("</script>\r\n");

    } else {
      //调用更新学生信息的方法
      StuDetailBean stuDetailBean2 = new StuDetailBean();
      boolean updateFlag = stuDetailBean2.modifyStuInfo(stuId,age,address, telephone, eMail, character, remark);
      if (updateFlag == true) {

      out.write("\r\n");
      out.write("<script language=\"javascript\" type=\"\">\r\n");
      out.write("    alert('修改成功！');\r\n");
      out.write("    </script>\r\n");

      } else {
        flag = "visible";

      out.write("\r\n");
      out.write("<script language=\"javascript\" type=\"\">\r\n");
      out.write("    alert('修改失败！');\r\n");
      out.write("    </script>\r\n");

      }
    }
 }

      out.write("\r\n");
      out.write("<html>\r\n");
      out.write("<head>\r\n");
      out.write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n");
      out.write("<title>学生信息修改</title>\r\n");
      out.write("<link href=\"css/style.css\" rel=\"stylesheet\" type=\"text/css\">\r\n");
      out.write("<style type=\"text/css\">\r\n");
      out.write("<!--\r\n");
      out.write("body {\r\n");
      out.write("\tbackground-color: #CCCCCC;\r\n");
      out.write("}\r\n");
      out.write("-->\r\n");
      out.write("</style>\r\n");
      out.write("</head>\r\n");
      out.write("<body>\r\n");
      out.write("<form name=\"form1\" method=\"post\" action=\"\">\r\n");
      out.write("<input type=\"hidden\" name=\"commitFlag\" value=\"submit\">\r\n");
      out.write("<table width=\"100%\" border=\"0\" align=\"center\">\r\n");
      out.write("  <tr>\r\n");
      out.write("    <td height=\"25\" bgcolor=\"#999999\">\r\n");
      out.write("      <table width=\"100%\" border=\"0\">\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td width=\"23%\" height=\"25\" align=\"right\">学号：</td>\r\n");
      out.write("          <td width=\"35%\">\r\n");
      out.write("            <input name=\"studentId\" type=\"text\" value=\"");
      out.print(stuId==null?"":stuId);
      out.write("\" class=\"text1\">\r\n");
      out.write("          </td>\r\n");
      out.write("          <td width=\"22%\">\r\n");
      out.write("            <input name=\"queryButton\" type=\"submit\" value=\"提交\">\r\n");
      out.write("          </td>\r\n");
      out.write("          <td width=\"20%\">&nbsp;</td>\r\n");
      out.write("        </tr>\r\n");
      out.write("      </table>\r\n");
      out.write("    </td>\r\n");
      out.write("  </tr>\r\n");
      out.write("  <tr>\r\n");
      out.write("    <td height=\"360\" align=\"center\" valign=\"top\">\r\n");
      out.write("      <table width=\"100%\" border=\"1\" bordercolorlight= #C1A4F4  borderColorDark=#ffffff cellPadding=0 cellSpacing=0>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td width=\"23%\" height=\"25\" align=\"right\">学号：</td>\r\n");
      out.write("          <td width=\"77%\">\r\n");
      out.write("            <input name=\"stuId2\" type=\"text\" class=\"text1\" id=\"stuId2\" size=\"15\" maxlength=\"15\" value=\"");
      out.print(stuId==null?"":stuId);
      out.write("\" readonly=\"readonly\">\r\n");
      out.write("          </td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <td height=\"25\" align=\"right\">修改时需要提供密码：</td>\r\n");
      out.write("        <td>\r\n");
      out.write("          <input name=\"pwd\" type=\"text\" class=\"text1\" id=\"password\">\r\n");
      out.write("        </td>\r\n");
      out.write("        <tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"25\" align=\"right\">姓名：</td>\r\n");
      out.write("          <td>\r\n");
      out.write("            <input name=\"name\" type=\"text\" class=\"text1\" id=\"name\" size=\"15\" maxlength=\"15\" value=\"");
      out.print(name);
      out.write("\" readonly=\"readonly\">\r\n");
      out.write("          </td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"25\" align=\"right\">性别：</td>\r\n");
      out.write("          <td>\r\n");
      out.write("            <input name=\"sex\" type=\"text\" class=\"text1\" id=\"sex\" size=\"15\" maxlength=\"15\" value=\"");
      out.print(sex);
      out.write("\" readonly=\"readonly\">\r\n");
      out.write("          </td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"25\" align=\"right\">年龄：</td>\r\n");
      out.write("          <td>\r\n");
      out.write("            <input name=\"age\" type=\"text\" class=\"text1\" id=\"age\" size=\"10\" maxlength=\"10\" value=\"");
      out.print(age);
      out.write("\">\r\n");
      out.write("          </td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"25\" align=\"right\">民族：</td>\r\n");
      out.write("          <td>\r\n");
      out.write("            <input name=\"nationality\" type=\"text\" class=\"text1\" id=\"nationality\" value=\"");
      out.print(nationality);
      out.write("\" readonly=\"readonly\">\r\n");
      out.write("          </td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"25\" align=\"right\">学院：</td>\r\n");
      out.write("          <td>\r\n");
      out.write("            <input name=\"college\" type=\"text\" class=\"text1\" id=\"college\" value=\"");
      out.print(college);
      out.write("\" readonly=\"readonly\">\r\n");
      out.write("          </td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"25\" align=\"right\">专业：</td>\r\n");
      out.write("          <td>\r\n");
      out.write("            <input name=\"specialty\" type=\"text\" class=\"text1\" id=\"specialty\" value=\"");
      out.print(specialty);
      out.write("\" readonly=\"readonly\">\r\n");
      out.write("          </td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"25\" align=\"right\">学制：</td>\r\n");
      out.write("          <td>\r\n");
      out.write("            <input name=\"lenOfSchooling\" type=\"text\" class=\"text1\" id=\"lenOfSchooling\" value=\"");
      out.print(lenOfSchooling);
      out.write("\" readonly=\"readonly\">\r\n");
      out.write("          </td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"25\" align=\"right\">入学年份：</td>\r\n");
      out.write("          <td>\r\n");
      out.write("            <input name=\"enrollTime\" type=\"text\" class=\"text1\" id=\"enrollTime\" value=\"");
      out.print(enrollTime);
      out.write("\" readonly=\"readonly\">\r\n");
      out.write("          </td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"25\" align=\"right\">政治面貌:</td>\r\n");
      out.write("          <td>\r\n");
      out.write("            <input name=\"character\" type=\"text\" class=\"text1\" id=\"character\" value=\"");
      out.print(character);
      out.write("\">\r\n");
      out.write("          </td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"25\" align=\"right\">电话：</td>\r\n");
      out.write("          <td>\r\n");
      out.write("            <input name=\"telephone\" type=\"text\" class=\"text1\" id=\"telephone\" value=\"");
      out.print(telephone);
      out.write("\">\r\n");
      out.write("          </td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"25\" align=\"right\">电子邮件：</td>\r\n");
      out.write("          <td>\r\n");
      out.write("            <input name=\"eMail\" type=\"text\" class=\"text1\" id=\"eMail\" value=\"");
      out.print(eMail);
      out.write("\">\r\n");
      out.write("          </td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"60\" align=\"right\">家庭住址：</td>\r\n");
      out.write("          <td>\r\n");
      out.write("            <textarea name=\"address\" cols=\"60\" rows=\"4\" id=\"address\">");
      out.print(address);
      out.write("</textarea>\r\n");
      out.write("          </td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"60\" align=\"right\">备注：</td>\r\n");
      out.write("          <td>\r\n");
      out.write("            <textarea name=\"remark\" cols=\"60\" rows=\"5\" id=\"remark\">");
      out.print(remark);
      out.write("</textarea>\r\n");
      out.write("          </td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"25\">&nbsp;</td>\r\n");
      out.write("          <td>\r\n");
      out.write("          ");
if (flag != null && flag.equals("visible")) {          
      out.write("\r\n");
      out.write("            <input name=\"modifyButton\" type=\"submit\" value=\"修改\" class=\"button1\">\r\n");
      out.write("          ");
} else {          
      out.write("\r\n");
      out.write("            &nbsp;\r\n");
      out.write("          ");
}          
      out.write("\r\n");
      out.write("          </td>\r\n");
      out.write("        </tr>\r\n");
      out.write("      </table>\r\n");
      out.write("    </td>\r\n");
      out.write("  </tr>\r\n");
      out.write("  <tr>\r\n");
      out.write("    <td height=\"39\">&nbsp;</td>\r\n");
      out.write("  </tr>\r\n");
      out.write("</table>\r\n");
      out.write("</form>\r\n");
      out.write("</body>\r\n");
      out.write("</html>\r\n");
    } catch (Throwable t) {
      if (!(t instanceof SkipPageException)){
        out = _jspx_out;
        if (out != null && out.getBufferSize() != 0)
          out.clearBuffer();
        if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
      }
    } finally {
      if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
    }
  }
}