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";
}