jsp新闻发布系统

共32个文件

jsp：16个

jpg：13个

mdb：1个

新闻发布系统

3星 · 超过75%的资源需积分: 9 86 下载量 75 浏览量 2011-10-24 18:35:03 上传评论 1 收藏 2.34MB ZIP 举报

温馨提示

<%@page contentType="text/html"%> <%@page pageEncoding="GB2312"%> <%@page import = "java.sql.*" %> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title>index</title> <script language="JavaScript" type="text/JavaScript">  </script> <style type="text/css">  </style> <% Object obj=session.getAttribute("access") ; if (obj==null) session.setAttribute("access","n") ; if(request.getParameter("adminid") !=null && request.getParameter("adminpwd") != null){ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:database"); Statement smt =con.createStatement (ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); String getpaperdata = "SELECT * FROM admin WHERE adminid='" + request.getParameter("adminid") + "' AND adminpwd='" + request.getParameter("adminpwd") + "'" ; ResultSet paperrs =smt.executeQuery(getpaperdata) ; if(paperrs.next()){ String adminid=paperrs.getString("adminid"); String adminpwd=paperrs.getString("adminpwd"); session.setAttribute("access","y") ; session.setAttribute("adminid",adminid) ; session.setAttribute("adminpwd",adminpwd) ; session.setAttribute("accessid",request.getParameter("adminid")) ; session.setMaxInactiveInterval(1800) ; response.sendRedirect("newslist.jsp") ; }else response.sendRedirect("wrong.jsp") ; } %> </head> <body bgcolor="#666666" text="#006E45" link="#006E45" vlink="#006E45" alink="#006E45" topmargin="0"> <table width="976" height="699" border="1" align="center" bordercolor="#000000" bgcolor="#CCCCCC"> <td height="125" colspan="3" bgcolor="#CCFF00"><marquee behavior="scroll" scrollamount="6" scrolldelay="1"><img src="images/c6.jpg" width="161" height="175"><img src="images/c7.jpg" width="161" height="175"><img src="images/c8.jpg" width="161" height="175"><img src="images/c9.jpg" width="161" height="175"><img src="images/c10.jpg" width="161" height="175"><img src="images/c11.jpg" width="161" height="178"></marquee></td> <tr> <td width="202" height="226" rowspan="2" bgcolor="#CCFF00"><div align="center" class="STYLE20"><font face="华文楷体">广<span class="STYLE18"></span>辉新闻网</font> </div> <table width="54%" border="0" align="center"> <tr> <td><img src="images/t.jpg" alt="LOGO" width="159" height="64" align="middle"></td> </tr> </table> <div align="center"><a href="http://ent.qq.com/" target="_parent">腾讯娱乐</a></div> <form action="" method="post" name="form1" target="_blank"> <table width="99%" height="104" border="1" align="center"> <tr> <td colspan="4"><div align="center" class="STYLE19"><strong>管理员登录</strong></div></td> </tr> <tr> <td width="29%" ><span class="STYLE23">账号</span></td> <td width="71%" ><input type="text" name="adminid" <% if(request.getParameter("adminid")!=null){ %> value ='<%=request.getParameter("adminid")%>' <%}%> size="16"></td> </tr> <tr> <td ><span class="STYLE23">密码</span></td> <td ><input type="password" name="adminpwd" <% if(request.getParameter("adminpwd")!=null){ %> value ='<%=request.getParameter("adminpwd")%>' <%}%> size="16"></td> </tr> <tr> <td height="26" colspan="4"> <table width="95%" border="0"> <tr> <td width="26%"> </td> <td width="30%"><input type="submit" value="登录" name="loginButton"></td> <td width="41%"><input type="reset" name="Submit" value="取消"></td> <td width="3%"> </td> </tr> </table> </td> </tr> </table> </form> </td> <td height="20" colspan="2" align="left" valign="top" bgcolor="#CCFF00"> <div align="left"> <p class="STYLE24"><strong>版主简介</strong> </p> </div></td> </tr> <tr> <td width="166" height="245" align="left" valign="top" bgcolor="#CCFF00"><img src="images/12.gif" width="166" height="242"></td> <td width="583" align="left" valign="top" bgcolor="#CCFF00"><p class="STYLE18">姓名：堵广辉<br> 性别：男<br> 生日：1988-02-02<br> 身高：178cm <br> 祖籍：河南新乡<br> 兴趣：运动，音乐，篮球<br> 最爱忠爱的球队：凯尔特人<br> 热爱的球星：加内特<br> 最喜爱的电影：国王的演讲<br> 最喜爱的演员：李念 <br> 最喜爱的乐队：子曰<br> 最欣赏的歌手：朴树<br> </p> </td> </tr> <tr> <td rowspan="2" bgcolor="#CCFF00"> <form action="messagesave.jsp" method="POST" target="_blank"> <div align="center"><strong></strong> </div> <table width="199" border="1" bordercolor="#CCCCCC"> <tr bgcolor="#000000"> <td height="19" colspan="2" bgcolor="#CCFF00"> <div align="center"><strong><font face="华文楷体"><a href="messagelist.jsp" target="_blank" class="STYLE21">游客留言板</a></font></strong></div></td> </tr> <tr> <td width="56" height="18" bgcolor="#CCFF00"><span class="STYLE23">姓名 </span></td> <td width="127" bgcolor="#CCFF00"><input type="text" size="18" name="name"></td> </tr> <tr> <td height="18" colspan="2" bgcolor="#CCFF00"><span class="STYLE23">内容:</span></td> </tr> <tr> <td height="148" colspan="2" bgcolor="#CCCCCC"> <textarea name="note" rows="8" cols="25"></textarea> </td> </tr> </table> <table width="43%" border="0" align="center"> <tr> <td width="35%"> </td> <td width="9%"><input name="submit" type="submit" value="提交"></td> <td width="17%"><input name="reset" type="reset" value="取消"></td> <td width="39%"> </td> </tr> </table> </form></p> </td> <td height="20" colspan="2" align="left" valign="top" bgcolor="#CCFF00"> <p><font face="黑体"><a href="newslist.jsp" target="_blank" class="STYLE24">新闻列表</a></font></p></td> </tr> <tr> <td height="224" colspan="2" valign="top" bordercolor="#000000" bgcolor="#CCFF00"> <span class="STYLE19"> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:database"); Statement smt =con.createStatement (ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); String getplacarddata = "" ; %> <% String getnewsdata = "" ; getnewsdata = "SELECT * FROM news WHERE published = true " ; ResultSet newsrs =smt.executeQuery(getnewsdata) ;%> <% while(newsrs.next()){ String newsid =newsrs.getString("newsid") ; String newstitle =newsrs.getString("newstitle") ; %> <a href="news.jsp?newsid=<%=newsid%>"><%=newstitle%></a> [<%=newsrs.getString("publishdate")%>]<br> <%}%> </span></td> </tr> </table> <p align="center"><font color="#FFFFFF"><span class="STYLE22"><strong>173632005@qq.com </strong>建议使用:1024 * 768 分辨率</span></font></p> </body> </html> <%@page contentType="text/html"%> <%@page pageEncoding="GB2312"%> <%@page import = "java.sql.*" %> <%@page import ="java.util.*,java.io.*"%> <%@page import ="javax.activation.*"%> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title>无标题文档</title> <style type="text/css">  </style></head> <body link="#000000" vlink="#000000" alink="#000000"> <% Object obj=session.getAttribute("access") ; if (obj==null) session.setAttribute("access","n") ; if(session.getAttribute("access").equals("n")) {%> <p>非法进入或页面超时，请重新登录…</p> <p><a href="index.jsp">返回</a> </p> <%}else{%> <% String editType=request.getParameter("editType"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:database"); Statement smt =con.createStatement (ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); String editSQL = "" ; String msgid = request.getParameter("msgid") ; editSQL = "DELETE FROM message WHERE " + "msgid=" + msgid ; smt.execute(editSQL) ; out.println("留言已删除!") ;%> <%response.setHeader("Refresh","1;url=messagelist.jsp");%> <%}%> </body> </html>

资源推荐

资源详情

资源评论