环境:开发工具:idea,数据库:MySQL5.7 jdk1.8
架构:Javaweb,前端jsp
主要功能
学生:课程管理、资源下载、数据可视化等;
教师:学生管理、文件管理、作业管理等;
管理员:用户管理、科目管理、成绩管理、选课管理等
项目截图:
部分代码:
/插入一条公告信息
public void update(Bulletin bulletin) throws SQLException {
Connection coon = null;
PreparedStatement preparedStatement = null;
try {
coon = DBOpenClose.openConnection();
String sql = "INSERT INTO bulletin(topic,content,is_check,create_time)" + "VALUES(?,?,?,?)";
preparedStatement = coon.prepareStatement(sql);
preparedStatement.setString(1, bulletin.getTopic());
preparedStatement.setString(2, bulletin.getContent());
preparedStatement.setString(3, bulletin.getIsCheck());
preparedStatement.setString(4, bulletin.getCreateTime());
preparedStatement.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
DBOpenClose.release(null, coon, preparedStatement);
}
}
// 根据id来删除数据
public void delete(int id) throws SQLException {
Connection coon = null;
PreparedStatement preparedStatement = null;
try {
coon = DBOpenClose.openConnection();
String sql = "DELETE FROM bulletin WHERE id =" + id;
preparedStatement = coon.prepareStatement(sql);
preparedStatement.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
DBOpenClose.release(null, coon, preparedStatement);
}
}
获取方式:联系下方名片获取👇