userdaonamedtemplate.java

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

package myspring.v3.jdbc.dao;

import java.sql.*;
import java.util.*;

import javax.sql.DataSource;

import oracle.jdbc.OracleTypes;

import org.springframework.jdbc.core.CallableStatementCallback;
import org.springframework.jdbc.core.CallableStatementCreator;
import org.springframework.jdbc.core.namedparam.BeanPropertySqlParameterSource;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcDaoSupport;
import org.springframework.jdbc.core.namedparam.SqlParameterSource;

public class UserDaoNamedTemplate extends  NamedParameterJdbcDaoSupport implements UserDao {
//public class UserDaoNamedTemplate extends NamedParameterJdbcTemplate implements UserDao {

	//public UserDaoNamedTemplate(DataSource dataSource){
	//	super(dataSource);
	//}
	
	public void deleteUser(int id) {
		// TODO Auto-generated method stub
	}

	public int getUserIdByName(String name) {
		// TODO Auto-generated method stub
		return 0;
	}

	public List getUsers() {
		// TODO Auto-generated method stub
		return null;
	}

	public void saveUser(String name, String password) {
		// TODO Auto-generated method stub
		String sql = "insert into spring_user(username,password) values(:name,:password)";
		Map namedParameters = new HashMap();
	    namedParameters.put("name", name);
	    namedParameters.put("password", password);
	    
		this.getNamedParameterJdbcTemplate().update(sql, namedParameters);
		//getJdbcOperations()方法封装了JdbcTemplate
		/*
		String[] args = {name, password};
		String sql1 = "insert into spring_user(username,password) values(?,?)";
		this.getJdbcOperations().update(sql1, args);
		*/
	}
	
	public void saveUser(User user) {
		// TODO Auto-generated method stub
		String sql = "insert into spring_user(username,password) values(:name,:password)";
				
		SqlParameterSource namedParameters = new BeanPropertySqlParameterSource(user);
		//:name -> user.getName();
		//:password -> user.getPassword();
		this.getNamedParameterJdbcTemplate().update(sql, namedParameters);
	
		
	}

	
	public void updateUser(int id, String name, String password) {
		// TODO Auto-generated method stub
		
	}

	/* (non-Javadoc)
	 * @see myspring.v3.jdbc.dao.UserDao#getUsersBySp()
	 */
	public List getUsersBySp(String name) {
		return null;
	}
	
	
}