news_add2.jsp

来自「此小软件实现了小型超市的进销存系统,它展示了小型超市的进货和销售,还有库存的各种」· JSP 代码 · 共 28 行

<%@page contentType="text/html; charset=gb2312"%>
<jsp:useBean id="DBConn" scope="page" class="jspeshop.DBConn"/>
<%@page import="java.sql.*"%>
<%


  if (session.getAttribute("name") == null) {
   
    response.sendRedirect("index.jsp");
  }
  else{
  request.setCharacterEncoding("GB2312");
  String title=request.getParameter("title");
  String body=request.getParameter("body1");
  String sql="insert into News(NEWS_TITLE,NEWS_BODY) values(?,?) ";
  Connection con=DBConn.GetConn();
  PreparedStatement st=con.prepareStatement(sql);
  st.setString(1,title);
  st.setString(2,body);
  int row=st.executeUpdate();
  if(row>0){
     response.sendRedirect("news_add.jsp");
  }

   }

  %>