room.java

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

/*
 * room.java
 *
 * Created on 2007年11月18日, 下午12:29
 *
 * 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 room {
    private StringBuffer str=new StringBuffer();
    /** Creates a new instance of room */
    public room() {
        try {
            dbConnect db=new dbConnect();
            db.rs=db.sat.executeQuery("select top 8 * from room");
            while(db.rs.next()){
                str.append("<li><img height='100' width='100' src='"+db.rs.getString("roompicture")+"' /><br /><a href='Show?id="+db.rs.getString("roomid")+"&type=room'>"+db.rs.getString("roomname")+"</a></li>");
            }
            db.doClose();
        } catch (SQLException ex) {            
            ex.printStackTrace();
        }
    }

    public StringBuffer getStr() {
        return str;
    }

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