第十一周 购物车实例

在MYSQL里面创建一个名为cart的数据库，在cart数据库下创建一个名为product的数据表，写入数据

 按要求下载好j2ee.rar案例并解压，将代码复制到IDEA里，在将路径和账户密码改成与自己电脑对应的，按教程导入相关依赖（刚开始导入依赖后运行一直没有成功，去网上查找了一下才知道是与tomcat版本不匹配导致的，后面去网上下载了新的依赖导入后运行成功了）

 ProductDAO.java里面代码如下（有点多，截图截不完全。。。）

package com.pjn.dao;

import com.pjn.bean.Product;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;


public class ProductDAO {
 
    public static void main(String[] args) {
 
        System.out.println(new ProductDAO().getProduct(1).getName());
 
    }
 
    public Product getProduct(int id) {
        Product result = null;
 
        try {
            Class.forName("com.mysql.jdbc.Driver");
 
            Connection c = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/cart?characterEncoding=UTF-8",
                    "root", "123");
 
            String sql = "select * from product where id = ?";
 
            PreparedStatement ps = c.prepareStatement(sql);
            ps.setInt(1, id);
 
            ResultSet rs = ps.executeQuery();
 
            if (rs.next()) {
                result = new Product();
                result.setId(id);
 
                String name = rs.getString(2);
                float price = rs.getFloat(3);
 
                result.setName(name);
                result.setPrice(price);
 
            }
 
            ps.close();
 
            c.close();
 
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return result;
    }
 
    public List<Product> ListProduct() {
        List<Product> products = new ArrayList<Product>();
 
        try {
            Class.forName("com.mysql.jdbc.Driver");
 
            Connection c = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/cart?characterEncoding=UTF-8",
                    "root", "admin");
 
            String sql = "select * from product order by id desc";
 
            PreparedStatement ps = c.prepareStatement(sql);
 
            ResultSet rs = ps.executeQuery();
 
            while (rs.next()) {
                Product product = new Product();
                int id = rs.getInt(1);
                String name = rs.getString(2);
                float price = rs.getFloat(3);
 
                product.setId(id);
                product.setName(name);
                product.setPrice(price);
                products.add(product);
 
            }
 
            ps.close();
 
            c.close();
 
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return products;
    }
}