📄 adminsave.jsp
字号:
<%@ include file="conn.jsp"%>
<%if ((session.getValue("admin")==null)||(session.getValue("admin")=="")){
response.sendRedirect("admin.jsp");
}
request.setCharacterEncoding("GB2312");
String txttitle=request.getParameter("txttitle");
String txtcontent=request.getParameter("txtcontent");
String classid=request.getParameter("classid");
String picurl=request.getParameter("piccontent");
String writefrom=request.getParameter("writefrom");
String writer=request.getParameter("writer");
String action1=request.getParameter("action");
String id=request.getParameter("id");
if(txttitle.equals("")){
out.print("<script>alert('对不起,名称不能为空');history.back();</script>");
}
if(txtcontent.equals("")){
out.print("<script>alert('内容不能为空');history.back();</script>");
}
if(classid.equals("")){
out.print("<script>alert('分类不能为空');history.back();</script>");
}
%>
<%if(action1.equals("add")){
stmt.executeUpdate("INSERT INTO scott.article(articleid,title,content,classid,picurl,writefrom,writer) VALUES(scott.id.nextval,'"+txttitle+"','"+txtcontent+"','"+classid+"','"+picurl+"','"+writefrom+"','"+writer+"')");
%>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<div align="center"><center>
<br><br>
<table class="border" align=center width="50%" border="0" cellpadding="4" cellspacing="0" bordercolor="#999999">
<tr align=center>
<td width="100%" class="title" height="20"><b>
添加资料成功</b></td>
</tr>
<tr>
<td class="tdbg"><p align="left"><br>
<b>
<b>
资料</b>标题为：<%=txttitle%></p>
您可以进行其他操作
</td>
</tr>
</table>
</center></div>
<%
}
%>
<%if(action1.equals("edit")){
stmt.executeUpdate("update scott.article set title='"+txttitle+"', content='"+txtcontent+"', classid='"+classid+"', picurl='"+picurl+"', writefrom='"+writefrom+"', writer='"+writer+"' where articleid='"+id+"'");
//out.print("update scott.article set title='"+txttitle+"', content='"+txtcontent+"', classid='"+classid+"', picurl='"+picurl+"', writefrom='"+writefrom+"', writer='"+writer+"' where articleid='"+id+"'");
%>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<div align="center"><center>
<br><br>
<table class="border" align=center width="50%" border="0" cellpadding="4" cellspacing="0" bordercolor="#999999">
<tr align=center>
<td width="100%" class="title" height="20"><b>
修改资料成功</b></td>
</tr>
<tr>
<td class="tdbg"><p align="left"><br>
<b>
<b>
资料</b>标题为：<%=txttitle%></p>
您可以进行其他操作
</td>
</tr>
</table>
</center></div>
<%
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -