java取数据库数据

java取数据库数据

通过for循环取列表里的每条数据，如lbdm与前台获取的数据进行比较决定是否插入数据库。

public String newJcfa(){
		Yhqx yhqx = (Yhqx) this.session.get("yhqx");
		String dwdm = yhqx.getDwdm();
		String fafxc = request.getParameter("fafxc");
		String fapcc = request.getParameter("fapcc");
		String famc = request.getParameter("famc");
		String lbdm = request.getParameter("lbdm");
		String lbmc = "";
		if(lbdm.equals("00")){
			lbmc = "单位";
		}else if(lbdm.equals("01")){
			lbmc = "人物";
		}else if(lbdm.equals("02")){
			lbmc = "部门";
		}else if(lbdm.equals("03")){
			lbmc = "事件";
		}else{
			lbmc = "其他";
		}
		try{
			String ztbh = sd.getlsh(dwdm);
			/*String lbdmcr = String.format("%02d",Integer.parseInt(sd.getlbdmcr(dwdm)));*/
			//String ztbh = dwdm+lbdm+lsh.substring(lsh.length()-4);
			sd.insertJcfa(dwdm,ztbh,fafxc,fapcc,famc,lbdm);
			lbdmdl = sd.getlbdmdl(dwdm);
			if(lbdmdl.size()==0){
				sd.insertLbdm(lbdm,lbmc,dwdm);
			}else{
				int k=0;
				for(int i=0;i<lbdmdl.size();i++){
					if(lbdm.equals(lbdmdl.get(i).getLbdm())){
						break;
					}else{
						k++;
					}
				}
				if(k==lbdmdl.size()){
					sd.insertLbdm(lbdm,lbmc,dwdm);
				}
			}
			setMessage("新建方案成功");
		}catch (SQLException e){
			e.printStackTrace();
			setMessage("新建方案失败");
		}
		return "success";
	}