other.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 add()
{
   window.open("addother.jsp","body","width=300,height=200");
}
</script>
<table width="502" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="25" bgcolor="3969A5"><div align="center"><font color="#FFFFFF">其他信息设置</font></div></td>
  </tr>
</table>
<table width="500" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#999999">
  <tr>
    <td>
	<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
        <tr>
		<td height="15"></td>
		</tr>
		<tr>
          <td>
		  <table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">
		  <%
		  String sql="select * from other";
		  ResultSet rs=data.executeQuery(sql);
		  int i=0;
		  int id=0;
		  String title="";
		  String text="";
		  while(rs.next())
		  {
		  i++;
		  id=rs.getInt("id");
		  title=rs.getString("title");
		  text=rs.getString("text");
		  %>
		  <%if(i%3==1){%>
		  <tr bgcolor="#FFFFFF">
		  <%}%>
		     <td width="150" height="25"><div align="center"><a href="other.jsp?id=<%=id%>"><%=title%></a></div></td>
		   <%if(i%3==0){%>
		   </tr>
		  <%}}%>
		  </table>
		  </td>
        </tr>
		<tr>
		<td height="15"></td>
		</tr>		
      </table></td>
  </tr>
</table>
<table width="502" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="25" bgcolor="3969A5"><div align="center">　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　<a href="javascript:add()"><font color="#FFFFFF">添加</font></a></div></td>
  </tr>
</table>
<br><br><br>
<%
String getid=request.getParameter("id");
if(getid!="" && getid!=null)
{
sql="select * from other where id='"+getid+"'";
rs=data.executeQuery(sql);
if(rs.next())
{
String gettitle=rs.getString("title");
String gettext=rs.getString("text");
%>
<form action="" method="post">
<input type="hidden" name="upthis" value="">
<input type="hidden" name="id" value="<%=getid%>">
<table width="400" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="80" height="25"><div align="center">主题:</div></td>
<td wdith="220"><input type="text" name="title" size="30" maxlength="20" value="<%=gettitle%>" 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="center">内容:</div></td>
<td><textarea name="text" cols="50" rows="8" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"><%=gettext%></textarea>
</tr>
</table><br>
<div align="center"><input type="submit" value="修改" onClick="document.all.upthis.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">
								   <input type="button" value="删除" onClick="javascript:window.location='other.jsp?delid=<%=id%>'"style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div>
</form>
<%}}%>
<%
String upthis=request.getParameter("upthis");
if(upthis!=null && upthis.equals("true"))
{
getid=request.getParameter("id");
title=request.getParameter("title");
title=new String(title.getBytes("ISO8859_1"),"GBK");
text=request.getParameter("text");
text=new String(text.getBytes("ISO8859_1"),"GBk");

sql="update other set title='"+title+"',text='"+text+"' where id='"+getid+"'";
rs=data.executeQuery(sql);
response.sendRedirect("other.jsp");
}
%>
<%
String delid=request.getParameter("delid");
if(delid!="" && delid!=null)
{
sql="delete from other where id='"+delid+"'";
rs=data.executeQuery(sql);
response.sendRedirect("other.jsp");
}
%>