yiban.java

这是一个简单的办公管理系统

package admin;

import java.io.Serializable;
import java.sql.ResultSet;


public class Yiban implements Serializable {
	private static final long serialVersionUID = 313232122321L;
	private String id[] ;
	private String dept[] ;
	private String timea[] ;
	private String title[] ;
	private String l[] ;
	private int i ;
	public String[] getId() {
		return id;
	}
	public int getI() {
		return i;
	}
	public String[] getDept()  { 
		return  dept;
	}
	public String[] getTimea()  { 
		return  timea;
	}
	public String[] getTitle()  { 
		return  title;
	}
	public String[] getL()  { 
		return  l;
	}

	public void setConnection(String tiaojian,String zhiduan){
		try{
			DataControl data1 = new DataControl();
			String sql = "select * from v_tab4 order by timea desc";
			if(!(tiaojian.equals("")) &&!(zhiduan.equals(""))){
				sql = "select * from v_tab4 where "+zhiduan+" like '%"+tiaojian+"%' order by timea desc";
			}
			System.out.println(sql);
			ResultSet rs = data1.getResulSet(sql);
			rs.last();
			i = rs.getRow();
			int j=0;
			String id[] = new String[i];
			String dept[] = new String[i];
			String timea[] = new String[i];
			String title[] = new String[i];
			String l[] = new String[i];
			rs.first();
			if(i>0){
				id[j] = new Integer(rs.getInt("id")).toString();
				dept[j] = rs.getString("dept");
				timea[j] = rs.getString("timea");
				title[j] = rs.getString("title");
				l[j] = rs.getString("l");
			}
			while(rs.next()){
				j=j+1;
				id[j] = new Integer(rs.getInt("id")).toString();
				dept[j] = rs.getString("dept");
				timea[j] = rs.getString("timea");
				title[j] = rs.getString("title");
				l[j] = rs.getString("l");
			}
			this.id = id;
			this.dept = dept;
			this.timea = timea;
			this.title = title;
			this.l = l;
			data1.close();
		}catch(Exception e){
			System.out.println(e.getStackTrace());
		}
	}
}