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个子文件） 
.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
资源评论
