📄 index.jsp
字号:
<%@ page contentType="text/html;charset=GBK"%>
<%@ page pageEncoding="GBK"%>
<%@ page import="java.sql.*" %>
<%
Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(ClassNotFoundException e)
{
out.print("类找不到!");
}
try
{
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ywjygl","feemanager","chuyanjun");
sql=con.createStatement();
rs=sql.executeQuery("select * from feerate");
rs.next();
%>
<head>
<title>用户费用登记</title>
</head>
<BODY>
<form name="form1" action="acceptInsertUserTable.jsp" method="post" onsubmit="return on_submit()">
<center>
<table border="1" width="700">
<tr>
<td width="100%" colspan="2" align="center">用户费用信息<a href=acceptInsertUserTable.jsp>(清单查询)</a></td>
</tr>
<tr>
<td width="10%">费用区间</td>
<td width="90%"><input type="text" name="feedate" onkeydown="if(event.keyCode==13)event.keyCode=9">(如：2006-2)</td>
</tr>
<tr>
<td width="10%">姓名:</td>
<td width="90%"><input type="text" name="username" onkeydown="if(event.keyCode==13)event.keyCode=9"></td>
</tr>
<tr>
<td width="10%">水:</td>
<td width="90%"><input type=text name="waterdun" onKeyPress="if (event.keyCode!=46 && event.keyCode!=45 && (event.keyCode<48 || event.keyCode>57)) event.returnValue=false" onchange="on_change()" onkeydown="if(event.keyCode==13)event.keyCode=9"> 吨 单价：<input type="text" readonly="true" size="5" value=<% out.print(rs.getString(1)); %> name="waterdj">(元/吨)<a href='updatewater.jsp?water_dj=<% out.print(rs.getString(1)); %>'>修改</a></td>
</tr>
<tr>
<td width="10%">电:</td>
<td width="90%"><input type="text" name="elecdu" onKeyPress="if (event.keyCode!=46 && event.keyCode!=45 && (event.keyCode<48 || event.keyCode>57)) event.returnValue=false" onchange="on_change()" onkeydown="if(event.keyCode==13)event.keyCode=9"> 度 单价：<input type="text" readonly="true" size="5" value=<% out.print(rs.getString(2)); %> name="elecdj">(元/度)<a href='updateelec.jsp?elec_dj=<% out.print(rs.getString(1)); %>'>修改</a></td>
</tr>
<tr>
<td width="12%">合计金额:</td>
<td width="88%"><input type="text" name="sumje" readonly="true"> 元</td>
</tr>
<tr>
<td colspan="2" align="center"> <input type="submit" value="提交"> <input type="reset" value="重输"></td>
</tr>
</form>
</table>
</center>
<%
con.close();
}
catch(SQLException e1)
{
out.print("SQL异常！");
}
%>
<script language="javascript">
var
waterje=0;
elecje=0;
function on_change()
{
if (form1.waterdun.value!="")
{
waterje=form1.waterdun.value*form1.waterdj.value;
}
if (form1.elecdu.value!="")
{
elecje=form1.elecdu.value*form1.elecdj.value;
}
form1.sumje.value=waterje+elecje;
}
function on_submit()
{
if (form1.feedate.value=="")
{
alert("请输入费用区间");
form1.feedate.focus();
return false;
}
if (form1.username.value == "")
{
alert("用户姓名不能为空！");
form1.username.focus();
return false;
}
if (form1.waterdun.value=="")
{
alert("请输入用户水用量！");
form1.waterdun.focus();
return false;
}
if (form1.elecdu.value=="")
{
alert("请输入用户电用量！");
form1.elecdu.focus();
return false;
}
}
</script>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -