message.java

实现复杂的分页查询

package jp.co.ttc.sample.bean;

import java.sql.*;
import java.util.*;

import com.yourcompany.struts.DBBean;

public class Message {
  private String message_no;
  private String message_sts;
  private String company_name;
  private String admin_sts;
  private String create_date;
  private String checkbox;
  public Message(){}
   public Message(String checkbox,String message_no, String message_sts, String company_name,
		String create_date, String admin_sts) {
		this.checkbox = checkbox;
	    this.message_no = message_no;
		this.message_sts = message_sts;
		this.company_name = company_name;
		this.create_date = create_date;
		this.admin_sts = admin_sts;
   }
/**
 * @return the message_no
 */
public String getMessage_no() {
	return message_no;
}
/**
 * @param message_no the message_no to set
 */
public void setMessage_no(String message_no) {
	this.message_no = message_no;
}
/**
 * @return the message_sts
 */
public String getMessage_sts() {
	return message_sts;
}
/**
 * @param message_sts the message_sts to set
 */
public void setMessage_sts(String message_sts) {
	this.message_sts = message_sts;
}
/**
 * @return the company_name
 */
public String getCompany_name() {
	return company_name;
}
/**
 * @param company_name the company_name to set
 */
public void setCompany_name(String company_name) {
	this.company_name = company_name;
}
/**
 * @return the admin_sts
 */
public String getAdmin_sts() {
	return admin_sts;
}
/**
 * @param admin_sts the admin_sts to set
 */
public void setAdmin_sts(String admin_sts) {
	this.admin_sts = admin_sts;
}
/**
 * @return the create_date
 */
public String getCreate_date() {
	return create_date;
}
/**
 * @param create_date the create_date to set
 */
public void setCreate_date(String create_date) {
	this.create_date = create_date;
}
/**
 * @return the checkbox
 */
public String getCheckbox() {
	return checkbox;
}
/**
 * @param checkbox the checkbox to set
 */
public void setCheckbox(String checkbox) {
	this.checkbox = checkbox;
}

public static ArrayList getAllMessage(String sql,String[] args){
	//String sql = "select * from message";
    ArrayList arrayList = new ArrayList();
    try{
    	DBBean db = new DBBean();               
		ResultSet rs = null;
		rs =db.query(sql,args);
        while(rs.next())
        {                
   		String checkbox ="0";
   		String message_no=rs.getString("message_no").trim();
   		String message_sts=rs.getString("message_sts").trim();
   		String company_name=rs.getString("corp_name").trim();
   		String create_date=rs.getString("create_date").trim();
   		String admin_sts=rs.getString("admin_sts").trim();
        Message message = new Message(checkbox,message_no,message_sts,company_name,create_date,admin_sts);   
        arrayList.add(message);
       }
       db.close();
    }catch(SQLException ex)
    {
           ex.printStackTrace();
    }

       return arrayList;
}
 
}