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

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

源码获取地址

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

后端&＃xff1a;mysql、jdbc、servlet
前端&＃xff1a;jsp

• 实体类&＃xff08;Student.java&＃xff09;

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 &＃61; id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username &＃61; username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password &＃61; password;
}
public String getSno() {
return sno;
}
public void setSno(String sno) {
this.sno &＃61; sno;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex &＃61; sex;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age &＃61; age;
}
}


• dao层&＃xff08;StudentDao.java&＃xff09;

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 &＃61; "select * from student where username&＃61;&＃39;"&＃43;username&＃43;"&＃39;";
Connection conn &＃61; DBUtil.getConn();
Statement state &＃61; null;
ResultSet rs &＃61; null;
Student user &＃61; new Student();
Boolean flag &＃61; false;
try {
state &＃61; conn.createStatement();
rs &＃61; state.executeQuery(sql);
while(rs.next())
{
flag &＃61; 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 &＃61; false;
String sql &＃61; "insert into student(username,password,sno,sex,age) values(&＃39;"&＃43;user.getUsername()&＃43;"&＃39;"
&＃43; ",&＃39;"&＃43;user.getPassword()&＃43;"&＃39;,&＃39;"&＃43;user.getSno()&＃43;"&＃39;,&＃39;"&＃43;user.getSex()&＃43;"&＃39;,&＃39;"&＃43;user.getAge()&＃43;"&＃39;)";

Connection conn &＃61; DBUtil.getConn();
Statement state &＃61; null;
int a &＃61; 0;
try {
state &＃61; conn.createStatement();
System.out.println(sql);
a &＃61; state.executeUpdate(sql);
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.close(state, conn);
}
if (a > 0) {
f &＃61; true;
}
return f;
}

/**
* 单个通过id查询
*/
public Student getDrugById(Integer id){
Student d &＃61; new Student();
String sql &＃61; "select * from student where id&＃61;"&＃43;id;

Connection conn &＃61; DBUtil.getConn();
Statement state &＃61; null;
ResultSet rs &＃61; null;
try {
state &＃61; conn.createStatement();
rs &＃61; 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 &＃61; "update student set ";
for(int i&＃61;0;i<strlist.length;i&＃43;&＃43;)
{
if(i!&＃61;strlist.length-1)
sql&＃43;&＃61;strlist[i]&＃43;"&＃61;&＃39;" &＃43; strlist1[i] &＃43; "&＃39;,";
else sql&＃43;&＃61;strlist[i]&＃43;"&＃61;&＃39;" &＃43; strlist1[i] &＃43; "&＃39; where id&＃61;" &＃43; id &＃43; "";
}
Connection conn &＃61; DBUtil.getConn();
Statement state &＃61; null;
boolean f &＃61; false;
int a &＃61; 0;
try {
state &＃61; conn.createStatement();
a &＃61; state.executeUpdate(sql);
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.close(state, conn);
}

if (a > 0) {
f &＃61; true;
}
return f;
}

/**
* 查找所有
*/
public List<Student> getAllByPage(){
List<Student> list &＃61; new ArrayList<>();
String sql &＃61; "select * from student ";

Connection conn &＃61; DBUtil.getConn();
Statement state &＃61; null;
ResultSet rs &＃61; null;
try {
state &＃61; conn.createStatement();
rs &＃61; state.executeQuery(sql);
while(rs.next())
{
Student d &＃61; 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;
}
}

运行截图