简易新闻增删改查功能代码及主题部分功能

下面是新闻主页面的添加功能代码

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%
request.setCharacterEncoding("utf-8");
//接受添加页面数据
//新闻主题编号
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("ncontebt");

//连接数据库
Class.forName("oracle.jdbc.OracleDriver");
	String url="jdbc:oracle:thin:@localhost:1521:orcl";
	Connection con=DriverManager.getConnection(url, "scott","tiger");
	//获取新闻的下一个编号
	int nextNid=1;
	PreparedStatement ps=con.prepareStatement("select max(nid) from news");
	ResultSet rs=ps.executeQuery();
	if(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>");

	}
%>

这个是删除功能代码块