link.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.addlink.name.value.length==0)
  {
     alert("请填写网站名称");
	 document.addlink.name.focus();
	 return false;
  }
  if(document.addlink.link.value.length==0)
  {
     alert("请填写该网站的地址");
	 document.addlink.link.focus();
	 return false;
  }
}
</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" cellspacing="0" cellpadding="0">
	<tr bgcolor="#FFFFFF">
	<td height="15"></td>
	</tr>	
	<%
	String sql="select * from link";
	ResultSet rs=data.executeQuery(sql);
	int id=0;
	String name="";
	String link="";
	while(rs.next())
	{
	id=rs.getInt("id");
	name=rs.getString("name");
	link=rs.getString("link");
	%>
	<tr>
	<td bgcolor="#FFFFFF"><div align="center">
	<form action="uplink.jsp" method="post">
	<input type="hidden" name="id" value="<%=id%>">
	<table width="90%" border="0" cellspacing="0" cellpadding="0">
	<tr bgcolor="#FFFFFF">
	  <td width="120" height="20"><div align="center"><input type="text" name="name" value="<%=name%>" size="16" maxlength="20" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
	  <td wdith="250"><div align="center"><input type="text" name="link" value="<%=link%>" size="40" maxlength="50" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
	  <td width="40"><div align="center"><input type="submit" value="修改" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
	  <td width="40"><div align="center"><input type="button" value="删除" onClick="javascript:window.location='link.jsp?id=<%=id%>'" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
	</tr>
	</table>
	</form>
	<%}	%>
	</div>
	</td>
	</tr>
	</table>	
	</td>
  </tr>
</table>
<table width="502" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="25" bgcolor="3969A5"></td>
  </tr>
</table>
<br><br><br>
<form action="" method="post" name="addlink" onSubmit="return check()">
<input type="hidden" name="addthis" value="">
<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" cellspacing="0" cellpadding="0">
        <tr> 
          <td height="10" colspan="3" bgcolor="#FFFFFF"></td>
        </tr>
		<tr> 
          <td width="150" height="20" bgcolor="#FFFFFF"><div align="center">网站名称</div></td>
          <td width="250" bgcolor="#FFFFFF"><div align="center">网站地址</div></td>
          <td width="100" bgcolor="#FFFFFF"><div align="center">操作</div></td>
        </tr>
        <tr> 
          <td height="20" bgcolor="#FFFFFF"><div align="center"> 
              <input type="text" name="name" size="20" maxlength="20" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
            </div></td>
          <td bgcolor="#FFFFFF"><div align="center">
              <input type="text" name="link" size="40" maxlength="50" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
            </div></td>
          <td bgcolor="#FFFFFF"><div align="center">
              <input type="submit" value="添加链接" onClick="document.all.addthis.value='true';" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
            </div></td>
        </tr>
        <tr> 
          <td height="10" colspan="3" bgcolor="#FFFFFF"></td>
        </tr>
      </table></td>
  </tr>
</table>
</form>
<%
String addthis=request.getParameter("addthis");
if(addthis!=null && addthis.equals("true"))
{
name=request.getParameter("name");
name=new String(name.getBytes("ISO8859_1"),"GBK");
link=request.getParameter("link");

sql="insert into link(name,link) values(\'"+name+"\',\'"+link+"\')";
rs=data.executeQuery(sql);
response.sendRedirect("link.jsp");
}
%>
<%
String getid=request.getParameter("id");
if(getid!="" && getid!=null)
{
sql="delete from link where id='"+getid+"'";
rs=data.executeQuery(sql);
response.sendRedirect("link.jsp");
}
%>