save.jsp

JSP新闻管理系统

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<%
	request.setCharacterEncoding("gb2312");
	String title="";
	String content="";
	String author="";
	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="insert into news(title,content,author,pubdate) values('"+title+"','"+content+"','"+author+"',date()+time())";
	conn.executeUpdate(sql);	
	conn.close();
	response.sendRedirect("index.jsp");
%>