typedao.java~6~

在线购物系统,ajax+jsp实现

package com.accp.gz.th.zm.server.dao;

import java.util.*;
import com.accp.gz.th.zm.server.entity.Goods;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;

public class TypeDAO {

    public ArrayList getAllType(){

        ArrayList list=null;
        Connection conn = ConnectionManager.getConn();
        try {
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("select * from Type");
            while(rs.next()){
                Type g=new Goods();
                g.setId(rs.getInt(1));
                g.setName(rs.getString(2));
                g.setPrice(rs.getInt(3));
                g.setNumber(rs.getInt(4));
                list.add(g);
            }
        } catch (SQLException ex) {
            System.out.println(ex.toString());
        }

        return list;
    }

}