todaysuggest.java

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

/*
 * TodaySuggest.java
 *
 * Created on 2007年11月18日, 下午1:11
 *
 * 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 TodaySuggest {
    private StringBuffer str=new StringBuffer();
    /** Creates a new instance of TodaySuggest */
    public TodaySuggest() {
        try {
            dbConnect db=new dbConnect();
            db.rs=db.sat.executeQuery("select top 10 * from food");
            while(db.rs.next()){
                getStr().append("<li><a href='Show?id="+db.rs.getString("foodid")+"&type=food'>"+db.rs.getString("foodname")+"</a>--("+db.rs.getString("room")+")</li>");
            }
            db.doClose();
        } catch (SQLException ex) {            
            ex.printStackTrace();
        }
    }

    public StringBuffer getStr() {
        return str;
    }

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