update.jsp

来自「课程设计中的在线书店源码」· JSP 代码 · 共 25 行

<%@ include file="check.jsp"%>
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<%
	String editid="";
	String title="";
	String content="";
	String author="";
	String pubdate="";
	request.setCharacterEncoding("gb2312");
	if(request.getParameter("editid")!=null)
		editid=request.getParameter("editid");
	if(request.getParameter("title")!=null)
		title=request.getParameter("title");
	if(request.getParameter("content")!=null)
		content=request.getParameter("content");
	if(request.getParameter("author")!=null)
		author=request.getParameter("author");

	String sql="update news set title='"+title+"',content='"+content+"',author='"+author+"' where id="+editid;
	conn.executeUpdate(sql);
	conn.close();
	response.sendRedirect("manage.jsp");
%>