userdaoimpl.java

来自「Java协同办公系统。实现公司内部的人事」· Java 代码 · 共 36 行

package com.icss.oa.dao.impl;

import java.util.List;
import java.util.Properties;

import com.icss.oa.base.BaseDAO;
import com.icss.oa.base.impl.BaseDAOImpl;
import com.icss.oa.bean.User;
import com.icss.oa.dao.UserDAO;
import com.icss.oa.bean.User;

public class UserDAOImpl extends BaseDAOImpl implements UserDAO {

	public boolean addUser(User user) {
		
		String strInsert = "insert into t_user values(user_seq.nextval,?,?,sysdate)";
		
		return executeObject(strInsert,new Object[]{"che100",new Integer(123)});
	}

	public User queryUserById(int id) {
		String strQuery = "select * from t_user where userid = ?";

		Properties prop = querySingleObject(strQuery,new Object[]{new Integer(id)});

		User userVO = new User();
		
		userVO.setName(prop.getProperty("USERNAME"));
		userVO.setPwd(prop.getProperty("USERPASS"));
		return userVO;
	}



}