public2.jsp

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

<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.sql.*"%>
<jsp:useBean id="DBConn" class="jspeshop.DBConn" scope="page"/>
<%
if(session.getAttribute("name")==null){
  
response.sendRedirect("index.jsp");
}else{
request.setCharacterEncoding("GB2312");
Connection con =DBConn.GetConn();
  Statement st = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);

String publics=request.getParameter("publics");
String sql="update Publics set PUBLIC='"+publics+"' where NUM='1001'";


int i=st.executeUpdate(sql);

if (i>0){
 sql="select * from Publics ";
  ResultSet rs=st.executeQuery(sql);
 publics="";
if (rs.next())
{
publics=rs.getString ("PUBLIC");

response.sendRedirect("right.jsp");
}

}
%>