typedao.java~4~

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

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

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

public class TypeDAO {

        /**
         * 查找所有记录
         */
        public ArrayList selectAllType() {

            ArrayList list = new ArrayList();

            Connection conn = ConnectionManager.getConn();
            try {
                Statement stmt = conn.createStatement();
                ResultSet rs = stmt.executeQuery("select * from Goods");
                while(rs.next()){
                    Goods 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;
        }


}