categoryimpl.java

jsp+servlet网上购物,是一个实现mvc的网站

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.ebook.impl;

import com.ebook.dao.*;
import java.util.*;
import java.sql.*;
import com.ebook.Entity.*;

/**
 *
 * @author 隆科
 */
public class CategoryImpl implements CategoryDao {

    Connection con;

    public CategoryImpl(Connection con) {
        this.con = con;
    }

    public ArrayList getCategory() throws Exception {
        ArrayList list = new ArrayList();
        PreparedStatement pstm;
        String sql = "select* from category";
        pstm = con.prepareStatement(sql);
        ResultSet rs = pstm.executeQuery();
        while(rs.next())
        {
            Category c= new Category();
            c.setCateid(rs.getInt("Cateid"));
            c.setCatename(rs.getString("Catename"));
            list.add(c);
        }
        return list;
    }
}