package com.yhcj.Dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.yhcj.Dao.Project;
import com.yhcj.Dao.ProjectInfo;
import com.yhcj.enity.ProAndReviewObject;
import com.yhcj.enity.ProRevObject;
import com.yhcj.enity.ProStuTeaAndRev;
import com.yhcj.enity.ProjectInfoObject;
import com.yhcj.enity.ProjectObject;
import com.yhcj.enity.UserObject;
import com.yhcj.utils.DBUtil;
public class ProjectInfoImpl extends DBUtil implements ProjectInfo {
@Override
public int getCount() {
Connection conn=null;
Statement statement = null;
ResultSet resultSet = null;
try {
conn=getConn();
statement = conn.createStatement();
//查询学生信息
String sqlForAllProInfo = "select count(*) from project";
System.out.println(sqlForAllProInfo);
resultSet = statement.executeQuery(sqlForAllProInfo);
if(resultSet.next()) {
System.out.println(resultSet.getInt(1)+"");
return resultSet.getInt(1);
}else {
return 0;
}
}catch(Exception e) {
e.printStackTrace();
return 0;
}
finally{
closeConn(resultSet,statement, conn);
}
}
@Override
public List<ProjectInfoObject> findAllProInfo(String pageNum, String pageSize) {
// TODO Auto-generated method stub
Connection conn=null;
Statement statement = null;
Statement statementLeader = null;
Statement statementTea = null;
ResultSet resultSet = null;
ResultSet resultSetLeader = null;
ResultSet resultSetTea = null;
// System.out.println(proId);
int numer = Integer.parseInt(pageNum);
int size = Integer.parseInt(pageSize);
try {
conn=getConn();
statement = conn.createStatement();
String sqlForAllPro = "select * from project limit "+(numer-1)*size+","+size+";";
// System.out.println(sqlForAllPro);
resultSet = statement.executeQuery(sqlForAllPro);
if(resultSet != null) {
// System.out.println(sqlForAllPro);
List<ProjectInfoObject> proInfoList = new ArrayList<ProjectInfoObject>();
while(resultSet.next()) {
System.out.println(sqlForAllPro);
ProjectObject proObj = new ProjectObject();
UserObject teaObj = new UserObject();
UserObject leaderObj = new UserObject();
// 项目信息
proObj.setPro_id(resultSet.getString("project_id"));
proObj.setPro_name(resultSet.getString("project_name"));
proObj.setPro_status(resultSet.getString("project_status"));
Project findActNum = new ProjectImpl();
int num = findActNum.projectActNumber(proObj.getPro_id());
proObj.setAct_num(num+"");
System.out.println("实际人数"+ proObj.getAct_num());
proObj.setStart_year(resultSet.getString("start_year"));
proObj.setPlan_num(resultSet.getString("plan_number"));
proObj.setPro_principal_id(resultSet.getString("project_principal_id"));
proObj.setPro_teacher_id(resultSet.getString("project_teacher_id"));
proObj.setPro_state(resultSet.getString("project_state"));
// 负责人信息
statementLeader = conn.createStatement();
String leaderId = proObj.getPro_principal_id();
String sqlLeader = "select user_id,user_name,user_mail,user_phone from user where user_id = '" + leaderId + "';";
resultSetLeader = statementLeader.executeQuery(sqlLeader);
if(resultSetLeader.next()) {
// 负责人信息
leaderObj.setUser_id(resultSetLeader.getString("user_id"));
leaderObj.setUser_name(resultSetLeader.getString("user_name"));
leaderObj.setUser_mail(resultSetLeader.getString("user_mail"));
leaderObj.setUser_phone(resultSetLeader.getString("user_phone"));
}
statementTea = conn.createStatement();
// 教师信息
String teaId = proObj.getPro_teacher_id();
String sqlTea = "select user_id,user_name,user_mail,user_phone from user where user_id = '" + teaId + "';";
resultSetTea = statementTea.executeQuery(sqlTea);
if(resultSetTea.next()) {
// 负责人信息
teaObj.setUser_id(resultSetTea.getString("user_id"));
teaObj.setUser_name(resultSetTea.getString("user_name"));
teaObj.setUser_mail(resultSetTea.getString("user_mail"));
teaObj.setUser_phone(resultSetTea.getString("user_phone"));
}
//项目学生老师对象
ProjectInfoObject proInfo = new ProjectInfoObject();
proInfo.setProObj(proObj);
proInfo.setLeaderObj(leaderObj);
proInfo.setTeaObj(teaObj);
proInfoList.add(proInfo);
}
return proInfoList;
}else {
//用户不存在
return null;
}
}catch(Exception e) {
e.printStackTrace();
return null;
}
finally{
closeConn(resultSet,statement, conn);
closeConn(resultSetLeader,statementLeader, conn);
closeConn(resultSetTea,statementTea, conn);
}
}
@Override
public ProjectInfoObject findProInfoById(String proId) {
// TODO Auto-generated method stub
Connection conn=null;
Statement statement = null;
Statement statementLeader = null;
Statement statementTea = null;
Statement statementProAndRev = null;
Statement statementRev = null;
ResultSet resultSet = null;
ResultSet resultSetLeader = null;
ResultSet resultSetTea = null;
ResultSet resultSetProAndRev = null;
ResultSet resultSetRev = null;
System.out.println(proId);
try {
conn=getConn();
statement = conn.createStatement();
ProjectObject proObj = new ProjectObject();
UserObject leaderObj = new UserObject();
UserObject teaObj = new UserObject();
ProAndReviewObject reviewObj = new ProAndReviewObject();
// 项目
String sqlPro = "select * from project where project_id = '" + proId + "';";
System.out.println(sqlPro);
resultSet = statement.executeQuery(sqlPro);
if(resultSet.next()) {
proObj.setPro_name(resultSet.getString("project_name"));
proObj.setPro_status(resultSet.getString("project_status"));
Project findActNum = new ProjectImpl();
int num = findActNum.projectActNumber(proObj.getPro_id());
proObj.setAct_num(num+"");
System.out.println("实际人数"+ proObj.getAct_num());
proObj.setPlan_num(resultSet.getString("plan_number"));
proObj.setStart_year(resultSet.getString("start_year"));
proObj.setFinish_year(resultSet.getString("finish_year"));
proObj.setPro_principal_id(resultSet.getString("project_principal_id"));
proObj.setPro_teacher_id(resultSet.getString("project_teacher_id"));
proObj.setPro_state(resultSet.getString("project_state"));
// 负责人
statementLeader = conn.createStatement();
String leaderId = proObj.getPro_principal_id();
String sqlStu = "select user_id,user_name,user_mail,user_phone from user where user_id = '" + leaderId + "';";
resultSetLeader = statementLeader.executeQuery(sqlStu);
if(resultSetLeader.next()) {
leaderObj.setUser_id(resultSetLeader.getString("user_id"));
leaderObj.setUser_name(resultSetLeader.getString("user_name"));
leaderObj.setUser_mail(resultSetLeader.getString("user_mail"));
leaderObj.setUser_phone(resultSetLeader.getString("user_phone"));
}
// 教师
statementTea = conn.createStatement();
String teaId = proObj.getPro_teacher_id();
String sqlTea = "select user_id,user_name,user_mail,user_phone from user where user_id = '" + teaId + "';";
resultSetTea = statementTea.executeQuery(sqlTea);
if(resultSetTea.next()) {
teaObj.setUser_id(resultSetTea.getString("user_id"));
teaObj.setUser_name(resultSetTea.getString("user_name"));
teaObj.setUser_mai
没有合适的资源?快使用搜索试试~ 我知道了~
基于VUE+Servlet的大学生竞赛系统【学生端+教师端+评审端+管理员端】.zip
共573个文件
class:212个
java:212个
vue:89个
需积分: 5 0 下载量 62 浏览量
2023-08-16
21:04:09
上传
评论
收藏 7.39MB ZIP 举报
温馨提示
基于VUE+Servlet的大学生竞赛系统【学生端+教师端+评审端+管理员端】
资源推荐
资源详情
资源评论
收起资源包目录
基于VUE+Servlet的大学生竞赛系统【学生端+教师端+评审端+管理员端】.zip (573个子文件)
.babelrc 230B
ProjectImpl.class 30KB
ProjectInfoImpl.class 26KB
ProReviewImpl.class 23KB
StudentImpl.class 19KB
EndProjectImpl.class 16KB
MidProjectImpl.class 16KB
NotifyMangeImpl.class 15KB
TeacherImpl.class 15KB
ProjectMemberImpl.class 15KB
ProjectReviewerImpl.class 10KB
ProjectAuditImpl.class 10KB
UserImpl.class 10KB
ReviewTaskImpl.class 9KB
ReviewerImpl.class 8KB
ProjectSignUpFileUpload.class 7KB
ProjectReviewUploadFiles.class 7KB
StudentSignUpFileUpload.class 7KB
Count.class 7KB
CountOther.class 6KB
NotifyMangeUpload.class 6KB
NotifyMangeFilesEdit.class 6KB
TeacherProjectAllFileDownload.class 5KB
ProjectReviewFileDownload.class 5KB
TeacherProjectMangeFileDownload.class 5KB
NotifyMangeDownload.class 5KB
TeacherProjectReviewFileDownload.class 5KB
ProjectMangeFileDownload.class 5KB
StudentSignUpFileDownload.class 5KB
AcaMajAndClassImpl.class 4KB
UpdateProInfo.class 4KB
UpdateReviewer.class 4KB
UpdateEndPro.class 4KB
UpdateMidPro.class 4KB
LogAndRegImpl.class 4KB
ProjectMangeFileDeleteByStateAndType.class 4KB
InsertPro.class 4KB
EduMajAndDegreeImpl.class 4KB
TeacherProjectMangeFileDeleteAll.class 4KB
UpdateStuProManage.class 4KB
ProjectReviewFileDeleteByType.class 4KB
NotifyMangeFilesDeleteAll.class 4KB
ProjectMangeFileDeleteByState.class 4KB
ProjectMangeFileDeleteByType.class 4KB
Register.class 4KB
ProjectReviewFileDeleteAll.class 4KB
StudentSignUpDeleteAllFiles.class 4KB
ProjectMangeFileDeleteAll.class 4KB
UpdateTea.class 4KB
UpdateStu.class 4KB
NotifyMangeFilesDeleteOne.class 3KB
ProjectReviewFileDeleteOne.class 3KB
StudentSignUpDeleteOneFile.class 3KB
ReviewerObject.class 3KB
TeacherProjectMangeFileDeleteOne.class 3KB
ProjectMangeFileDeleteOne.class 3KB
ProReviewManage.class 3KB
UpdatePro.class 3KB
NotifyMangeAdd.class 3KB
UpdateUser.class 3KB
FindAllMidPro.class 3KB
NotifyMangeEdit.class 3KB
StudentSignUpAddNewPerson.class 3KB
FindAllProMemberByTea.class 3KB
ReRecState.class 3KB
FindAllMemberByStu.class 3KB
UpdateReviewTask.class 3KB
FindAllProjectInfoByTea.class 3KB
FindProjectFileByTea.class 3KB
UpdateProReview.class 3KB
QueryAllPublishNotifyInfo.class 3KB
FindAllProRevByTea.class 3KB
FindAllProByTeacher.class 3KB
UpdateChangeInfoByTea.class 3KB
FindAllStuFileManage.class 3KB
FindAllStuProManage.class 3KB
FindAllEndProByTea.class 3KB
FindAllMidProByTea.class 3KB
FindAllStuProInfo.class 3KB
FindAllStuProReview.class 3KB
FindReviewTask.class 3KB
FindAllStuEndPro.class 3KB
FindAllStuMidPro.class 3KB
FindAllStuProApply.class 3KB
TeacherProjectMangeFileQueryByStateAndType.class 3KB
StudentSignUpEachDetails.class 3KB
FindAllProReviewer.class 3KB
Login.class 3KB
FindAllProMember.class 3KB
ProjectMangeFileQueryByStateAndType.class 3KB
FindChangeInfoByType.class 3KB
FindAllProjectInfo.class 3KB
QueryAllPublishProjectInfo.class 3KB
FindAllProReview.class 3KB
FindAllProAudit.class 3KB
FindReviewerAll.class 3KB
FindUserView.class 3KB
FindAllEndPro.class 3KB
NotifyPublishDetails.class 3KB
FindAllProject.class 3KB
共 573 条
- 1
- 2
- 3
- 4
- 5
- 6
资源评论
独处东汉
- 粉丝: 430
- 资源: 822
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功