wenjian.java

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

package admin;

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


public class Wenjian implements Serializable {
	private static final long serialVersionUID = 313232122321L;
	private String id[] ;
	private String jinji[] ;
	private String timea[] ;
	private String title[] ;
	private String content[] ;
	private int i ;
	public String[] getId() {
		return id;
	}
	public int getI() {
		return i;
	}
	public String[] getjinji()  { 
		return  jinji;
	}
	public String[] getTimea()  { 
		return  timea;
	}
	public String[] getTitle()  { 
		return  title;
	}
	public String[] getContent()  { 
		return  content;
	}

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