📄 addother.jsp

📁 用JSP写的一个在线购物网站的代码
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<%
String admin=(String)session.getValue("admin");
if(admin=="" || admin==null)
{%>
<script language="javascript">
alert("请登陆后再执行管理操作");
self.location="index.jsp";
</script>
<%}else{
String sql="select * from admin where admin='"+admin+"'";
ResultSet rs=data.executeQuery(sql);
if(!rs.next())
{%>
<script language="javascript">
alert("对不起，无此管理员帐号");
history.back();
</script>
<%}}%>
<style type="text/css">
<!-- @import url(../images/css.css); -->
</style>
<script language="JavaScript">
function check()
{
  if(document.addthis.title.value.length==0)
  {
     alert("请检查您是否填写了信息主题");
	 document.addthis.title.focus();
	 return false;
  }
}
</script>
<body leftmargin="0" topmargin="0">
<form action="" method="post" name="addthis" onSubmit="return check()">
<input type="hidden" name="addother" value="">
<table width="300" border="0" cellspacing="0" cellpadding="0">
  <tr>
  <td colspan="3" height="10">
  </tr>
  <tr> 
    <td width="50" height="25"><div align="right">主题:</div></td>
    <td width="10"></td>
    <td><input type="text" name="title" size="20" maxlength="20" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></td>
  </tr>
  <tr> 
    <td valign="top"><div align="right">内容:</div></td>
    <td></td>
    <td><textarea name="text" cols="40" rows="8" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></textarea></td>
  </tr>
  <tr> 
    <td colspan="3" height="10"></td>
  </tr>
  <tr>
    <td colspan="3" height="25"><div align="center"><input type="submit" value="添加" onClick="document.all.addother.value='true';" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
	                             <input type="reset" value="重写" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
  </tr>
</table>
</form>
<%
String addother=request.getParameter("addother"); 
if(addother!=null && addother.equals("true"))
{
String title=request.getParameter("title");
title=new String(title.getBytes("ISO8859_1"),"GBK");
String text=request.getParameter("text");
text=new String(text.getBytes("ISO8859_1"),"GBK");
String sql="insert into other(title,text) values(\'"+title+"\',\'"+text+"\')";
ResultSet rs=data.executeQuery(sql);
%>
<script language="JavaScript">
alert("添加成功");
window.close();
</script>
<%}%>
⌨️ 快捷键说明

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