edit.jsp

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

<%@ page contentType="text/html;charset=GBK" %>
<%@ 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 = "";
int currid = 0;
String sql = "";
ResultSet rs = null;
%>
<link rel="stylesheet" type="text/css" href="myshop.css">
<%
// 下面主要是为了进行显示
if(request.getParameter("id") != null) {
	id = request.getParameter("id");
	sql="select * from goods where id=" + request.getParameter("id");
    rs = conn.executeQuery( sql );
	if(rs.next()) {
		shopname  = rs.getString("shopname");
		shopcontent = rs.getString("shopcontent");
		price  = rs.getString("price");
		factory  = rs.getString("factory");
		times = rs.getString("times");
        number  = rs.getString("number"); 
		rs.close();
%>
		<form name=form1 method="post" action="save.jsp">
		  <input value="<%=id%>" type=hidden name=id>
		  <P align="center">商品名称：<INPUT size=95 name=shopname value=<%=shopname%>></P>
		  <P align="center">商品简介：<TEXTAREA cols=93 name=shopcontent rows=15><%=shopcontent%></TEXTAREA></P>
		  <P align="center">价格：<INPUT size=30 name=price value=<%=price%>>
		　生产公司：
		　<INPUT size=30 name=factory value=<%=factory%>></p>
          <p align="center">生产日期：<INPUT size=30 name=times value=<%=times%>>
		  数量:　<INPUT size=30 name=number value=<%=number%>>　</p>
		  <p align="center">
		  <INPUT class=buttonface type=submit value=" 确 定 ">
		  <INPUT class=buttonface type=reset value=" 清 除 "></p>
		</form>
<%
   } else {
		  out.println("<hr>");	
		  out.println("<center>非法的id号！</center>");
		  out.println("<hr>");	
   }
}
%>
<P align="right"><a href="manage.jsp">编辑商品</a>　<a href="index.jsp">查看商品</a>
</BODY>
</HTML>