userdao.java

一个简单的基于spring的mvc实现

package dao;

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

import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.namedparam.BeanPropertySqlParameterSource;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcDaoSupport;
import org.springframework.jdbc.core.namedparam.SqlParameterSource;




public class UserDAO extends NamedParameterJdbcDaoSupport implements IUserDAO {
	

	

	public void deleteUser(String id) {
		// TODO Auto-generated method stub
		String sql = "delete from dept where id = :id";
		Map map = new HashMap();
		map.put("id", id);
		this.getNamedParameterJdbcTemplate().update(sql, map);
	}

	public User getUser(String id,String psw) {
		// TODO Auto-generated method stub
		String sql = "Select * from dept where id = :id and psw = :psw";
		Map map = new HashMap();
		map.put("id", id);
		map.put("psw", psw);
		User user = (User) this.getNamedParameterJdbcTemplate().queryForObject(sql, map, User.class);
		return user;
	}

	public List getUserList() {
		// TODO Auto-generated method stub
		String sql = "select * from dept";
		//Map map = new Map();
		Map map = new HashMap();
		List list = this.getNamedParameterJdbcTemplate().queryForList(sql, map);
		return list;
	}
	public void savUser(String id,String psw) {
		// TODO Auto-generated method stub
		try{
			String sql = "insert into dept values(:id,:psw)";
			Map map = new HashMap();
			map.put("id", id);
			map.put("psw", psw);
			//this.getNamedParameterJdbcTemplate().update(sql, map);
			this.getNamedParameterJdbcTemplate().update(sql, map);
		}catch(DataAccessException e){
			throw e;
		}
		
	}

	public void saveUser(User user) {
		// 直接用对象操作数据库
		String sql = "insert into dept values(:id,:psw)";
		SqlParameterSource sqs = new BeanPropertySqlParameterSource(user);
		int i = this.getNamedParameterJdbcTemplate().update(sql, sqs);
		System.out.println("save "+i+"行");
	}

}