JSP技术基础

第1关：JSP脚本元素

1-5 DABBB
6-8 BCB

第2关：JSP指令

1-5 AABBB

第3关：JSP隐式对象

1-2 BD

第4关：EL表达式和JSTL标签库

1-5 ADCCD
6-8 DAD

基于JSP的网上商店

package com.educoder.service.impl;

import java.util.List;

import com.educoder.entity.Goods;
import com.educoder.service.GoodsService;
import com.educoder.dao.impl.BaseDao;

import java.sql.*;
import java.lang.Exception;
import java.util.*;

public class GoodsServiceImpl implements GoodsService {
  public static final String url = "jdbc:mysql://127.0.0.1:3306/online_shop?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true";
  public static final String user = "root";
  public static final String password = "123123";

  private static Connection conn = null;
  private static Statement stmt = null;
  private static ResultSet rs = null;

  /**
   * 商品详情接口
   */
  public Goods getGoodsByGoodsId(String goodsId) {
    /********* Begin *********/
    String sql = "select * from t_goods where goodsId=?";
    List < Object > parameters = new ArrayList < Object > ();
    parameters.add(goodsId);

    List < Goods > goodsList = null;
    try {
      goodsList = BaseDao.operQuery(sql, parameters, Goods.class);
    } catch (Exception e) {
      e.printStackTrace();
    }

    return goodsList.get(0);
    /********* End *********/
  }

  /**
   * 商品搜索接口
   */
  public List < Goods > searchGoods(String condition) {
    /********* Begin *********/
    condition = "%" + condition + "%";
    String sql = "select * from t_goods where goodsName like ? or goodsClass like ?";
    List < Object > parameters = new ArrayList < Object > ();
    parameters.add(condition);
    parameters.add(condition);

    List < Goods > goodsList = null;
    try {
      goodsList = BaseDao.operQuery(sql, parameters, Goods.class);
    } catch (Exception e) {
      e.printStackTrace();
    }

    return goodsList;
    /********* End *********/
  }

  /**
   * 商品列表接口
   */
  public List < Goods > getGoodsList() {
    /********* Begin *********/
    List < Goods > goodsList = new ArrayList < Goods > ();

    try {
      //1.加载驱动程序
      Class.forName("com.mysql.jdbc.Driver");
      //2. 获得数据库连接
      conn = DriverManager.getConnection(url, user, password);
      stmt = conn.createStatement();
      rs = stmt.executeQuery("select * from t_goods order by salesNum desc limit 4");

      while (rs.next()) {
        Goods goods = new Goods();

        goods.setGoodsId(rs.getString("goodsId"));
        goods.setGoodsName(rs.getString("goodsName"));
        goods.setGoodsImg(rs.getString("goodsImg"));
        goods.setGoodsPrice(rs.getBigDecimal("goodsPrice"));
        goods.setGoodsNum(rs.getInt("goodsNum"));
        goods.setSalesNum(rs.getInt("salesNum"));
        goods.setGoodsSize(rs.getString("goodsSize"));
        goods.setGoodsFrom(rs.getString("goodsFrom"));
        goods.setGoodsTime(rs.getString("goodsTime"));
        goods.setGoodsSaveCondition(rs.getString("goodsSaveCondition"));
        goods.setGoodsDescribe(rs.getString("goodsDescribe"));
        goods.setGoodsExplain(rs.getString("goodsExplain"));
        goods.setGoodsClass(rs.getString("goodsClass"));
        goods.setGoodsDiscount(rs.getBigDecimal("goodsDiscount"));
        goods.setDiscountStartTime(rs.getDate("discountStartTime"));
        goods.setDiscountEndTime(rs.getDate("discountEndTime"));

        goodsList.add(goods);
      }
    } catch (ClassNotFoundException e) {
      e.printStackTrace();
    } catch (SQLException e) {
      e.printStackTrace();
    }

    return goodsList;
    /********* End *********/
  }
}