userdaoimpl.java

用户模块和指标模块等等,还有其它的模块吧

package com.srit.gcz.dao.impl.user;

import java.util.List;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapperResultSetExtractor;

import com.srit.gcz.bean.rowmapper.user.UserInfoRowMapper;
import com.srit.gcz.bean.user.UserInfo;
import com.srit.gcz.bean.user.UserRoleRel;
import com.srit.gcz.dao.user.UserDao;
import com.srit.gcz.util.SysConstant;

/**
 * 用户
 * @Company 国研科技
 * @author 谢锦清
 * @date 2009-3-30
 * @version 1.0
 * @since 1.0
 */

public class UserDaoImpl implements UserDao {
	//新增用户
	private static final String INSERT_USER = "INSERT INTO" + SysConstant.TABLE_USER_USERINFO + "(ID,USERNAME,PASSWORD,BIRTHDAY,BIRTHORIGIN,ADDRESS,POST,PHONE1,PHONE2,TITLE,SEX,EMAIL,REMARK,LOGINNAME) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
	//更新用户
	private static final String UPDATE_USER = "UPDATE" + SysConstant.TABLE_USER_USERINFO + "SET USERNAME=?,PASSWORD=?,BIRTHDAY=?,BIRTHORIGIN=?,POST=?,PHONE1=?,PHONE2=?,SEX=?,EMAIL=?,REMARK=?,LOGINNAME=? WHERE ID=?";
	//删除用户
	private static final String DELETE_USER = "DELETE FROM" +SysConstant.TABLE_USER_USERINFO + "WHERE ID=?";
	//查询某用户
	private static final String QUERY_USER = "SELECT * FROM " + SysConstant.TABLE_USER_USERINFO + "WHERE ID=?";
	//查询所有的用户
	private static final String QUERY_ALL_USER = "SELECT * FROM " + SysConstant.TABLE_USER_USERINFO ;
	//新增用户角色的关系
	private static final String INSERT_REL_USER = "INSERT INTO" + SysConstant.TABLE_USER_USERROLE + "(USERID,ROLEID,REMARK) VALUES (?,?,?)";
	//删除用户角色的关系
	private static final String DELETE_REL_USER = "DELETE FROM" +SysConstant.TABLE_USER_USERROLE + "WHERE ROLEID=?";
	
	// Spring注入
	private JdbcTemplate jdbcTemplate;
	
	/**
	 * 保存用户
	 * @param userInfo
	 * @return
	 */
	public boolean save(UserInfo userInfo){
		
		int operMark = jdbcTemplate.update(INSERT_USER, new Object[]{userInfo.getId(),userInfo.getUserName(),userInfo.getPassword(),userInfo.getBirthday(),
																	 userInfo.getBirthorigin(),userInfo.getAddress(),userInfo.getPost(),userInfo.getPhone1(),
																	 userInfo.getPhone2(),userInfo.getTitle(),userInfo.getSex(),userInfo.getEmail(),
																	 userInfo.getRemark(),userInfo.getLoginName()});
		
		return (operMark > 0)? true : false;
	}
	
	/**
	 * 保存用户和角色的关联
	 * @param ID
	 * @param rels
	 * @return
	 */
	public boolean saveRel(UserRoleRel userRoleRel){
		int operMark = jdbcTemplate.update(INSERT_REL_USER, new Object[]{userRoleRel.getUserId(),userRoleRel.getRoldId(),userRoleRel.getRemark()});
		
		return (operMark>0)? true:false;
	}
			
	/**
	 * 修改用户
	 * @param userInfo
	 * @return
	 */
	public boolean update(UserInfo userInfo){
		int operMark = jdbcTemplate.update(UPDATE_USER, new Object[]{userInfo.getUserName(),userInfo.getPassword(),userInfo.getBirthday(),userInfo.getBirthorigin(),
																	 userInfo.getPost(),userInfo.getPhone1(),userInfo.getPhone2(),userInfo.getSex(),userInfo.getEmail(),
																	 userInfo.getRemark(),userInfo.getLoginName(),userInfo.getId()});
		return (operMark > 0) ? true : false;
	}
	
	/**
	 * 修改用户和角色关联
	 * @param ID
	 * @param rels
	 * @return
	 */
	public boolean updateRel(int userId){
		
		return true;
	}
	/**
	 * 删除用户
	 * @param userInfo
	 * @return
	 */
	public boolean delete(UserInfo userInfo){
		int operMark = jdbcTemplate.update(DELETE_USER, new Object[]{userInfo.getId()});
		return (operMark > 0) ? true : false;
	}
	
	/**
	 * 删除用户和角色关联
	 * @param IDs 用户ID
	 * @return
	 */
	public boolean deleteRel(UserRoleRel userRoleRel){
		int operMark = jdbcTemplate.update(DELETE_REL_USER, new Object[]{userRoleRel.getRoldId()});
		return (operMark>0)? true : false;
	}
	/**
	 * 获得用户
	 * @param ID
	 * @return
	 */
	public UserInfo getUserByInfo(int ID){
		UserInfo userInfo = (UserInfo) jdbcTemplate.queryForObject(QUERY_USER, new Object[] { ID },
				new UserInfoRowMapper());
		return userInfo;
	}
	/**
	 * 根据条件获取所有的用户
	 * @param 
	 * @return
	 */
	public List getUserAllInfo(){
		Object obj = jdbcTemplate.query(QUERY_ALL_USER,
				new RowMapperResultSetExtractor(new UserInfoRowMapper()));
		return (List<UserInfo>) obj;
	}



	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}
	
}