package com.easyjf.dbo.example;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;
import java.util.List;

import com.easyjf.dbo.EasyJDB;
import com.easyjf.dbo.IObject;
public class Message implements IObject {
private String cid;
private String title;
private String content;
private String inputUser;
private Date inputTime;
private Integer status;
	public String getTableName() {		
		return "message";
	}
	public String getKeyField() {		
		return "cid";
	}
	public String getKeyGenerator() {		
		return "com.easyjf.dbo.IdGenerator";
	}
	public String getCid() {
		return cid;
	}
	public void setCid(String cid) {
		this.cid = cid;
	}
	public String getContent() {
		return content;
	}
	public void setContent(String content) {
		this.content = content;
	}
	public java.util.Date getInputTime() {
		return inputTime;
	}
	public void setInputTime(java.util.Date inputTime) {
		this.inputTime = inputTime;
	}
	public String getInputUser() {
		return inputUser;
	}
	public void setInputUser(String inputUser) {
		this.inputUser = inputUser;
	}
	public Integer getStatus() {
		return status;
	}
	public void setStatus(Integer status) {
		this.status = status;
	}
	public String getTitle() {
		return title;
	}
	public void setTitle(String title) {
		this.title = title;
	}	
	//把對象持久化（保存）到關系數據庫中
	public boolean save()
	{
		EasyJDB db=EasyJDB.getInstance();
		return db.saveOrUpdate(this);
	}
	//從持久化存儲設備數據庫系統中永久刪除對象
	public boolean del()
	{
		EasyJDB db=EasyJDB.getInstance();
		return db.del(this);
	}
	//通過主鍵id從數據庫系統中讀取數據，返回一個對象
	public static Message read(String cid)
	{
		EasyJDB db=EasyJDB.getInstance();
		return (Message)db.get(Message.class,cid);
	}
	//通過sql從數據庫中查詢符合條件的數據，返回對象列表
    public static List query(String sql)
    {
    	EasyJDB db=EasyJDB.getInstance();    	
    	return db.query(Message.class,sql);
    }
    //應用演示代碼
	public static void main(String[] args) {
		Message m=new Message();
		m.setTitle("標題");
		m.setContent("內容");
		m.setInputTime(new Date());
		m.setInputUser("test");
		m.setStatus(new Integer(1));
		if(m.save())
		{
			System.out.print("成功把對象保存到關系數據庫中");			
		}
		else
		{
			System.out.println("保存數據出錯！");
		}		
		//查詢數據
		EasyJDB db=EasyJDB.getInstance();
		 Collection paras=new ArrayList();
    	 paras.add(new Integer(0));
		for(int i=0;i<10;i++)
			System.out.println(db.uniqueResult("select count(*) from Message where status>=?",paras));
	}
}