⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 adminsave.jsp

📁 jsp+oracle开发例程
💻 JSP
字号:
<%@ include file="../conn.jsp"%>
<%request.setCharacterEncoding("GB2312");
String actions;
String movie=request.getParameter("movie");
String filename=request.getParameter("txtfilename");
String filename1=request.getParameter("txtfilename1");
String filename2=request.getParameter("txtfilename2");
String filename3=request.getParameter("txtfilename3");
String filename4=request.getParameter("txtfilename4");
String txtname=request.getParameter("txtname");
String txtname1=request.getParameter("txtname1");
String txtname2=request.getParameter("txtname2");
String txtname3=request.getParameter("txtname3");
String txtname4=request.getParameter("txtname4");
String showname=request.getParameter("txtshowname");
String bb=request.getParameter("txtbb");
String classid=request.getParameter("classid");
if ((session.getValue("admin")==null)){
	response.sendRedirect("login.jsp"); 
}else{
String txtshowname=request.getParameter("txtshowname");

if((txtshowname==null)|(txtshowname.equals(""))){%>
<SCRIPT language=JavaScript>
	alert('软件名称不能为空');
javascript:history.go(-1);
</SCRIPT>
<%}else{
String txtnote=request.getParameter("txtnote");
if((txtnote==null)|(txtnote.equals(""))){
	out.print("<SCRIPT language=JavaScript>alert('软件简介不能为空');");
out.print("javascript:history.go(-1);</SCRIPT>");
}else{

if((classid==null)|(classid.equals("==请选类型=="))){
	out.print("<SCRIPT language=JavaScript>alert('请选择类型');");
out.print("javascript:history.go(-1);</SCRIPT>");
}else{
String Nclassid=request.getParameter("Nclassid");
if((Nclassid==null)|(Nclassid.equals("==请选分类=="))){
	out.print("<SCRIPT language=JavaScript>alert('请选择类型');");
out.print("javascript:history.go(-1);</SCRIPT>");
      }else{
String note=request.getParameter("txtnote");
String hot=request.getParameter("hot");
String system=request.getParameter("system");
String size=request.getParameter("size");
String images=request.getParameter("images");
String fromurl=request.getParameter("fromurl");
String order=request.getParameter("order");
String xxyf=request.getParameter("xxyf");
String hy=request.getParameter("hy");
 actions="add";
if(actions.equals(request.getParameter("action")))
 {
 stmt.executeUpdate("INSERT INTO scott.download(id,movie,txtname,txtname1,showname,bb,classid,Nclassid,fromurl,note,system,size1,images,orders,xxyf) VALUES(scott.downloadid.nextval,'"+movie+"','"+txtname+"','"+txtname1+"','"+showname+"','"+bb+"','"+classid+"','"+Nclassid+"','"+fromurl+"','"+note+"','"+system+"','"+size+"','"+images+"','"+order+"','"+xxyf+"')");

 }else{
     actions="edit";
    if(actions.equals(request.getParameter("action")))
	      { 
//String hy1="update scott.download set movie='"+movie+"',filename='"+filename+"',filename1='"+filename1+"',filename2='"+filename2+"',filename3='"+filename3+"',filename4='"+filename4+"',txtname='"+txtname+"',txtname1='"+txtname1+"',txtname2='"+txtname2+"',txtname3='"+txtname3+"',txtname4='"+txtname4+"',showname='"+showname+"',bb='"+bb+"',classid='"+classid+"',Nclassid='"+Nclassid+"',fromurl='"+fromurl+"',note='"+note+"',system='"+system+"',size='"+size+"',images='"+images+"',orders='"+order+"',xxyf='"+xxyf+"' ,hy='"+hy+"'  where id='"+request.getParameter("id")+"'";
//out.print(hy1);
		stmt.executeUpdate("update scott.download set movie='"+movie+"',filename='"+filename+"',filename1='"+filename1+"',filename2='"+filename2+"',filename3='"+filename3+"',filename4='"+filename4+"',txtname='"+txtname+"',txtname1='"+txtname1+"',txtname2='"+txtname2+"',txtname3='"+txtname3+"',txtname4='"+txtname4+"',showname='"+showname+"',bb='"+bb+"',classid='"+classid+"',Nclassid='"+Nclassid+"',fromurl='"+fromurl+"',note='"+note+"',system='"+system+"',size1='"+size+"',images='"+images+"',orders='"+order+"',xxyf='"+xxyf+"' ,hy='"+hy+"'  where id='"+request.getParameter("id")+"'");
		  }

 }
	  }
}
}
%>
<html>

<head>
<title></title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>

<body bgcolor="#39867B">
<br><br>
  
<table width="50%" border="0" cellpadding="3" cellspacing="1" align="center">
  <tr>
    
<td width="100%" height="20" bgcolor="#E1F4EE">
<p align="center"><FONT color="#000000">
 <%actions="add";
if(actions.equals(request.getParameter("action")))
 {		
%>
 添加
 <%}else{%>
 修改
 <%}%>
 程序成功</font>
</td>
  </tr>
  <tr>
    
<td width="100%" bgcolor="#E1F4EE">
<p align="left"><br>
    显示名称为:<%=request.getParameter("txtshowname")%>&nbsp;<%=bb%><br>


    </p>
    您可以进行其他操作 <a href="freeadd.jsp" target="_self">添加</a> <a href="adminedit.jsp" target="_self">修改删除</a></td>
  </tr>
</table>


</body>
</html>
	<%}
	}%>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -