testjdbcdao.java

来自「自己做的关于spring框架的使用」· Java 代码 · 共 86 行

package myspring.v3.test;

import myspring.v3.jdbc.*;
import myspring.v3.jdbc.dao.User;
import myspring.v3.jdbc.dao.UserDao;
import myspring.v3.jdbc.dao.UserDaoNamedTemplate;

import java.sql.ResultSet;
import java.sql.SQLException;

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

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.FileSystemXmlApplicationContext;
import org.springframework.core.io.ClassPathResource;
import org.springframework.core.io.Resource;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowCallbackHandler;
import org.springframework.jdbc.core.RowCountCallbackHandler;


public class TestJDBCDao {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		
		
		TestJDBCDao test = new TestJDBCDao();
		test.testJDBC();
		//test.testJdbcSp();
		//test.testNamedJDBC();
		
	}
	
	public void testJDBC(){
		ApplicationContext ctx = new	FileSystemXmlApplicationContext("bean_jdbc_dao.xml");
		UserDao dao = (UserDao)ctx.getBean("dbtest");
		
		//System.out.println(dao.getUserIdByName("myname"));
		
		//dao.saveUser("name", "password");
		//dao.deleteUser(2);
		
		//dao.updateUser(3, "newname", "888888");
		
		List list = dao.getUsers();
		Iterator iterater = list.iterator();
		while(iterater.hasNext()){
			Map map = (Map)iterater.next();
			System.out.println(map.get("username"));
			System.out.println(map.get("password"));
		}
	}
	
	public void testJdbcSp(){
		ApplicationContext ctx = new FileSystemXmlApplicationContext("bean_jdbc_dao_sp.xml");
		UserDao dao = (UserDao)ctx.getBean("dbtest");
			
		List list = dao.getUsersBySp("J");
		Iterator iterater = list.iterator();
		while(iterater.hasNext()){
			Map map = (Map)iterater.next();
			System.out.println(map.get("FIRST_NAME"));
		}
	}
	
	public void testNamedJDBC(){
		ApplicationContext ctx = new	FileSystemXmlApplicationContext("bean_jdbc_nameddao.xml");
		UserDaoNamedTemplate dao = (UserDaoNamedTemplate)ctx.getBean("dbtest");
		
		//System.out.println(dao.getUserIdByName("myname"));
		
		dao.saveUser("named", "password");
		
		dao.saveUser(new User("named", "password"));
		
	}

}