momocoll.java

企业办公自动化管理系统

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 MomoColl
{
	Condata con=new Condata();
	private String names="";
	public MemoRous mess=new MemoRous();
	
	public MomoColl(){
		try{
			con.getConnection();
		}catch(Exception e){
			e.getStackTrace();
		}
	}
	
	public MemoRous getMess(String name){
		this.names=name;
		Collection first=new ArrayList();
		try{
			String sql1="select * from tb_roes where perNam='"+this.names+"'";
			ResultSet rs=con.executeQuery(sql1);
			int rscount=0;
			if(rs.next()){
					int a=rs.getInt("row11");
					mess.setId1(a);
					mess.setId2(rs.getInt("row12"));
					mess.setId3(rs.getInt(5));
					mess.setId4(rs.getInt(6));
					mess.setId5(rs.getInt(7));
					mess.setId6(rs.getInt(8));
					mess.setId7(rs.getInt(9));
					mess.setId8(rs.getInt(10));
					mess.setId9(rs.getInt(11));
					mess.setId10(rs.getInt(12));
					mess.setId11(rs.getInt(13));
					mess.setId12(rs.getInt(14));
					mess.setId13(rs.getInt(15));
					mess.setId14(rs.getInt(16));
					mess.setId15(rs.getInt(17));
					mess.setId16(rs.getInt(18));
					mess.setId17(rs.getInt(19));
					mess.setId18(rs.getInt(20));
					mess.setId19(rs.getInt(21));
					mess.setId20(rs.getInt(22));
					mess.setId21(rs.getInt(23));
					mess.setId22(rs.getInt(24));
					mess.setId23(rs.getInt(25));
					mess.setId24(rs.getInt(26));
					mess.setId25(rs.getInt(27));
					mess.setId26(rs.getInt(28));
				}
				rs.close();
				con.close();
		}catch(Exception ee){
			ee.getStackTrace();
		}
		return mess;
	}
}