userdaospringtemplate.java

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

package myspring.v3.jdbc.dao;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.sql.DataSource;

import myspring.v3.jdbc.object.UserUpdate;

import oracle.jdbc.OracleTypes;

import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.CallableStatementCallback;
import org.springframework.jdbc.core.CallableStatementCreator;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

public class UserDaoSpringTemplate extends JdbcDaoSupport implements UserDao {
	
	
	
	public void deleteUser(int id) {
		// TODO Auto-generated method stub
		String sql = "delete from spring_user where id=" + id;
		this.getJdbcTemplate().update(sql);
		
		
	}

	public void saveUser(String name, String password) {
		// TODO Auto-generated method stub
		String sql = "insert into spring_user(username,password) values(?,?)";
		String[] args = {name, password};
		
		this.getJdbcTemplate().update(sql, args);
		
	}
	//JDBC操作的Java对象化
	public void updateUser(int id, String name, String password) {
		// TODO Auto-generated method stub
		UserUpdate  us = new UserUpdate(this.getDataSource());
		us.update(new Object[] {name,password,id});
	}

	public int getUserIdByName(String name) {
		// TODO Auto-generated method stub
		int id = 0;
		String[] values = {name};
		String sql = "select id from spring_user where username=?";
		
		id = this.getJdbcTemplate().queryForInt(sql, values);
		
		return id;
	}

	public List getUsers() {
		// TODO Auto-generated method stub
		String sql = "select * from spring_user ";
		return this.getJdbcTemplate().queryForList(sql);
	}

	public void saveUser(User user) {
		// TODO Auto-generated method stub
		
	}

	/* (non-Javadoc)
	 * @see myspring.v3.jdbc.dao.UserDao#getUsersBySp()
	 */
	public List getUsersBySp(String name) {
		final String storedProcName = "scott.display_employees_package.display_employees_proc";    
	     final String param = name;
	     
	     SpringStoredProce springStoredProce = new SpringStoredProce();
	     
	     List<Map> resultList = springStoredProce.execute(storedProcName, param, this.getJdbcTemplate()); 
	     
	     return resultList;
		
	}
	
	
}