ResultSet rs1=access.query("select * from gongxianbiao where id="+rengshu);
rs1.next();
double peoplebili=rs1.getDouble("people");
double people1bili=rs1.getDouble("people1");
double people2bili=rs1.getDouble("people2");
double people3bili=rs1.getDouble("people3");
double people4bili=rs1.getDouble("people4");
double people5bili=rs1.getDouble("people5");
double people6bili=rs1.getDouble("people6");
double people7bili=rs1.getDouble("people7");
double people8bili=rs1.getDouble("people8");
double people9bili=rs1.getDouble("people9");
double people10bili=rs1.getDouble("people10");

double fuzerengfei=0.0;
fuzerengfei=defei*peoplebili;
out.println("fuzerengfei="+fuzerengfei);
double people1fei=0.0;
people1fei=defei*people1bili;
double people2fei=0.0;
people2fei=defei*people2bili;
double people3fei=0.0;
people3fei=defei*people3bili;
double people4fei=0.0;
people4fei=defei*people4bili;
double people5fei=0.0;
people5fei=defei*people5bili;
double people6fei=0.0;
people6fei=defei*people6bili;
double people7fei=0.0;
people7fei=defei*people7bili;
double people8fei=0.0;
people8fei=defei*people8bili;
double people9fei=0.0;
people9fei=defei*people9bili;
double people10fei=0.0;
people10fei=defei*people10bili;


access.update("insert into xiangmubao(year,xuhao,mingcheng,time1,hetonge,"+
"yuanguanfei,defei,laiyuan,hengzongxiang,leixing,fuzereng,people1,people2,"+
"people3,people4,people5,people6,people7,people8,people9,people10,ketibenhao,rengshu) values('"+
year1+"','"+
xuhao+"','"+
mingcheng+"','"+
time+"',"+
hetonge+","+
yuanguanfei+","+
defei+",'"+
laiyuan+"','"+
hengzongxiang+"','"+
leixing1+"','"+
fuzereng+"','"+
people1+"','"+
people2+"','"+
people3+"','"+
people4+"','"+
people5+"','"+
people6+"','"+
people7+"','"+
people8+"','"+
people9+"','"+
people10+"','"+
ketibinhao+"',"+
rengshu+")");

ResultSet rs2=access.query("select * from kaohebiao where xingming='"
+fuzereng+"'"+"and year1='"+year1+"'" );