第一、二、三题:
package com.educoder.service.impl;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.educoder.entity.Goods;
import com.educoder.service.GoodsService;
import com.educoder.dao.impl.BaseDao;
public class GoodsServiceImpl implements GoodsService {
/**
* 商品详情接口
*/
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.size() == 0 ? null : goodsList.get(0);
/********* End *********/
}
/**
* 商品搜索接口
*/
public List<Goods> searchGoods(String condition) {
/********* Begin *********/
String sql = "select * from t_goods where goodsName like ? or goodsClass like ? order by salesNum desc";
List<Goods> goodsList = null;
condition = "%" + condition + "%";
List<Object> paramenter = new ArrayList<Object>();
paramenter.add(condition);
paramenter.add(condition);
try {
goodsList = BaseDao.operQuery(sql, paramenter, Goods.class);
} catch (Exception e) {
e.printStackTrace();
}
return goodsList;
/********* End *********/
}
/**
* 商品列表接口
*/
public List<Goods> getGoodsList() {
/********* Begin *********/
String USERNAME = "root";
String PASSWORD = "123