javaweb绑定数据&删除&查看&修改

一、绑定数据 连接数据库

<ul class="classlist">
			<%
				String CNAME="oracle.jdbc.driver.OracleDriver";
				String URL="jdbc:oracle:thin:@localhost:1521:orcl";
				//加载驱动
				Class.forName(CNAME);
				//创建连接
				Connection con=DriverManager.getConnection(URL, "scott", "tiger");
				//定义sql语句
				String sql = "select nid,ntitle,nauthor from news280";
				//获得执行对象
				PreparedStatement ps = con.prepareStatement(sql);
				//获得结果集
				ResultSet rs = ps.executeQuery();
				//循环遍历
				while(rs.next()){
			%>
				 <li id="aa"> <a href="/JW05/read.jsp?nid=<%=rs.getInt(1)%>"><%=rs.getString(2) %></a>
       <span> 作者：<%=rs.getString(3) %>&#160;&#160;&#160;&#160;
        <a href='/JW05/update.jsp?nid=<%=rs.getInt(1)%>'>修改</a> &#160;&#160;&#160;&#160; 
        <a href='/JW05/dodelete.jsp?nid=<%=rs.getInt(1) %>' onclick='return clickdel()' >删除</a> 
         </span> 
        </li>
				<%
					}
				//关闭资源
				if(con!=null&&!con.isClosed()){
					con.close();
				}
				if(ps!=null){
					ps.close();
				}
				if(rs!=null){
					rs.close();
				}
				%>
				<li class='space'></li>
				<p align="right">
					当前页数:[1/3]&nbsp; <a href="#">下一页</a> <a href="#">末页</a>
				</p>
			</ul>

二、删除

---------------------------------------------------------------------------------------
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%
  //接收nid 根据键拿到值
  	String nid=request.getParameter("nid");\\传过来的nid
    String URL="jdbc:oracle:thin:@localhost:1521:orcl";
	 String CNAME="oracle.jdbc.driver.OracleDriver";
	
	//加载驱动
	Class.forName(CNAME);
	//创建连接
	Connection con=DriverManager.getConnection(URL, "scott", "tiger");
	//定义sql语句
	String sql="delete from news280 where nid="+nid;
	//获取执行对象
	PreparedStatement ps=con.prepareStatement(sql);
	 int n=ps.executeUpdate();
	if(n>0){
		response.sendRedirect("/JW05/news/admin.jsp");
	}
	else{
		out.print("<script>slert('删除失败');location.href=&#