📄 food_modify_deal.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.lang.*"%>
<jsp:useBean id="connDB" scope="page" class="beans.connDB"/>
<jsp:useBean id="chStr" scope="page" class="beans.chStr"/>
<jsp:include page="safe.jsp"/>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<%
if(request.getParameter("foodid")!=""){
String foodid=chStr.convertStr(request.getParameter("foodid"));
String foodname=chStr.convertStr(request.getParameter("foodname"));
String type=chStr.convertStr(request.getParameter("type"));
String pDate=chStr.convertStr(request.getParameter("pDate"));
String cover=chStr.convertStr(request.getParameter("cover"));
float price=Float.valueOf(request.getParameter("price")).floatValue();
int commend=Integer.parseInt(request.getParameter("commend"));
int newfood=Integer.parseInt(request.getParameter("newfood"));
String introduce=chStr.convertStr(request.getParameter("introduce"));
if(introduce.equals("")) introduce="暂无";
String sql="update tb_foodinfo set foodName='"+foodname+"',Type='"+type+"',Introduce='"+introduce+"',price="+price+",pDate='"+pDate+"',cover='"+cover+"',newfood="+newfood+",commend="+commend+" where foodid='"+foodid+"'";
//out.println(sql);
int ret=0;
ret=connDB.executeUpdate(sql);
if (ret!=0){
out.println("<script language='javascript'>alert('餐品信息修改成功！');window.location.href='index.jsp';</script>");
}else{
out.println("<script language='javascript'>alert('餐品信息修改失败！');window.location.href='index.jsp';</script>");
}
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -