📄 wzgg.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" import="java.sql.*" %>
<%@ page import="mfkvit.login" %><%@ page import="mfkvit.JdbcBean,java.util.*" %>
<jsp:useBean id="login" class="mfkvit.login" scope="session">
</jsp:useBean>
<%
if(session.isNew()){response.sendRedirect("index.jsp");}
String success=login.getSuccess();
if(success==null){success="";}
if(!(success.equals("ok"))){response.sendRedirect("index.jsp");}
%>
<script Language="JavaScript">
<!--
function isspacestring(mystring)
{ var istring=mystring;
var temp,i,strlen;
temp=true;
strlen=istring.length;
for (i=0;i<strlen;i++)
{
if ((istring.substring(i,i+1)!=" ")&(temp))
{ temp=false; }
}
return temp;
}
function firstisspace(mystring)
{ var istring=mystring;
var temp,i,strlen;
temp=false;
if (istring.substring(0,1)==" ")
{ temp=true; }
return temp;
}
function check_input(theForm)
{
if ((theForm.bt.value == "")|(firstisspace(theForm.bt.value)))
{
alert("请输入公告标题.不能以空格开头");
theForm.bt.focus();
return (false);
}
if ((theForm.wzgg.value == "")|(isspacestring(theForm.wzgg.value)))
{
alert("请输入公告内容.");
theForm.wzgg.focus();
return (false);
}
}
//-->
</script>
<script type="" language="javascript">
function check(val) {
var a = document.all.tags("input");
if (a!=null) {
if (a.length!=null) {
for (i=0; i<a.length; i++) {
if (a(i).type== "checkbox")
a(i).checked=val;
}
}
}
}
function submitdel(){
if (confirm("确定删除记录？")){
document.myform.action="/servlet2"
document.myform.submit();
}}
</script>
<html>
<head>
<title>
gsjj
</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="c.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body {
background-image: url();
background-color: #d6dff7;
}
-->
</style></head>
<body leftmargin="0" topmargin="0">
<form name="form1" method="post" action="/servlet2" onSubmit="return check_input(this)">
<%
request.setCharacterEncoding("gb2312");
String x = request.getParameter("id");
if(x!=null){
try{
JdbcBean dbutil = new JdbcBean();
String condition="select * from wzgg where id="+x;
int i = dbutil.execQueryName(condition);
if(i>0){
HashMap hm = (HashMap)(dbutil.getRS().get(0));
%>
<table width=86% height="228" border=0 align=center cellpadding=4 cellspacing=0 bordercolor="#993300" bgcolor="#E8EDF4" style="border-collapse: collapse" >
<tr valign="baseline" bgcolor="#8AA5C8">
<td height=23 colspan="2" align=left valign=top bgcolor="#799ae1"><div align="center"><span class="dfd">发布网站公告</span></div></td>
</tr>
<tr valign="baseline" bgcolor="#F5EFE7">
<td height=11 align=left valign=top bordercolor="#F5EFE7" bgcolor="#E8EDF4" class="c"><div align="right">公告标题：
<label></label>
</div></td>
<td align=left valign=top bordercolor="#E8EDF4" bgcolor="#E8EDF4" class="c"><input name="bt" type="text" id="bt" size="60" value="<%=(String)hm.get("bt")%>"></td>
<input name="id1" type="hidden" id="bt" size="60" value="<%=x%>">
</tr>
<tr valign="baseline" bgcolor="#F5EFE7">
<td width="185" height=133 align=left valign=middle bordercolor="#F5EFE7" bgcolor="#E8EDF4" class="c"><p align="right"> 公告内容：</p></td>
<td width="653" height=133 align=left valign=top bordercolor="#F5EFE7" bgcolor="#E8EDF4" class="c"><textarea name="wzgg" cols="67" rows="10" class="c" id="wzgg"><%=(String)hm.get("wzgg")%></textarea></td>
</tr>
<tr valign="baseline" bgcolor="#F5EFE7">
<td height="28" colspan="2" align=left valign=middle bordercolor="#F5EFE7" bgcolor="#E8EDF4"><div align="center">
<input type="hidden" name="customer" value="wzgg">
<input style="BORDER-RIGHT: #7AC8EB 1px solid; BORDER-TOP: #7AC8EB 1px solid; FONT-SIZE: 9pt; BORDER-LEFT: #7AC8EB 1px solid; BORDER-BOTTOM: #7AC8EB 1px solid; HEIGHT: 18px; BACKGROUND-COLOR: #E8F6FC" type="submit" name="Submit2222" value="修改公告" >
<input style="BORDER-RIGHT: #7AC8EB 1px solid; BORDER-TOP: #7AC8EB 1px solid; FONT-SIZE: 9pt; BORDER-LEFT: #7AC8EB 1px solid; BORDER-BOTTOM: #7AC8EB 1px solid; HEIGHT: 18px; BACKGROUND-COLOR: #E8F6FC" type="reset" name="Submit2222" value="全部重写" >
</div></td>
</tr>
</table>
</form>
<% } %>
<%} catch (Exception ex) {ex.printStackTrace();}
}else{
%>
<form name="form1" method="post" action="/servlet2" onSubmit="return check_input(this)">
<table width=86% height="228" border=0 align=center cellpadding=4 cellspacing=0 bordercolor="#993300" bgcolor="#E8EDF4" style="border-collapse: collapse" >
<tr valign="baseline" bgcolor="#8AA5C8">
<td height=23 colspan="2" align=left valign=top bgcolor="#799ae1"><div align="center"><span class="dfd">发布网站公告</span></div></td>
</tr>
<tr valign="baseline" bgcolor="#F5EFE7">
<td height=11 align=left valign=top bordercolor="#F5EFE7" bgcolor="#E8EDF4" class="c"><div align="right">公告标题：
<label></label>
</div></td>
<td align=left valign=top bordercolor="#E8EDF4" bgcolor="#E8EDF4" class="c"><input name="bt" type="text" id="bt" size="60" ></td>
</tr>
<tr valign="baseline" bgcolor="#F5EFE7">
<td width="179" height=133 align=left valign=middle bordercolor="#F5EFE7" bgcolor="#E8EDF4" class="c"><p align="right"> 公告内容：</p></td>
<td width="659" height=133 align=left valign=top bordercolor="#F5EFE7" bgcolor="#E8EDF4" class="c"><textarea name="wzgg" cols="67" rows="10" class="c" id="wzgg"></textarea></td>
</tr>
<tr valign="baseline" bgcolor="#F5EFE7">
<td height="28" colspan="2" align=left valign=middle bordercolor="#F5EFE7" bgcolor="#E8EDF4"><div align="center">
<input type="hidden" name="customer" value="addwzgg">
<input style="BORDER-RIGHT: #7AC8EB 1px solid; BORDER-TOP: #7AC8EB 1px solid; FONT-SIZE: 9pt; BORDER-LEFT: #7AC8EB 1px solid; BORDER-BOTTOM: #7AC8EB 1px solid; HEIGHT: 18px; BACKGROUND-COLOR: #E8F6FC" type="submit" name="Submit222" value="添加公告" >
<input style="BORDER-RIGHT: #7AC8EB 1px solid; BORDER-TOP: #7AC8EB 1px solid; FONT-SIZE: 9pt; BORDER-LEFT: #7AC8EB 1px solid; BORDER-BOTTOM: #7AC8EB 1px solid; HEIGHT: 18px; BACKGROUND-COLOR: #E8F6FC" type="reset" name="Submit2223" value="全部重写" >
</div></td>
</tr>
</table>
<%}%>
</form>
<form name="myform" method="post" action="">
<table width="86%" border="0" align="center" cellspacing="0" bordercolor="#993300">
<tr bgcolor="#8AA5C8">
<td height="22" colspan="6" valign="bottom" bordercolor="#E8EDF4" bgcolor="#799ae1">
<div align="center" class="unnamed1">
<p align="left" class="w"><span class="fds"><img src="img/userlist1.gif" width="16" height="16"></span><span class="dfd">网站公告管理</span></p>
</div></td>
</tr>
<tr bgcolor="#E8EDF4">
<td height="24" bordercolor="#CCCCCC" bgcolor="#E8EDF4"> <div align="center" class="nr">操作</div></td>
<td width="241" bordercolor="#CCCCCC"> <div align="center" ><span class="nr">公告标题</span></div>
<div align="center" class="nr"></div>
<div align="center" class="nr"></div></td>
<td width="243" bordercolor="#CCCCCC"><div align="center"><span class="nr">发布时间</span></div></td>
<td width="206" colspan="3" bordercolor="#CCCCCC"> <div align="center"><span class="unnamed1"><font size="2"><a class="unnamed1" style="TEXT-DECORATION:underline;cursor:hand" onClick="check(1)">全选</a> </font></span><font color="#003366" size="2"><font color="#FF3366"><a class="unnamed1" style="TEXT-DECORATION:underline;cursor:hand" onClick="check(0)">全不选
</a> </font>
<input style="BORDER-RIGHT: #7AC8EB 1px solid; BORDER-TOP: #7AC8EB 1px solid; FONT-SIZE: 9pt; BORDER-LEFT: #7AC8EB 1px solid; BORDER-BOTTOM: #7AC8EB 1px solid; HEIGHT: 18px; BACKGROUND-COLOR: #E8F6FC" name="cc" type="button" id="cc" value="删 除" onClick="submitdel();">
</font></div></td>
<%
request.setCharacterEncoding("gb2312");
try{
JdbcBean dbutil = new JdbcBean();
String condition="select * from wzgg";
int rowcount = dbutil.execQueryName(condition);
ArrayList al = dbutil.getRS();
for(int i=0;i<rowcount;i++){
HashMap colValue = (HashMap)al.get(i);
%>
<tr bordercolor="#CCCCCC" bgcolor="#F5EFE7">
<% String id = (String)colValue.get("id");
%>
<td width="157" height="27" bgcolor="#E8EDF4"> <div āalign="center" class="unnamed1">
<div align="center"><font size="2"><a href="wzgg.jsp?id=<%=id%>"><font class="er"><img src="img/edit.gif" width="36" height="15" border="0" usemap="#Map"></font></a></font></div>
</div></td>
<td bgcolor="#E8EDF4"> <div align="center" class="c"><%=(String)colValue.get("bt") %></div>
<div align="center" class="c"></div>
<div align="center" class="c"></div></td>
<td bgcolor="#E8EDF4"> <div align="center" class="c"><%=(String)colValue.get("time") %></div></td>
<td colspan="3" bgcolor="#E8EDF4"> <div align="center"> <font size="2"> <span class="c">
<input name="sc" type="checkbox" id="sc" value="<%=id%>">
<input type="hidden" name="customer" value="delwzgg" />
</span></font><span class="c"></font></font></span></div></td>
</tr>
<% } %>
<%} catch (Exception ex) {ex.printStackTrace();} %>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -