基于javaweb+mysql的jsp+servlet在线商城鲜花花卉商城(前台、后台)(java+jsp+servlet+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
功能说明
在线商城，实现了商城的基本功能
如分类展示商品信息、搜索商品信息、用户注册登录、添加商品到购物车、提交订单、个人中心查看订单、留言板留言等
管理员登录后台后可以查看管理用户信息、商品分类信息、商品信息、新闻信息、留言信息、订单信息等。
idea或eclipse
后台管理员
前台用户
技术框架
CSS JavaScript JSP Servlet JDBC MySQL
基于javaweb+mysql的JSP+Servlet在线商城鲜花花卉商城(前台、后台)(java+jsp+servlet+mysql)
String [] sPPrice=arg0.getParameterValues("sPPrice");
//购买后对商品表的库存进行修改
for(int i=0;i<EP_ID.length;i++){
int count5=ESDao.updateStock(Integer.parseInt(quantity[i]),Integer.parseInt(EP_ID[i]));
}
//商品单个总价
int [] pprice=new int[EP_ID.length];
for(int i=0;i<EP_ID.length;i++){
pprice[i]=Integer.parseInt(quantity[i])*Integer.parseInt(sPPrice[i]);
}
/得到序列
//往订单表里添加数据
int count=ESDao.insertDD(id, name, address,Integer.parseInt(price));
int getSequenceId=ESDao.getSequenceId();
//循环往订单详情添加
for(int i=0;i<EP_ID.length;i++){
EASYBUY_ORDER_DETAIL eod=new EASYBUY_ORDER_DETAIL(1,getSequenceId,Integer.parseInt(EP_ID[i]),Integer.parseInt(quantity[i]),pprice[i]);
int count2=ESDao.eodInsert(eod);
}
// 开单后，修改购物车
String [] esID=arg0.getParameterValues("esID");
for(int i=0;i<esID.length;i++){
int count3 =ESDao.esdelete(Integer.parseInt(esID[i]));
}
/
if(count>0){
out.print("<script>");
out.print("alert('购物成功');");
out.print("location.href='shopping-result.jsp';");
out.print("</script>");
out.close();
}else{
out.print("<script>");
out.print("alert('购物失败，请重新选择商品');");
out.print("location.href='ShopSelect';");
out.print("</script>");
//把当前页数传递给guestbook.jsp使用
req.setAttribute("page", page);
// 跳
req.getRequestDispatcher("guestbook.jsp").forward(req,resp);
}else{
req.setAttribute("list", list);
//把总页数传递给guestbook.jsp 使用
req.setAttribute("max_page", max_page);
//把当前页数传递给guestbook.jsp使用
req.setAttribute("page", page);
// 跳
req.getRequestDispatcher("guestbook.jsp").forward(req,resp);
}
}
}
public class SelectDD extends HttpServlet {
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
req.setCharacterEncoding("UTF-8");
//查询分类数据
ArrayList<EASYBUY_PRODUCT_CATEGORY> flist = EASYBUY_PRODUCT_CATEGORYDao.selectFather();
out.close();
}
}
}
public class UpManage extends HttpServlet {
@Override
protected void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
int id=Integer.parseInt(request.getParameter("orderId"));
String name=request.getParameter("name");
String replyContent=request.getParameter("replyContent");
String Content=request.getParameter("Content");
Date date=new Date();
System.out.println(Content);
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String replyTime=sdf.format(date);
EASYBUY_COMMENT comment=new EASYBUY_COMMENT(id,Content,replyTime,replyContent,replyTime,name);
//System.out.println(id+"--"+content+"--"+replyTime+"--"+replyContent+"--"+name);
comment.setEC_ID(id);
int num=EASYBUY_COMMENTDao.update(comment);
if(num>0){
response.sendRedirect("manage-result.jsp");
}else{
}
}
}
// es_ep_name NVARCHAR2(30),--商品名
// es_ep_price NUMBER,--商品单价
// es_eod_quantity NUMBER,--购买数量
// es_ep_stock NUMBER,--商品库存
// es_ep_id NUMBER,--商品id
// es_EU_USER_ID NVARCHAR2(30),--用户id
// es_valid NUMBER --是否结账，1未结账，2已结账
EASYBUY_PRODUCT p = null;
String pid = req.getParameter("id");
String count = req.getParameter("count");
if(pid!=null){
p = EASYBUY_PRODUCTDao.selectById(Integer.parseInt(pid));
}
resp.setContentType("text/html;charset=utf-8");
PrintWriter out = resp.getWriter();
HttpSession session = req.getSession();
EASYBUY_USER user=(EASYBUY_USER)session.getAttribute("name");
if(user!=null){
// System.out.println("登录好了");
EASYBUY_USER eu=(EASYBUY_USER)session.getAttribute("name");
String id=(String)eu.getEU_USER_ID();
ArrayList<eb_shop> list=ESDao.getShop(id);
req.setAttribute("shoplist",list);
//req.getRequestDispatcher("shopping.jsp").forward(req, resp);
}else{
out.print("<script>");
out.print("alert('请先登录');");
out.print("location.href='login.jsp';");
out.print("</script>");
out.close();
return;
}
String uid = user.getEU_USER_ID();
int valid = 1;
eb_shop sp = new eb_shop(0, p.getEP_FILE_NAME(), p.getEP_NAME(), p.getEP_PRICE(), Integer.parseInt(count), p.getEP_STOCK(), p.getEP_ID(), uid, valid);
int epid=p.getEP_ID();
ESDao.insert(sp);
resp.sendRedirect("selectProductView?id="+epid);
//req.getRequestDispatcher("selectProductView?id=").forward(req, resp);
}
try {
su.upload();
} catch (SmartUploadException e) {
e.printStackTrace();
}
Files fs = su.getFiles();//获得所有文件
File f = fs.getFile(0);//获得上传的文件
String fname = f.getFileName();//获得文件名
try {
su.save("images/product");//保存图片到指定位置
} catch (SmartUploadException e) {
e.printStackTrace();
}
Request req1 = su.getRequest();
String pname = req1.getParameter("productName");
String id = req1.getParameter("parentId");
String price = req1.getParameter("productPrice");
String desc = req1.getParameter("productDesc");
String stock = req1.getParameter("productStock");
EASYBUY_PRODUCT p = null;
if(price!=null && stock!=null && id!=null){
p = new EASYBUY_PRODUCT(0, pname, desc,
Integer.parseInt(price),
Integer.parseInt(stock),
Integer.parseInt(id.split("-")[0]),
Integer.parseInt(id.split("-")[1]),
fname);
}
int count = 0;
if(p!=null){
count = EASYBUY_PRODUCTDao.insert(p);
}
req.getRequestDispatcher("productSelect").forward(req, resp);
}
}
Files fs = su.getFiles();//获得所有文件
File f = fs.getFile(0);//获得上传的文件
String fname = f.getFileName();//获得文件名
try {
su.save("images/product");//保存图片到指定位置
} catch (SmartUploadException e) {
e.printStackTrace();
}
Request req1 = su.getRequest();
String pname = req1.getParameter("productName");
String id = req1.getParameter("parentId");
String price = req1.getParameter("productPrice");
String desc = req1.getParameter("productDesc");
String stock = req1.getParameter("productStock");
EASYBUY_PRODUCT p = null;
if(price!=null && stock!=null && id!=null){
p = new EASYBUY_PRODUCT(0, pname, desc,
Integer.parseInt(price),
Integer.parseInt(stock),
Integer.parseInt(id.split("-")[0]),
Integer.parseInt(id.split("-")[1]),
fname);
}
int count = 0;
if(p!=null){
count = EASYBUY_PRODUCTDao.insert(p);
}
req.getRequestDispatcher("productSelect").forward(req, resp);
}
}
g.drawLine(x1, y1, x2, y2);
}
Font f=new Font("Times New Roman",Font.BOLD,50);
g.setFont(f);
int red=0,green=0,blue=0;
String code="";
for (int i = 0; i < 4; i++) {
red=rand.nextInt(255);
green=rand.nextInt(255);
blue=rand.nextInt(255);
Color c=new Color(red,green,blue);
g.setColor(c);
int num=rand.nextInt(10);
code+=num;
g.drawString(num+"", i*20+20, 49);
}
HttpSession session=req.getSession();
session.setAttribute("syscode", code);
ServletOutputStream out=resp.getOutputStream();
ImageIO.write(img, "jpg", out);
}
}
public class UseraddServlet extends HttpServlet {
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
EncodeUtil.encode(req);
resp.setContentType("text/html;charset=utf-8");
public class DoProductAddServlet extends HttpServlet {
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
SmartUpload su = new SmartUpload();
su.initialize(this.getServletConfig(), req, resp);
try {
su.upload();
} catch (SmartUploadException e) {
e.printStackTrace();
}
Files fs = su.getFiles();//获得所有文件
File f = fs.getFile(0);//获得上传的文件
String fname = f.getFileName();//获得文件名
try {
su.save("images/product");//保存图片到指定位置
} catch (SmartUploadException e) {
e.printStackTrace();
}
Request req1 = su.getRequest();
String pname = req1.getParameter("productName");
String id = req1.getParameter("parentId");
String price = req1.getParameter("productPrice");
String desc = req1.getParameter("productDesc");
String stock = req1.getParameter("productStock");
EASYBUY_PRODUCT p = null;
if(price!=null && stock!=null && id!=null){
p = new EASYBUY_PRODUCT(0, pname, desc,
// es_ep_price NUMBER,--商品单价
// es_eod_quantity NUMBER,--购买数量
// es_ep_stock NUMBER,--商品库存
// es_ep_id NUMBER,--商品id
// es_EU_USER_ID NVARCHAR2(30),--用户id
// es_valid NUMBER --是否结账，1未结账，2已结账
EASYBUY_PRODUCT p = null;
String pid = req.getParameter("id");
String count = req.getParameter("count");
if(pid!=null){
p = EASYBUY_PRODUCTDao.selectById(Integer.parseInt(pid));
}
resp.setContentType("text/html;charset=utf-8");
PrintWriter out = resp.getWriter();
HttpSession session = req.getSession();
EASYBUY_USER user=(EASYBUY_USER)session.getAttribute("name");
if(user!=null){
// System.out.println("登录好了");
EASYBUY_USER eu=(EASYBUY_USER)session.getAttribute("name");
String id=(String)eu.getEU_USER_ID();
ArrayList<eb_shop> list=ESDao.getShop(id);
req.setAttribute("shoplist",list);
//req.getRequestDispatcher("shopping.jsp").forward(req, resp);
}else{
out.print("<script>");
out.print("alert('请先登录');");
out.print("location.href='login.jsp';");
out.print("</script>");
out.close();
return;
}
String uid = user.getEU_USER_ID();
int valid = 1;
eb_shop sp = new eb_shop(0, p.getEP_FILE_NAME(), p.getEP_NAME(), p.getEP_PRICE(), Integer.parseInt(count), p.getEP_STOCK(), p.getEP_ID(), uid, valid);
ESDao.insert(sp);
resp.sendRedirect("ShopSelect");
//req.getRequestDispatcher("ShopSelect").forward(req, resp);
}
}
protected void service(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
ArrayList<EASYBUY_PRODUCT_CATEGORY> flist = EASYBUY_PRODUCT_CATEGORYDao.selectFather();
req.setAttribute("flist", flist);
ArrayList<EASYBUY_PRODUCT_CATEGORY> clist = EASYBUY_PRODUCT_CATEGORYDao.selectChild();
req.setAttribute("clist", clist);
String id = req.getParameter("id");
HttpSession session = req.getSession();
//查询最近浏览的商品
ArrayList<Integer> ids = (ArrayList<Integer>)session.getAttribute("ids");
if(ids==null){
ids = new ArrayList<Integer>();
}
if(ids.size()>=5){
ids.remove(0);
}
//System.out.println(!ids.contains(Integer.parseInt(id)));
if(id!=null&&(!ids.contains(Integer.parseInt(id)))){
ids.add(Integer.parseInt(id));
}
session.setAttribute("ids", ids);
ids = (ArrayList<Integer>) session.getAttribute("ids");
if(ids!=null){
ArrayList<EASYBUY_PRODUCT> lastlylist = EASYBUY_PRODUCTDao.selectById(ids);
req.setAttribute("lastlylist", lastlylist);
}
//查询商品
EASYBUY_PRODUCT p = null;
if(id!=null){
p = EASYBUY_PRODUCTDao.selectById(Integer.parseInt(id));
}
req.setAttribute("p", p);
req.getRequestDispatcher("product-view.jsp").forward(req, resp);
}
}
public class LoginServlet extends HttpServlet {
public class SelectProductViewServlet extends HttpServlet {
@SuppressWarnings("unchecked")
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
ArrayList<EASYBUY_PRODUCT_CATEGORY> flist = EASYBUY_PRODUCT_CATEGORYDao.selectFather();
req.setAttribute("flist", flist);
ArrayList<EASYBUY_PRODUCT_CATEGORY> clist = EASYBUY_PRODUCT_CATEGORYDao.selectChild();
req.setAttribute("clist", clist);
String id = req.getParameter("id");
HttpSession session = req.getSession();
//查询最近浏览的商品
ArrayList<Integer> ids = (ArrayList<Integer>)session.getAttribute("ids");
if(ids==null){
ids = new ArrayList<Integer>();
}
if(ids.size()>=5){
ids.remove(0);
}
//System.out.println(!ids.contains(Integer.parseInt(id)));
if(id!=null&&(!ids.contains(Integer.parseInt(id)))){
ids.add(Integer.parseInt(id));
}
session.setAttribute("ids", ids);
ids = (ArrayList<Integer>) session.getAttribute("ids");
if(ids!=null){
ArrayList<EASYBUY_PRODUCT> lastlylist = EASYBUY_PRODUCTDao.selectById(ids);
req.setAttribute("lastlylist", lastlylist);
}
//查询商品
EASYBUY_PRODUCT p = null;
if(id!=null){
p = EASYBUY_PRODUCTDao.selectById(Integer.parseInt(id));
}
req.setAttribute("p", p);
req.getRequestDispatcher("product-view.jsp").forward(req, resp);
}
}
public class LoginServlet extends HttpServlet {
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
req.setCharacterEncoding("UTF-8");
String username=req.getParameter("userName");
String passWord=req.getParameter("passWord");
String veryCode=req.getParameter("veryCode");
resp.setContentType("text/html;charset=utf-8");
HttpSession session = req.getSession();
//获得系统生成的验证码
String sysCode = (String)session.getAttribute("syscode");
int count=EASYBUY_USERDao.selectByNM(username, passWord);
EASYBUY_USER user=EASYBUY_USERDao.selectAdmin(username, passWord);
if(sysCode.equals(veryCode)){
if(count>0){
session.setAttribute("name", user);
if(user.getEU_STATUS()==2){
//System.out.println(user.getEU_STATUS());
//resp.sendRedirect("manage/index.jsp");
resp.sendRedirect("manage/index.jsp");
}else{
resp.sendRedirect("indexSelect");
}
}else{
PrintWriter out = resp.getWriter();
out.print("<script>");
out.print("alert('用户名或密码错误');");
out.print("location.href='login.jsp';");
out.print("</script>");
out.close();
}
}else{
PrintWriter out = resp.getWriter();
out.print("<script>");
out.print("alert('验证码错误');");
out.print("location.href='login.jsp';");
out.print("</script>");
out.close();
}
}
}
int count = 0;
if(p!=null){
count = EASYBUY_PRODUCTDao.insert(p);
}
req.getRequestDispatcher("productSelect").forward(req, resp);
}
}
public class SelectProductViewServlet extends HttpServlet {
@SuppressWarnings("unchecked")
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
ArrayList<EASYBUY_PRODUCT_CATEGORY> flist = EASYBUY_PRODUCT_CATEGORYDao.selectFather();
req.setAttribute("flist", flist);
ArrayList<EASYBUY_PRODUCT_CATEGORY> clist = EASYBUY_PRODUCT_CATEGORYDao.selectChild();
req.setAttribute("clist", clist);
String id = req.getParameter("id");
HttpSession session = req.getSession();
//查询最近浏览的商品
ArrayList<Integer> ids = (ArrayList<Integer>)session.getAttribute("ids");
if(ids==null){
ids = new ArrayList<Integer>();
}
if(ids.size()>=5){
ids.remove(0);
}
//System.out.println(!ids.contains(Integer.parseInt(id)));
public class gmServlet extends HttpServlet {
@Override
protected void service(HttpServletRequest arg0, HttpServletResponse arg1)
throws ServletException, IOException {
arg1.setContentType("text/html;charset=utf-8");
PrintWriter out=arg1.getWriter();
EncodeUtil.encode(arg0);
HttpSession session=arg0.getSession();
EASYBUY_USER list=(EASYBUY_USER)session.getAttribute("name");
//用户id
String id=list.getEU_USER_ID();
//用户姓名
String name=list.getEU_USER_NAME();
//用户地址
String address=list.getEU_ADDRESS();
//总价钱
String price=arg0.getParameter("jstext");
//商品id
String [] EP_ID=arg0.getParameterValues("spID");
//购买数量
String [] quantity=arg0.getParameterValues("number");
//商品单价
String [] sPPrice=arg0.getParameterValues("sPPrice");
//购买后对商品表的库存进行修改
for(int i=0;i<EP_ID.length;i++){
int count5=ESDao.updateStock(Integer.parseInt(quantity[i]),Integer.parseInt(EP_ID[i]));
}
//商品单个总价
int [] pprice=new int[EP_ID.length];
for(int i=0;i<EP_ID.length;i++){
pprice[i]=Integer.parseInt(quantity[i])*Integer.parseInt(sPPrice[i]);
}
/得到序列
//往订单表里添加数据
int count=ESDao.insertDD(id, name, address,Integer.parseInt(price));
EASYBUY_PRODUCT p = null;
if(price!=null && stock!=null && id!=null){
p = new EASYBUY_PRODUCT(0, pname, desc,
Integer.parseInt(price),
Integer.parseInt(stock),
Integer.parseInt(id.split("-")[0]),
Integer.parseInt(id.split("-")[1]),
fname);
}
int count = 0;
if(p!=null){
count = EASYBUY_PRODUCTDao.insert(p);
}
req.getRequestDispatcher("productSelect").forward(req, resp);
}
}
public class SelectProductViewServlet extends HttpServlet {
@SuppressWarnings("unchecked")
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
ArrayList<EASYBUY_PRODUCT_CATEGORY> flist = EASYBUY_PRODUCT_CATEGORYDao.selectFather();
req.setAttribute("flist", flist);
ArrayList<EASYBUY_PRODUCT_CATEGORY> clist = EASYBUY_PRODUCT_CATEGORYDao.selectChild();
String [] quantity=arg0.getParameterValues("number");
//商品单价
String [] sPPrice=arg0.getParameterValues("sPPrice");
//购买后对商品表的库存进行修改
for(int i=0;i<EP_ID.length;i++){
int count5=ESDao.updateStock(Integer.parseInt(quantity[i]),Integer.parseInt(EP_ID[i]));
}
//商品单个总价
int [] pprice=new int[EP_ID.length];
for(int i=0;i<EP_ID.length;i++){
pprice[i]=Integer.parseInt(quantity[i])*Integer.parseInt(sPPrice[i]);
}
/得到序列
//往订单表里添加数据
int count=ESDao.insertDD(id, name, address,Integer.parseInt(price));
int getSequenceId=ESDao.getSequenceId();
//循环往订单详情添加
for(int i=0;i<EP_ID.length;i++){
EASYBUY_ORDER_DETAIL eod=new EASYBUY_ORDER_DETAIL(1,getSequenceId,Integer.parseInt(EP_ID[i]),Integer.parseInt(quantity[i]),pprice[i]);
int count2=ESDao.eodInsert(eod);
}
// 开单后，修改购物车
String [] esID=arg0.getParameterValues("esID");
for(int i=0;i<esID.length;i++){
int count3 =ESDao.esdelete(Integer.parseInt(esID[i]));
}
/
if(count>0){
out.print("<script>");
out.print("alert('购物成功');");
out.print("location.href='shopping-result.jsp';");
out.print("</script>");
out.close();
}else{
out.print("<script>");
out.print("alert('购物失败，请重新选择商品');");
out.print("location.href='ShopSelect';");
out.print("</script>");
out.close();
}
}
}
if(spage!=null){ //如果页面上传递了页数,将当前页数改变掉
page=Integer.parseInt(spage);
}
//查出总页数
ArrayList<EASYBUY_COMMENT> list=EASYBUY_COMMENTDao.selPage(page, pagesize);
int max_page=EASYBUY_COMMENTDao.getMax(pagesize);
if(list.size()>0&&max_page>0){
req.setAttribute("list", list);
//把总页数传递给guestbook.jsp 使用
req.setAttribute("max_page", max_page);
//把当前页数传递给guestbook.jsp使用
req.setAttribute("page", page);
// 跳
req.getRequestDispatcher("guestbook.jsp").forward(req,resp);
}else{
req.setAttribute("list", list);
//把总页数传递给guestbook.jsp 使用
req.setAttribute("max_page", max_page);
//把当前页数传递给guestbook.jsp使用
req.setAttribute("page", page);
// 跳
req.getRequestDispatcher("guestbook.jsp").forward(req,resp);
}
}
}
EASYBUY_USER user=(EASYBUY_USER)session.getAttribute("name");
if(user!=null){
// System.out.println("登录好了");
EASYBUY_USER eu=(EASYBUY_USER)session.getAttribute("name");
String id=(String)eu.getEU_USER_ID();
ArrayList<eb_shop> list=ESDao.getShop(id);
req.setAttribute("shoplist",list);
//req.getRequestDispatcher("shopping.jsp").forward(req, resp);
}else{
out.print("<script>");
out.print("alert('请先登录');");
out.print("location.href='login.jsp';");
out.print("</script>");
out.close();
return;
}
String uid = user.getEU_USER_ID();
int valid = 1;
eb_shop sp = new eb_shop(0, p.getEP_FILE_NAME(), p.getEP_NAME(), p.getEP_PRICE(), Integer.parseInt(count), p.getEP_STOCK(), p.getEP_ID(), uid, valid);
int epid=p.getEP_ID();
ESDao.insert(sp);
resp.sendRedirect("selectProductView?id="+epid);
//req.getRequestDispatcher("selectProductView?id=").forward(req, resp);
}
}
308
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
