基于javaweb+mysql的简单购物车
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
注册、登录、注销
商品加入购物车,查看购物车,删除购物车中的商品和清空购物车
生成订单,查看历史订单及订单详情等
技术框架
JSP Servlet MySQL JDBC Tomcat
Goods g=new Goods();
g.setGoodsname(rs.getString(2));
g.setPrice(rs.getDouble(3));
goods.add(g);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
if(rs!=null) {
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
req.setAttribute("goods", goods);
req.getRequestDispatcher("list.jsp").forward(req, resp);
goods.clear();
db.close();
}
}
package entity;
try {
while(rs.next()) {
Goods g=new Goods();
g.setGoodsname(rs.getString(2));
g.setPrice(rs.getDouble(3));
goods.add(g);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
if(rs!=null) {
try {
import entity.User;
import mysql.DataBase;
public class OrderServlet extends HttpServlet {
public static List<Cart> cart=new ArrayList<Cart>();
//备份cart 生成订单时用
public static List<Cart> cart_=new ArrayList<Cart>();
//订单号 list
public static List<String> OrderId = new ArrayList<String>();
//订单详情 List
public static List<Order> order = new ArrayList<Order>();
//时间+随机数
public static String getOrderIdByTime() {
SimpleDateFormat sdf=new SimpleDateFormat("yyyyMMddHHmmss");
String newDate=sdf.format(new Date());
String result="";
Random random=new Random();
for(int i=0;i<3;i++) {
result+=random.nextInt(10);