随着我国经济的快速发展,高校毕业生数量和市场需求的矛盾使得就业市场竞争日趋激烈,鼓励大学生进行创业,“以创业促就业”逐渐成为缓解就业压力,提高大学生核心竞争力的有 效途径。为了各大高校可以更方便地管理大学生创新创业训练项目,强化项目管理,转变传统的管理理念与管理模式,建立一个大学生创新创业项目管理平台是十分重要且迫切的。本文结合我国大学生创新创业的实际情况,在分析建立创新创业项目管理平台意义的基础上,对平台进行了需求分析,给出了系统总体的构架设计和系统流程设计,旨在为大学生创新创业营造良好的社会环境,以此来提高大学生的创业积极性。
基于 B/S 架构的大学生创业管理系统把计算机技术应用在大学生创业管理实践中,基于 java的SSM框架开发系统;通过在MYSQL数据存储系统,结合数据共享和互联网技术来进行系统设计与实现,最终实现大学生创业管理系统的主要功能模块,并对项目管理的研究和发展起到了积极的作用。
关键字: 创新创业管理;B/S模式;SSM;MYSQL
【686】基于ssm大学生创新创业项目申报管理系统源码和论文
ABSTRACT
With the rapid development of China's economy, the contradiction between the number of college graduates and the market demand makes the competition in the employment market increasingly fierce. Encourage college students to start their own businesses. "Promoting employment through entrepreneurship" has gradually become an effective way to alleviate employment pressure and improve the core competitiveness of college students. In order to facilitate the management of college students' innovation and entrepreneurship training projects, strengthen project management, change traditional management concepts and management models, it is very important and urgent to establish a college students' innovation and entrepreneurship project management platform. Based on the actual situation of college students' innovation and entrepreneurship in China and the analysis of the significance of establishing an innovation and entrepreneurship project management platform, this paper analyzes the needs of the platform, and gives the overall framework design and system process design of the system, aiming to create a good social environment for college students' innovation and entrepreneurship, so as to improve their entrepreneurial enthusiasm.
The undergraduate entrepreneurship management system based on B/S architecture applies computer technology to the practice of undergraduate entrepreneurship management, and develops the system based on the Java SSM framework; Through the design and implementation of the system in the MYSQL data storage system, combined with data sharing and Internet technology, the main functional modules of the college student entrepreneurship management system were finally realized, and played a positive role in the research and development of project management。
Keywords: innovation and entrepreneurship management; B/S mode; SSM; MYSQL
package com.bw.controller;
import java.io.IOException;
import java.net.URLEncoder;
import java.util.ArrayList;
import java.util.HashSet;
import java.util.List;
import java.util.Set;
import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy;
import com.alibaba.fastjson.JSONObject;
import com.bw.model.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import com.bw.mapper.AdminMapper;
import org.springframework.web.bind.annotation.ResponseBody;
@Controller
public class AdminController {
@Autowired
private AdminMapper adminmapper;
@RequestMapping("adminlist")
public String listadmin(Model model, HttpServletRequest request) {
System.out.println("adminid:" + request.getParameter("username"));
AdminBean admin = adminmapper.AdminListById(request.getParameter("username"));
model.addAttribute("Admin", admin);
return "manager_list";
}
@RequestMapping("admineditpassword")
public String editpassword(String oldpassword, String newpassword, String repassword, Model model,
HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
System.out.println("adminid:" + request.getParameter("username"));
AdminBean admin = new AdminBean();
admin = adminmapper.AdminListById(request.getParameter("username"));
if (!oldpassword.equals(admin.getAdmin_password())) {
String error=new String("密码错误");
request.setAttribute("error", error);
return "admin_password";
}
if (!newpassword.equals(repassword)) {
String error=new String("两次密码不一致");
request.setAttribute("error", error);
return "admin_password";
}
admin.setAdmin_password(newpassword);
adminmapper.updateAdminpwd(admin);
System.out.println(admin + "**********************");
AdminBean admin1 = adminmapper.AdminListById(admin.getAdmin_id());
model.addAttribute("admin", admin1);
return "forward:adminlist.do";
}
@RequestMapping("manageredit")
public String manageredit(String admin_name, Model model, HttpServletRequest request) {
System.out.println("adminid:" + request.getParameter("username"));
AdminBean admin = new AdminBean();
admin = adminmapper.AdminListById(request.getParameter("username"));
admin.setAdmin_name(admin_name);
adminmapper.updateAdmin(admin);
AdminBean admin1 = adminmapper.AdminListById(admin.getAdmin_id());
model.addAttribute("admin", admin1);
return "forward:adminlist.do";
}
@RequestMapping(value="allGongAdjus",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allGongAdjus(Model model,String username)
{
List<AdjuBean> allAdjus=adminmapper.allGongjurylist();
JsonObject jsonObject=JsonObject.success();
jsonObject.setCount(allAdjus.size());
jsonObject.add("data",allAdjus);
return JSONObject.toJSONString(jsonObject);
}
@RequestMapping(value="allLiAdjus",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allLiAdjus(Model model,String username)
{
List<AdjuBean> allAdjus=adminmapper.allLijurylist();
JsonObject jsonObject=JsonObject.success();
jsonObject.setCount(allAdjus.size());
jsonObject.add("data",allAdjus);
return JSONObject.toJSONString(jsonObject);
}
@RequestMapping(value="allJingAdjus",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allJingAdjus(Model model,String username)
{
List<AdjuBean> allAdjus=adminmapper.allJingjurylist();
JsonObject jsonObject=JsonObject.success();
jsonObject.setCount(allAdjus.size());
jsonObject.add("data",allAdjus);
return JSONObject.toJSONString(jsonObject);
}
@RequestMapping(value="allJiaoAdjus",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allJiaoAdjus(Model model,String username)
{
List<AdjuBean> allAdjus=adminmapper.allJiaojurylist();
JsonObject jsonObject=JsonObject.success();
jsonObject.setCount(allAdjus.size());
jsonObject.add("data",allAdjus);
return JSONObject.toJSONString(jsonObject);
}
@RequestMapping(value="allNongAdjus",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allNongAdjus(Model model,String username)
{
List<AdjuBean> allAdjus=adminmapper.allNongjurylist();
JsonObject jsonObject=JsonObject.success();
jsonObject.setCount(allAdjus.size());
jsonObject.add("data",allAdjus);
return JSONObject.toJSONString(jsonObject);
}
@RequestMapping(value="allZheAdjus",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allZheAdjus(Model model,String username)
{
List<AdjuBean> allAdjus=adminmapper.allZhejurylist();
JsonObject jsonObject=JsonObject.success();
jsonObject.setCount(allAdjus.size());
jsonObject.add("data",allAdjus);
return JSONObject.toJSONString(jsonObject);
}
@RequestMapping(value="allYiAdjus",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allYiAdjus(Model model,String username)
{
List<AdjuBean> allAdjus=adminmapper.allYijurylist();
JsonObject jsonObject=JsonObject.success();
jsonObject.setCount(allAdjus.size());
jsonObject.add("data",allAdjus);
return JSONObject.toJSONString(jsonObject);
}
@RequestMapping(value="allYishuAdjus",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allYishuAdjus(Model model,String username)
{
List<AdjuBean> allAdjus=adminmapper.allYishujurylist();
JsonObject jsonObject=JsonObject.success();
jsonObject.setCount(allAdjus.size());
jsonObject.add("data",allAdjus);
return JSONObject.toJSONString(jsonObject);
}
//使用
@RequestMapping(value="notDistributeAdjus",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String notDistributeaAjus(Model model)
{
List<AdjuBean> notDistributeAdjus=adminmapper.notDistributeAdjus();
JsonObject jsonObject=JsonObject.success();
jsonObject.setCount(notDistributeAdjus.size());
jsonObject.add("data",notDistributeAdjus);
return JSONObject.toJSONString(jsonObject);
}
//使用
@RequestMapping(value="deleteAdju",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String deleteAdju(String adjudicator_id,Model model)
{
if(adminmapper.DeleteByAdjuId(adjudicator_id)!=0)
{
JsonObject jsonObject=JsonObject.success();
return JSONObject.toJSONString(jsonObject);
}
else
{
JsonObject jsonObject=JsonObject.fail();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="deleteStu",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String deleteStu(String student_id,Model model)
{
if(adminmapper.DeleteByStudentId(student_id)!=0)
{
JsonObject jsonObject=JsonObject.success();
return JSONObject.toJSONString(jsonObject);
}
else
{
JsonObject jsonObject=JsonObject.fail();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="deletePro",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String deletePro(String project_id,Model model)
{
if(adminmapper.DeleteByProjectId(Integer.parseInt(project_id))!=0)
{
JsonObject jsonObject=JsonObject.success();
return JSONObject.toJSONString(jsonObject);
}
else
{
JsonObject jsonObject=JsonObject.fail();
return JSONObject.toJSONString(jsonObject);
}
}
// 专家选入各个专家组
@RequestMapping(value="chooseGongAdju",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String chooseGongAdju(Model model,String adjudicator_id)
{
Integer judgenum=adminmapper.selectIfHasjudgeByAdju(adjudicator_id);
Integer projectnum=adminmapper.selectGongProjectNum();
if(projectnum==0)
{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
else if(!judgenum.equals(projectnum))
{
adminmapper.deleteJudgeByAdju(adjudicator_id);
List<ProjectBean> projectBeanList=adminmapper.allGongProjects();
for(int i=0;i<projectnum;i++)
{
int project_id=projectBeanList.get(i).getProject_id();
String project_name=projectBeanList.get(i).getProject_name();
adminmapper.insertJudgeByAdju(project_id,adjudicator_id,project_name);
}
AdjuBean adjuBean=adminmapper.FindbyIdAdju(adjudicator_id);
adjuBean.setIsdistributed(1);
adminmapper.updateAdju(adjuBean);
JsonObject jsonObject=JsonObject.success();
return JSONObject.toJSONString(jsonObject);
}else
{
JsonObject jsonObject=JsonObject.fail10();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="chooseLiAdju",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String chooseLiAdju(Model model,String adjudicator_id)
{
Integer judgenum=adminmapper.selectIfHasjudgeByAdju(adjudicator_id);
Integer projectnum=adminmapper.selectLiProjectNum();
if(projectnum==0)
{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
else if(!judgenum.equals(projectnum))
{
adminmapper.deleteJudgeByAdju(adjudicator_id);
List<ProjectBean> projectBeanList=adminmapper.allLiProjects();
for(int i=0;i<projectnum;i++)
{
int project_id=projectBeanList.get(i).getProject_id();
String project_name=projectBeanList.get(i).getProject_name();
adminmapper.insertJudgeByAdju(project_id,adjudicator_id,project_name);
}
AdjuBean adjuBean=adminmapper.FindbyIdAdju(adjudicator_id);
adjuBean.setIsdistributed(1);
adminmapper.updateAdju(adjuBean);
JsonObject jsonObject=JsonObject.success();
return JSONObject.toJSONString(jsonObject);
}else
{
JsonObject jsonObject=JsonObject.fail10();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="chooseJingAdju",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String chooseJingAdju(Model model,String adjudicator_id)
{
Integer judgenum=adminmapper.selectIfHasjudgeByAdju(adjudicator_id);
Integer projectnum=adminmapper.selectJingProjectNum();
if(projectnum==0)
{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
else if(!judgenum.equals(projectnum))
{
adminmapper.deleteJudgeByAdju(adjudicator_id);
List<ProjectBean> projectBeanList=adminmapper.allJingProjects();
for(int i=0;i<projectnum;i++)
{
int project_id=projectBeanList.get(i).getProject_id();
String project_name=projectBeanList.get(i).getProject_name();
adminmapper.insertJudgeByAdju(project_id,adjudicator_id,project_name);
}
AdjuBean adjuBean=adminmapper.FindbyIdAdju(adjudicator_id);
adjuBean.setIsdistributed(1);
adminmapper.updateAdju(adjuBean);
JsonObject jsonObject=JsonObject.success();
return JSONObject.toJSONString(jsonObject);
}else
{
JsonObject jsonObject=JsonObject.fail10();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="chooseJiaoAdju",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String chooseJiaoAdju(Model model,String adjudicator_id)
{
Integer judgenum=adminmapper.selectIfHasjudgeByAdju(adjudicator_id);
Integer projectnum=adminmapper.selectJiaoProjectNum();
if(projectnum==0)
{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
else if(!judgenum.equals(projectnum))
{
adminmapper.deleteJudgeByAdju(adjudicator_id);
List<ProjectBean> projectBeanList=adminmapper.allJiaoProjects();
for(int i=0;i<projectnum;i++)
{
int project_id=projectBeanList.get(i).getProject_id();
String project_name=projectBeanList.get(i).getProject_name();
adminmapper.insertJudgeByAdju(project_id,adjudicator_id,project_name);
}
AdjuBean adjuBean=adminmapper.FindbyIdAdju(adjudicator_id);
adjuBean.setIsdistributed(1);
adminmapper.updateAdju(adjuBean);
JsonObject jsonObject=JsonObject.success();
return JSONObject.toJSONString(jsonObject);
}else
{
JsonObject jsonObject=JsonObject.fail10();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="chooseNongAdju",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String chooseNongAdju(Model model,String adjudicator_id)
{
Integer judgenum=adminmapper.selectIfHasjudgeByAdju(adjudicator_id);
Integer projectnum=adminmapper.selectNongProjectNum();
if(projectnum==0)
{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
else if(!judgenum.equals(projectnum))
{
adminmapper.deleteJudgeByAdju(adjudicator_id);
List<ProjectBean> projectBeanList=adminmapper.allNongProjects();
for(int i=0;i<projectnum;i++)
{
int project_id=projectBeanList.get(i).getProject_id();
String project_name=projectBeanList.get(i).getProject_name();
adminmapper.insertJudgeByAdju(project_id,adjudicator_id,project_name);
}
AdjuBean adjuBean=adminmapper.FindbyIdAdju(adjudicator_id);
adjuBean.setIsdistributed(1);
adminmapper.updateAdju(adjuBean);
JsonObject jsonObject=JsonObject.success();
return JSONObject.toJSONString(jsonObject);
}else
{
JsonObject jsonObject=JsonObject.fail10();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="chooseZheAdju",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String chooseZheAdju(Model model,String adjudicator_id)
{
Integer judgenum=adminmapper.selectIfHasjudgeByAdju(adjudicator_id);
Integer projectnum=adminmapper.selectZheProjectNum();
if(projectnum==0)
{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
else if(!judgenum.equals(projectnum))
{
adminmapper.deleteJudgeByAdju(adjudicator_id);
List<ProjectBean> projectBeanList=adminmapper.allZheProjects();
for(int i=0;i<projectnum;i++)
{
int project_id=projectBeanList.get(i).getProject_id();
String project_name=projectBeanList.get(i).getProject_name();
adminmapper.insertJudgeByAdju(project_id,adjudicator_id,project_name);
}
AdjuBean adjuBean=adminmapper.FindbyIdAdju(adjudicator_id);
adjuBean.setIsdistributed(1);
adminmapper.updateAdju(adjuBean);
JsonObject jsonObject=JsonObject.success();
return JSONObject.toJSONString(jsonObject);
}else
{
JsonObject jsonObject=JsonObject.fail10();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="chooseYiAdju",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String chooseYiAdju(Model model,String adjudicator_id)
{
Integer judgenum=adminmapper.selectIfHasjudgeByAdju(adjudicator_id);
Integer projectnum=adminmapper.selectYiProjectNum();
if(projectnum==0)
{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
else if(!judgenum.equals(projectnum))
{
adminmapper.deleteJudgeByAdju(adjudicator_id);
List<ProjectBean> projectBeanList=adminmapper.allYiProjects();
for(int i=0;i<projectnum;i++)
{
int project_id=projectBeanList.get(i).getProject_id();
String project_name=projectBeanList.get(i).getProject_name();
adminmapper.insertJudgeByAdju(project_id,adjudicator_id,project_name);
}
AdjuBean adjuBean=adminmapper.FindbyIdAdju(adjudicator_id);
adjuBean.setIsdistributed(1);
adminmapper.updateAdju(adjuBean);
JsonObject jsonObject=JsonObject.success();
return JSONObject.toJSONString(jsonObject);
}else
{
JsonObject jsonObject=JsonObject.fail10();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="chooseYishuAdju",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String chooseYishuAdju(Model model,String adjudicator_id)
{
Integer judgenum=adminmapper.selectIfHasjudgeByAdju(adjudicator_id);
Integer projectnum=adminmapper.selectYishuProjectNum();
if(projectnum==0)
{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
else if(!judgenum.equals(projectnum))
{
adminmapper.deleteJudgeByAdju(adjudicator_id);
List<ProjectBean> projectBeanList=adminmapper.allYishuProjects();
for(int i=0;i<projectnum;i++)
{
int project_id=projectBeanList.get(i).getProject_id();
String project_name=projectBeanList.get(i).getProject_name();
adminmapper.insertJudgeByAdju(project_id,adjudicator_id,project_name);
}
AdjuBean adjuBean=adminmapper.FindbyIdAdju(adjudicator_id);
adjuBean.setIsdistributed(1);
adminmapper.updateAdju(adjuBean);
JsonObject jsonObject=JsonObject.success();
return JSONObject.toJSONString(jsonObject);
}else
{
JsonObject jsonObject=JsonObject.fail10();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="quitDistribute",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String quitDistribute(String adjudicator_id)
{
if(adminmapper.FindbyIdAdju(adjudicator_id).getIsdistributed()==1)
{
if(adminmapper.deleteJudgeByAdju(adjudicator_id)!=0)
{
AdjuBean adjuBean=adminmapper.FindbyIdAdju(adjudicator_id);
adjuBean.setIsdistributed(0);
adminmapper.updateAdju(adjuBean);
JsonObject jsonObject = JsonObject.success();
return JSONObject.toJSONString(jsonObject);
}
else {
JsonObject jsonObject = JsonObject.fail09();
return JSONObject.toJSONString(jsonObject);
}
}
else
{
JsonObject jsonObject=JsonObject.fail09();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value = "execelOut",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String execelOut(HttpServletResponse response,int projectIdList[]){
try{
List<ProjectBean> projectList= new ArrayList<>();
for (int i = 0; i < projectIdList.length; i++) {
ProjectBean projectBean=adminmapper.projectById(projectIdList[i]);
projectList.add(projectBean);
}
ServletOutputStream outStream = response.getOutputStream();
response.setContentType("application/vnd.ms-excel");
response.setCharacterEncoding("utf-8");
//设置防止文件名中文乱码
String fileName = URLEncoder.encode("请依据此文件确定校级和推荐省级","utf-8");
response.setHeader("Content-disposition", "attachment;filename="+ fileName + ".xlsx");
//构建写入到Excel中的数据(此数据可以从数据库中获取)
Set<String> excludeColumnFiledNames = new HashSet<>();
//排除掉hireDate和userName字段
excludeColumnFiledNames.add("project_subject");
excludeColumnFiledNames.add("all_adju_num");
excludeColumnFiledNames.add("now_adju_num");
excludeColumnFiledNames.add("file_name");
excludeColumnFiledNames.add("bz");
EasyExcel.write(outStream, ProjectBean.class)
.excludeColumnFiledNames(excludeColumnFiledNames)
.sheet("确定和推荐")
// 设置字段宽度为自动调整,不太精确
.registerWriteHandler(new LongestMatchColumnWidthStyleStrategy())
.doWrite(projectList);}
catch (IOException e)
{
e.printStackTrace();
}
JsonObject jsonObject=JsonObject.success();
return JSONObject.toJSONString(jsonObject);
}
@RequestMapping(value = "submitSchoolLevel",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String submitSchoolLevel(HttpServletResponse response,int projectIdList[]){
try{
List<ProjectBean> projectList= new ArrayList<>();
List<ProjectBean> projectList1= new ArrayList<>();
for (int i = 0; i < projectIdList.length; i++) {
ProjectBean projectBean=adminmapper.projectById(projectIdList[i]);
if(projectBean.getProject_level()!=null){
if(projectBean.getProject_level().equals("校级")||projectBean.getProject_level().equals("省级"))
{
projectList1.add(projectBean);
continue;
}
}
projectList.add(projectBean);
projectList1.add(projectBean);
projectBean.setProject_level("校级");
adminmapper.updateProject(projectBean);
adminmapper.insertToSchoolTemplet(projectBean);
}
ServletOutputStream outStream = response.getOutputStream();
response.setContentType("application/vnd.ms-excel");
response.setCharacterEncoding("utf-8");
//设置防止文件名中文乱码
String fileName = URLEncoder.encode("此文件中项目将是校级项目","utf-8");
response.setHeader("Content-disposition", "attachment;filename="+ fileName + ".xlsx");
//构建写入到Excel中的数据(此数据可以从数据库中获取)
Set<String> excludeColumnFiledNames = new HashSet<>();
//排除掉hireDate和userName字段
excludeColumnFiledNames.add("project_subject");
excludeColumnFiledNames.add("all_adju_num");
excludeColumnFiledNames.add("now_adju_num");
excludeColumnFiledNames.add("file_name");
excludeColumnFiledNames.add("bz");
EasyExcel.write(outStream, ProjectBean.class)
.excludeColumnFiledNames(excludeColumnFiledNames)
.sheet("确定和推荐")
// 设置字段宽度为自动调整,不太精确
.registerWriteHandler(new LongestMatchColumnWidthStyleStrategy())
.doWrite(projectList1);}
catch (IOException e)
{
e.printStackTrace();
}
JsonObject jsonObject=JsonObject.success();
return JSONObject.toJSONString(jsonObject);
}
@RequestMapping(value = "recommendProvinceLevel",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String recommendProvinceLevel(HttpServletResponse response,int projectIdList[]){
try{
List<ProjectBean> projectList= new ArrayList<>();
List<ProjectBean> projectList1= new ArrayList<>();
for (int i = 0; i < projectIdList.length; i++) {
ProjectBean projectBean=adminmapper.projectById(projectIdList[i]);
if(projectBean.getProject_level().equals("省级"))
{
projectList1.add(projectBean);
continue;
}
projectList.add(projectBean);
projectList1.add(projectBean);
projectBean.setProject_level("省级");
adminmapper.updateProject(projectBean);
adminmapper.insertToProvinceTemplet(projectBean);
}
ServletOutputStream outStream = response.getOutputStream();
response.setContentType("application/vnd.ms-excel");
response.setCharacterEncoding("utf-8");
//设置防止文件名中文乱码
String fileName = URLEncoder.encode("此文件中项目将是省级项目","utf-8");
response.setHeader("Content-disposition", "attachment;filename="+ fileName + ".xlsx");
//构建写入到Excel中的数据(此数据可以从数据库中获取)
Set<String> excludeColumnFiledNames = new HashSet<>();
//排除掉hireDate和userName字段
excludeColumnFiledNames.add("project_id");
excludeColumnFiledNames.add("project_subject");
excludeColumnFiledNames.add("all_adju_num");
excludeColumnFiledNames.add("now_adju_num");
excludeColumnFiledNames.add("file_name");
excludeColumnFiledNames.add("bz");
EasyExcel.write(outStream, ProjectBean.class)
.excludeColumnFiledNames(excludeColumnFiledNames)
.sheet("推荐")
// 设置字段宽度为自动调整,不太精确
.registerWriteHandler(new LongestMatchColumnWidthStyleStrategy())
.doWrite(projectList1);}
catch (Exception e)
{
e.printStackTrace();
}
JsonObject jsonObject=JsonObject.success();
return JSONObject.toJSONString(jsonObject);
}
@RequestMapping(value="allprojects",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allprojects(String username, Model model) {
List<ProjectBean> projectBeanList=adminmapper.allProjects();
if(projectBeanList.size()!=0||projectBeanList!=null)
{
JsonObject jsonObject=JsonObject.success();
jsonObject.add("data",projectBeanList);
jsonObject.setCount(projectBeanList.size());
return JSONObject.toJSONString(jsonObject);
}
else{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="allschoolprojects",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allschoolprojects(String username, Model model) {
List<ProjectBean> projectBeanList=adminmapper.allSchoolProjects();
if(projectBeanList.size()!=0||projectBeanList!=null)
{
JsonObject jsonObject=JsonObject.success();
jsonObject.add("data",projectBeanList);
jsonObject.setCount(projectBeanList.size());
return JSONObject.toJSONString(jsonObject);
}
else{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="allgongprojects",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allgongproject(String username, Model model,HttpServletResponse response) throws IOException {
List<ProjectBean> projectBeanList = adminmapper.allGongProjects();
if (projectBeanList.size() != 0 || projectBeanList != null) {
JsonObject jsonObject = JsonObject.success();
jsonObject.add("data", projectBeanList);
jsonObject.setCount(projectBeanList.size());
return JSONObject.toJSONString(jsonObject);
} else {
JsonObject jsonObject = JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="allgongschoolprojects",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allgongschoolprojects(String username, Model model,HttpServletResponse response) throws IOException {
List<ProjectBean> projectBeanList = adminmapper.allGongSchoolProjects();
if (projectBeanList.size() != 0 || projectBeanList != null) {
JsonObject jsonObject = JsonObject.success();
jsonObject.add("data", projectBeanList);
jsonObject.setCount(projectBeanList.size());
return JSONObject.toJSONString(jsonObject);
} else {
JsonObject jsonObject = JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="allliprojects",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allliproject(String username, Model model) {
List<ProjectBean> projectBeanList=adminmapper.allLiProjects();
if(projectBeanList.size()!=0||projectBeanList!=null)
{
JsonObject jsonObject=JsonObject.success();
jsonObject.add("data",projectBeanList);
jsonObject.setCount(projectBeanList.size());
return JSONObject.toJSONString(jsonObject);
}
else{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="alllischoolprojects",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String alllischoolprojects(String username, Model model) {
List<ProjectBean> projectBeanList=adminmapper.allLiSchoolProjects();
if(projectBeanList.size()!=0||projectBeanList!=null)
{
JsonObject jsonObject=JsonObject.success();
jsonObject.add("data",projectBeanList);
jsonObject.setCount(projectBeanList.size());
return JSONObject.toJSONString(jsonObject);
}
else{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="alljingprojects",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String alljingprojects(String username, Model model) {
List<ProjectBean> projectBeanList=adminmapper.allJingProjects();
if(projectBeanList.size()!=0||projectBeanList!=null)
{
JsonObject jsonObject=JsonObject.success();
jsonObject.add("data",projectBeanList);
jsonObject.setCount(projectBeanList.size());
return JSONObject.toJSONString(jsonObject);
}
else{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="alljingschoolprojects",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String alljingschoolprojects(String username, Model model) {
List<ProjectBean> projectBeanList=adminmapper.allJingSchoolProjects();
if(projectBeanList.size()!=0||projectBeanList!=null)
{
JsonObject jsonObject=JsonObject.success();
jsonObject.add("data",projectBeanList);
jsonObject.setCount(projectBeanList.size());
return JSONObject.toJSONString(jsonObject);
}
else{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="alljiaoprojects",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String alljiaoprojects(String username, Model model) {
List<ProjectBean> projectBeanList=adminmapper.allJiaoProjects();
if(projectBeanList.size()!=0||projectBeanList!=null)
{
JsonObject jsonObject=JsonObject.success();
jsonObject.add("data",projectBeanList);
jsonObject.setCount(projectBeanList.size());
return JSONObject.toJSONString(jsonObject);
}
else{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="alljiaoschoolprojects",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String alljiaoschoolprojects(String username, Model model) {
List<ProjectBean> projectBeanList=adminmapper.allJiaoSchoolProjects();
if(projectBeanList.size()!=0||projectBeanList!=null)
{
JsonObject jsonObject=JsonObject.success();
jsonObject.add("data",projectBeanList);
jsonObject.setCount(projectBeanList.size());
return JSONObject.toJSONString(jsonObject);
}
else{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="allnongprojects",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allnongprojects(String username, Model model) {
List<ProjectBean> projectBeanList=adminmapper.allNongProjects();
if(projectBeanList.size()!=0||projectBeanList!=null)
{
JsonObject jsonObject=JsonObject.success();
jsonObject.add("data",projectBeanList);
jsonObject.setCount(projectBeanList.size());
return JSONObject.toJSONString(jsonObject);
}
else{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="allnongschoolprojects",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allnongschoolprojects(String username, Model model) {
List<ProjectBean> projectBeanList=adminmapper.allNongSchoolProjects();
if(projectBeanList.size()!=0||projectBeanList!=null)
{
JsonObject jsonObject=JsonObject.success();
jsonObject.add("data",projectBeanList);
jsonObject.setCount(projectBeanList.size());
return JSONObject.toJSONString(jsonObject);
}
else{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="allzheprojects",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allzheprojects(String username, Model model) {
List<ProjectBean> projectBeanList=adminmapper.allZheProjects();
if(projectBeanList.size()!=0||projectBeanList!=null)
{
JsonObject jsonObject=JsonObject.success();
jsonObject.add("data",projectBeanList);
jsonObject.setCount(projectBeanList.size());
return JSONObject.toJSONString(jsonObject);
}
else{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="allzheschoolprojects",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allzheschoolprojects(String username, Model model) {
List<ProjectBean> projectBeanList=adminmapper.allZheSchoolProjects();
if(projectBeanList.size()!=0||projectBeanList!=null)
{
JsonObject jsonObject=JsonObject.success();
jsonObject.add("data",projectBeanList);
jsonObject.setCount(projectBeanList.size());
return JSONObject.toJSONString(jsonObject);
}
else{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="allyiprojects",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allyiprojects(String username, Model model) {
List<ProjectBean> projectBeanList=adminmapper.allYiProjects();
if(projectBeanList.size()!=0||projectBeanList!=null)
{
JsonObject jsonObject=JsonObject.success();
jsonObject.add("data",projectBeanList);
jsonObject.setCount(projectBeanList.size());
return JSONObject.toJSONString(jsonObject);
}
else{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="allyischoolprojects",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allyischoolprojects(String username, Model model) {
List<ProjectBean> projectBeanList=adminmapper.allYiSchoolProjects();
if(projectBeanList.size()!=0||projectBeanList!=null)
{
JsonObject jsonObject=JsonObject.success();
jsonObject.add("data",projectBeanList);
jsonObject.setCount(projectBeanList.size());
return JSONObject.toJSONString(jsonObject);
}
else{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="allyishuprojects",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allyishuprojects(String username, Model model) {
List<ProjectBean> projectBeanList=adminmapper.allYishuProjects();
if(projectBeanList.size()!=0||projectBeanList!=null)
{
JsonObject jsonObject=JsonObject.success();
jsonObject.add("data",projectBeanList);
jsonObject.setCount(projectBeanList.size());
return JSONObject.toJSONString(jsonObject);
}
else{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="allyishuschoolprojects",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String allyishuschoolprojects(String username, Model model) {
List<ProjectBean> projectBeanList=adminmapper.allYishuSchoolProjects();
if(projectBeanList.size()!=0||projectBeanList!=null)
{
JsonObject jsonObject=JsonObject.success();
jsonObject.add("data",projectBeanList);
jsonObject.setCount(projectBeanList.size());
return JSONObject.toJSONString(jsonObject);
}
else{
JsonObject jsonObject=JsonObject.fail11();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="studentlist",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String studentlist(Model model,HttpServletResponse response)
{
List<StudentBean> student = adminmapper.allstudentlist();
JsonObject jsonObject=JsonObject.success();
jsonObject.setCount(student.size());
jsonObject.add("data",student);
return JSONObject.toJSONString(jsonObject);
}
@RequestMapping(value="studentlistById",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String studentlistById(Model model,String name,HttpServletResponse response)
{
List<StudentBean> student = adminmapper.studentlistById(name);
JsonObject jsonObject=JsonObject.success();
jsonObject.setCount(student.size());
jsonObject.add("data",student);
return JSONObject.toJSONString(jsonObject);
}
// @RequestMapping("jurylist")
// public String jurylist(String username, Model model) {
//
// List<AdjuBean> jury = adminmapper.alljurylist();
// model.addAttribute("jury", jury);
//
// return "jury_information_list";
//
// }
@RequestMapping("deletejuryproject")
public String deletejuryproject(HttpServletRequest request, Model model) {
String judge_id = request.getParameter("judge_id");
adminmapper.DeleteByJudgeId(judge_id);
return "forward:juryprojectlist.do";
}
@RequestMapping(value="juryUpdate",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String juryUpdate(AdjuBean adjuBean,Model model) {
String id =adjuBean.getAdjudicator_id();
String phonenum=adjuBean.getAdjudicator_phonenum();
int num=adminmapper.FindbyAdju(id);
if(!id.matches("^\\d{6}$")|| !phonenum.matches("^1([38][0-9]|4[579]|5[0-3,5-9]|6[6]|7[0135678]|9[89])\\d{8}$"))
{
return JSONObject.toJSONString(JsonObject.fail09());
}
if (num != 0) {
AdjuBean adjuBean1=adminmapper.FindbyIdAdju(id);
adjuBean1.setAdjudicator_name(adjuBean.getAdjudicator_name());
adjuBean1.setAdjudicator_phonenum(adjuBean.getAdjudicator_phonenum());
if(adminmapper.updateAdju(adjuBean1)!=0) {
return JSONObject.toJSONString(JsonObject.success());
}
else {
return JSONObject.toJSONString(JsonObject.fail09());
}
}
else
{
return JSONObject.toJSONString(JsonObject.fail());
}
}
@RequestMapping(value="juryAdd")
public String juryAdd(AdjuBean adjuBean,Model model) {
String id =adjuBean.getAdjudicator_id();
String phonenum=adjuBean.getAdjudicator_phonenum();
int num=adminmapper.FindbyAdju(id);
int isHasAdju = Integer.valueOf(num);
if(!id.matches("^\\d{6}$")|| !phonenum.matches("^1([38][0-9]|4[579]|5[0-3,5-9]|6[6]|7[0135678]|9[89])\\d{8}$"))
{
model.addAttribute("error","工号或手机号格式不正确");
model.addAttribute("adju",adjuBean);
return "jury_information_add";
}
if (isHasAdju == 0) {
if(adminmapper.insertjury(adjuBean)!=0) {
model.addAttribute("error","添加成功");
model.addAttribute("adju",adjuBean);
return "jury_information_add";
}
else {
model.addAttribute("error","添加失败");
model.addAttribute("adju",adjuBean);
return "jury_information_add";
}
}
else
{
model.addAttribute("error","已有此用户,请重新填写");
model.addAttribute("adju",adjuBean);
return "jury_information_add";
}
}
@RequestMapping(value="stuUpdate",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String stuUpdate(StudentBean student,String student_sex,Model model) {
String id = student.getStudent_id();
String phonenum = student.getStudent_phonenumber();
String clazz = student.getStudent_class();
String college = student.getStudent_college();
String name = student.getStudent_name();
if (!phonenum.matches("^1([38][0-9]|4[579]|5[0-3,5-9]|6[6]|7[0135678]|9[89])\\d{8}$")) {
return JSONObject.toJSONString(JsonObject.fail09());
}
StudentBean studentBean = adminmapper.selectStuById(id);
studentBean.setStudent_name(name);
studentBean.setStudent_sex(student_sex);
studentBean.setStudent_class(clazz);
studentBean.setStudent_college(college);
studentBean.setStudent_phonenumber(phonenum);
if (adminmapper.updateStu(studentBean) != 0) {
return JSONObject.toJSONString(JsonObject.success());
} else {
return JSONObject.toJSONString(JsonObject.fail09());
}
}
@RequestMapping("juryprojectlist")
public String juryprojectlist(String username, Model model) {
List<JudgeBean> jury = adminmapper.allJudges();
model.addAttribute("alljury", jury);
return "all_judges";
}
//各个组的评审专家
@RequestMapping("adminChoosegongAdju")
public String adminChoosegongAdju(Model model)
{
int distributednums=adminmapper.gongdistributedAdjuNum();
model.addAttribute("distributednums",distributednums);
return "admin_gong_adjus";
}
@RequestMapping("adminChooseliAdju")
public String adminChooseliAdju(Model model)
{
int distributednums=adminmapper.lidistributedAdjuNum();
model.addAttribute("distributednums",distributednums);
return "admin_li_adjus";
}
@RequestMapping("adminChoosejingAdju")
public String adminChoosejingAdju(Model model)
{
int distributednums=adminmapper.jingdistributedAdjuNum();
model.addAttribute("distributednums",distributednums);
return "admin_jing_adjus";
}
@RequestMapping("adminChoosejiaoAdju")
public String adminChoosejiaoAdju(Model model)
{
int distributednums=adminmapper.jiaodistributedAdjuNum();
model.addAttribute("distributednums",distributednums);
return "admin_jiao_adjus";
}
@RequestMapping("adminChoosenongAdju")
public String adminChoosenongAdju(Model model)
{
int distributednums=adminmapper.nongdistributedAdjuNum();
model.addAttribute("distributednums",distributednums);
return "admin_nong_adjus";
}
@RequestMapping("adminChoosezheAdju")
public String adminChoosezheAdju(Model model)
{
int distributednums=adminmapper.zhedistributedAdjuNum();
model.addAttribute("distributednums",distributednums);
return "admin_zhe_adjus";
}
@RequestMapping("adminChooseyiAdju")
public String adminChooseyiAdju(Model model)
{
int distributednums=adminmapper.yidistributedAdjuNum();
model.addAttribute("distributednums",distributednums);
return "admin_yi_adjus";
}
@RequestMapping("adminChooseyishuAdju")
public String adminChooseyishuAdju(Model model)
{
int distributednums=adminmapper.yishudistributedAdjuNum();
model.addAttribute("distributednums",distributednums);
return "admin_yishu_adjus";
}
@RequestMapping("openapply")
@ResponseBody
public String openapply()
{
adminmapper.openapply();
return null;
}
@RequestMapping("closeapply")
@ResponseBody
public String closeapply()
{
adminmapper.closeapply();
return null;
}
@RequestMapping("opencommit")
@ResponseBody
public String opencommit()
{
adminmapper.opencommit();
return null;
}
@RequestMapping("closecommit")
@ResponseBody
public String closecommit()
{
adminmapper.closecommit();
return null;
}
@RequestMapping(value="lookjudges",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String lookjudges(HttpServletRequest request)
{
List<JudgeBean> judges=adminmapper.allJudges();
if(judges!=null||judges.size()!=0) {
JsonObject jsonObject = JsonObject.success();
jsonObject.setCount(judges.size());
jsonObject.add("data", judges);
return JSONObject.toJSONString(jsonObject);
}
JsonObject jsonObject=JsonObject.fail09();
return JSONObject.toJSONString(jsonObject);
}
@RequestMapping(value="searchJudgesByPro",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String searchJudgesByPro(HttpServletRequest request,String pro)
{
List<JudgeBean> judges = adminmapper.searchJudgesByPro(Integer.parseInt(pro));
if (judges != null || judges.size() != 0) {
JsonObject jsonObject = JsonObject.success();
jsonObject.setCount(judges.size());
jsonObject.add("data", judges);
return JSONObject.toJSONString(jsonObject);
}
else{
JsonObject jsonObject = JsonObject.fail09();
return JSONObject.toJSONString(jsonObject);
}
}
@RequestMapping(value="searchJudgesByAdju",produces = {"application/json;charset=utf-8"})
@ResponseBody
public String searchJudgesByAdju(HttpServletRequest request,String adju)
{
List<JudgeBean> judges=adminmapper.searchJudgesByAdju(adju);
if(judges!=null||judges.size()!=0) {
JsonObject jsonObject = JsonObject.success();
jsonObject.setCount(judges.size());
jsonObject.add("data", judges);
return JSONObject.toJSONString(jsonObject);
}
JsonObject jsonObject=JsonObject.fail09();
return JSONObject.toJSONString(jsonObject);
}
}