save.jsp

这是用JSP+ACESS构建的网上购物系统,适合JSP初学者.

<%@ page contentType="text/html;charset=GBK" import="java.sql.*" %>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="conn" scope="page" class="myshop.conn"/>
<%!
String id = "";
String shopname = "";
String shopcontent = "";
String price = "";
String factory = "";
String times = "";
String number = "";
boolean flag1=false;
boolean flag2=false;
boolean flag3=false;
boolean flag4=false;
boolean flag5=false;
boolean flag6=false;
boolean flag7=false;
String sql = "";
ResultSet rs = null;
%>
<link rel="stylesheet" type="text/css" href="myshop.css">
<%
request.setCharacterEncoding("GBK");
if(request.getParameter("id")!=null)     {
	flag1=true; id = request.getParameter("id");
}
if(request.getParameter("shopname")!=null)  {
	flag2=true; shopname = request.getParameter("shopname");
}
if(request.getParameter("shopcontent")!=null)   {
	flag3=true; shopcontent = request.getParameter("shopcontent");  
}
if(request.getParameter("price")!=null)    {
	flag4=true; price = request.getParameter("price");
}
if(request.getParameter("factory")!=null)  {
	flag5=true; factory = request.getParameter("factory");
}
if(request.getParameter("times")!=null)  {
	flag6=true; times = request.getParameter("times");
}
if(request.getParameter("number")!=null)  {
	flag7=true; number = request.getParameter("number");
}
// 如果shopname不为空，则添加或修改记录
if(flag1 & flag2 & flag3 & flag4 & flag5 & flag6 & flag7) {
        // 执行插入操作
	    sql =  "update goods set shopname='" + shopname+"',shopcontent='" + shopcontent + "',price=" + price + ",factory='"+factory + "',times='" + times + "', goods.number="+number+" where id="+id;

	    //out.print(number);
        int i=conn.executeUpdate( sql );
		//out.print(sql+"<br>"+i);
		if(i!=0){
		out.println("<script>alert('添加成功！');window.location='manage.jsp';</script>");

		}
		
}
%>