product.java

来自「ajax实例源程序」· Java 代码 · 共 47 行

package noteBookStore;

import java.sql.ResultSet;

public class Product {
	private int id;		
	private String name;		
	private String contents;	
	public String getContents() {
		return contents;
	}
	public void setContents(String contents) {
		this.contents = contents;
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}		

	public static Product GetDetail(DB db,Integer Id) throws Exception{
		ResultSet rs;
        String strSql=null;
        String rplContent=null;
		
        strSql = "select * from product where id = " + Id ;
		rs = db.executeQuery(strSql);
		Product product = new Product();
		if (rs.next()){
			
			product.setName(rs.getString("name")) ;
			
			rplContent = rs.getString("contents");
			rplContent = rplContent.replaceAll("\n","<br>");
			product.setContents(rplContent) ;
		}
		return product;
	}
}