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代码
序号:
选择图片:
商品描述:
商品价格:
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);