JSP新闻主题维护

//设置编码-设置请求对象的编号
request.setCharacterEncoding("utf-8");
//添加接收添加的页面的数据
//新闻主题编号
int tid = Integer.valueOf(request.getParameter("tid"));
String tname=request.getParameter("tname");
//链接数据库，查询新闻
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://localhost:1433;DataBaseName=T277";
Connection con = DriverManager.getConnection(url, "sa", "a");

//用一个隐藏的标签接收 
PreparedStatement ps = con.prepareStatement("update subject set tname=? where tid="+tid);
ps.setString(1, tname);

//执行sql语句
int i = ps.executeUpdate();
if (i > 0) {
	out.print("<script>alert('修改成功');location.href='admin.jsp'</script>");
} else {
	out.print("<script>alert('修改失败');location.href='add_subup.jsp'</script>");
}

修改JSP主题的代码块

//设置编码-设置请求对象的编号
request.setCharacterEncoding("utf-8");
//添加接收添加的页面的数据
//新闻主题编号
//int tid = Integer.valueOf(request.getParameter("ntid"));
//新闻标题
//String ntitle=request.getParameter("nauthor");
String sname=request.getParameter("nauthor");

//链接数据库，查询新闻
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://localhost:1433;DataBaseName=T277";
Connection con = DriverManager.getConnection(url, "sa", "a");

//获取新闻的下一个编号
int nextTid=1;
PreparedStatement ps = con.prepareStatement("select max(tid) from subject");
ResultSet rs = ps.executeQuery();
if(rs.next()){
	nextTid=rs.getInt(1)+1;
}

ps=con.prepareStatement("insert into subject values(?,?)");
ps.setInt(1, nextTid);
ps.setString(2, sname);
//执行sql语句
int i = ps.executeUpdate();
if (i > 0) {
	out.print("<script>alert('添加成功');location.href='admin.jsp'</script>");
} else {
	out.print("<script>alert('添加失败');location.href='add_sub.jsp'</script>");
}

添加主题的代码块

function check(){
	  			var cauthor = document.getElementById("cauthor");
	  			var content = document.getElementById("ccontent");
	  			if(cauthor.value == ""){
	  				alert("用户名不能为空！！");
	  				return false;
	  			}else if(content.value == ""){
	  				alert("评论内容不能为空！！");
	  				return false;
	  			}
	  			return true;
	  		}

用户评论的方法

//获取要删除的用户编号
	String id = request.getParameter("nid");
	//把字符串转换为整数编号
	int nid = Integer.valueOf(id);
	//设置编码-设置请求对象的编号（防止乱码）
	request.setCharacterEncoding("utf-8");

	//链接数据库，查询新闻
	Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
	String url = "jdbc:sqlserver://localhost:1433;DataBaseName=T277";
	Connection con = DriverManager.getConnection(url, "sa", "a");
	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>");
	}

删除方法