userdaojdbcimpl.java

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

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

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

import org.dfbz.spring.domain.User;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

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

	/* (non-Javadoc)
	 * @see org.dfbz.spring.dao.IUserDao#deleteUser(int)
	 */
	public void deleteUser(int id) {
		
		String sql = "DELETE FROM spring_user WHERE id=" + id;
		this.getJdbcTemplate().update(sql);

	}

	/* (non-Javadoc)
	 * @see org.dfbz.spring.dao.IUserDao#getAllUsers()
	 */
	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;

	}

	/* (non-Javadoc)
	 * @see org.dfbz.spring.dao.IUserDao#getUserIdBylogname(java.lang.String)
	 */
	public Integer getUserIdByLogname(String logname) {
		String sql = "SELECT id FROM spring_user WHERE username=?";
		return this.getJdbcTemplate().queryForInt(sql, new String[]{logname});

	}

	/* (non-Javadoc)
	 * @see org.dfbz.spring.dao.IUserDao#saveUser(java.lang.String, java.lang.String)
	 */
	public void saveUser(String name, String password) {
		String sql = "INSERT INTO spring_user(username,password) VALUES(?,?)";
		this.getJdbcTemplate().update(sql, new String[]{name, password});

	}

	/* (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,asas, password) VALUES(?,?)";
		this.getJdbcTemplate().update(sql, new String[]{user.getName(), user.getPassword()});

	}

	/* (non-Javadoc)
	 * @see org.dfbz.spring.dao.IUserDao#updateUser(org.dfbz.spring.domain.User)
	 */
	public void updateUser(User user) {
		throw new UnsupportedOperationException();

	}

}