.#userinfodao.java.1.2

J2ee开发的 人事管理系统 使用oracle数据库 myeclips平台开发

package com.galaxy.dao;

import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.galaxy.base.DaoInterface;
import com.galaxy.db.ConnectDB;
import com.galaxy.vo.DeptInfoVO;
import com.galaxy.vo.RoleInfoVO;
import com.galaxy.vo.UserInfoVO;

public class UserInfoDAO extends ConnectDB implements DaoInterface{

	public int addObject(Object ob) 
	{
		UserInfoVO userinfovo = (UserInfoVO)ob;
		int i = 0;		
		super.openDBConnection();
		String sql = "insert into user_info values(seq.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";				
		try 
		{
			PreparedStatement pst = super.dbConnection.prepareStatement(sql);			
			pst.setLong(1, userinfovo.getRoleInfo().getRiId());
			pst.setLong(2, userinfovo.getDeptInfo().getDiId());
			pst.setString(3, userinfovo.getUiLoadname());
			pst.setString(4, userinfovo.getUiPassword());
			pst.setString(5, userinfovo.getUiRealname());
			pst.setString(6, userinfovo.getUiState());
			pst.setString(7, userinfovo.getUiSex());
			pst.setString(8, userinfovo.getUiXueli());
			pst.setString(9, userinfovo.getUiDegree());
			pst.setString(10, userinfovo.getUiZhiwu());
			pst.setString(11, userinfovo.getUiDuty());
			pst.setString(12, userinfovo.getUiPhoto());
			pst.setLong(13, 13213321);
			pst.setLong(14, userinfovo.getUiAge());
			pst.setString(15, userinfovo.getUiExtend());			
						
			i = pst.executeUpdate();		
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		super.closeDBConnection();	
		return i;
	}

	public int deleteObject(Object cond) {
		// TODO Auto-generated method stub
		return 0;
	}

	public List queryByCondition(Object cond)
	{
		List userlist = new ArrayList();
		String psql = "select * from user_info u join dept_info d on u.di_id=d.di_id where 1=1" + (String)cond;		
		Long depid = 0l;
		Long roleid = 0l;
		super.openDBConnection();
		try
		{
			super.dbResultSet = super.dbStatement.executeQuery(psql);
			while(super.dbResultSet.next())
			{
				UserInfoVO uservo = new UserInfoVO();
				uservo.setUiLoadname(dbResultSet.getString("ui_loadname"));
				uservo.setUiId(dbResultSet.getLong("ui_id"));
				uservo.setUiPassword(dbResultSet.getString("ui_password"));
				uservo.setUiRealname(dbResultSet.getString("ui_realname"));
				uservo.setUiState(dbResultSet.getString("ui_state"));
				uservo.setUiSex(dbResultSet.getString("ui_sex"));
				uservo.setUiXueli(dbResultSet.getString("ui_xueli"));
				uservo.setUiDegree(dbResultSet.getString("ui_degree"));
				uservo.setUiZhiwu(dbResultSet.getString("ui_zhiwu"));
				uservo.setUiDuty(dbResultSet.getString("ui_duty"));
				uservo.setUiPhoto(dbResultSet.getString("ui_photo"));
				uservo.setUiPersonid(dbResultSet.getLong("ui_personid"));
				uservo.setUiAge(dbResultSet.getLong("ui_age"));
				uservo.setUiExtend(dbResultSet.getString("ui_extend"));
				
				depid = dbResultSet.getLong("di_id");
				roleid = dbResultSet.getLong("ri_id");
				
				DeptInfoDAO depdao = new DeptInfoDAO();
				DeptInfoVO depvo = new DeptInfoVO();
				RoleInfoDAO roledao = new RoleInfoDAO();
				RoleInfoVO rolevo = new RoleInfoVO();
				
				rolevo.setRiId(roleid);
				depvo.setDiId(depid);
				
				depvo = (DeptInfoVO)depdao.readObject(depvo);								
				rolevo = (RoleInfoVO)roledao.readObject(rolevo);
				uservo.setDeptInfo(depvo);
				uservo.setRoleInfo(rolevo);
				userlist.add(uservo);
			}
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
		super.closeDBConnection();
		return userlist;
	}

	public Object readObject(Object cond) {
		// TODO Auto-generated method stub
		return null;
	}

	public int updateObject(Object ob) {
		// TODO Auto-generated method stub
		return 0;
	}

}