JavaWEB新闻展示&删除&查看&修改&绑定

1.显示

<!-- 功能：显示所有新闻  -->
				<%
				//数据库交互oracleDriver
				//加载驱动
				Class.forName("oracle.jdbc.driver.OracleDriver");
				//建立连接
				Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott","123");
				//sql
				String sql="select *from tb_t281_news";
				PreparedStatement ps=conn.prepareStatement(sql);
				//返回结果集对象
				ResultSet rs=ps.executeQuery();
				//遍历
				while(rs.next()){
					out.print("<li><a href='adminNewsDetail.jsp?nid="+rs.getInt(1)+"'>"+rs.getString(3)+"</a> <span> 作者："+rs.getString(4)+"&#160;&#160;&#160;&#160; <a href='adminEditNews.jsp?nid="+rs.getInt(1)+"'>修改</a> &#160;&#160;&#160;&#160; <a href='#' onclick='r