基于javaweb+mysql的ssm教师科研信息管理系统(java+ssm+jsp+js+mysql)

于 2023-07-23 20:44:40 发布
阅读量80 收藏
点赞数
文章标签： mysql java javascript
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_71414463/article/details/131884090
版权

基于javaweb+mysql的ssm教师科研信息管理系统(java+ssm+jsp+js+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb+mysql的SSM教师科研信息管理系统(java+ssm+jsp+js+mysql)

项目介绍

管理员角色包含以下功能： 管理员登录,用户列表管理,管理员管理,合同管理,项目管理,知识产权管理,科研信息统计等功能。

用户角色包含以下功能： 用户登录,本人合同管理,项目管理,知识产权管理,数据统计,个人信息管理等功能。

环境需要

1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可 4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS； 5.数据库：MySql 5.7版本；

技术栈

  1. 后端：Spring+SpringMVC+Mybatis 2. 前端：HTML+CSS+JavaScript+jsp

使用说明

  1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中application.yml配置文件中的数据库配置改为自己的配置; 4. 运行项目，输入localhost:8080/ 登录
	public String addPage(cqjb cqjb,HttpServletRequest request){
		Map<String,Object> map= new HashMap<String,Object>();
		
		System.out.println("addPageok");
		return "cqjb/cqjbadd";
	}
	
	@RequestMapping(value="/add")
	public String add(cqjb cqjb,HttpServletRequest request){
		Map<String,Object> map= new HashMap<String,Object>();
		//String name=(String)request.getParameter("name");

		map.put("cqjbid", cqjb.getCqjbid());//产权级别编号

		map.put("jb", cqjb.getJb());//级别

		cqjbdao.save(map);
		
		
		System.out.println("addok");
		return "cqjb/cqjbadd";
	}
	
	/**删除 
	 * 
	 */
	@RequestMapping(value="/del")
	public String  del(Integer id,HttpServletRequest request,Map<String,Object> map){
	//	Map<String,Object> map= new HashMap<String,Object>();
		String a=(String)request.getParameter("keyid");
		id=Integer.parseInt(a);
		cqjbdao.del(id);
		return selectall(null,map,request);
	}
	/**
	 * 修改cqjb信息
	 */
	@RequestMapping(value="/update")
	public String update(cqjb cqjb,HttpServletRequest request,Map<String,Object> map1){
		Map<String,Object> map= new HashMap<String,Object>();
		map.put("cqjbid", cqjb.getCqjbid());//产权级别编号

		map.put("jb", cqjb.getJb());//级别

		cqjbdao.update(map);
		return selectall(null,map1,request);
	}
	/**
	 * 查询cqjb信息

@Controller
@RequestMapping(value="/zscq")
public class zscqAction {
	/**
	 * 自动注入业务逻辑层，注入方式使用了注解自动注入
	 */

	@Resource zscqDao zscqdao;
	@RequestMapping(value="/addPage")
	public String addPage(zscq zscq,HttpServletRequest request){
		Map<String,Object> map= new HashMap<String,Object>();
		
		System.out.println("addPageok");
		return "zscq/zscqadd";
	}
	
	@RequestMapping(value="/add")
	public String add(zscq zscq,HttpServletRequest request){
		Map<String,Object> map= new HashMap<String,Object>();
		//String name=(String)request.getParameter("name");

		map.put("zscqid", zscq.getZscqid());//知识产权编号

		map.put("cqmc", zscq.getCqmc());//产权名称

		map.put("lx", zscq.getLx());//类型

		map.put("fj", zscq.getFj());//附件

		map.put("nr", zscq.getNr());//内容

		map.put("cqjb", zscq.getCqjb());//产权级别

		map.put("ytcg", zscq.getYtcg());//依托成果

		map.put("djr", zscq.getDjr());//登记人

		map.put("djsj", zscq.getDjsj());//登记时间

		zscqdao.save(map);
		

		map.put("htbh", hetong.getHtbh());//合同编号

		map.put("htnr", hetong.getHtnr());//合同内容

		map.put("qcsj", hetong.getQcsj());//起草时间

		map.put("qcr", hetong.getQcr());//起草人

		map.put("jf", hetong.getJf());//甲方

		map.put("jflxfs", hetong.getJflxfs());//甲方联系方式

		map.put("yf", hetong.getYf());//乙方

		map.put("yflxfs", hetong.getYflxfs());//乙方联系方式

		map.put("fj", hetong.getFj());//乙方联系方式
		String zt=hetong.getZt();
		
		
		String bgjl=(String)request.getParameter("bgjl");
		DBO db=new DBO();
		String sql="";
		try{
		if(zt.equals("未审核")){
		//只记录 变更情况，此种情况不需要 对变更记录审核 继续操作
			
			map.put("zt", hetong.getZt());//状态 //状态
			
			 sql="insert into htbg(htbh,bgsmbgr,sj,zt) values('"+hetong.getHtbh()+"','"+bgjl+"','"+StaticMethod.getStringDate()+"','通过')";//未审批过的不需要审核，直接默认 通过
			
		}else{
			//如果已经审核过了那么 会对 原来合同信息不进行审核了，需要对变更记录信息审核，审核通过了，才能对生效合同记录
			map.put("zt", "变更未审核");//状态 //状态
			 sql="insert into htbg(htbh,bgsmbgr,sj,zt) values('"+hetong.getHtbh()+"','"+bgjl+"','"+StaticMethod.getStringDate()+"','未审核')";//直接对变更记录审批信息审核，但是不能对合同审核了
		}
		
		db.update(sql);
		}catch(Exception e){
			e.printStackTrace();
		}
		
		
		

		hetongdao.update(map);
		return myselectall(null,map1,request);
	}
	/**
	 * 查询hetong信息
	 */

		request.setAttribute("qcr", list.get(0).get("qcr"));//起草人

		request.setAttribute("jf", list.get(0).get("jf"));//甲方

		request.setAttribute("jflxfs", list.get(0).get("jflxfs"));//甲方联系方式

		request.setAttribute("yf", list.get(0).get("yf"));//乙方

		request.setAttribute("yflxfs", list.get(0).get("yflxfs"));//乙方联系方式

		request.setAttribute("zt", list.get(0).get("zt"));//状态
		request.setAttribute("fj", list.get(0).get("fj"));//状态
		
		return "hetong/modify";
	}
	
	@RequestMapping(value="/detail")
	public String detail(Integer id,Map<String,Object> map,HttpServletRequest request){
		String keyid=(String)request.getParameter("keyid");
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
		list=hetongdao.select(Integer.parseInt(keyid));
		request.setAttribute("htid", list.get(0).get("htid"));//合同编号
		request.setAttribute("keyid", keyid);//合同编号
		request.setAttribute("htbt", list.get(0).get("htbt"));//合同标题

		request.setAttribute("htbh", list.get(0).get("htbh"));//合同编号

		request.setAttribute("htnr", list.get(0).get("htnr"));//合同内容

		request.setAttribute("qcsj", list.get(0).get("qcsj"));//起草时间

		request.setAttribute("qcr", list.get(0).get("qcr"));//起草人

		request.setAttribute("jf", list.get(0).get("jf"));//甲方

		request.setAttribute("jflxfs", list.get(0).get("jflxfs"));//甲方联系方式

		request.setAttribute("yf", list.get(0).get("yf"));//乙方

		request.setAttribute("yflxfs", list.get(0).get("yflxfs"));//乙方联系方式

		request.setAttribute("zt", list.get(0).get("zt"));//状态
		request.setAttribute("fj", list.get(0).get("fj"));//状态
		return "hetong/hetongdetail";
	}
	
	/**
	 * 查询hetong信息
	 */
	@RequestMapping(value="/selectall")
	public String selectall(Integer id,Map<String,Object> map,HttpServletRequest request){
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
	Map<String,Object> map1= new HashMap<String,Object>();


		zscqdao.update(map);
		return selectall(null,map1,request);
	}
	/**
	 * 查询zscq信息
	 */
	@RequestMapping(value="/modify")
	public String modify(Integer id,Map<String,Object> map,HttpServletRequest request){
		String keyid=(String)request.getParameter("keyid");
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
		list=zscqdao.select(Integer.parseInt(keyid));
		request.setAttribute("zscqid", list.get(0).get("zscqid"));//知识产权编号

		request.setAttribute("cqmc", list.get(0).get("cqmc"));//产权名称

		request.setAttribute("lx", list.get(0).get("lx"));//类型

		request.setAttribute("fj", list.get(0).get("fj"));//附件

		request.setAttribute("nr", list.get(0).get("nr"));//内容

		request.setAttribute("cqjb", list.get(0).get("cqjb"));//产权级别

		request.setAttribute("ytcg", list.get(0).get("ytcg"));//依托成果

		request.setAttribute("djr", list.get(0).get("djr"));//登记人

		request.setAttribute("djsj", list.get(0).get("djsj"));//登记时间

		
		return "zscq/zscqmodify";
	}
	
	@RequestMapping(value="/detail")
	public String detail(Integer id,Map<String,Object> map,HttpServletRequest request){
		String keyid=(String)request.getParameter("keyid");
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
		list=zscqdao.select(Integer.parseInt(keyid));
		request.setAttribute("zscqid", list.get(0).get("zscqid"));//知识产权编号

		request.setAttribute("cqmc", list.get(0).get("cqmc"));//产权名称

		request.setAttribute("lx", list.get(0).get("lx"));//类型


	public String selectall(Integer id,Map<String,Object> map,HttpServletRequest request){
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
	Map<String,Object> map1= new HashMap<String,Object>();
	String qx="",yhm="";
	
	if(request.getSession().getAttribute("yhm")!=null){
		qx=request.getSession().getAttribute("qx").toString();
		yhm=request.getSession().getAttribute("yhm").toString();
		if(!qx.equals("管理员"))
		map1.put("yhm", yhm);//标题
	}
		list=xmzjdao.selectAll(map1);
		System.out.println("listsize="+list.size());
		
		map.put("mylist", list);
		return "xmzj/xmzjlist";
	}
}
package com.action;

@Controller
@RequestMapping(value="/gly")
public class glyAction {
	/**
	 * 自动注入业务逻辑层，注入方式使用了注解自动注入
	 */

	@Resource glyDao glydao;
	@RequestMapping(value="/addPage")
	public String addPage(gly gly,HttpServletRequest request){
		Map<String,Object> map= new HashMap<String,Object>();

	 */

	@Resource xmzjDao xmzjdao;
	@RequestMapping(value="/addPage")
	public String addPage(xmzj xmzj,HttpServletRequest request){
		Map<String,Object> map= new HashMap<String,Object>();
		
		System.out.println("addPageok");
		return "xmzj/xmzjadd";
	}
	
	@RequestMapping(value="/add")
	public String add(xmzj xmzj,HttpServletRequest request){
		Map<String,Object> map= new HashMap<String,Object>();
		//String name=(String)request.getParameter("name");

		map.put("xmzjid", xmzj.getXmzjid());//项目中检编号

		map.put("xm", xmzj.getXm());//项目

		map.put("zjnr", xmzj.getZjnr());//中检内容

		map.put("yh", xmzj.getYh());//用户

		map.put("sj", xmzj.getSj());//时间

		xmzjdao.save(map);
		
		try{
		String sql="update xiangmu set xmjd='中检' where xmid='"+xmzj.getXm()+"'";
		DBO db=new DBO();
		db.update(sql);
		}catch(Exception e){
			
			e.printStackTrace();
		}
		
		
		System.out.println("addok");
		return "xmzj/xmzjadd";
	}
	
	/**删除 
	 * 
	 */
	@RequestMapping(value="/del")
	public String  del(Integer id,HttpServletRequest request,Map<String,Object> map){
	//	Map<String,Object> map= new HashMap<String,Object>();
		String a=(String)request.getParameter("keyid");
		id=Integer.parseInt(a);

		System.out.println("addPageok");
		return "xmbg/xmbgadd";
	}
	
	@RequestMapping(value="/add")
	public String add(xmbg xmbg,HttpServletRequest request){
		Map<String,Object> map= new HashMap<String,Object>();
		//String name=(String)request.getParameter("name");

		map.put("xmbgid", xmbg.getXmbgid());//项目变更编号

		map.put("xm", xmbg.getXm());//项目

		map.put("bgnr", xmbg.getBgnr());//变更内容

		map.put("xmsm", xmbg.getXmsm());//项目说明

		xmbgdao.save(map);
		
		
		System.out.println("addok");
		return "xmbg/xmbgadd";
	}
	
	/**删除 
	 * 
	 */
	@RequestMapping(value="/del")
	public String  del(Integer id,HttpServletRequest request,Map<String,Object> map){
	//	Map<String,Object> map= new HashMap<String,Object>();
		String a=(String)request.getParameter("keyid");
		id=Integer.parseInt(a);
		xmbgdao.del(id);
		return selectall(null,map,request);
	}
	/**
	 * 修改xmbg信息
	 */
	@RequestMapping(value="/update")
	public String update(xmbg xmbg,HttpServletRequest request,Map<String,Object> map1){
		Map<String,Object> map= new HashMap<String,Object>();
		map.put("xmbgid", xmbg.getXmbgid());//项目变更编号

		map.put("xm", xmbg.getXm());//项目

		map.put("bgnr", xmbg.getBgnr());//变更内容

		map.put("xmsm", xmbg.getXmsm());//项目说明


	@RequestMapping(value="/detail")
	public String detail(Integer id,Map<String,Object> map,HttpServletRequest request){
		String keyid=(String)request.getParameter("keyid");
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
		list=glydao.select(Integer.parseInt(keyid));
		request.setAttribute("glyid", list.get(0).get("glyid"));//管理员编号

		request.setAttribute("yhm", list.get(0).get("yhm"));//用户名

		request.setAttribute("mm", list.get(0).get("mm"));//密码

		request.setAttribute("xm", list.get(0).get("xm"));//姓名

		return "gly/glydetail";
	}
	
	/**
	 * 查询gly信息
	 */
	@RequestMapping(value="/selectall")
	public String selectall(Integer id,Map<String,Object> map,HttpServletRequest request){
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
	Map<String,Object> map1= new HashMap<String,Object>();
		list=glydao.selectAll(map1);
		System.out.println("listsize="+list.size());
		
		map.put("mylist", list);
		return "gly/glylist";
	}
}
package com.action;


		request.setAttribute("cqmc", list.get(0).get("cqmc"));//产权名称

		request.setAttribute("lx", list.get(0).get("lx"));//类型

		request.setAttribute("fj", list.get(0).get("fj"));//附件

		request.setAttribute("nr", list.get(0).get("nr"));//内容

		request.setAttribute("cqjb", list.get(0).get("cqjb"));//产权级别

		request.setAttribute("ytcg", list.get(0).get("ytcg"));//依托成果

		request.setAttribute("djr", list.get(0).get("djr"));//登记人

		request.setAttribute("djsj", list.get(0).get("djsj"));//登记时间

		return "zscq/zscqdetail";
	}
	
	/**
	 * 查询zscq信息
	 */
	@RequestMapping(value="/selectall")
	public String selectall(Integer id,Map<String,Object> map,HttpServletRequest request){
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
	Map<String,Object> map1= new HashMap<String,Object>();
		list=zscqdao.selectAll(map1);
		System.out.println("listsize="+list.size());
		String qx="",yhm="";
		
		if(request.getSession().getAttribute("yhm")!=null){
			qx=request.getSession().getAttribute("qx").toString();
			yhm=request.getSession().getAttribute("yhm").toString();
			if(!qx.equals("管理员"))
			map1.put("yhm", yhm);//标题
		}
		map.put("mylist", list);
		return "zscq/zscqlist";
	}
}
package com.action;

	 * 修改xmzj信息
	 */
	@RequestMapping(value="/update")
	public String update(xmzj xmzj,HttpServletRequest request,Map<String,Object> map1){
		Map<String,Object> map= new HashMap<String,Object>();
		map.put("xmzjid", xmzj.getXmzjid());//项目中检编号

		map.put("xm", xmzj.getXm());//项目

		map.put("zjnr", xmzj.getZjnr());//中检内容

		map.put("yh", xmzj.getYh());//用户

		map.put("sj", xmzj.getSj());//时间

		xmzjdao.update(map);
		return selectall(null,map1,request);
	}
	/**
	 * 查询xmzj信息
	 */
	@RequestMapping(value="/modify")
	public String modify(Integer id,Map<String,Object> map,HttpServletRequest request){
		String keyid=(String)request.getParameter("keyid");
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
		list=xmzjdao.select(Integer.parseInt(keyid));
		request.setAttribute("xmzjid", list.get(0).get("xmzjid"));//项目中检编号

		request.setAttribute("xm", list.get(0).get("xm"));//项目

		request.setAttribute("zjnr", list.get(0).get("zjnr"));//中检内容

		request.setAttribute("yh", list.get(0).get("yh"));//用户

		request.setAttribute("sj", list.get(0).get("sj"));//时间

		
		return "xmzj/xmzjmodify";
	}
	
	@RequestMapping(value="/detail")
	public String detail(Integer id,Map<String,Object> map,HttpServletRequest request){
		String keyid=(String)request.getParameter("keyid");
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
		list=xmzjdao.select(Integer.parseInt(keyid));
		request.setAttribute("xmzjid", list.get(0).get("xmzjid"));//项目中检编号

		request.setAttribute("xm", list.get(0).get("xm"));//项目

		request.setAttribute("zjnr", list.get(0).get("zjnr"));//中检内容

		map.put("xmjxid", xmjx.getXmjxid());//项目结项编号

		map.put("xm", xmjx.getXm());//项目

		map.put("jxsm", xmjx.getJxsm());//结项说明

		map.put("yh", xmjx.getYh());//用户

		map.put("sj", xmjx.getSj());//时间

		map.put("bz", xmjx.getBz());//备注

		xmjxdao.save(map);

		try{
		String sql="update xiangmu set xmjd='结项' where xmid='"+xmjx.getXm()+"'";
		DBO db=new DBO();
		db.update(sql);
		}catch(Exception e){
			
			e.printStackTrace();
		}
		
		System.out.println("addok");
		return "xmjx/xmjxadd";
	}
	
	/**删除 
	 * 
	 */
	@RequestMapping(value="/del")
	public String  del(Integer id,HttpServletRequest request,Map<String,Object> map){
	//	Map<String,Object> map= new HashMap<String,Object>();
		String a=(String)request.getParameter("keyid");
		id=Integer.parseInt(a);
		xmjxdao.del(id);
		return selectall(null,map,request);
	}
	/**
	 * 修改xmjx信息
	 */
	@RequestMapping(value="/update")


		request.setAttribute("yf", list.get(0).get("yf"));//乙方

		request.setAttribute("yflxfs", list.get(0).get("yflxfs"));//乙方联系方式

		request.setAttribute("zt", list.get(0).get("zt"));//状态
		request.setAttribute("fj", list.get(0).get("fj"));//状态
		
		return "hetong/modify";
	}
	
	@RequestMapping(value="/detail")
	public String detail(Integer id,Map<String,Object> map,HttpServletRequest request){
		String keyid=(String)request.getParameter("keyid");
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
		list=hetongdao.select(Integer.parseInt(keyid));
		request.setAttribute("htid", list.get(0).get("htid"));//合同编号
		request.setAttribute("keyid", keyid);//合同编号
		request.setAttribute("htbt", list.get(0).get("htbt"));//合同标题

		request.setAttribute("htbh", list.get(0).get("htbh"));//合同编号

		request.setAttribute("htnr", list.get(0).get("htnr"));//合同内容

		request.setAttribute("qcsj", list.get(0).get("qcsj"));//起草时间

		request.setAttribute("qcr", list.get(0).get("qcr"));//起草人

		request.setAttribute("jf", list.get(0).get("jf"));//甲方

		request.setAttribute("jflxfs", list.get(0).get("jflxfs"));//甲方联系方式

		request.setAttribute("yf", list.get(0).get("yf"));//乙方

		request.setAttribute("yflxfs", list.get(0).get("yflxfs"));//乙方联系方式

		request.setAttribute("zt", list.get(0).get("zt"));//状态
		request.setAttribute("fj", list.get(0).get("fj"));//状态
		return "hetong/hetongdetail";
	}
	
	/**
	 * 查询hetong信息
	 */
	@RequestMapping(value="/selectall")
	public String selectall(Integer id,Map<String,Object> map,HttpServletRequest request){
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();


		map.put("nl", yonghu.getNl());//年龄

		yonghudao.update(map);
		return selectall(null,map1,request);
	}
	/**
	 * 查询yonghu信息
	 */
	@RequestMapping(value="/modify")
	public String modify(Integer id,Map<String,Object> map,HttpServletRequest request){
		String keyid=(String)request.getParameter("keyid");
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
		list=yonghudao.select(Integer.parseInt(keyid));
		request.setAttribute("yhid", list.get(0).get("yhid"));//用户编号

		request.setAttribute("yhm", list.get(0).get("yhm"));//用户名

		request.setAttribute("mm", list.get(0).get("mm"));//密码

		request.setAttribute("xm", list.get(0).get("xm"));//姓名

		request.setAttribute("xy", list.get(0).get("xy"));//学院

		request.setAttribute("QQ", list.get(0).get("QQ"));//QQ

		request.setAttribute("dh", list.get(0).get("dh"));//电话

		request.setAttribute("xb", list.get(0).get("xb"));//性别

		request.setAttribute("nl", list.get(0).get("nl"));//年龄

		
		return "yonghu/yonghumodify";
	}
	
	@RequestMapping(value="/detail")
	public String detail(Integer id,Map<String,Object> map,HttpServletRequest request){
		String keyid=(String)request.getParameter("keyid");
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
		list=yonghudao.select(Integer.parseInt(keyid));
		request.setAttribute("yhid", list.get(0).get("yhid"));//用户编号

		request.setAttribute("yhm", list.get(0).get("yhm"));//用户名

		request.setAttribute("mm", list.get(0).get("mm"));//密码

		request.setAttribute("xm", list.get(0).get("xm"));//姓名


		htbgdao.save(map);
		
		
		System.out.println("addok");
		return "htbg/htbgadd";
	}
	
	/**删除 
	 * 
	 */
	@RequestMapping(value="/del")
	public String  del(Integer id,HttpServletRequest request,Map<String,Object> map){
	//	Map<String,Object> map= new HashMap<String,Object>();
		String a=(String)request.getParameter("keyid");
		id=Integer.parseInt(a);
		htbgdao.del(id);
		return selectall(null,map,request);
	}
	/**
	 * 修改htbg信息
	 */
	@RequestMapping(value="/update")
	public String update(htbg htbg,HttpServletRequest request,Map<String,Object> map1){
		Map<String,Object> map= new HashMap<String,Object>();
		map.put("htbgid", htbg.getHtbgid());//合同变更编号

		map.put("htbh", htbg.getHtbh());//合同编号

		map.put("bgsmbgr", htbg.getBgsmbgr());//变更说明变更人

		map.put("sj", htbg.getSj());//时间

		map.put("zt", htbg.getZt());//状态
		
		String zt=(String)htbg.getZt();
		DBO db=new DBO();
		System.out.println("zt="+zt);
		
		
		String sql="";
		
		try{
			if(!zt.equals("未审核")){
				
				sql="update hetong set zt='"+zt+"' where htbh='"+htbg.getHtbh()+"'";
				System.out.println(sql);
				db.update(sql);
			}
			

	 * 查询hetong信息
	 */
	@RequestMapping(value="/selectall")
	public String selectall(Integer id,Map<String,Object> map,HttpServletRequest request){
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
	Map<String,Object> map1= new HashMap<String,Object>();
		list=hetongdao.selectAll(map1);
		System.out.println("listsize="+list.size());
		
		map.put("mylist", list);
		return "hetong/hetonglist";
	}
	
	
	/**
	 * 查询hetong信息
	 */
	@RequestMapping(value="/myselectall")
	public String myselectall(Integer id,Map<String,Object> map,HttpServletRequest request){
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
	Map<String,Object> map1= new HashMap<String,Object>();
	String qx="",yhm="";
	
	if(request.getSession().getAttribute("yhm")!=null){
		qx=request.getSession().getAttribute("qx").toString();
		yhm=request.getSession().getAttribute("yhm").toString();
		if(!qx.equals("管理员"))
		map1.put("yhm", yhm);//标题
	}
	
	String htmc=(String)request.getParameter("htmc");
	System.out.println("htmc="+htmc);
	if(htmc!=null&&!htmc.equals("")){
		
		map1.put("htmc", htmc);//标题
	}
	
		list=hetongdao.selectAll(map1);
		System.out.println("listsize11="+list.size());
		
		map.put("mylist", list);
		return "hetong/hetongmylist";
	}
}
package com.action;

		list=xmbgdao.select(Integer.parseInt(keyid));
		request.setAttribute("xmbgid", list.get(0).get("xmbgid"));//项目变更编号

		request.setAttribute("xm", list.get(0).get("xm"));//项目

		request.setAttribute("bgnr", list.get(0).get("bgnr"));//变更内容

		request.setAttribute("xmsm", list.get(0).get("xmsm"));//项目说明

		return "xmbg/xmbgdetail";
	}
	
	/**
	 * 查询xmbg信息
	 */
	@RequestMapping(value="/selectall")
	public String selectall(Integer id,Map<String,Object> map,HttpServletRequest request){
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
	Map<String,Object> map1= new HashMap<String,Object>();
String qx="",yhm="";
	
	if(request.getSession().getAttribute("yhm")!=null){
		qx=request.getSession().getAttribute("qx").toString();
		yhm=request.getSession().getAttribute("yhm").toString();
		if(!qx.equals("管理员"))
		map1.put("yhm", yhm);//标题
	}
		list=xmbgdao.selectAll(map1);
		System.out.println("listsize="+list.size());
		
		map.put("mylist", list);
		return "xmbg/xmbglist";
	}
}
package com.action;


	
	@RequestMapping(value="/detail")
	public String detail(Integer id,Map<String,Object> map,HttpServletRequest request){
		String keyid=(String)request.getParameter("keyid");
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
		list=zscqdao.select(Integer.parseInt(keyid));
		request.setAttribute("zscqid", list.get(0).get("zscqid"));//知识产权编号

		request.setAttribute("cqmc", list.get(0).get("cqmc"));//产权名称

		request.setAttribute("lx", list.get(0).get("lx"));//类型

		request.setAttribute("fj", list.get(0).get("fj"));//附件

		request.setAttribute("nr", list.get(0).get("nr"));//内容

		request.setAttribute("cqjb", list.get(0).get("cqjb"));//产权级别

		request.setAttribute("ytcg", list.get(0).get("ytcg"));//依托成果

		request.setAttribute("djr", list.get(0).get("djr"));//登记人

		request.setAttribute("djsj", list.get(0).get("djsj"));//登记时间

		return "zscq/zscqdetail";
	}
	
	/**
	 * 查询zscq信息
	 */
	@RequestMapping(value="/selectall")
	public String selectall(Integer id,Map<String,Object> map,HttpServletRequest request){
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
	Map<String,Object> map1= new HashMap<String,Object>();
		list=zscqdao.selectAll(map1);
		System.out.println("listsize="+list.size());
		String qx="",yhm="";
		
		if(request.getSession().getAttribute("yhm")!=null){
			qx=request.getSession().getAttribute("qx").toString();
			yhm=request.getSession().getAttribute("yhm").toString();
			if(!qx.equals("管理员"))
			map1.put("yhm", yhm);//标题
		}
		map.put("mylist", list);
		return "zscq/zscqlist";
	}
}
package com.action;

		request.setAttribute("mm", list.get(0).get("mm"));//密码

		request.setAttribute("xm", list.get(0).get("xm"));//姓名

		
		return "gly/glymodify";
	}
	
	@RequestMapping(value="/detail")
	public String detail(Integer id,Map<String,Object> map,HttpServletRequest request){
		String keyid=(String)request.getParameter("keyid");
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
		list=glydao.select(Integer.parseInt(keyid));
		request.setAttribute("glyid", list.get(0).get("glyid"));//管理员编号

		request.setAttribute("yhm", list.get(0).get("yhm"));//用户名

		request.setAttribute("mm", list.get(0).get("mm"));//密码

		request.setAttribute("xm", list.get(0).get("xm"));//姓名

		return "gly/glydetail";
	}
	
	/**
	 * 查询gly信息
	 */
	@RequestMapping(value="/selectall")
	public String selectall(Integer id,Map<String,Object> map,HttpServletRequest request){
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
	Map<String,Object> map1= new HashMap<String,Object>();
		list=glydao.selectAll(map1);
		System.out.println("listsize="+list.size());
		
		map.put("mylist", list);
		return "gly/glylist";
	}
}
package com.action;


		request.setAttribute("yhm", list.get(0).get("yhm"));//用户名

		request.setAttribute("mm", list.get(0).get("mm"));//密码

		request.setAttribute("xm", list.get(0).get("xm"));//姓名

		
		return "gly/glymodify";
	}
	
	@RequestMapping(value="/detail")
	public String detail(Integer id,Map<String,Object> map,HttpServletRequest request){
		String keyid=(String)request.getParameter("keyid");
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
		list=glydao.select(Integer.parseInt(keyid));
		request.setAttribute("glyid", list.get(0).get("glyid"));//管理员编号

		request.setAttribute("yhm", list.get(0).get("yhm"));//用户名

		request.setAttribute("mm", list.get(0).get("mm"));//密码

		request.setAttribute("xm", list.get(0).get("xm"));//姓名

		return "gly/glydetail";
	}
	
	/**
	 * 查询gly信息
	 */
	@RequestMapping(value="/selectall")
	public String selectall(Integer id,Map<String,Object> map,HttpServletRequest request){
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
	Map<String,Object> map1= new HashMap<String,Object>();
		list=glydao.selectAll(map1);
		System.out.println("listsize="+list.size());
		
		map.put("mylist", list);
		return "gly/glylist";
	}
}
package com.action;

		map.put("lx", zscq.getLx());//类型

		map.put("fj", zscq.getFj());//附件

		map.put("nr", zscq.getNr());//内容

		map.put("cqjb", zscq.getCqjb());//产权级别

		map.put("ytcg", zscq.getYtcg());//依托成果

		map.put("djr", zscq.getDjr());//登记人

		map.put("djsj", zscq.getDjsj());//登记时间

		zscqdao.update(map);
		return selectall(null,map1,request);
	}
	/**
	 * 查询zscq信息
	 */
	@RequestMapping(value="/modify")
	public String modify(Integer id,Map<String,Object> map,HttpServletRequest request){
		String keyid=(String)request.getParameter("keyid");
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
		list=zscqdao.select(Integer.parseInt(keyid));
		request.setAttribute("zscqid", list.get(0).get("zscqid"));//知识产权编号

		request.setAttribute("cqmc", list.get(0).get("cqmc"));//产权名称

		request.setAttribute("lx", list.get(0).get("lx"));//类型

		request.setAttribute("fj", list.get(0).get("fj"));//附件

		request.setAttribute("nr", list.get(0).get("nr"));//内容

		request.setAttribute("cqjb", list.get(0).get("cqjb"));//产权级别

		request.setAttribute("ytcg", list.get(0).get("ytcg"));//依托成果

		request.setAttribute("djr", list.get(0).get("djr"));//登记人

		request.setAttribute("djsj", list.get(0).get("djsj"));//登记时间

		

	 */
	@RequestMapping(value="/selectall")
	public String selectall(Integer id,Map<String,Object> map,HttpServletRequest request){
		List<Map<String,Object>> list= new  ArrayList<Map<String,Object>>();
	Map<String,Object> map1= new HashMap<String,Object>();
		list=htbgdao.selectAll(map1);
		System.out.println("listsize="+list.size());
		
		map.put("mylist", list);
		return "htbg/htbglist";
	}
}
package com.action;

@Controller
@RequestMapping(value="/xmzj")
public class xmzjAction {
	/**
	 * 自动注入业务逻辑层，注入方式使用了注解自动注入
	 */

	@Resource xmzjDao xmzjdao;
	@RequestMapping(value="/addPage")
	public String addPage(xmzj xmzj,HttpServletRequest request){
		Map<String,Object> map= new HashMap<String,Object>();
		
		System.out.println("addPageok");
		return "xmzj/xmzjadd";
	}


@Controller
@RequestMapping(value="/xmbg")
public class xmbgAction {
	/**
	 * 自动注入业务逻辑层，注入方式使用了注解自动注入
	 */

	@Resource xmbgDao xmbgdao;
	@RequestMapping(value="/addPage")
	public String addPage(xmbg xmbg,HttpServletRequest request){
		Map<String,Object> map= new HashMap<String,Object>();
		
		System.out.println("addPageok");
		return "xmbg/xmbgadd";
	}
	
	@RequestMapping(value="/add")
	public String add(xmbg xmbg,HttpServletRequest request){
		Map<String,Object> map= new HashMap<String,Object>();
		//String name=(String)request.getParameter("name");

		map.put("xmbgid", xmbg.getXmbgid());//项目变更编号

		map.put("xm", xmbg.getXm());//项目

		map.put("bgnr", xmbg.getBgnr());//变更内容

		map.put("xmsm", xmbg.getXmsm());//项目说明

		xmbgdao.save(map);
		
		
		System.out.println("addok");
		return "xmbg/xmbgadd";
	}
	
	/**删除 
	 * 
	 */
	@RequestMapping(value="/del")
	public String  del(Integer id,HttpServletRequest request,Map<String,Object> map){
	//	Map<String,Object> map= new HashMap<String,Object>();

@Controller
@RequestMapping(value="/hetong")
public class hetongAction {
	/**
	 * 自动注入业务逻辑层，注入方式使用了注解自动注入
	 */

	@Resource hetongDao hetongdao;
	@RequestMapping(value="/addPage")
	public String addPage(hetong hetong,HttpServletRequest request){
		Map<String,Object> map= new HashMap<String,Object>();
		
		System.out.println("addPageok");
		return "hetong/hetongadd";
	}
	
	@RequestMapping(value="/add")
	public String add(hetong hetong,HttpServletRequest request){
		Map<String,Object> map= new HashMap<String,Object>();
		//String name=(String)request.getParameter("name");

		map.put("htid", hetong.getHtid());//合同编号

		map.put("htbt", hetong.getHtbt());//合同标题

		map.put("htbh", hetong.getHtbh());//合同编号

		map.put("htnr", hetong.getHtnr());//合同内容

		map.put("qcsj", hetong.getQcsj());//起草时间

		map.put("qcr", hetong.getQcr());//起草人

		map.put("jf", hetong.getJf());//甲方

		map.put("jflxfs", hetong.getJflxfs());//甲方联系方式

		map.put("yf", hetong.getYf());//乙方

		map.put("yflxfs", hetong.getYflxfs());//乙方联系方式

		map.put("zt", hetong.getZt());//状态
		
		map.put("fj", hetong.getFj());//状态

		hetongdao.save(map);
		
		
		System.out.println("addok");


@Controller
@RequestMapping(value="/xiangmu")
public class xiangmuAction {
	/**
	 * 自动注入业务逻辑层，注入方式使用了注解自动注入
	 */

	@Resource xiangmuDao xiangmudao;
	@RequestMapping(value="/addPage")
	public String addPage(xiangmu xiangmu,HttpServletRequest request){
		Map<String,Object> map= new HashMap<String,Object>();
		
		System.out.println("addPageok");
		return "xiangmu/xiangmuadd";
	}
	
	@RequestMapping(value="/add")
	public String add(xiangmu xiangmu,HttpServletRequest request){
		Map<String,Object> map= new HashMap<String,Object>();
		//String name=(String)request.getParameter("name");

		map.put("xmid", xiangmu.getXmid());//项目编号

		map.put("xmmc", xiangmu.getXmmc());//项目名称

		map.put("fzr", xiangmu.getFzr());//负责人

		map.put("xmjd", xiangmu.getXmjd());//项目阶段

		map.put("gs", xiangmu.getGs());//概述

		map.put("lxsj", xiangmu.getLxsj());//立项时间

		map.put("js", xiangmu.getJs());//介绍

		map.put("yh", xiangmu.getYh());//用户

		map.put("zt", xiangmu.getZt());//状态
		map.put("fj", xiangmu.getFj());//状态
		xiangmudao.save(map);
		


@Controller
@RequestMapping(value="/htbg")
public class htbgAction {
	/**
	 * 自动注入业务逻辑层，注入方式使用了注解自动注入
	 */

	@Resource htbgDao htbgdao;
	@RequestMapping(value="/addPage")
	public String addPage(htbg htbg,HttpServletRequest request){
		Map<String,Object> map= new HashMap<String,Object>();
		
		System.out.println("addPageok");
		return "htbg/htbgadd";
	}
	
	@RequestMapping(value="/add")
	public String add(htbg htbg,HttpServletRequest request){
		Map<String,Object> map= new HashMap<String,Object>();
		//String name=(String)request.getParameter("name");

		map.put("htbgid", htbg.getHtbgid());//合同变更编号

		map.put("htbh", htbg.getHtbh());//合同编号

		map.put("bgsmbgr", htbg.getBgsmbgr());//变更说明变更人

		map.put("sj", htbg.getSj());//时间

		map.put("zt", htbg.getZt());//状态

		htbgdao.save(map);
		
		
		System.out.println("addok");
		return "htbg/htbgadd";
	}

请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述

m0_71414463
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值