jsp servlet mysql实现的在线商城项目

运行环境

jdk：1.7 1.8
eclipse java ee
mysql

代码已经上传github，下载地址： https://github.com/21503882/net-cosmetic

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-

transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

#mag{
    border:1px solid #000;
    overflow:hidden;
    z-index:100;
}
</style>
<script type="text/javascript">
function searchHot(name){
    location.href='selectProductList?name='+name;
}
function getEventObject(W3CEvent) {//事件标准化函数
    return W3CEvent || window.event;
}
function getPointerPosition(e) {//兼容浏览器的鼠标x,y获得函数
    e = e || getEventObject(e);
    var x = e.pageX || (e.clientX + (document.documentElement.scrollLeft || document.body.scrollLeft));
    var y = e.pageY || (e.clientY + (document.documentElement.scrollTop || document.body.scrollTop));

    return { 'x':x,'y':y };
}
function setOpacity(elem,level) {//兼容浏览器设置透明值
    if(elem.filters) {
        elem.style.filter = 'alpha(opacity=' + level * 100 + ')';
    } else {
        elem.style.opacity = level;
    }
}
function css(elem,prop) {    //css设置函数,可以方便设置css值,并且兼容设置透明值
    for(var i in prop) {
        if(i == 'opacity') {
            setOpacity(elem,prop[i]);
        } else {
            elem.style[i] = prop[i];
        }
    }
    return elem;
}
var magnifier = {
    m : null,

    init:function(magni){
        var m = this.m = magni || {
            cont : null,    //装载原始图像的div
            img : null,    //放大的图像
            mag : null,    //放大框
            scale : 20    //比例值,设置的值越大放大越大,但是这里有个问题就是如果不可以整除时,会产生些很小的白边,目前不知道如何解决
        }

        css(m.img,{
            'position' : 'absolute',
            'width' : (m.cont.clientWidth * m.scale) + 'px',                //原始图像的宽*比例值
            'height' : (m.cont.clientHeight * m.scale) + 'px'                //原始图像的高*比例值
            })

        css(m.mag,{
            'display' : 'none',
            'width' : m.cont.clientWidth + 'px',    //m.cont为原始图像,与原始图像等宽
            'height' : m.cont.clientHeight + 'px',
            'position' : 'absolute',
            'left' : m.cont.offsetLeft + m.cont.offsetWidth + 10 + 'px',//放大框的位置为原始图像的右方远10px
            'top' : m.cont.offsetTop + 'px'
            })

        var borderWid = m.cont.getElementsByTagName('div')[0].offsetWidth - m.cont.getElementsByTagName('div')[0].clientWidth;        //获取border的宽

        css(m.cont.getElementsByTagName('div')[0],{            //m.cont.getElementsByTagName('div')[0]为浏览框
            'display' : 'none',                                //开始设置为不可见
            'width' : m.cont.clientWidth / m.scale - borderWid + 'px',            //原始图片的宽/比例值 - border的宽度
            'height' : m.cont.clientHeight / m.scale - borderWid + 'px',//原始图片的高/比例值 - border的宽度
            'opacity' : 0.5//设置透明度
            })

        m.img.src = m.cont.getElementsByTagName('img')[0].src;//让原始图像的src值给予放大图像
        m.cont.style.cursor = 'crosshair';

        m.cont.onmouseover = magnifier.start;

    },

    start:function(e){

        if(document.all){//只在IE下执行,主要避免IE6的select无法覆盖
            magnifier.createIframe(magnifier.m.img);
        }

        this.onmousemove = magnifier.move;//this指向m.cont
        this.onmouseout = magnifier.end;
    },

    move:function(e){
        var pos = getPointerPosition(e);        //事件标准化

        this.getElementsByTagName('div')[0].style.display = '';

        css(this.getElementsByTagName('div')[0],{
            'top' : Math.min(Math.max(pos.y - this.offsetTop - parseInt(this.getElementsByTagName('div')[0].style.height) / 2,0),this.clientHeight - this.getElementsByTagName('div')[0].offsetHeight) + 'px',
            'left' : Math.min(Math.max(pos.x - this.offsetLeft - parseInt(this.getElementsByTagName('div')[0].style.width) / 2,0),this.clientWidth - this.getElementsByTagName('div')[0].offsetWidth) + 'px'            //left=鼠标x - this.offsetLeft - 浏览框宽/2,Math.max和Math.min让浏览框不会超出图像
            })

        magnifier.m.mag.style.display = '';

        css(magnifier.m.img,{
            'top' : - (parseInt(this.getElementsByTagName('div')[0].style.top) * magnifier.m.scale) + 'px',
            'left' : - (parseInt(this.getElementsByTagName('div')[0].style.left) * magnifier.m.scale) + 'px'
            })

    },

    end:function(e){
        this.getElementsByTagName('div')[0].style.display = 'none';
        magnifier.removeIframe(magnifier.m.img);        //销毁iframe

        magnifier.m.mag.style.display = 'none';
    },

    createIframe:function(elem){
        var layer = document.createElement('iframe');
        layer.tabIndex = '-1';
        layer.src = 'javascript:false;';
        elem.parentNode.appendChild(layer);

        layer.style.width = elem.offsetWidth + 'px';
        layer.style.height = elem.offsetHeight + 'px';
    },

    removeIframe:function(elem){
        var layers = elem.parentNode.getElementsByTagName('iframe');
        while(layers.length >0){
            layers[0].parentNode.removeChild(layers[0]);
        }
    }
}
window.onload = function(){
    magnifier.init({
                   cont : document.getElementById('magnifier'),
                   img : document.getElementById('magnifierImg'),
                   mag : document.getElementById('mag'),
                   scale : 3
                   });
}
    function jian(){
        var count = parseInt(document.getElementById("count").value);
        if(count>0){
            count--;
        }
        if(count==0){
            count=1;
        }
        document.getElementById("count").value = count;
    }
    function jia(){
        var count = parseInt(document.getElementById("count").value);
        var stock = parseInt(document.getElementById("stock").innerHTML);
        if(count<stock){
            count++;
        }
        document.getElementById("count").value = count;
    }
    function checkcount(){
        var count = parseInt(document.getElementById("count").value);
        var stock = parseInt(document.getElementById("stock").innerHTML);
        if(count>stock){
            alert('库存不足');
            document.getElementById("count").value = stock;
        }
        if(count==0){
            alert('购买数量不能小于1哦,亲');
            document.getElementById("count").value = 1;
        }
        if(count<0){
            alert('数量非法');
            document.getElementById("count").value = 1;
        }
    }
    function shopAdd(idd){
        var id = idd;
        var count = parseInt(document.getElementById("count").value);
        location.href='shopAdd?id='+id+'&count='+count;
    }
    function shopAdd2(idd){
        var id = idd;
        var count = parseInt(document.getElementById("count").value);
        location.href='shopAdd2?id='+id+'&count='+count;
    }
</script>
<script type="text/javascript">
function selectname(){
      var name = document.getElementById("selectname").value;
      location.href='selectProductList?name='+name;
}
</script>
</head>
<body>
<div id="header" class="wrap">
    <div id="logo"><img src="images/logo.gif" /></div>
    <div class="help"><c:if test="${name!=null}"><a href="selectdd?dd=${name.EU_USER_ID }">个人订单</a></c:if><c:if test="${name!=null}">当前用户${name.EU_USER_ID }</c:if><a href="ShopSelect" class="shopping">购物车</a><c:if test="${name==null}"><a href="login.jsp">登录</a>|<a href="register.jsp">注册</a></c:if><c:if test="${name!=null}"><a href="zx">退出</a></c:if><a href="SelallServlet">留言</a><c:if test="${name.EU_STATUS==2}"><a href="manage/index.jsp" >去后台</a></c:if></div>
    <div class="navbar">
        <ul class="clearfix">
            <c:choose>
            <c:when test="${empty selected_fid}">
            <li class="current" ><a href="indexSelect">首页</a></li>
            </c:when>
            <c:otherwise>
            <li ><a href="indexSelect">首页</a></li>
            </c:otherwise>
            </c:choose>
            <c:forEach var="f" items="${flist}">
            <c:choose>
            <c:when test="${selected_fid == f.EPC_ID}">
            <li class="current" ><a href="selectProductList?fid=${f.EPC_ID }">${f.EPC_NAME }</a></li>
            </c:when>
            <c:otherwise>
            <li><a href="selectProductList?fid=${f.EPC_ID }">${f.EPC_NAME }</a></li>
            </c:otherwise>
            </c:choose>
            </c:forEach>
        </ul>
    </div>
</div>
<div id="childNav">
    <div class="wrap">
        <ul class="clearfix">
            <li class="first"><a href="javascript:searchHot('音乐')">音乐</a></li>
            <li><a href="javascript:searchHot('影视')">影视</a></li>
            <li><a href="javascript:searchHot('少儿')">少儿</a></li>
            <li><a href="javascript:searchHot('动漫')">动漫</a></li>
            <li><a href="javascript:searchHot('小说')">小说</a></li>
            <li><a href="javascript:searchHot('外语')">外语</a></li>
            <li><a href="javascript:searchHot('数码相机')">数码相机</a></li>
            <li><a href="javascript:searchHot('笔记本')">笔记本</a></li>
            <li><a href="javascript:searchHot('羽绒服')">羽绒服</a></li>
            <li><a href="javascript:searchHot('秋冬靴')">秋冬靴</a></li>
            <li><a href="javascript:searchHot('运动鞋')">运动鞋</a></li>
            <li><a href="javascript:searchHot('美容护肤')">美容护肤</a></li>
            <li><a href="javascript:searchHot('饰品')">饰品</a></li>
            <li class="last"><input type="text" id="selectname"/><a href="javascript:selectname()">搜索</a></li>
        </ul>
    </div>
</div>
<div id="position" class="wrap">
    您现在的位置：<a href="indexSelect">猿来入此-商城</a> > <a href="selectProductList">商品分类</a> > ${title }
</div>
<div id="main" class="wrap">
    <div class="lefter">
        <div class="box">
            <h2>商品分类</h2>
            <dl>
                <dt><a href="selectProductList">全部商品</a></dt>
                <c:forEach var="f" items="${flist}">
                    <dt><a href="selectProductList?fid=${f.EPC_ID }">${f.EPC_NAME }</a></dt>
                    <c:forEach var="c" items="${clist}">
                        <c:if test="${f.EPC_ID==c.EPC_PARENT_ID}">
                            <c:if test="${p.EPC_CHILD_ID!=c.EPC_ID}">
                                <dd><a href="selectProductList?cid=${c.EPC_ID }">${c.EPC_NAME }</a></dd>
                            </c:if>
                        </c:if>
                    </c:forEach>
                </c:forEach>
            </dl>
        </div>
        <div class="spacer"></div>
        <div class="last-view">
            <h2>最近浏览</h2>
            <dl class="clearfix">
                <c:forEach var="lastp" items="${lastlylist}">
                    <dt><a href="selectProductView?id=${lastp.EP_ID }"><img height="40" src="images/product/${lastp.EP_FILE_NAME }" /></a></dt>
                    <dd><a href="selectProductView?id=${lastp.EP_ID }">${lastp.EP_NAME }</a></dd>
                </c:forEach>
            </dl>
        </div>
    </div>
    <div id="product" class="main">
        <h1>${p.EP_NAME }</h1>
        <div class="infos">
        <div id="magnifier">
            <img src="images/product/${p.EP_FILE_NAME }" id="img" />
            <div id="Browser"></div>
        </div>
        <div id="mag"><img id="magnifierImg" /></div>

            <div class="buy">
                <p>商城价：<span class="price">￥${p.EP_PRICE }.00</span></p>
                <p>邮递方式：<font color="red">圆通快递</font></p>
                <p>热卖程度：☆☆☆☆☆</p>
                <p>库存：<span id="stock">${p.EP_STOCK }</span></p>
                <p>购买数量：<input type="button" value=" - " οnclick="jian()"/><input align="middle" type="text" value="1" id="count" name="count" οnblur="checkcount()"/><input type="button" value=" + " οnclick="jia()"/></p>
                <div class="button"><input type="button" name="button" value="" οnclick="shopAdd(${p.EP_ID})" /><a href="javascript:shopAdd2(${p.EP_ID})">放入购物车</a></div>
            </div>
            <div class="clear"></div>
        </div>
        <div class="introduce">
            <h2><strong>商品详情</strong></h2>
            <div class="text">
                ${p.EP_DESCRIPTION }<br />
            </div>
        </div>
    </div>
    <div class="clear"></div>
</div>
<div id="footer">
    Copyright © 扣扣+79120063
</div>
</body>
</html>

原文链接：https://blog.csdn.net/MyQQ79120063/article/details/104276339