JavaWeb-新闻内容操作

主页面

 绑定数据

 <ul class="classlist">
    <% 
    Class.forName("oracle.jdbc.driver.OracleDriver");
	//连接数据库
	String url = "jdbc:oracle:thin:@localhost:1521:orcl";
	Connection con = DriverManager.getConnection(url, "scott", "tiger");
	//创建对象
	PreparedStatement ps = con.prepareStatement("select * from news order by nid desc");
	ResultSet rs=ps.executeQuery();
	while(rs.next()){
    %>
      <li><%=rs.getString("ntitle") %><span> 作者：
      <%=rs.getString("nzz") %>
        news                                              
        &#160;&#160;&#160;&#160; <a href='#'>修改</a> &#160;&#160;&#160;&#160; 
        <a href='dodel.jsp?nid=<%=rs.getInt(1) %>' onclick='return clickdel()'>删除</a> </span> </li>
      <li class='space'></li>
      <%} %>
      <p align="right"> 当前页数:[1/3]&nbsp; <a href="#">下一页</a> <a href="#">末页</a> </p>
    </ul>

添加数据

<%
	int tid=Integer.valueOf(request.getParameter("ntid"));
	String ntitle=request.getParameter("ntitle");
	String nzz=request.getParameter("nauthor");
	String nzy=request.getParameter("nsummary");
	String nnr=request.getParameter("ncontent");
	
	Class.forName("oracle.jdbc.driver.OracleDriver");
	Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL", "scott", "tiger");
	int nextNid=1;
	PreparedStatement ps=con.prepareStatement("select max(nid) from news");
	ResultSet rs=ps.executeQuery();
	while(rs.next()){
		nextNid=rs.getInt(1)+1;
	}
	
	ps=con.prepareStatement("insert into news values(?,?,?,?,?,sysdate,0,?)");
	ps.setInt(1, nextNid);
	ps.setInt(2, tid);
	ps.setString(3, ntitle);
	ps.setString(4, nzz);
	ps.setString(5, nnr);
	ps.setString(6, nzy);
	
	int i=ps.executeUpdate();
	if(i>0){
		out.print("<script>alert('添加成功');location.href='admin.jsp'</script>");
	}else{
		out.print("<script>alert('添加失败');location.href='add_news.jsp'</script>");
	}
%>

删除数据

<%
	int nid=Integer.valueOf(request.getParameter("nid"));
	Class.forName("oracle.jdbc.driver.OracleDriver");
	Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL", "scott", "tiger");
	PreparedStatement ps=con.prepareStatement("delete news where nid="+nid);
	int i=ps.executeUpdate();
	if(i>0){
		out.print("<script>alert('删除成功');location.href='admin.jsp'</script>");
	}else{
		out.print("<script>alert('删除失败');location.href='admin.jsp'</script>");
	}
%>

修改数据

<%
    int nid=Integer.valueOf(request.getParameter("nid"));
	int tid=Integer.valueOf(request.getParameter("ntid"));
	String ntitle=request.getParameter("ntitle");
	String nzz=request.getParameter("nauthor");
	String nzy=request.getParameter("nsummary");
	String nnr=request.getParameter("ncontent");
	
	Class.forName("oracle.jdbc.driver.OracleDriver");
	Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL", "scott", "tiger");
	int nextNid=1;
	PreparedStatement ps=con.prepareStatement("select max(nid) from news");
	ResultSet rs=ps.executeQuery();
	while(rs.next()){
		nextNid=rs.getInt(1)+1;
	}
	
	ps=con.prepareStatement("update news set ntitle=?,nrr=?,nzy=? where nid="+nid);
	ps.setString(1, ntitle);
	ps.setString(2, nnr);
	ps.setString(3, nzy);
	
	int i=ps.executeUpdate();
	if(i>0){
		out.print("<script>alert(修改成功');location.href='admin.jsp'</script>");
	}else{
		out.print("<script>alert('修改失败');location.href='update_news.jsp'</script>");
	}
%>