Java web项目爱分享社区管理文章管理部分代码

来源：互联网发布：任天堂vb用电池的吗编辑：程序博客网时间：2024/06/05 06:53
<%@ page import ="java.sql.*"   %><%@ page import ="model.*"   %><%@ page import ="java.util.*"   %><%@ page language="java" contentType="text/html; charset=utf-8"    pageEncoding="utf-8"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>文章管理</title></head><body><STYLE type=text/css> BODY {PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; BACKGROUND-COLOR: #2a8dc8}BODY {FONT-SIZE: 12px; COLOR: #003366; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif}TD {FONT-SIZE: 12px; COLOR: #003366; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif}DIV {FONT-SIZE: 12px; COLOR: #003366; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif}P {FONT-SIZE: 12px; COLOR: #003366; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif}</STYLE><META content="MSHTML 6.00.2900.3492" name=GENERATOR></HEAD><BODY><TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>  <TBODY>  <TR>    <TD width=10><IMG src="images/new_001.jpg" border=0></TD>    <TD background=images/new_002.jpg><FONT size=4><B>文章管理中心      </B></FONT> </TD>    <TD background=images/new_002.jpg>      <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>        <TBODY>        <TR>          <TD align=right height=25></TD></TR>        <TR>          <TD height=35>           <A href="articleadd.jsp"  target=_top><FONT color=red><B>发布文章</B></FONT></A>      <form  action="articledelete.jsp"    >请输入要删除的文章id：<input   type="text"    name="delid"        ><input  type="submit"     name="submit"      value="提交" /    ></form>          <A href="exit.jsp"   target=_top><FONT color=red><B>安全退出</B></FONT></A>             </TD></TR>           </TBODY></TABLE></TD>    <TD width=10><IMG src="images/new_003.jpg" border=0></TD></TR></TBODY></TABLE></BODY><%Class.forName("oracle.jdbc.driver.OracleDriver"); Connection  conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","system","Oracle11g");  request.setCharacterEncoding("utf-8"); Statement stmt =conn.createStatement();  ArrayList<Article> articles=new ArrayList<Article>();String sql1 = "select  *  from  comm ";      ResultSet rs=stmt.executeQuery(sql1);while(rs.next()){Article art=new Article();art.id=rs.getString("articleid");art.content=rs.getString("contenr");art.title=rs.getString("name");articles.add(art);} stmt.close();conn.close();%><table width="990" border="2" style="background:#ccccff"><tr height="35"><td align="left" width="660" colspan="9">此时所有的文章如下：</td></tr><tr height="30"><th>文章id</th><th>文章内容</th><th>文章标题</th></tr><% for(int i=0;i<articles.size();i++){%><tr height="25"><td><%=articles.get(i).getId()%></td><td><%=articles.get(i).getTitle()%></td><td><%=articles.get(i).getContent() %></td></tr><% } %></table></body></html>
0 0
Java web项目 爱分享社区管理文章管理部分代码

Java web项目爱分享社区管理文章管理部分代码
