type.java

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

/*
 * type.java
 *
 * Created on 2007年11月18日, 下午1:32
 *
 * 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 type {
    private StringBuffer str=new StringBuffer();
    private StringBuffer hotstr=new StringBuffer();
    /** Creates a new instance of type */
    public type() {
        
    }

    public StringBuffer getStr() {
        try {
            dbConnect db=new dbConnect();
            db.rs=db.sat.executeQuery("select top 10 * from type");
            while(db.rs.next()){
                str.append("<a href='list.jsp?id="+db.rs.getString("typeid")+"'>"+db.rs.getString("typename")+"</a> |  ");
            }
            db.doClose();
        } catch (SQLException ex) {            
            ex.printStackTrace();
        }
        return str;
    }

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

    public StringBuffer getHotstr() {
        try {
            dbConnect db=new dbConnect();
            db.rs=db.sat.executeQuery("select top 4 * from type order by typescore desc");
            while(db.rs.next()){
                hotstr.append("<a href='list.jsp?id="+db.rs.getString("typeid")+"'>"+db.rs.getString("typename")+"</a> &nbsp;&nbsp;  ");
            }
            db.doClose();
        } catch (SQLException ex) {            
            ex.printStackTrace();
        }
        return hotstr;
    }

    public void setHotstr(StringBuffer hotstr) {
        this.hotstr = hotstr;
    }
    
}