项目简介

基于Servlet+jsp的学生信息管理系统；
功能简单，适合学习以及大作业等，jsp页面，form表单提交数据
学生登录注册，增改查相关信息
使用MVC设计模式开发

项目获取

源码获取地址

开发环境

运行环境：推荐jdk1.8；
开发工具：eclipse以及idea（推荐）；
操作系统：windows 10 8G内存以上（其他windows以及macOS支持，但不推荐）；
浏览器：Firefox(推荐)、Google Chrome(推荐)、Edge;
数据库：MySQL8.0(推荐)及其他版本（支持，但容易异常尤其MySQL5.7（不含）以下版本）；
数据库可视化工具：Navicat Premium 15（推荐）以及其他Navicat版本
是否maven项目：否

项目技术

后端：mysql、jdbc、servlet
前端：jsp

相关代码

• 实体类（Student.java）

package bean;

public class Student {
	private int id; //主键
	private String username;//用户名 
	private String password;//密码
	private String sno; //学号
	private String sex; //性别
	private String age; //年龄
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public String getSno() {
		return sno;
	}
	public void setSno(String sno) {
		this.sno = sno;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public String getAge() {
		return age;
	}
	public void setAge(String age) {
		this.age = age;
	}
}

• dao层（StudentDao.java）

package dao;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;

import bean.Student;
import util.DBUtil;

public class StudentDao {
	public String login(String username,String password, HttpServletRequest request){
		String sql = "select * from student where username='"+username+"'";
	     Connection conn = DBUtil.getConn();
	     Statement state = null;
	     ResultSet rs = null;
	     Student user = new Student();
	     Boolean flag = false;
	     try {
	         state = conn.createStatement();
	         rs = state.executeQuery(sql);
	         while(rs.next())
	         {
	        	 flag = true;
	        	 user.setId(rs.getInt("id"));
	        	 user.setUsername(rs.getString("username"));
	        	 user.setPassword(rs.getString("password"));
	         }
	     } catch (SQLException e) {
	         e.printStackTrace();
	     } finally {
	         DBUtil.close(state, conn);
	     }
	     if(!flag){
	    	 return "用户名不存在";
	     }else{
	    	 if(user.getPassword().equals(password)){
	    		 //存到session中
	    		 request.getSession().setAttribute("userinfo", user);
	    		 return "验证成功";
	    		 
	    	 }else{
	    		 return "密码错误";
	    	 }
	     }
	}
	/**
	 * 新增
	 */
	public boolean insert(Student user){
		boolean f = false;
        String sql = "insert into student(username,password,sno,sex,age) values('"+user.getUsername()+"'"
        		+ ",'"+user.getPassword()+"','"+user.getSno()+"','"+user.getSex()+"','"+user.getAge()+"')";
        
        Connection conn = DBUtil.getConn();
        Statement state = null;
        int a = 0;
        try {
            state = conn.createStatement();
            System.out.println(sql);
            a = state.executeUpdate(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(state, conn);
        }
        if (a > 0) {
            f = true;
        }
        return f;
	}
	
	/**
	 * 单个通过id查询
	 */
	public Student getDrugById(Integer id){
		Student d = new Student();
	     String sql = "select * from student where id="+id;
	     
	     Connection conn = DBUtil.getConn();
	     Statement state = null;
	     ResultSet rs = null;
	     try {
	         state = conn.createStatement();
	         rs = state.executeQuery(sql);
	         while(rs.next())
	         {
	        	 d.setId(rs.getInt("id"));
	        	 d.setAge(rs.getString("age"));
	        	 d.setSex(rs.getString("sex"));
	        	 d.setPassword(rs.getString("password"));
	        	 d.setUsername(rs.getString("username"));
	        	 d.setSno(rs.getString("sno"));
	         }
	     } catch (SQLException e) {
	         e.printStackTrace();
	     } finally {
	         DBUtil.close(state, conn);
	     }
	     return d;
	}
	
	  /**
     * 修改*/
    public boolean update(String []strlist,String []strlist1,Integer id) {
        String sql = "update student set ";
        for(int i=0;i<strlist.length;i++)
        {
            if(i!=strlist.length-1)
                sql+=strlist[i]+"='" + strlist1[i] + "',";
            else sql+=strlist[i]+"='" + strlist1[i] + "' where id=" + id + "";
        }

        Connection conn = DBUtil.getConn();
        Statement state = null;
        boolean f = false;
        int a = 0;

        try {
            state = conn.createStatement();
            a = state.executeUpdate(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(state, conn);
        }
        
        if (a > 0) {
            f = true;
        }
        return f;
    }
    
    /**
     * 查找所有
     */
    public List<Student> getAllByPage(){
    	List<Student> list = new ArrayList<>();
	     String sql = "select * from student ";
	     
	     Connection conn = DBUtil.getConn();
	     Statement state = null;
	     ResultSet rs = null;
	     try {
	         state = conn.createStatement();
	         rs = state.executeQuery(sql);
	         while(rs.next())
	         {
	        	 Student d = new Student();
	        	 d.setId(rs.getInt("id"));
	        	 d.setAge(rs.getString("age"));
	        	 d.setSex(rs.getString("sex"));
	        	 d.setPassword(rs.getString("password"));
	        	 d.setUsername(rs.getString("username"));
	        	 d.setSno(rs.getString("sno"));
	             list.add(d);
	         }
	     } catch (SQLException e) {
	         e.printStackTrace();
	     } finally {
	         DBUtil.close(state, conn);
	     }
    	return list;
    }
}

运行截图