concoll.java

一个简单的OA系统,希望能提高大家的JAVA能力.功能蛮多的,于初学者修改,SQLserver数据库,TOMcat服务器数据库,在database文件下,附加到SQLSERVE即可。

package swing;

import java.sql.ResultSet;
import java.util.Collection;
import java.util.ArrayList;
import com.zh.conpool.Condata;
import java.sql.Connection;

public class Concoll
{
	Condata con=new Condata();
	
	public Concoll(){
		try{
			con.getConnection();
		}catch(Exception e){
			e.getStackTrace();
		}
	}
	
	public Collection getMess(){
		Collection first=new ArrayList();
		try{
			String sql="select count(*) from tb_person";
			ResultSet rs=con.executeQuery(sql);
			int rscount=0;
			if(rs.next()){
				rscount=rs.getInt(1);
				rs.close();
			}
			if(rscount>0){
				String sql1="select * from tb_person where Popdeom=1";
				rs=con.executeQuery(sql1);
				while(rs.next()){
					Conmessage mess=new Conmessage();
					mess.setName(rs.getString("Name"));
					first.add(mess);
				}
				rs.close();
				con.close();
			}
		}catch(Exception ee){
			ee.getStackTrace();
		}
		return first;
	}
}