📄 updatewater2.jsp
字号:
<%@ page contentType="text/html;charset=GBK"%>
<%@ page pageEncoding="GBK"%>
<%@ page import="java.sql.*" %>
<%!
public String codeToString(String str)
{
String s=str;
try
{
byte tempB[]=s.getBytes("ISO-8859-1");
s=new String(tempB);
return s;
}
catch(Exception e)
{
return s;
}
}
%>
<% //接收客户端提交的数据
String waterdj=codeToString(request.getParameter("newwater_dj"));
float feefloat;
try
{
feefloat=Float.parseFloat(waterdj.trim());
}
catch(Exception e)
{
feefloat=0;
}
//构造追加纪录SQL
String sqlString=null;
sqlString="update feerate set water="+feefloat;
//执行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();
sql.executeUpdate(sqlString);
con.close();
// }
// catch(SQLException e1)
// {
// out.print("SQL异常!");
// }
%>
<head>
<title>修改水费单价</title>
</head>
<BODY>
<center>
修改水费单价成功！<a href=index.jsp>返回</a>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -