papermanage.java

网上商店

	 * @return zqh
	 */
	public String getZqh() {
		return zqh;
	}
	/**
	 * @param zqh 要设置的 zqh
	 */
	public void setZqh(String zqh) {
		this.zqh = zqh;
	}
	
	public PaperManage(boolean Conn) {
		if (Conn) {
			try {
				dbc = new SQLBean();
			} catch (Exception e) {
				System.err.println(e);
			}
		}
	};

	/***************************************************************************
	 * 添加新代码类型 *
	 **************************************************************************/
	public String addPaper(HttpServletRequest request) throws Exception {
		request.setCharacterEncoding("GBK");
		String lwzwmc = ParamUtils.getString(request, "lwzwmc", "");
		String lwywmc = ParamUtils.getString(request, "lwywmc", "");
		String yxsh = ParamUtils.getString(request, "yxsh", "");
		String lwlxm = ParamUtils.getString(request, "lwlxm", "");
		String lzlbm = ParamUtils.getString(request, "lzlbm", "");
		String xkm = ParamUtils.getString(request, "xkm", "");
		String xmlym = ParamUtils.getString(request, "xmlym", "");
		String zgyzm = ParamUtils.getString(request, "zgyzm", "");
		String yzm = ParamUtils.getString(request, "yzm", "");
		String scisl = ParamUtils.getString(request, "scisl", "");
		String eisl = ParamUtils.getString(request, "eisl", "");
		String istpsl = ParamUtils.getString(request, "istpsl", "");
		String isrsl = ParamUtils.getString(request, "isrsl", "");
		String xmbh = ParamUtils.getString(request, "xmbh", "");
		String kwmc = ParamUtils.getString(request, "kwmc", "");
		String fbrq = ParamUtils.getString(request, "fbrq", "");
		String cbh = ParamUtils.getString(request, "cbh", "");
		String gbm = ParamUtils.getString(request, "gbm", "");
		String jbm = ParamUtils.getString(request, "jbm", "");
		String nh = ParamUtils.getString(request, "nh", "");
		String jh = ParamUtils.getString(request, "jh", "");
		String qh = ParamUtils.getString(request, "qh", "");
		String zqh = ParamUtils.getString(request, "zqh", "");
		String ys = ParamUtils.getString(request, "ys", "");
		String pdfwj = ParamUtils.getString(request, "pdfwj", "");
		String rybh = ParamUtils.getString(request, "rybh", "");
		String jsm = ParamUtils.getString(request, "jsm", "");	
		
		ResultSet rs;
			String sql = "INSERT INTO `srms`.`srms_kjlw_jb` (`LWZWMC` ,`LWYWMC` ,'YXSH',`LWLXM` ,`LZLBM` ,`XKM` ,`XMLYM` ,`ZGYZM` ,`YZM` ,`SCISL` ,`EISL` ,`ISTPSL` ,`ISRSL` ,`PDFWJ` ,`XMBH` )"
					+ " VALUES ('"
					+ lwzwmc
					+ "','"
					+ lwywmc
					+ "','"
					+ yxsh
					+ "','"
					+ lwlxm
					+ "','" 
					+ lzlbm 
					+ "','"
					+ xkm
					+ "','"
					+ xmlym
					+ "','"
					+ zgyzm
					+ "','"
					+ yzm
					+ "','"
					+ scisl
					+ "','"
					+ eisl
					+ "','"
					+ istpsl
					+ "','"
					+ isrsl
					+ "','"
					+ xmbh
					+ "','"
					+ pdfwj					
					+ "')";
			String sql1="Select LWBH from srms_kjlw_jb where LWZWMC=? ";
			try{
				dbc.beginTrans();
				dbc.executeUpdate(sql);
				rs = dbc.executeQuery(sql1);
				rs.next();
				lwbh = rs.getString("LWBH");
				String sql2="insert into `srms`.`srms_kjlw_fb` (lwbh,kwmc.fbrq,cbh,gbm,jbm,nh,jh,qh,zqh,ys) values('"+lwbh+"','"+kwmc+"','"+fbrq+"','"+cbh+"','"+gbm+"','"+jbm+"','"+nh+"','"+jh+"','"+qh+"','"+zqh+"','"+ys+"')";
				String sql3="insert into `srms`.`srms_kjlw_ry` (lwbh,rybh,jsm) values('"+lwbh+"','"+rybh+"','"+jsm+"')";
				dbc.executeUpdate(sql2);
				dbc.executeUpdate(sql3);
				dbc.commit();
			}catch (Exception e) {
				System.err.println(e);
				try{
					dbc.rollback();
				}catch (Exception sqlex){
					System.err.println(sqlex);
				}
			} 
		dbc.close();
		return lwbh;
	}

	
	/***************************************************************************
	 * 读出节点信息 *
	 **************************************************************************/
	public PaperManage getByLwbh(int lwbh) throws Exception {
		PaperManage paperManage = new PaperManage(false);
		String sql1 = "select * from srms_kjlw_jb where lwbh=" + lwbh;
		String sql2 = "select * from srms_kjlw_fb where lwbh=" + lwbh;
		
		ResultSet rs1 = dbc.executeQuery(sql1);
		ResultSet rs2 = dbc.executeQuery(sql2);
		
		// System.out.println("criterion_id: " + id);
		if(rs1.next()){
			paperManage.setLwbh(rs1.getString("LWBH"));
			paperManage.setLwzwmc(rs1.getString("LWZWMC"));
			paperManage.setLwywmc(rs1.getString("LWYWMC"));
			paperManage.setYxsh(rs1.getString("YXSH"));
			paperManage.setLwlxm(rs1.getString("LWLXM"));
			paperManage.setLzlbm(rs1.getString("LZLBM"));
			paperManage.setXkm(rs1.getString("XKM"));
			paperManage.setXkmlm(rs1.getString("XKMLM"));
			paperManage.setXmlym(rs1.getString("XMLYM"));
			paperManage.setZgyzm(rs1.getString("ZGYZM"));
			paperManage.setYzm(rs1.getString("YZM"));
			paperManage.setScisl(rs1.getString("scisl"));
			paperManage.setEisl(rs1.getString("eisl"));
			paperManage.setIstpsl(rs1.getString("istpsl"));
			paperManage.setIsrsl(rs1.getString("isrsl"));
			paperManage.setXmbh(rs1.getString("xmbh"));
			paperManage.setKwmc(rs2.getString("kwmc"));
			paperManage.setFbrq(rs2.getString("fbrq"));
			paperManage.setCbh(rs2.getString("cbh"));
			paperManage.setGbm(rs2.getString("gbm"));
			paperManage.setJbm(rs2.getString("jbm"));
			paperManage.setNh(rs2.getString("nh"));
			paperManage.setJh(rs2.getString("jh"));
			paperManage.setQh(rs2.getString("qh"));
			paperManage.setZqh(rs2.getString("zqh"));
			paperManage.setYs(rs2.getString("ys"));
			paperManage.setPdfwj(rs1.getString("pdfwj"));		
			
		}
		return paperManage;
	}
	
	/***************************************************************************
	 * 读出科技论文人员信息 *
	 **************************************************************************/
	public ArrayList getRyByLwbh(int lwbh) throws Exception {
		ArrayList<PaperManage> rylist = new ArrayList<PaperManage>();
		String sql = "select * from srms_kjlw_ry where lwbh=" + lwbh;
		ResultSet rs = dbc.executeQuery(sql);
		
		while(rs.next()){
			PaperManage paperManage = new PaperManage(false);
			paperManage.setRybh(rs.getString("rybh"));
			paperManage.setJsm(rs.getString("jsm"));
			rylist.add(paperManage);			
		}
		return rylist;
	}


	/***************************************************************************
	 * 读出所有论文的基本资料 *
	 **************************************************************************/
	public ArrayList loadAll() {
		ArrayList<PaperManage> paperlist = new ArrayList<PaperManage>();
		try {
			String sql1 = "select * from srms_kjlw_jb order by lwbh" ;
			String sql2 = "" ;
			ResultSet rs1 = dbc.executeQuery(sql1);
			ResultSet rs2 = null;
			rs1.last();// 移动到最后一行
			int row = rs1.getRow();// 得到总记录数
			if (row <= 0) {// 如果没有子结点
				return null;// 返回null
			} else {// 如果有子结点
				rs1.beforeFirst();
				while (rs1.next()) {
					PaperManage paperManage = new PaperManage(false);
					
					paperManage.setLwbh(rs1.getString("LWBH"));
					paperManage.setLwzwmc(rs1.getString("LWZWMC"));
					paperManage.setLwywmc(rs1.getString("LWYWMC"));
					paperManage.setYxsh(rs1.getString("YXSH"));
					paperManage.setLwlxm(rs1.getString("LWLXM"));
					paperManage.setLzlbm(rs1.getString("LZLBM"));
					paperManage.setXkm(rs1.getString("XKM"));
					paperManage.setXkmlm(rs1.getString("XKMLM"));
					paperManage.setXmlym(rs1.getString("XMLYM"));
					paperManage.setZgyzm(rs1.getString("ZGYZM"));
					paperManage.setYzm(rs1.getString("YZM"));
					paperManage.setScisl(rs1.getString("scisl"));
					paperManage.setEisl(rs1.getString("eisl"));
					paperManage.setIstpsl(rs1.getString("istpsl"));
					paperManage.setIsrsl(rs1.getString("isrsl"));
					paperManage.setXmbh(rs1.getString("xmbh"));					
					paperManage.setPdfwj(rs1.getString("pdfwj"));	
					sql2 = "select * from srms_kjlw_fb where lwbh ="+rs1.getString("LWBH");
					rs2 = dbc.executeQuery(sql2);
					if(rs2.next()){
						paperManage.setKwmc(rs2.getString("kwmc"));
						paperManage.setFbrq(rs2.getString("fbrq"));
						paperManage.setCbh(rs2.getString("cbh"));
						paperManage.setGbm(rs2.getString("gbm"));
						paperManage.setJbm(rs2.getString("jbm"));
						paperManage.setNh(rs2.getString("nh"));
						paperManage.setJh(rs2.getString("jh"));
						paperManage.setQh(rs2.getString("qh"));
						paperManage.setZqh(rs2.getString("zqh"));
						paperManage.setYs(rs2.getString("ys"));
					}
					paperlist.add(paperManage);
				}
				rs1.close();
				rs2.close();
				return paperlist;// 返回该记录的所有子结点
			}
		} catch (Exception e) {
			System.err.println(e);
		}
		return paperlist;
	}
	
	/***************************************************************************
	 * 删除论文 *
	 **************************************************************************/
	public int del(int id) {
		int i = 0;
		try {
			String sql = "select * from srms_dmk where PARENTID =" + id;
			ResultSet rs = dbc.executeQuery(sql);
			while (rs.next()) {
				CodeManager codeManager = new CodeManager(false);
				codeManager.del(rs.getInt("ID"));
			}
			sql = "delete from srms_dmk where ID =" + id;
			dbc.executeUpdate(sql);
			i = 1;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return i;
	}

	/***************************************************************************
	 * 修改论文 *
	 **************************************************************************/
	public int modify(HttpServletRequest request) {
		int i = 0;
		try {
			String name = request.getParameter("name");
			int id = Integer.parseInt(request.getParameter("id"));
			String note = request.getParameter("note");
			String code = request.getParameter("code");
			System.out.println(name + "," + id + "," + note + "," + code); // test
			String sql = "update srms_dmk set name='" + name + "', note='"
					+ note + "', code='" + code + "', where id=" + id;
			dbc.executeUpdate(sql);
			dbc.close();
			i = 1;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return i;
	}
	
	/***************************************************************************
	 * 修改论文收录情况 *
	 **************************************************************************/
	public int modifySl(HttpServletRequest request) {
		int i = 0;
		try {
			String name = request.getParameter("name");
			int id = Integer.parseInt(request.getParameter("id"));
			String note = request.getParameter("note");
			String code = request.getParameter("code");
			System.out.println(name + "," + id + "," + note + "," + code); // test
			String sql = "update srms_dmk set name='" + name + "', note='"
					+ note + "', code='" + code + "', where id=" + id;
			dbc.executeUpdate(sql);
			dbc.close();
			i = 1;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return i;
	}
	
	/***************************************************************************
	 * 审核论文 *
	 **************************************************************************/
	public int vertify(HttpServletRequest request) {
		int i = 0;
		try {
			String name = request.getParameter("name");
			int id = Integer.parseInt(request.getParameter("id"));
			String note = request.getParameter("note");
			String code = request.getParameter("code");
			System.out.println(name + "," + id + "," + note + "," + code); // test
			String sql = "update srms_dmk set name='" + name + "', note='"
					+ note + "', code='" + code + "', where id=" + id;
			dbc.executeUpdate(sql);
			dbc.close();
			i = 1;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return i;
	}
	
	/***************************************************************************
	 * 审核论文收录情况 *
	 **************************************************************************/
	public int vertifySl(HttpServletRequest request) {
		int i = 0;
		try {
			String name = request.getParameter("name");
			int id = Integer.parseInt(request.getParameter("id"));
			String note = request.getParameter("note");
			String code = request.getParameter("code");
			System.out.println(name + "," + id + "," + note + "," + code); // test
			String sql = "update srms_dmk set name='" + name + "', note='"
					+ note + "', code='" + code + "', where id=" + id;
			dbc.executeUpdate(sql);
			dbc.close();
			i = 1;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return i;
	}
	
	/***************************************************************************
	 * 关闭sqlbean *
	 **************************************************************************/
	public void close() throws SQLException {
		if (dbc != null)
			dbc.close();
	}
	
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO 自动生成方法存根

	}
}