BS1077-基于java+JSP+mysql开发实现高校学生学籍管理系统

function submit() {
                //获取表单数据前取消禁用
                $("#banjiSelect").attr('disabled',false);
                //获取表单数据前取消禁用
                $("#zhuanyeSelect").attr('disabled',false);
                //获取表单数据前取消禁用
                $("#yuanxiSelect").attr('disabled',false);

			var crossFlag = getQueryString("cross");
			if(validform() ==true && compare() == true){
				if(crossFlag) {
				}
				let data = {};
				getContent();
				let value = $('#addOrUpdateForm').serializeArray();
				$.each(value, function (index, item) { 
							data[item.name] = item.value;
						});
				let json = JSON.stringify(data);
				var urlParam;
				var successMes = '';
				if(updateId!=null && updateId!="null" && updateId!=''){
					urlParam = 'update';
					successMes = '修改成功';
				}else{		
					urlParam = 'save';
					successMes = '添加成功';
				}
				//更新跨表属性
			       var crossuserid;
			       var crossrefid;
			       var crossoptnum;
				if(crossFlag) {
					var statusColumnName = window.sessionStorage.getItem('statusColumnName'); 
					var statusColumnValue = window.sessionStorage.getItem('statusColumnValue'); 
					var obj = JSON.parse(window.sessionStorage.getItem('crossObj'));
					if(statusColumnName!='') {
						if(!statusColumnName.startsWith("[")) {
							for (var o in obj){
								if(o==statusColumnName){
									obj[o] = statusColumnValue;
								}
							}
							var table = window.sessionStorage.getItem('crossTableName');
							httpJson(crossTableName + "/update","POST",obj,(res)=>{
								if(res.code == 0){
									console.log('更新属性成功');
								}
							});   
						} else  {
							crossuserid = Number(window.sessionStorage.getItem('userid'));
							crossrefid = obj["id"];
							crossoptnum = window.sessionStorage.getItem('statusColumnName');
							crossoptnum=crossoptnum.replace(/\[/,"").replace(/\]/,"");
						}
					}
				}
				if(crossrefid && crossuserid) {
					data.crossuserid=crossuserid;
					data.crossrefid=crossrefid;
					http("xuesheng/page","GET",{
						page:1,
						limit:10,
						crossuserid:data.crossuserid,
						crossrefid:data.crossrefid,			
					},(res)=>{
						if(res.data.total >= crossoptnum){
							alert(window.sessionStorage.getItem('tips'));
							return false;
						} else {
							httpJson("xuesheng/"+urlParam,"POST",data,(res)=>{
								if(res.code == 0){
									window.sessionStorage.removeItem('id');
									let flag = true;
									if(crossFlag) {
									}

									if(flag){
										alert(successMes);
									}
									if(window.sessionStorage.getItem('onlyme') != null && window.sessionStorage.getItem('onlyme') == "true"){
										window.sessionStorage.removeItem('onlyme');
										window.location.href="${pageContext.request.contextPath}/index.jsp";
									}else{
										window.location.href="list.jsp";
									}
									
								}
							});
						}
					});
				} else {
					httpJson("xuesheng/"+urlParam,"POST",data,(res)=>{
						if(res.code == 0){
							window.sessionStorage.removeItem('id');
							let flag = true;
							if(crossFlag) {
							}

							if(flag){
								alert(successMes);
							}
							if(window.sessionStorage.getItem('onlyme') != null && window.sessionStorage.getItem('onlyme') == "true"){
								window.sessionStorage.removeItem('onlyme');
								window.location.href="${pageContext.request.contextPath}/index.jsp";
							}else{
								window.location.href="list.jsp";
							}
							
						}
					});
				}
			}else{
				alert("表单未填完整或有错误");
			}
		}

import java.sql.*;
import java.util.*;

public class StudentManagement {
    private Connection conn;
    private PreparedStatement pstmt;
    private ResultSet rs;

    public StudentManagement() throws SQLException {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://localhost:3306/school";
            String user = "root";
            String password = "password";
            conn = DriverManager.getConnection(url, user, password);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

    public void addStudent(String name, String id, String gender, int age, String classname) throws SQLException {
        String sql = "INSERT INTO student (name, id, gender, age, classname) VALUES (?, ?, ?, ?, ?)";
        pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, name);
        pstmt.setString(2, id);
        pstmt.setString(3, gender);
        pstmt.setInt(4, age);
        pstmt.setString(5, classname);
        pstmt.executeUpdate();
    }

    public void deleteStudent(String id) throws SQLException {
        String sql = "DELETE FROM student WHERE id = ?";
        pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, id);
        pstmt.executeUpdate();
    }

    public void updateStudent(String id, String name, String gender, int age, String classname) throws SQLException {
        String sql = "UPDATE student SET name = ?, gender = ?, age = ?, classname = ? WHERE id = ?";
        pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, name);
        pstmt.setString(2, gender);
        pstmt.setInt(3, age);
        pstmt.setString(4, classname);
        pstmt.setString(5, id);
        pstmt.executeUpdate();
    }

    public List<Map<String, Object>> getStudents() throws SQLException {
        String sql = "SELECT * FROM student";
        pstmt = conn.prepareStatement(sql);
        rs = pstmt.executeQuery();
        List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
        while (rs.next()) {
            Map<String, Object> map = new HashMap<String, Object>();
            map.put("id", rs.getString("id"));
            map.put("name", rs.getString("name"));
            map.put("gender", rs.getString("gender"));
            map.put("age", rs.getInt("age"));
            map.put("classname", rs.getString("classname"));
            list.add(map);
        }
        return list;
    }
}