1 概述
网站浏览者必须先进行注册登录系统后,才能够购买网站的商品。浏览者注册的信息提交到网站后台,由网站管理员进行管理。网站为用户提供,商品查询,商品购买的功能,并用购物车记录用户的购物选择,从而形成订单信息。用户登录,首先要有一个提供用户登录的表单。用户登录的表单应该嵌入整体的结构当中。在实际的应用中,可以这样设计,如果用户没有登录,在页面中显示用户登录的选项,用户登录后,可隐藏用户登录的选项而代之以用户的基本信息。
2 数据库表
表1 Bulletin公告表
字段名称 | 字段大小 | 字段类型 | 说明 |
id | 4 | 长整型(3) | 编号 |
title | 100 | 文本(202) | 标题 |
content | 536870910 | 备注/超级链接(203) | 内容 |
userId | 4 | 长整型(3) | 用户ID |
createTime | 50 | 文本(202) | 时间 |
表2 CustomerDetailInfo 客户详细信息
字段名称 | 字段大小 | 字段类型 | 说明 |
customerId | 4 | 长整型(3) | 编号 |
name | 50 | 文本(202) | 姓名 |
telphone | 20 | 文本(202) | 电话 |
movePhone | 20 | 文本(202) | 手机 |
address | 100 | 文本(202) | 地址 |
3 关键代码
package com.control.third;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.dao.GoodsInfoDAO;
import com.dao.GoodsTypeDAO;
import com.dao.GoodsTypeDetailInfoDAO;
import com.entity.GoodsInfo;
import com.entity.GoodsTypeDetail;
import com.util.PublicToolCheckParam;
import com.util.PublicToolShowGoodsInfolist;
public class ManageGoodsInfo extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = 7321956339019190364L;
static GoodsInfoDAO gdao = new GoodsInfoDAO();
public static void deleteGoodsInfo(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String goodsId = request.getParameter("goodsId");
String thirdId = request.getParameter("thirdId");
if(PublicToolCheckParam.checkNullAndEmpty(goodsId)){
gdao.deleteGoodsInfo(Integer.parseInt(goodsId));
String isSearching = request.getParameter("isSearching");
String currentPage = request.getParameter("currentPage");
if(PublicToolCheckParam.checkNullAndEmpty(isSearching)){
String key = request.getParameter("key");
PublicToolShowGoodsInfolist.searchGoodsInfoforthirdId(request, response, currentPage, key,thirdId);
request.setAttribute("isSearching", "yes");
}
else{
PublicToolShowGoodsInfolist.showGoodsInfoListforthirdId(request, response, currentPage,thirdId);
}
}
request.getRequestDispatcher("../third/manageGoodsInfo.jsp").forward(request, response);
}
public static void deleteMoreGoodsInfo(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String thirdId = request.getParameter("thirdId");
String currentPage = request.getParameter("currentPage");
String[] ckb = request.getParameterValues("ckb");
if(ckb != null){
for(int i=0;i<ckb.length;i++){
gdao.deleteGoodsInfo(Integer.parseInt(ckb[i]));
}
}
PublicToolShowGoodsInfolist.showGoodsInfoListforthirdId(request, response, currentPage,thirdId);
request.getRequestDispatcher("../third/manageGoodsInfo.jsp").forward(request, response);
}
public static void insertGoodsInfo(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String thirdId = request.getParameter("thirdId");
String str_goodsName = request.getParameter("goodsName");
String typeDetailInfo = request.getParameter("typeDetailInfo");
String str_price = request.getParameter("price");
String str_discount = request.getParameter("discount");
String[] ckb = request.getParameterValues("ckb");
String str_photo = request.getParameter("photo");
String str_remark = request.getParameter("remark");
String countRequire = request.getParameter("countRequire");
//String deadline = request.getParameter("deadline");
float discount = (float)10.0;
int isNew = 1;
int isRecommend = 1;
int status = 1;
String photo = null;
if(PublicToolCheckParam.checkNullAndEmpty(str_goodsName) && PublicToolCheckParam.checkNullAndEmpty(typeDetailInfo) && PublicToolCheckParam.checkNullAndEmpty(str_price) && PublicToolCheckParam.checkNullAndEmpty(countRequire) ){
if(PublicToolCheckParam.checkNullAndEmpty(str_discount)){
discount = Float.parseFloat(str_discount);
}
if(ckb != null){
for(int i=0;i<ckb.length;i++){
if(ckb[i].equals("isNew")){
isNew = 0;
}
else if(ckb[i].equals("isRecommend")){
isRecommend = 0;
}
else if(ckb[i].equals("status")){
status = 0;
}
}
}
if(PublicToolCheckParam.checkNullAndEmpty(str_photo)){
String[] photoArray = str_photo.split("\\\\");
photo = photoArray[photoArray.length-1];
photo = photo.replaceAll("'", "’");
}
str_goodsName = str_goodsName.replaceAll("'", "’");
gdao.addGoodsInfo(typeDetailInfo, str_goodsName, Double.parseDouble(str_price), discount, isNew, isRecommend, status, photo, str_remark,Integer.parseInt(countRequire),thirdId,"1");
String currentPage = request.getParameter("currentPage");
PublicToolShowGoodsInfolist.showGoodsInfoListforthirdId(request, response, currentPage,thirdId);
request.getRequestDispatcher("../third/manageGoodsInfo.jsp").forward(request, response);
}
}
public static void getTypeDetailInfo(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
PrintWriter out = response.getWriter();
String typeId = request.getParameter("goodsTypeId");
GoodsTypeDetailInfoDAO gtddao = new GoodsTypeDetailInfoDAO();
ArrayList<Object> typeDetailInfoList = gtddao.GoodsTypeDetailAllInfoDAO(Integer.parseInt(typeId));
if(typeDetailInfoList != null){
for(int i=0;i<typeDetailInfoList.size();i++){
GoodsTypeDetail typeDetailInfo = (GoodsTypeDetail)typeDetailInfoList.get(i);
out.println(typeDetailInfo.getTypeDetailInfo()+","+typeDetailInfo.getId()+"|");
}
}
out.flush();
out.close();
}
public static void searchGoodsInfo(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String thirdId = request.getParameter("thirdId");
String currentPage = request.getParameter("currentPage");
String key = request.getParameter("key");
key = new String(key.getBytes("iso-8859-1"),"utf-8");//转换关键词的编码
PublicToolShowGoodsInfolist.searchGoodsInfoforthirdId(request, response, currentPage, key,thirdId);
request.setAttribute("isSearching", "yes");
request.setAttribute("key", key);
request.getRequestDispatcher("../third/manageGoodsInfo.jsp").forward(request, response);
}
public static void showAddGoodsInfoPage(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String thirdId = request.getParameter("thirdId");
GoodsTypeDAO gtdao = new GoodsTypeDAO();
ArrayList<Object> typeList = gtdao.getAllType();
GoodsTypeDetailInfoDAO gtddao = new GoodsTypeDetailInfoDAO();
ArrayList<Object> typeDetailInfoList = gtddao.GoodsTypeDetailAllInfoDAO(6);
request.setAttribute("typeList", typeList);
request.setAttribute("typeDetailInfoList", typeDetailInfoList);
request.setAttribute("thirdId", thirdId);
request.getRequestDispatcher("../third/addGoodsInfo.jsp").forward(request, response);
}
public static void showManageGoodsInfoPage(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
String currentPage = request.getParameter("currentPage");
String goodsId = request.getParameter("goodsId");
String thirdId = request.getParameter("thirdId");
PublicToolShowGoodsInfolist.showGoodsInfoListforthirdId(request, response, currentPage,thirdId);
request.getRequestDispatcher("../third/manageGoodsInfo.jsp").forward(request, response);
}
public static void updateGoodsInfo(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String currentPage = request.getParameter("currentPage");
String submit = request.getParameter("submit");
String goodsId = request.getParameter("goodsId");
String thirdId = request.getParameter("thirdId");
if(PublicToolCheckParam.checkNullAndEmpty(goodsId)){
if(PublicToolCheckParam.checkNullAndEmpty(submit)){
if(submit.equals("1")){
String str_goodsName = request.getParameter("goodsName");
String typeDetailInfo = request.getParameter("typeDetailInfo");
String str_price = request.getParameter("price");
String str_discount = request.getParameter("discount");
String[] ckb = request.getParameterValues("ckb");
String str_photo = request.getParameter("photo");
String str_remark = request.getParameter("remark");
String countRequire = request.getParameter("countRequire");
// String deadline = request.getParameter("deadline");
float discount = (float)10.0;
int isNew = 1;
int isRecommend = 1;
int status = 1;
String photo = null;
if(PublicToolCheckParam.checkNullAndEmpty(str_goodsName) && PublicToolCheckParam.checkNullAndEmpty(typeDetailInfo) && PublicToolCheckParam.checkNullAndEmpty(str_price) && PublicToolCheckParam.checkNullAndEmpty(countRequire) ){
if(PublicToolCheckParam.checkNullAndEmpty(str_discount)){
discount = Float.parseFloat(str_discount);
}
if(ckb != null){
for(int i=0;i<ckb.length;i++){
if(ckb[i].equals("isNew")){
isNew = 0;
}
else if(ckb[i].equals("isRecommend")){
isRecommend = 0;
}
else if(ckb[i].equals("status")){
status = 0;
}
}
}
if(PublicToolCheckParam.checkNullAndEmpty(str_photo)){
String[] photoArray = str_photo.split("\\\\");
photo = photoArray[photoArray.length-1];
}
gdao.updateGoodsInfo(Integer.parseInt(goodsId),typeDetailInfo, str_goodsName, Double.parseDouble(str_price), discount, isNew, isRecommend, status, photo, str_remark,Integer.parseInt(countRequire),"1");
PublicToolShowGoodsInfolist.showGoodsInfoListforthirdId(request, response, currentPage,thirdId);
request.getRequestDispatcher("../third/manageGoodsInfo.jsp").forward(request, response);
}
}
}
else{
GoodsInfo goodsInfo = gdao.getQueryGoodsInfo(Integer.parseInt(goodsId));
GoodsTypeDAO gtdao = new GoodsTypeDAO();
ArrayList<Object> typeList = gtdao.getAllType();
GoodsTypeDetailInfoDAO gtddao = new GoodsTypeDetailInfoDAO();
ArrayList<Object> typeDetailInfoList = gtddao.GoodsTypeDetailAllInfoDAO(6);
request.setAttribute("typeList", typeList);
request.setAttribute("typeDetailInfoList", typeDetailInfoList);
request.setAttribute("goodsInfo", goodsInfo);
request.setAttribute("thirdId", thirdId);
request.getRequestDispatcher("../third/updateGoodsInfo.jsp").forward(request, response);
}
}
}
/**
* Constructor of the object.
*/
public ManageGoodsInfo() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String method = request.getParameter("method");
if(PublicToolCheckParam.checkNullAndEmpty(method)){
if(method.equals("showAddGoodsInfoPage")){
showAddGoodsInfoPage(request, response);
}
else if(method.equals("showManageGoodsInfoPage")){
showManageGoodsInfoPage(request, response);
}
else if(method.equals("insert")){
insertGoodsInfo(request, response);
}
else if(method.equals("delete")){
deleteGoodsInfo(request, response);
}
else if(method.equals("deleteMore")){
deleteMoreGoodsInfo(request, response);
}
else if(method.equals("search")){
searchGoodsInfo(request, response);
}
else if(method.equals("update")){
updateGoodsInfo(request, response);
}
else if(method.equals("getTypeDetailInfo")){
getTypeDetailInfo(request, response);
}
}
}
public static void coolGoodsInfo(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String GoodsId = request.getParameter("GoodsId");
String isCooled = request.getParameter("isCooled");
if(PublicToolCheckParam.checkNullAndEmpty(GoodsId) && PublicToolCheckParam.checkNullAndEmpty(isCooled)){
gdao.coolGoods(Integer.parseInt(GoodsId),Integer.parseInt(isCooled));
String isSearching = request.getParameter("isSearching");
String currentPage = request.getParameter("currentPage");
if(PublicToolCheckParam.checkNullAndEmpty(isSearching)){
String key = request.getParameter("key");
PublicToolShowGoodsInfolist.searchGoodsInfo(request, response, currentPage, key);
request.setAttribute("key", key);
request.setAttribute("isSearching", "yes");
}
else{
PublicToolShowGoodsInfolist.showGoodsInfoList(request, response, currentPage);
}
}
request.getRequestDispatcher("../third/manageGoodsInfo.jsp").forward(request, response);
}
public static void coolMoreGoodsInfo(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String currentPage = request.getParameter("currentPage");
String[] ckb = request.getParameterValues("ckb");
if(ckb != null){
for(int i=0;i<ckb.length;i++){
// cdao.coolGoods(Integer.parseInt(ckb[i]));
}
}
PublicToolShowGoodsInfolist.showGoodsInfoList(request, response, currentPage);
request.getRequestDispatcher("../third/manageGoodsInfo.jsp").forward(request, response);
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
4 效果演示
idea或eclipse开发,mysql数据库