WebRoot/yongdian/yongdiando.jsp

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.util.*"%>

<%
/*
用电添加后台
*/
DBO db=new DBO();
request.setCharacterEncoding("gb2312");
ResultSet rs=null;
	String keyid =(String)request.getParameter("keyid");
String yd=(String)request.getParameter("yd");//用电
String dw=(String)request.getParameter("dw");//单位
String y=(String)request.getParameter("y");//月
String djsj=(String)request.getParameter("djsj");//登记时间
String ydl=(String)request.getParameter("ydl");//用电量
String df=(String)request.getParameter("df");//电费

String sql="";

;//用电SQL 语句
int row=1;
		
try{
sql="select jfd from ydlb where lb in (select lb from danwei where dw='"+dw+"')";
rs=db.query(sql);
String b="";
if(rs.next()){
b=rs.getString("jfd");
}
float c=Float.parseFloat(ydl)*Float.parseFloat(b);

 sql="insert into yongdian(yd,dw,y,djsj,ydl,df) values('"+yd+"','"+dw+"','"+y+"','"+djsj+"','"+ydl+"','"+c+"')";
	
		//int row =0;
		row=db.update(sql);
}catch(Exception e){
System.out.println(e.toString());}
if(row==1){
out.println("<script>");
out.println("alert('操作成功');");
out.println("window.location='yongdianadd.jsp'");
out.println("</script>");
}else{
out.println("<script>");
out.println("alert('操作失败');");
out.println("window.location='yongdianadd.jsp'");
out.println("</script>");
}
db.close();
%>