【JAVA程序设计】（C00086）基于Servlet+jsp的学生信息管理系统

项目简介

基于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;
	}
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47

• 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;
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170

运行截图