queryAllNonAdju
select * from judge where adju_id=001 and is_judged='未评分';
setAdju
INSERT INTO judge(student_id," +
"project_id,adju_id) VALUES(?,?,?)")
addScore(String studentID, String projectID, String adjuID, String newScore,int hasScoredAdjuNumber
UPDATE judge SET project_score=\'" + newScore + "\' WHERE " +
"student_id=\'" + studentID + "\' and project_id=\'" + projectID +
"\' and adju_id=\'" + adjuID + "\'"))
public boolean addScore(String studentID, String projectID, String adjuID, String newScore,int hasScoredAdjuNumber) {
if (prepareMySql("UPDATE judge SET project_score=\'" + newScore + "\' WHERE " +
"student_id=\'" + studentID + "\' and project_id=\'" + projectID +
"\' and adju_id=\'" + adjuID + "\'")) {
try {
pstmt.executeUpdate();
hasScoredAdjuNumber++;
String sql = "UPDATE apply SET has_scored_adju_number=\'" +
hasScoredAdjuNumber + "\' WHERE student_id=\'" +
studentID + "\'";
pstmt = conn.prepareStatement(sql);
pstmt.executeUpdate();
sql = "UPDATE judge SET is_judged=\'已评分\' WHERE " +
"student_id=\'" + studentID + "\' and project_id=\'" + projectID +
"\' and adju_id=\'" + adjuID + "\'";
pstmt = conn.prepareStatement(sql);
pstmt.executeUpdate();
updateTotalScore(String studentID, String totalScore) {
UPDATE apply SET project_total_score=\'" + totalScore + "\' WHERE student_id=\'" + studentID + "\'")) {
}
@RequestMapping("loginServelt")
public String login(Map<String, Object> map,
HttpServletRequest request, HttpSession session, ModelAndView mv) {
String name = request.getParameter("username");
String password = request.getParameter("password");
String role = request.getParameter("role");
C:\Users\yqwld\AppData\Local\Temp\tomcat-docbase.1005.5134775979729381047\upload
getSelectedProjectAdjuNumber
SELECT adju_number from apply WHERE student_id=\'" + studentID +
3月17 SQL语句 : boolean setSelectedProjectPass(String studentID)
UPDATE apply SET pass_status='通过' WHERE student_id=\'" + studentID + "\'"
setSelectedProjectAdjuNumber(String studentID, String adjuNumber)
"UPDATE apply SET adju_number=\'" + Integer.toString(adjudicatorNumber) + "\' WHERE student_id" +"=\'" + studentID
//n您已添加了多少个项目projectNumber()"SELECT COUNT(*) AS ProjectNumber FROM project"
queryProjectGroupByTeacherID
SELECT * FROM apply WHERE teacher_id=\'" + teacherID +
addProjectTeach(String studentID,String projectTeach)
UPDATE apply SET project_teach=\'" + projectTeach + "\' WHERE student_id=\'" + studentID
changeProjectProgress(String studentID, String status) teacherDAO.changeProjectProgress(thisStudentID,"已辅导,待通过")
UPDATE apply SET project_progress=\'" + status + "\' WHERE student_id=\'" + studentID
boolean setAdju(JudgeBean judgeBean) //为项目分配评审员
INSERT INTO judge(student_id," + "project_id,adju_id) VALUES(?,?,?)
boolean isRepetitive(String adjuID, String studentID, String project_id)
SELECT COUNT(*) AS peopleNumber FROM judge WHERE adju_id=\'" + adjuID + "\' and" +" student_id=\'" + studentID + "\' and" + " project_id=\'" + project_id
List<JudgeBean> queryAllNonAdju(String adjuID)
SELECT * FROM judge WHERE is_judged=\'未评分\' and adju_id=\'" + adjuID +
addScore(String studentID, String projectID, String adjuID, String newScore,int hasScoredAdjuNumber)
UPDATE judge SET project_score=\'" + newScore + "\' WHERE " +student_id=\'" + studentID + "\' and project_id="+ projectID + and adju_id=\'" + adjuID
updateTotalScore UPDATE apply SET project_total_score=" + totalScore + "\' WHERE student_id=\'" + studentID + "\'")
queryAllNeededAdjuProject(String adjuID) "SELECT * FROM judge WHERE adju_id=\'" + adjuID
teacherDAO.changeProjectProgress(studentID, "已辅导,并通过,已评分")
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
基于springboot的大学生创新创业管理系统源码+数据库(毕业设计).zip 该项目是个人大作业高分项目源码,获得老师高度认可,都经过严格调试,确保可以运行!放心下载使用。 该项目资源主要针对相关专业的学生或从业者下载使用,也可作为期末课程设计、期末课程大作业等,具有较高的学习价值。 基于springboot的大学生创新创业管理系统源码+数据库(毕业设计).zip 该项目是个人大作业高分项目源码,获得老师高度认可,都经过严格调试,确保可以运行!放心下载使用。 该项目资源主要针对相关专业的学生或从业者下载使用,也可作为期末课程设计、期末课程大作业等,具有较高的学习价值。 基于springboot的大学生创新创业管理系统源码+数据库(毕业设计).zip 该项目是个人大作业高分项目源码,获得老师高度认可,都经过严格调试,确保可以运行!放心下载使用。 该项目资源主要针对相关专业的学生或从业者下载使用,也可作为期末课程设计、期末课程大作业等,具有较高的学习价值。 基于springboot的大学生创新创业管理系统源码+数据库(毕业设计).zip 该项目是个人大作业高分项目源码,
资源推荐
资源详情
资源评论
收起资源包目录
基于springboot的大学生创新创业管理系统源码+数据库(毕业设计).zip (1268个子文件)
AdminController.class 15KB
UserController.class 11KB
StudentController.class 8KB
Apply.class 7KB
Booktest.class 5KB
Student.class 4KB
ProPlus.class 4KB
UsertestServiceImpl.class 4KB
StudentServiceImpl.class 4KB
User.class 4KB
Project.class 3KB
Judge.class 3KB
TeacherController.class 3KB
AdjuController.class 3KB
R.class 3KB
ProjectServiceImpl.class 3KB
AdminServiceImpl.class 3KB
Book.class 3KB
Usertest.class 3KB
Teacher.class 3KB
Adjudicator.class 2KB
ServiceTest.class 2KB
Admin.class 2KB
AdjuServiceImpl.class 2KB
TestController.class 2KB
TeacherServiceImpl.class 2KB
ApplyServiceImpl.class 2KB
JsonResult.class 2KB
LoginInterceptorConfiger.class 2KB
IndexController.class 2KB
ResponseResult.class 2KB
LoginInterceptorConfigurer.class 1KB
TestTest.class 1KB
MvcConfig.class 1KB
AdjuDao.class 1KB
ProPlusImpl.class 1KB
UsernameDuplicateException.class 1KB
FileUploadIOException.class 1KB
PasswordNotMatchException.class 1KB
FileStateException.class 1KB
FileEmptyException.class 1KB
FileTypeException.class 1KB
FileSizeException.class 1KB
UserNotFoundException.class 1KB
FileUploadException.class 1KB
UpdateException.class 1KB
TeacherDao.class 1KB
ServiceException.class 1KB
MPConfig.class 987B
AdjuService.class 960B
AdminService.class 938B
AdminDao.class 933B
ApplyDao.class 929B
ProjectExceptionAdvice.class 923B
StudentService.class 908B
TeacherService.class 906B
UsertestService.class 885B
ProjectService.class 840B
ApplyService.class 839B
StudentDao.class 797B
ProPlusDao.class 765B
InnovationApplication.class 741B
TestTest$MyClass.class 640B
BaseController.class 576B
ApplyController.class 533B
RoleMatchException.class 510B
UserDao.class 480B
UsertestDao.class 376B
ProjectDao.class 373B
ProPlusService.class 314B
MybatisPlusConfig.class 314B
JudgeDao.class 286B
mvnw.cmd 7KB
bootstrap.css 170KB
bootstrap.css 170KB
bootstrap.min.css 138KB
bootstrap.min.css 138KB
style.default.css 66KB
style.default.css 66KB
style.violet.css 66KB
style.violet.css 66KB
style.blue.css 66KB
style.pink.css 66KB
style.sea.css 66KB
style.blue.css 66KB
style.pink.css 66KB
style.sea.css 66KB
style.red.css 66KB
style.green.css 66KB
style.green.css 66KB
style.red.css 66KB
bootstrap-grid.css 37KB
bootstrap-grid.css 37KB
font-awesome.css 37KB
font-awesome.css 37KB
font-awesome.min.css 30KB
font-awesome.min.css 30KB
bootstrap-grid.min.css 28KB
bootstrap-grid.min.css 28KB
bootstrap-reboot.css 5KB
共 1268 条
- 1
- 2
- 3
- 4
- 5
- 6
- 13
资源评论
- 2301_763137762024-04-04资源很不错,内容和描述一致,值得借鉴,赶紧学起来!
盈梓的博客
- 粉丝: 6871
- 资源: 1251
下载权益
C知道特权
VIP文章
课程特权
开通VIP
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功