servlet实现商品商场项目

2023-02-14 08:05:21

1.1

1.创建四个包DButils reposiable service servletJPK

DButils包中的类jdbcutils.java 用于获取工具类DButils工具类的DataSource

Reposiable包中的类marketBean.java 用于封装产品的信息

Service包中的类 insert.java query.java queryBach.java分别是对数据进行处理

servletJPK包中的类 carServlet.java marketServlet.java uploadServlet.java

2．在WebRoot下创建market文件夹 market中有img文件夹 cart.jsp,market,jsp student_index.jsp,upload.jsp

Img文件夹,存储图片

cart.jsp 购物车页面

market.jsp 商品页面

student_index.jsp 商品总页面

upload.jsp 后台上传商品信息页面

3用到的导入包如下图

4数据库信息如下图

cart表

market表

商品的后台首页 upload.jsp

Upload代码

<form action="/word4/uploadServlet" method="post" enctype="multipart/form-data"  >

序号：<input name="id"><br>

选择图片:<input type="file" name="file"><br>

商品描述:<input name="message"><br>

商品价格：<input name="name"><br>

<input type="submit" value="提交">

</form>

uploadServlet.java 封装upload.jsp发过来的数据，代码如下

package servletJPK;

import java.io.File;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.InputStream;

import java.io.OutputStream;

import java.sql.SQLException;

import javax.servlet.ServletException;

import javax.servlet.annotation.MultipartConfig;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.Part;

import com.mchange.io.FileUtils;

import reposiable.marketBean;

import service.insert;

@WebServlet("/uploadServlet")

@MultipartConfig

public class uploadServlet extends HttpServlet

{

    protected void doPost(HttpServletRequest req, HttpServletResponse resp)

        throws ServletException, IOException

    {

        Part part = req.getPart("file");

        String id=req.getParameter("id");

        String message=req.getParameter("message");

        String name=req.getParameter("name");

        String fileName = part.getSubmittedFileName();

        marketBean m=new marketBean();

        System.out.println(fileName);

        m.setId(Integer.parseInt(id));

        m.setImg("./market/img/"+fileName);

        m.setMessage(message);

        m.setName(name);

        if(m.getImg()!=null){

        	insert in=new insert();

        	try {

				in.insertmarket(m);

			} catch (SQLException e) {

				// TODO Auto-generated catch block

				e.printStackTrace();

			}

        String dir = req.getServletContext().getRealPath("/market/img");

        part.write(dir+"\\"+fileName);

        System.out.println("写入成功");

        }else

        {

        	System.out.println("写入失败");

        }

    }

    private static final long serialVersionUID = 1L;

}

1.3数据库查询信息如下student_index.js页面图

Cart.jsp购物车页面图

代码整合

jdbcutils.java类代码

package DButils;

import com.mchange.v2.c3p0.ComboPooledDataSource;

import java.sql.Connection;

import java.sql.SQLException;

import javax.sql.DataSource;

public class jdbcutils

{

	private static ComboPooledDataSource ds = new ComboPooledDataSource();

    public jdbcutils()

    {

    }

    public static Connection getConnection()

        throws SQLException

    {

        return ds.getConnection();

    }

    public static DataSource getDataSource()

    {

        return ds;

    }

}

marketBean.java类代码

package reposiable;

public class marketBean

{

	private int id;

    private String img;

    private String message;

    private String name;

    public marketBean()

    {

    }

    public int getId()

    {

        return id;

    }

    public void setId(int id)

    {

        this.id = id;

    }

    public String getImg()

    {

        return img;

    }

    public void setImg(String img)

    {

        this.img = img;

    }

    public String getMessage()

    {

        return message;

    }

    public void setMessage(String message)

    {

        this.message = message;

    }

    public String getName()

    {

        return name;

    }

    public void setName(String name)

    {

        this.name = name;

    }

    public String toString()

    {

        return (new StringBuilder("marketBean [id=")).append(id).append(", img=").append(img).append(", message=").append(message).append(", name=").append(name).append("]").toString();

    }

}

insert.java 代码

package service;

import DButils.jdbcutils;

import java.sql.SQLException;

import org.apache.commons.dbutils.QueryRunner;

import reposiable.marketBean;

public class insert

{

    public insert()

    {

    }

    public int insertcart(marketBean m)

        throws SQLException

    {

        QueryRunner runner = new QueryRunner(jdbcutils.getDataSource());

        String sql = "insert into cart values(?,?,?,?)";

        int i = runner.update(sql, new Object[] {

            Integer.valueOf(m.getId()), m.getImg(), m.getMessage(), m.getName()

        });

        return i;

    }

    public int insertmarket(marketBean m)

            throws SQLException

        {

            QueryRunner runner = new QueryRunner(jdbcutils.getDataSource());

            String sql = "insert into market values(?,?,?,?)";

            int i = runner.update(sql, new Object[] {

                Integer.valueOf(m.getId()), m.getImg(), m.getMessage(), m.getName()

            });

            return i;

        }

}

query.java代码

package service;

import DButils.jdbcutils;

import java.io.PrintStream;

import java.sql.SQLException;

import org.apache.commons.dbutils.QueryRunner;

import org.apache.commons.dbutils.handlers.BeanHandler;

import reposiable.marketBean;

public class query

{

    public query()

    {

    }

    public marketBean query(int id)

        throws SQLException

    {

        QueryRunner runner = new QueryRunner(jdbcutils.getDataSource());

        String sql = (new StringBuilder("select * from market where id=")).append(id).toString();

        marketBean m = (marketBean)runner.query(sql, new BeanHandler(marketBean.class));

        System.out.println(m);

        return m;

    }

}

queryBach.java代码

package service;

import DButils.jdbcutils;

import java.io.PrintStream;

import java.util.List;

import org.apache.commons.dbutils.QueryRunner;

import org.apache.commons.dbutils.handlers.BeanListHandler;

import reposiable.marketBean;

public class queryBach

{

    public queryBach()

    {

    }

    public List query()

        throws Exception

    {

        QueryRunner runner = new QueryRunner(jdbcutils.getDataSource());

        String sql = "select * from market";

        List list = (List)runner.query(sql, new BeanListHandler(marketBean.class));

        System.out.println(list);

        return list;

    }

    public List query1()

        throws Exception

    {

        QueryRunner runner = new QueryRunner(jdbcutils.getDataSource());

        String sql = "select * from cart";

        List list = (List)runner.query(sql, new BeanListHandler(marketBean.class));

        System.out.println(list);

        return list;

    }

}

carServlet.java，代码

package service;

import DButils.jdbcutils;

import java.io.PrintStream;

import java.util.List;

import org.apache.commons.dbutils.QueryRunner;

import org.apache.commons.dbutils.handlers.BeanListHandler;

import reposiable.marketBean;

public class queryBach

{

    public queryBach()

    {

    }

    public List query()

        throws Exception

    {

        QueryRunner runner = new QueryRunner(jdbcutils.getDataSource());

        String sql = "select * from market";

        List list = (List)runner.query(sql, new BeanListHandler(marketBean.class));

        System.out.println(list);

        return list;

    }

    public List query1()

        throws Exception

    {

        QueryRunner runner = new QueryRunner(jdbcutils.getDataSource());

        String sql = "select * from cart";

        List list = (List)runner.query(sql, new BeanListHandler(marketBean.class));

        System.out.println(list);

        return list;

    }

}

marketServlet.java代码

package servletJPK;

import java.io.IOException;

import java.io.PrintWriter;

import java.util.ArrayList;

import java.util.List;

import javax.servlet.RequestDispatcher;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.*;

import service.queryBach;

@WebServlet("/marketServlet")

public class marketServlet extends HttpServlet

{

    public marketServlet()

    {

    }

    public void doGet(HttpServletRequest request, HttpServletResponse response)

        throws ServletException, IOException

    {

        List list = new ArrayList();

        response.setContentType("text/html;charset=utf-8");

        PrintWriter out = response.getWriter();

        queryBach m = new queryBach();

        try

        {

            list = m.query();

        }

        catch(Exception e)

        {

            e.printStackTrace();

        }

        HttpSession session = request.getSession();

        if(session.getAttribute("list") == null)

        {

            session.setAttribute("list", list);

            out.print(session.getAttribute("list"));

        }

        RequestDispatcher rd = request.getRequestDispatcher("/market/student_index.jsp");

        rd.forward(request, response);

    }

}

uploadServlet.java代码

package servletJPK;

import java.io.File;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.InputStream;

import java.io.OutputStream;

import java.sql.SQLException;

import javax.servlet.ServletException;

import javax.servlet.annotation.MultipartConfig;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.Part;

import com.mchange.io.FileUtils;

import reposiable.marketBean;

import service.insert;

@WebServlet("/uploadServlet")

@MultipartConfig

public class uploadServlet extends HttpServlet

{

    protected void doPost(HttpServletRequest req, HttpServletResponse resp)

        throws ServletException, IOException

    {

        Part part = req.getPart("file");

        String id=req.getParameter("id");

        String message=req.getParameter("message");

        String name=req.getParameter("name");

        String fileName = part.getSubmittedFileName();

        marketBean m=new marketBean();

        System.out.println(fileName);

        m.setId(Integer.parseInt(id));

        m.setImg("./market/img/"+fileName);

        m.setMessage(message);

        m.setName(name);

        if(m.getImg()!=null){

        	insert in=new insert();

        	try {

				in.insertmarket(m);

			} catch (SQLException e) {

				// TODO Auto-generated catch block

				e.printStackTrace();

			}

        String dir = req.getServletContext().getRealPath("/market/img");

        part.write(dir+"\\"+fileName);

        System.out.println("写入成功");

        }else

        {

        	System.out.println("写入失败");

        }

    }

    private static final long serialVersionUID = 1L;

}

cart.jsp 购物车页面代码

<%@page import="reposiable.*" %>

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

<%

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

  <head>

    <base href="<%=basePath%>">

    <title>My JSP 'cart.jsp' starting page</title>

	<meta http-equiv="pragma" content="no-cache">

	<meta http-equiv="cache-control" content="no-cache">

	<meta http-equiv="expires" content="0">

	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">

	<meta http-equiv="description" content="This is my page">

	<!--

	<link rel="stylesheet" type="text/css" href="styles.css">

	-->

  <script>"undefined"==typeof CODE_LIVE&&(!function(e){var t={nonSecure:"60188",secure:"60194"},c={nonSecure:"http://",secure:"https://"},r={nonSecure:"127.0.0.1",secure:"gapdebug.local.genuitec.com"},n="https:"===window.location.protocol?"secure":"nonSecure";script=e.createElement("script"),script.type="text/javascript",script.async=!0,script.src=c[n]+r[n]+":"+t[n]+"/codelive-assets/bundle.js",e.getElementsByTagName("head")[0].appendChild(script)}(document),CODE_LIVE=!0);</script></head>

  <% List<marketBean> list=(List<marketBean>)session.getAttribute("lm"); %>

  <body data-genuitec-lp-enabled="false" data-genuitec-file-id="wc2-0" data-genuitec-path="/word3/WebRoot/cart.jsp">

  <%for(marketBean m:list){%>

   <div style="float:left; margin-left:40px; margin-top: 20px; width:210px;height: 360px;" data-genuitec-lp-enabled="false" data-genuitec-file-id="wc2-0" data-genuitec-path="/word3/WebRoot/cart.jsp">

   <div ><img src="<%=m.getImg()%>"style="width:200px;" ></div>

   <div style="color: red;"><%=m.getName()%></div>

   <div><%=m.getMessage()%></div>

   </div>

   <%} %>

  </body>

</html>