JSP+mysql开发网上书店系统的代码详情-代码-最代码

首页>代码>JSP+mysql开发网上书店系统>/JSP网上书店系统/day23/src/cn/itcast/dao/impl/CategoryDaoImpl.java
01package cn.itcast.dao.impl;
02 
03import java.sql.SQLException;
04import java.util.List;
05 
06import org.apache.commons.dbutils.QueryRunner;
07import org.apache.commons.dbutils.handlers.BeanHandler;
08import org.apache.commons.dbutils.handlers.BeanListHandler;
09 
10import cn.itcast.dao.CategoryDao;
11import cn.itcast.domain.Category;
12import cn.itcast.exception.DaoException;
13import cn.itcast.util.DBCPUtil;
14/*
15create table category(
16            id varchar(100) primary key,
17            name varchar(100) not null unique,
18            description varchar(255)
19        );
20 */
21public class CategoryDaoImpl implements CategoryDao {
22    private QueryRunner qr = new QueryRunner(DBCPUtil.getDataSource());
23    public void addCategory(Category c) {
24        try {
25            qr.update("insert into category (id,name,description) values(?,?,?)", c.getId(),c.getName(),c.getDescription());
26        } catch (SQLException e) {
27            throw new DaoException(e);
28        }
29    }
30 
31    public List<Category> findAll() {
32        try {
33            return qr.query("select * from category", new BeanListHandler<Category>(Category.class));
34        } catch (SQLException e) {
35            throw new DaoException(e);
36        }
37    }
38 
39    public Category findCatetoryById(String categoryId) {
40        try {
41            return qr.query("select * from category where id=?", new BeanHandler<Category>(Category.class),categoryId);
42        } catch (SQLException e) {
43            throw new DaoException(e);
44        }
45    }
46 
47}