insertnews.java

：一个用JavaScript开发的新闻管理系统。

package news;
import java.io.*;
import java.sql.*;
import java.util.Date;
import java.io.IOException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

public class InsertNews extends HttpServlet {
  PrintWriter out;
  String title,style,from,content,postor,datetime;

public void doPost(HttpServletRequest request,
                  HttpServletResponse response)
    throws IOException
{
   response.setContentType("text/html;charset=GBK");
   out=response.getWriter();
   HttpSession session=request.getSession(false);
   //String id=(String)session.getAttribute("adminid");
   int adminid=(Integer)session.getAttribute("adminid");
   StrEncode SE=new StrEncode();
   title=SE.Encode(request.getParameter("title"));
   style=SE.Encode(request.getParameter("style"));
   from=SE.Encode(request.getParameter("from"));
   content=SE.Encode(request.getParameter("content"));
   content=SE.HtmlRep(content);
   Date date=new Date();
   datetime=date.toLocaleString();
   DBConn conn=new DBConn();
   try{
     String sql = "INSERT INTO news VALUES(?,?,?,?,?,?,?,?)";
     PreparedStatement pstmt = conn.getPstmt(sql);
     pstmt.setInt(1,0);
     pstmt.setString(2,title);
     pstmt.setString(3,style);
     pstmt.setString(4,from);
     pstmt.setString(5,content);
     pstmt.setInt(6,adminid);
     pstmt.setString(7,datetime);
     pstmt.setInt(8,0);
     int flag=pstmt.executeUpdate();
     pstmt.close();
     conn.DBclose();
     if(flag>0){
       response.sendRedirect("listnews.jsp");
     }
   }
   catch(Exception e){
     out.print("新闻发布写入数据库失败！"+e.toString());
   }
}
public void doGet(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException
    {
        doPost(request, response);
    }

}