userdaonamedparameterjdbcimpl.java

自己做的关于spring与hibernate框架的使用

/**
 * 
 */
package org.dfbz.spring.dao;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.dfbz.spring.domain.User;
import org.springframework.jdbc.core.namedparam.BeanPropertySqlParameterSource;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcDaoSupport;
import org.springframework.jdbc.core.namedparam.SqlParameterSource;

/**
 * @author maboli
 * @date Dec 13, 2008
 *
 */
public class UserDaoNamedParameterJdbcImpl extends NamedParameterJdbcDaoSupport implements IUserDao {

	public void deleteUser(int id) {
		String sql = "DELETE FROM spring_user WHERE id=" + id;
		this.getJdbcTemplate().update(sql);
	}
	public List getAllUsers() {
		List resultList = new ArrayList();
		String sql = "SELECT * FROM spring_user";
		List queryList = this.getJdbcTemplate().queryForList(sql);
		for(int i = 0; i < queryList.size(); i++){
			Map map = (Map)queryList.get(i);
			User user = new User();
			user.setName((String)map.get("username"));
			System.out.println("name:" + user.getName());
			user.setPassword((String)map.get("password"));
			resultList.add(user);
		}
		return resultList;
	}
	public Integer getUserIdByLogname(String logname) {
		String sql = "SELECT id FROM spring_user WHERE username=?";
		return this.getJdbcTemplate().queryForInt(sql, new String[]{logname});

	}
	public void saveUser(String name, String password) {
		User user = new User(name, password);
		/*
		String sql = "INSERT INTO spring_user(username,password) VALUES(:name,:password)";
		Map params = new HashMap();
		params.put("name", name);
		params.put("password", password);
		*/
		this.saveUser(user);
	}

	/* (non-Javadoc)
	 * @see org.dfbz.spring.dao.IUserDao#saveUser(org.dfbz.spring.domain.User)
	 */
	public void saveUser(User user) {
		String sql = "INSERT INTO spring_user(username,password) VALUES(:name,:password)";
		SqlParameterSource paramSource = new BeanPropertySqlParameterSource(user);
		this.getNamedParameterJdbcTemplate().update(sql, paramSource);
	}

	/* (non-Javadoc)
	 * @see org.dfbz.spring.dao.IUserDao#updateUser(org.dfbz.spring.domain.User)
	 */
	public void updateUser(User user) {
		String sql = "UPDATE spring_user SET username=:name,password=:password WHERE id=:id";
		SqlParameterSource paramSource = new BeanPropertySqlParameterSource(user);
		this.getNamedParameterJdbcTemplate().update(sql, paramSource);

	}

}