📄 insertcategory.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.*" errorPage="" %>
<%@ include file="Connections/Local.jsp" %>
<html>
<head>
<title>已经添加</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../css/Menu.css" rel="stylesheet" type="text/css">
</head>
<%
request.setCharacterEncoding("GB2312");
String ParentId=request.getParameter("ParentId");
String Name=request.getParameter("Name");
String temp="go";
int i=0;
Vector cnameList=new Vector();
Vector cdesList=new Vector();
Vector ctypeList=new Vector();
Vector csizeList=new Vector();
while(temp!=null&&!temp.equals("")){
cnameList.addElement(temp=request.getParameter("added_"+i));
cdesList.addElement(request.getParameter("des_"+i));
ctypeList.addElement(request.getParameter("type_"+i));
csizeList.addElement(request.getParameter("size_"+i));
i++;
}
Driver driver = (Driver)Class.forName(DB_DRIVER).newInstance();
Connection connection = DriverManager.getConnection(DB_STRING,DB_USERNAME,DB_PASSWORD);
Statement statement=connection.createStatement();
ResultSet resultset;
resultset=statement.executeQuery("SELECT * FROM TreeMenu WHERE ParentId='"+ParentId+"' AND Name='"+Name+"'");
if(resultset.next()){
out.println("已经存在此分类，不需要添加。");
resultset.close();
return;
}
String ParentName=">";
resultset=statement.executeQuery("SELECT FullName FROM TreeMenu WHERE ClassId='"+ParentId+"'");
if(resultset.next()){
ParentName=resultset.getString("FullName");
}
int Index=0;
resultset=statement.executeQuery("SELECT ChildIndex FROM TreeMenu WHERE ParentId='"+ParentId+"' ORDER BY ChildIndex DESC");
if(resultset.next()){
Index=resultset.getInt("ChildIndex");
}
Index++;
String ClassId=ParentId+"_"+Index;
String Columns="ClassId,ColName,Description,ColType,ColSize,ColPosition";
String NewVals,InsertSQL,cname,cdes,ctype,csize;
Columns="ParentId,ChildIndex,ClassId,FullName,Name,Extended";
NewVals="'"+ParentId+"',"+Index+",'"+ClassId+"','"+ParentName+"-"+Name+"','"+Name+"',"+((i==1)? 0:1);
InsertSQL="INSERT INTO TreeMenu ("+Columns+")"+" VALUES ("+NewVals+")";
int chgd=0;
try{
chgd=statement.executeUpdate(InsertSQL);
}catch(Exception e){
e.printStackTrace();
}
if(chgd==1){
%>
成功添加入数据库<br>
<%
}
%>
可以<a href="AddCategory.jsp">继续添加分类</a><br>
</body>
</html>
<%
connection.close();
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -