indexcenter.java

一个jsp的课程设计：电子商务网站

/*
 * indexCenter.java
 *
 * Created on 2007年11月18日, 下午2:12
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package dbpack;
import java.sql.SQLException;
/**
 *
 * @author weiyunbo
 */
public class indexCenter {
    private StringBuffer str=new StringBuffer();
    /** Creates a new instance of indexCenter */
    public indexCenter() {
    }

    public StringBuffer getStr() {
        try {
            dbConnect db=new dbConnect();
            db.rs=db.sat.executeQuery("select top 12 * from food");
            while(db.rs.next()){
                str.append("");
            }
            db.doClose();
        } catch (SQLException ex) {            
            ex.printStackTrace();
        }
        return str;
    }

    public void setStr(StringBuffer str) {
        this.str = str;
    }
    
}