otherinfodao.java

实现办公自动化系统

package com.oa.struts.perOffice.modle;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import com.oa.struts.vo.*;
import com.oa.util.DBConn;

public class OtherInfoDAO 
{
	Connection con=null;
	PreparedStatement pstmt=null;
	ResultSet rs=null;
	DBConn db=null;
    

	
	public OtherInfoDAO() {
		super();
		// TODO Auto-generated constructor stub
	}



	//查询他人信息
	public List searchOtherInfo(String realName)
	{
		OtherInfo info=new OtherInfo();
		List list=new ArrayList();
		try
		{
			String sql="select * from tb_userInfo where realName like %?%";
			db=new DBConn();
			con=db.getConnection();
			pstmt=con.prepareStatement(sql);
			pstmt.setString(1,realName);		
			rs=pstmt.executeQuery();
			
			String userID="";
			String userName="";
			int sex;
			String userDepTel="";

			while(rs.next())
			{
				userID=rs.getString(1);
				userName=rs.getString(2);
				sex=rs.getInt(5);
				userDepTel=rs.getString(9);
				info.setUserID(userID);
			    info.setUserName(userName);
			    info.setSex(sex);
			    
			    info.setUserDepTel(userDepTel);
			   
				list.add(info);
			}
			
			
			
			if(rs!=null) rs.close();
			if(pstmt!=null) pstmt.close();
			if(con!=null) con.close();		
			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}	
		return list;
	}
}