JavaWeb(绑定&删除&查看&修改)

一、查看

//接收主界面传过来的值=nid
	String nid=request.getParameter("nid");
	//思路:根据nid拿到其他对应的新闻信息=单个查询
	//jdbc连接数据库查询所有的新闻：id 新闻标题 作者
	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 * from xw where nid="+nid;
	//获得执行对象
	PreparedStatement ps=con.prepareStatement(sql);
	//获得结果集
	ResultSet rs=ps.executeQuery();
	//扩大作用域
	String title="";
	String author="";
	String addtime="";
	String content="";
	
	//循环遍历
	if(rs.next()){
		title=rs.getString(2);
		author=rs.getString(3);
		content=rs.getString(5);
		addtime=rs.getString(7);
	}
	//关闭资源
	if(con!=null&&!con.isClosed()){
		con.close();
	}
	if(ps!=null){
		ps.close();
	}
	if(rs!=null){
		rs.close();
	}

二、删除

	//接收
	String nid=request.getParameter("nid");
	//jdbc删除 delete from xw where nid=?
	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 * from xw where nid="+nid;
	//获得执行对象
	PreparedStatement ps=con.prepareStatement(sql);
	//开始执行
	int n=ps.executeUpdate();//影响行数
	//关闭资源
	if(con!=null&&!con.isClosed()){
		con.close();
	}
	if(ps!=null){
		ps.close();
	}
	//做判断
	if(n>0){
		//删除成功
		response.sendRedirect("/s5/news/admin.jsp");
	}
	else{
		//删除失败
		out.print("<script>alert('删除失败');location.href='admin.jsp';</script>");
	}

三、绑定

 <%
    	//jdbc连接Oracle查询所有的新闻：id 新闻标题 作者 
    	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,nname,nzz from xw order by nid desc";
   		//获得执行对象
   		PreparedStatement ps=con.prepareStatement(sql);
   		//获得结果集
   		ResultSet rs=ps.executeQuery();
   		while(rs.next()){
    %>
      <li><a href="/s5/news/read.jsp?nid=<%=rs.getInt(1) %>"><%=rs.getString(2) %></a>
      	<span> 作者：<%=rs.getString(3) %>&#160;&#160;&#160;&#160; 
	      <a href='/s5/news/update.jsp?nid=<%=rs.getInt(1) %>'>修改</a> &#160;&#160;&#160;&#160; 
	      <a href='/s5/news/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();
   		}
      %>

四、修改

//设置编码方式
	request.setCharacterEncoding("utf-8");
	//接收表单提交过来的值
	String nid=request.getParameter("nid");//没有传值!!!隐藏域传值
	String ntid=request.getParameter("ntid");
	String ntitle=request.getParameter("title");
	String nauthor=request.getParameter("author");
	String nsummary=request.getParameter("summary");
	String ncontent=request.getParameter("content");
	String naddtime=new Date().toLocaleString();//取系统当前时间
	//实现修改
	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="update xw set nname=?,nzz=?,nzy=?,nnr=?,nzt=?,ntime=? where nid=?";
	//获得执行对象
	PreparedStatement ps=con.prepareStatement(sql);
	//给占位符赋值
	ps.setString(1, ntitle);
	ps.setString(2, nauthor);
	ps.setString(3, nsummary);
	ps.setString(4, ncontent);
	ps.setInt(5, Integer.parseInt(ntid));
	ps.setString(6, naddtime);
	ps.setInt(7, Integer.parseInt(nid));
	
	//获得影响行数
	int n=ps.executeUpdate();
	//关闭资源
	if(con!=null&&!con.isClosed()){
		con.close();
	}
	if(ps!=null){
		ps.close();
	}
	//做判断
	if(n>0){//说明修改成功
		//新闻主界面
		response.sendRedirect("/s5/news/admin.jsp");
	}
	else{//说明修改失败
		out.print("<script>alert('修改失败');location.href='update.jsp?nid="+nid+"';</script>");
	}