📄 xpartsmodify.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="check.jsp" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="../oa.css" rel="stylesheet" type="text/css">
</head>
<body class="notice">
<p>
<%
String parentpart = charset.ISO_2_GBK(request.getParameter("parentpart"));
String partname = request.getParameter("son");
String newname = request.getParameter("newname");
String ifcheck = request.getParameter("ifcheck");
String comments = charset.ISO_2_GBK(request.getParameter("comments"));
out.println(ifcheck+","+newname+","+parentpart+","+partname+","+comments);
String sql="";
dbc.getConnection();
if(ifcheck==null)
{//对类别没有做修改，直接修改内容
sql = "update parts set parentpart='"+parentpart+"',partcomments='"+comments+"' where id='"+partname+"'";
dbc.update(charset.ISO_2_GBK(sql));
out.println("<br>sql1 "+charset.ISO_2_GBK(sql));
//response.sendRedirect("../partsmodify.jsp?t=0");
}
else
{
//检查是否已经存在
dbc.getConnection();
sql="select count(*) from parts where parentpart='"+parentpart+"' and partname='"+newname+"'";
out.println("<br>sql2 "+charset.ISO_2_GBK(sql));
if(dbc.getCount(sql)>0)
{
dbc.close();
//response.sendRedirect("../partsmodify.jsp?t=1");
}
else
{
sql = "update parts set parentpart='"+parentpart+"',partname='"+newname+"',partcomments='"+comments+"' where id='"+partname+"'";
dbc.update(charset.ISO_2_GBK(sql));
dbc.close();
out.println("<br>sql3 "+charset.ISO_2_GBK(sql));
//response.sendRedirect("../partsmodify.jsp?t=0");
}
}
%>
</p>
<p align="center"><%@include file="../include/foot.jsp" %></p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -