数据库已有学生表,如何在打开修改页面的时候把学生之前设置的性别值也带到修改页面

Question

package com.noxa.medical.wu.web;

import com.google.common.base.Strings;
import com.google.inject.Inject;
import com.noxa.frame.annotations.Action;
import com.noxa.frame.annotations.Controller;
import com.noxa.frame.result.Result;
import com.noxa.frame.tools.Tools;
import com.noxa.medical.wu.model.wuPatient;
import com.noxa.medical.wu.service.wuPatientService;
import com.noxa.sys.base.BaseAction;
import com.noxa.sys.mybatis.Page;

/**
 * 学生信息管理 Controller
 * @author wjw
 * @date 2020-12-22 17:58:39
 * @company Noxatec
 */
@Controller("/medical/wu")
public class wuPatientAction extends BaseAction {
    private static final String wu_list = "/jsp/medical/wu/wu_list.jsp";

    private static final String wu_view = "/jsp/medical/wu/wu_view.jsp";

    private static final String wu_detail = "/jsp/medical/wu/wu_detail.jsp";

    @Inject
    private wuPatientService wuPatientService;

    /**
     * 学生信息管理数据展示跳转
     * @path /medical/wu/list.noxa
     */
    @Action
    public void list() {
        renderJsp(wu_list);
    }

    /**
     * 学生信息管理分页查询返回
     * @path /medical/wu/page.noxa
     */
    @Action
    public void page(wuPatient model, Page<wuPatient> page) {
        renderJson(wuPatientService.selectPageByColumn(page, model));
    }

    /**
     * 学生信息管理保存跳转
     * @path /medical/wu/view.noxa
     */
    @Action
    public void view(wuPatient model) {
        if (model != null) {
            this.setParam("model", wuPatientService.selectOneByColumn(model));
        }
        renderJsp(wu_view);
    }

    /**
     * 学生信息管理查看跳转
     * @path /medical/wu/see.noxa
     */
    @Action
    public void see(wuPatient model) {
        this.setParam("model", wuPatientService.selectOneByColumn(model));
        renderJsp(wu_detail);
    }

    /**
     * 学生信息管理保存
     * @path /medical/wu/save.noxa
     */
    @Action
    public void save(wuPatient model) {
        if (model != null && !Strings.isNullOrEmpty(model.getId())) {
        	wuPatientService.updateByColumn(model);
        } else {
            model.setId(Tools.getUUID());
            wuPatientService.insertByColumn(model);
        }
        renderJson(Result.success(model.getId()));
    }

    /**
     * 学生信息管理回收站
     * @path /medical/wu/recycle.noxa
     */
    @Action
    public void recycle(wuPatient model) {
        int rel = wuPatientService.recycleByColumn(model);
        if (rel > 0) {
            renderJson(Result.success("删除成功!", rel));
        } else {
            renderJson(Result.error("删除失败,未检索到需要删除的数据!"));
        }
    }

    /**
     * 学生信息管理回收站批量
     * @path /medical/wu/recycles.noxa
     */
    @Action
    public void recycles(String keys) {
        if (Strings.isNullOrEmpty(keys)) {
            renderJson(Result.error("删除失败,选择相应条目!"));
        } else {
            int rel = wuPatientService.recycleByKeys(keys.split(","));
            if (rel > 0) {
                renderJson(Result.success("删除成功, 成功删除%s条数据!", rel));
            } else {
                renderJson(Result.error("删除失败,未检索到需要删除的数据!"));
            }
        }
    }
}


<%@page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@include file="/app/common/common.jsp" %>
<!-- modal 头部 -->
<div class="modal-header p-sm">
	<button type="button" class="close" data-dismiss="modal" title="关闭">
		<span  class="fa fa-close" aria-hidden="true"></span>
	</button>
	<h5 class="modal-title">学生信息管理</h5>
</div>
<!-- modal 内容 -->
<div class="modal-body">

	<form id="wutestViewForm" class="form-horizontal" data-toggle="ajaxModalSubmit" data-target="#wutestTable" action="${webctx }/medical/wu/save.noxa" method="post" autocomplete="off">
		<input type="hidden" name="model.id" value="${model.id }">
		<div class="panel panel-default">
			  <div class="panel-heading">
			    <span class="font-bold">学生信息管理</span>
			  </div>
			  <div class="panel-body">
			      <div class="form-group">
			        <div class="col-sm-3">
			        	<label>姓名</label>
						<input type="text" name="model.name" value="${model.name }" class="form-control input-sm" required="required" maxlength="50">
			        </div>
			          <div class="col-sm-3">
			        	<label>性别</label> <select required="required"
								name="model.sex" class="form-control">
								<option></option>
								<option value="1">男</option>
								<option value="2">女</option>
							</select>
			        </div>
			      <div class="col-sm-3">
			        	<label>年级号</label>
						<input type="text" name="model.gradeCode"  class="form-control input-sm" value="${model.gradeCode }" >
						</div>
			        <div class="col-sm-3">
			        	<label>班级号</label>
						<input type="text" name="model.classCode" value="${model.classCode }" class="form-control input-sm" maxlength="50">
			        </div>
		      </div>
	      </div>
	      </div>
	</form>
</div>
<!-- 底部 -->
<div class="modal-footer p-xs">
	<button type="submit" class="btn btn-primary w-xs" form="wutestViewForm">提交</button>
    <button type="button" class="btn w-xs btn-default btn-sm" data-toggle="close" data-dismiss="modal">关闭</button>
</div>


var syspatient = {
		//性别
		sex:function(data) {
			if(data == 1){
				return '男';	
			} else if(data == 2){
				return '女';	
			}
		}
}

Answer 1

这个学期的JavaEE课程设计，我做的也是学生管理系统，你是想在修改数据的时候，想让数据显示在表单里，然后在进行修改。你需要通过学生表的主键，如stu_id主键，通过stu_id来查询学生表数据，然后在Controller类中通过model对象返回给JSP页面。具体如下：

<!-- 根据id获取学生信息 -->
<select id="getStudentById" parameterType="Integer"
	resultType="student">
	    select * from student where stu_id = #{id}
	</select>

// 通过id获取修改的学生信息
	function editStudent(id) {
	    $.ajax({
	        type:"get",
	        url:"<%=basePath%>student/getStudentById.action",
	        data:{"id":id},
	        success:function(data) {
	            $("#edit_stu_id").val(data.stu_id);
	            $("#edit_studentName").val(data.stu_name);
	            $("#edit_studentFaculty").val(data.stu_faculty)
	            $("#edit_stuMajor").val(data.stu_major)
	            $("#edit_stuClass").val(data.stu_class)
	            $("#edit_phone").val(data.stu_phone);
	            $("#edit_address").val(data.stu_address);
	        }
	    });
	}