suoyoudao.java

来自「java编写的网络购物简洁版」· Java 代码 · 共 53 行

package shop;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Collection;

public class suoyouDAO {
public Collection getAllsuoyou(int id) {
    	DBTools dao = new DBTools();
        Connection con = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;   

        Collection <suoyouBean> studentList = new ArrayList<suoyouBean>();

        try {

            con = dao.getConnection();
            
            pstmt = con.prepareStatement(
                    "SELECT breed.breedName, breed.bewrite, product.productName, product.factory, product.price,product.amout,product.remark FROM breed INNER JOIN  product ON breed.breedID = product.breedID WHERE product.breedID = ?");
            pstmt.setInt(1,id);
            rs =  pstmt.executeQuery();

            while(rs.next())
            {
            	suoyouBean s = new suoyouBean();  //学生实体类
                s.setBreedName(rs.getString(1));
                s.setBewrite(rs.getString(2));
                s.setProductName(rs.getString(3));
                s.setFactory(rs.getString(4));
                s.setPrice(rs.getFloat(5));
                s.setAmout(rs.getInt(6));
                s.setRemark(rs.getString(7));
                studentList.add(s);  
                
            }

        } catch (Exception ex) {
            ex.printStackTrace();
        }finally{

            	dao.close(con, pstmt, rs);

        }

        return studentList;  
    }

}