jsp+servlet+mysql实现的在线鲜花商城
JDK:jdk1.8
ida:eclipse
数据库:mysql开发环境:
Eclipse ,MYSQL,JDK1.8,Tomcat 8.5
涉及技术点:
MVC模式、SpringBoot、Mybatis、Redis、HTML、log4j、druid、Bootstrap、
Semantic UI、Thymeleaf、JavaScript、CSS、JQUERY、Ajax等
适合学习J2EE的一段时间的熟手,代码思路清晰,注解详细,数据库用的是mysql5.1,服务器用的tomcat8.5,JDK版本1.8. 编程软件Eclispe J2EE版本。是典型MVC架构,并且前后台分离
主要功能:
代码已经上传github,下载地址:/21503882/network-flower
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import com.hr.entity.EASYBUY_PRODUCT;
public class EASYBUY_PRODUCTDao {
/**
* 查询所有
* @return
*/
public static ArrayList<EASYBUY_PRODUCT> selectAll(){
ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
ResultSet rs = null;
Connection conn = Basedao.getconn();
PreparedStatement ps = null;
try {
ps = conn.prepareStatement("select * from EASYBUY_PRODUCT");
rs = ps.executeQuery();
while(rs.next()){
EASYBUY_PRODUCT p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"),
rs.getString("EP_NAME"),
rs.getString("EP_DESCRIPTION"),
rs.getInt("EP_PRICE"),
rs.getInt("EP_STOCK"),
rs.getInt("EPC_ID"),
rs.getInt("EPC_CHILD_ID"),
rs.getString("EP_FILE_NAME"));
list.add(p);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
Basedao.closeall(rs, ps, conn);
}
return list;
}
/**
* 名字模糊查询
* @return
*/
public static ArrayList<EASYBUY_PRODUCT> selectAllByName(String name){
ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
ResultSet rs = null;
Connection conn = Basedao.getconn();
PreparedStatement ps = null;
try {
ps = conn.prepareStatement("select * from EASYBUY_PRODUCT where EP_NAME like ?");
ps.setString(1, "%"+name+"%");
rs = ps.executeQuery();
while(rs.next()){
EASYBUY_PRODUCT p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"),
rs.getString("EP_NAME"),
rs.getString("EP_DESCRIPTION"),
rs.getInt("EP_PRICE"),
rs.getInt("EP_STOCK"),
rs.getInt("EPC_ID"),
rs.getInt("EPC_CHILD_ID"),
rs.getString("EP_FILE_NAME"));
list.add(p);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
Basedao.closeall(rs, ps, conn);
}
return list;
}
/**
* 根据id查询单个
* @param id
* @return
*/
public static EASYBUY_PRODUCT selectById(int id){
EASYBUY_PRODUCT p = null;
ResultSet rs = null;
Connection conn = Basedao.getconn();
PreparedStatement ps = null;
try {
ps = conn.prepareStatement("select * from EASYBUY_PRODUCT where EP_ID=?");
ps.setInt(1, id);
rs = ps.executeQuery();
while(rs.next()){
p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"),
rs.getString("EP_NAME"),
rs.getString("EP_DESCRIPTION"),
rs.getInt("EP_PRICE"),
rs.getInt("EP_STOCK"),
rs.getInt("EPC_ID"),
rs.getInt("EPC_CHILD_ID"),
rs.getString("EP_FILE_NAME"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
Basedao.closeall(rs, ps, conn);
}
return p;
}
/**
* 根据fid查询所有
* @param fid
* @return
*/
public static ArrayList<EASYBUY_PRODUCT> selectAllByFid(int fid){
ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
ResultSet rs = null;
Connection conn = Basedao.getconn();
PreparedStatement ps = null;
try {
ps = conn.prepareStatement("select * from EASYBUY_PRODUCT where EPC_ID=?");
ps.setInt(1, fid);
rs = ps.executeQuery();
while(rs.next()){
EASYBUY_PRODUCT p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"),
rs.getString("EP_NAME"),
rs.getString("EP_DESCRIPTION"),
rs.getInt("EP_PRICE"),
rs.getInt("EP_STOCK"),
rs.getInt("EPC_ID"),
rs.getInt("EPC_CHILD_ID"),
rs.getString("EP_FILE_NAME"));
list.add(p);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
Basedao.closeall(rs, ps, conn);
}
return list;
}
/**
* 根据cid查询所有
* @param fid
* @return
*/
public static ArrayList<EASYBUY_PRODUCT> selectAllByCid(int cid){
ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
ResultSet rs = null;
Connection conn = Basedao.getconn();
PreparedStatement ps = null;
try {
ps = conn.prepareStatement("select * from EASYBUY_PRODUCT where EPC_CHILD_ID=?");
ps.setInt(1, cid);
rs = ps.executeQuery();
while(rs.next()){
EASYBUY_PRODUCT p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"),
rs.getString("EP_NAME"),
rs.getString("EP_DESCRIPTION"),
rs.getInt("EP_PRICE"),
rs.getInt("EP_STOCK"),
rs.getInt("EPC_ID"),
rs.getInt("EPC_CHILD_ID"),
rs.getString("EP_FILE_NAME"));
list.add(p);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
Basedao.closeall(rs, ps, conn);
}
return list;
}
public static int insert(EASYBUY_PRODUCT p){
String sql = "insert into EASYBUY_PRODUCT values(null,?,?,?,?,?,?,?)";
Object[] params = {p.getEP_NAME(),
p.getEP_DESCRIPTION(),
p.getEP_PRICE(),
p.getEP_STOCK(),
p.getEPC_ID(),
p.getEPC_CHILD_ID(),
p.getEP_FILE_NAME()};
return Basedao.exectuIUD(sql, params);
}
public static int update(EASYBUY_PRODUCT p){
if(!p.getEP_FILE_NAME().equals("")){
String sql = "update EASYBUY_PRODUCT set EP_NAME=?," +
"EP_DESCRIPTION=?," +
"EP_PRICE=?," +
"EP_STOCK=?," +
"EPC_ID=?," +
"EPC_CHILD_ID=?," +
"EP_FILE_NAME=? " +
" where EP_ID=?";
Object[] params = {p.getEP_NAME(),
p.getEP_DESCRIPTION(),
p.getEP_PRICE(),
p.getEP_STOCK(),
p.getEPC_ID(),
p.getEPC_CHILD_ID(),
p.getEP_FILE_NAME(),
p.getEP_ID()};
return Basedao.exectuIUD(sql, params);
}else{
Stringsql = "update EASYBUY_PRODUCT set EP_NAME=?," +
"EP_DESCRIPTION=?," +
"EP_PRICE=?," +
"EP_STOCK=?," +
"EPC_ID=?," +
"EPC_CHILD_ID=? " +
" where EP_ID=?";
Object[] params = {p.getEP_NAME(),
p.getEP_DESCRIPTION(),
p.getEP_PRICE(),
p.getEP_STOCK(),
p.getEPC_ID(),
p.getEPC_CHILD_ID(),
p.getEP_ID()};
return Basedao.exectuIUD(sql, params);
}
}
public static int del(int id){
String sql = "delete from EASYBUY_PRODUCT where EP_ID=?";
Object[] params = {id};
return Basedao.exectuIUD(sql, params);
}
public static int totalPage(int count){
int tpage = 1;
Connection conn = Basedao.getconn();
PreparedStatement ps = null;
ResultSet rs = null;
try {
ps = conn.prepareStatement("select count(*) from EASYBUY_PRODUCT");
rs = ps.executeQuery();
if(rs.next()){
int sum = rs.getInt(1);//获得表的总行数
if(sum%count==0){
tpage = sum/count;//总行数是每页行数的整倍数
}else {
tpage = sum/count+1;//不是整倍数要加一
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
Basedao.closeall(rs, ps, conn);
}
return tpage;
}
public static int totalPageByFid(int count,int fid){
int tpage = 1;
Connection conn = Basedao.getconn();
PreparedStatement ps = null;
ResultSet rs = null;
try {
ps = conn.prepareStatement("select count(*) from EASYBUY_PRODUCT where EPC_ID=?");
ps.setInt(1, fid);
rs = ps.executeQuery();
if(rs.next()){
int sum = rs.getInt(1);//获得表的总行数
if(sum%count==0){
tpage = sum/count;//总行数是每页行数的整倍数
}else {
tpage = sum/count+1;//不是整倍数要加一
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
Basedao.closeall(rs, ps, conn);
}
return tpage;
}
public static int totalPageByCid(int count,int cid){
int tpage = 1;
Connection conn = Basedao.getconn();
PreparedStatement ps = null;
ResultSet rs = null;
try {
ps = conn.prepareStatement("select count(*) from EASYBUY_PRODUCT where EPC_CHILD_ID=?");
ps.setInt(1, cid);
rs = ps.executeQuery();
if(rs.next()){
int sum = rs.getInt(1);//获得表的总行数
if(sum%count==0){
tpage = sum/count;//总行数是每页行数的整倍数
}else {
tpage = sum/count+1;//不是整倍数要加一
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
Basedao.closeall(rs, ps, conn);
}
return tpage;
}
public static int totalPageByName(int count,String name){
int tpage = 1;
Connection conn = Basedao.getconn();
PreparedStatement ps = null;
ResultSet rs = null;
try {
ps = conn.prepareStatement("select count(*) from EASYBUY_PRODUCT where EP_NAME like ?");
ps.setString(1, "%"+name+"%");
rs = ps.executeQuery();
if(rs.next()){
int sum = rs.getInt(1);//获得表的总行数
if(sum%count==0){
tpage = sum/count;//总行数是每页行数的整倍数
}else {
tpage = sum/count+1;//不是整倍数要加一
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
Basedao.closeall(rs, ps, conn);
}
return tpage;
}
/**
* 分页查询
* @param cpage
* @param count
* @return
*/
public static ArrayList<EASYBUY_PRODUCT> selectAll(int cpage,int count){
ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
Connection conn =Basedao.getconn();
PreparedStatement ps = null;
ResultSet rs = null;
String sql = "select * from EASYBUY_PRODUCT order by EP_ID desc limit ?,? ";
try {
ps = conn.prepareStatement(sql);
//设置数据区间
ps.setInt(1, count*(cpage-1));
ps.setInt(2, count);
rs = ps.executeQuery();
while(rs.next()) {
EASYBUY_PRODUCT p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"),
rs.getString("EP_NAME"),
rs.getString("EP_DESCRIPTION"),
rs.getInt("EP_PRICE"),
rs.getInt("EP_STOCK"),
rs.getInt("EPC_ID"),
rs.getInt("EPC_CHILD_ID"),
rs.getString("EP_FILE_NAME"));
list.add(p);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
Basedao.closeall(rs, ps, conn);
}
return list;
}
/**
* fid分页查询
* @param cpage
* @param count
* @return
*/
public static ArrayList<EASYBUY_PRODUCT> selectAllByFid(int cpage,int count,int fid){
ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
Connection conn =Basedao.getconn();
PreparedStatement ps = null;
ResultSet rs = null;
String sql = "select * from EASYBUY_PRODUCT where EPC_ID = ? order by EP_ID desc limit ?,?";
try {
ps = conn.prepareStatement(sql);
//设置数据区间
ps.setInt(1, fid);
ps.setInt(2, count*(cpage-1));
ps.setInt(3, count);
rs = ps.executeQuery();
while(rs.next()) {
EASYBUY_PRODUCT p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"),
rs.getString("EP_NAME"),
rs.getString("EP_DESCRIPTION"),
rs.getInt("EP_PRICE"),
rs.getInt("EP_STOCK"),
rs.getInt("EPC_ID"),
rs.getInt("EPC_CHILD_ID"),
rs.getString("EP_FILE_NAME"));
list.add(p);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
Basedao.closeall(rs, ps, conn);
}
return list;
}
/**
* cid分页查询
* @param cpage
* @param count
* @return
*/
public static ArrayList<EASYBUY_PRODUCT> selectAllByCid(int cpage,int count,int cid){
ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
Connection conn =Basedao.getconn();
PreparedStatement ps = null;
ResultSet rs = null;
String sql = "select * from EASYBUY_PRODUCT where EPC_CHILD_ID = ? order by EP_ID desc limit ?,?";
try {
ps = conn.prepareStatement(sql);
//设置数据区间
ps.setInt(1, cid);
ps.setInt(2, count*(cpage-1));
ps.setInt(3, count);
rs = ps.executeQuery();
while(rs.next()) {
EASYBUY_PRODUCT p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"),
rs.getString("EP_NAME"),
rs.getString("EP_DESCRIPTION"),
rs.getInt("EP_PRICE"),
rs.getInt("EP_STOCK"),
rs.getInt("EPC_ID"),
rs.getInt("EPC_CHILD_ID"),
rs.getString("EP_FILE_NAME"));
list.add(p);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
Basedao.closeall(rs, ps, conn);
}
return list;
}
/**
* 根据id数组查询单个,并放入集合
* @param id
* @return
*/
public static ArrayList<EASYBUY_PRODUCT> selectById(ArrayList<Integer> ids){
ArrayList<EASYBUY_PRODUCT> lastlylist = new ArrayList<EASYBUY_PRODUCT>();
EASYBUY_PRODUCT p = null;
ResultSet rs = null;
Connection conn = Basedao.getconn();
PreparedStatement ps = null;
try {
for(int i=0;i<ids.size();i++){
ps = conn.prepareStatement("select * from EASYBUY_PRODUCT where EP_ID=?");
ps.setInt(1, ids.get(i));
rs = ps.executeQuery();
while(rs.next()){
p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"),
rs.getString("EP_NAME"),
rs.getString("EP_DESCRIPTION"),
rs.getInt("EP_PRICE"),
rs.getInt("EP_STOCK"),
rs.getInt("EPC_ID"),
rs.getInt("EPC_CHILD_ID"),
rs.getString("EP_FILE_NAME"));
lastlylist.add(p);
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
Basedao.closeall(rs, ps, conn);
}
return lastlylist;
}
/**
* 查询特价商品
* @return
*/
public static ArrayList<EASYBUY_PRODUCT> selectAllByT(){
ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
Connection conn =Basedao.getconn();
PreparedStatement ps = null;
ResultSet rs = null;
String sql = "select * from EASYBUY_PRODUCT order by EP_PRICE asc limit 0,9";
try {
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next()) {
EASYBUY_PRODUCT p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"),
rs.getString("EP_NAME"),
rs.getString("EP_DESCRIPTION"),
rs.getInt("EP_PRICE"),
rs.getInt("EP_STOCK"),
rs.getInt("EPC_ID"),
rs.getInt("EPC_CHILD_ID"),
rs.getString("EP_FILE_NAME"));
list.add(p);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
Basedao.closeall(rs, ps, conn);
}
return list;
}
/**
* 查询热卖商品
* @return
*/
public static ArrayList<EASYBUY_PRODUCT> selectAllByHot(){
ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
Connection conn =Basedao.getconn();
PreparedStatement ps = null;
ResultSet rs = null;
String sql = "select * from ( select tab1.* from ( select * from easybuy_product a, (select ep_id eod_ep_id,sum(EOD_QUANTITY) buysum from EASYBUY_ORDER_DETAIL group by EP_id order by sum(EOD_QUANTITY) desc) b where a.ep_id=b.eod_ep_id order by buysum desc ) tab1) tab2 limit 0,8";
try {
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next()) {
EASYBUY_PRODUCT p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"),
rs.getString("EP_NAME"),
rs.getString("EP_DESCRIPTION"),
rs.getInt("EP_PRICE"),
rs.getInt("EP_STOCK"),
rs.getInt("EPC_ID"),
rs.getInt("EPC_CHILD_ID"),
rs.getString("EP_FILE_NAME"));
list.add(p);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
Basedao.closeall(rs, ps, conn);
}
return list;
}
}
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib uri="/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>猿来入此-商城 - 首页</title>
<link type="text/css" rel="stylesheet" href="css/style.css" />
<script type="text/javascript" src="scripts/function.js"></script>
<style type="text/css">
#magnifier{
width:300px;
height:300px;
position:absolute;
/*top:200px;
left:400px;*/
font-size:0;
border:1px solid #000;
}
#img{
width:300px;
height:300px;
}
#Browser{
border:1px solid #000;
z-index:100;
position:absolute;
background:#555;
}
#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>
<%@ include file="/include/search_bar.jsp" %>
<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 © 猿来入此 All Rights Reserved. 沪ICP备案000001号
</div>
</body>
</html>
如果觉得《jsp+servlet+mysql实现的鲜花商城》对你有帮助,请点赞、收藏,并留下你的观点哦!