package org.ssi.dao.ibatisDao;

import java.sql.SQLException;
import java.util.Iterator;
import java.util.List;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.FileSystemXmlApplicationContext;
import org.ssi.biz.bo.Account;
import org.ssi.dao.AccountDao;

public class AccountIbatisDaoTest {
	public void testInsert(AccountDao accountDao) {
		Account account = new Account();
		account.setUserID("zhhp1314520");
		account.setAddress1("hunan");
		account.setAddress2("changde");
		account.setCity("lixian");
		account.setCountry("china");
		account.setEmail("zhhp@126.com");
		account.setFirstName("huaping");
		account.setLastName("zhang");
		account.setPhone("12345678");
		account.setState("hunan");
		account.setStatus("activit");
		account.setZip("415503");
		System.out.println(account);

		accountDao.insertAccount(account);
	}

	public void testUpdate(AccountDao accountDao) {

		Account account = null;
		account = (Account) accountDao.getAccountByName("zhhp1314");
		System.out.println(account);
		account.setEmail("kekeke@sina.com");
		accountDao.updateAccount(account);
	}

	public void testGetList(AccountDao accountDao) {

		List accountList = null;
		accountList = accountDao.getAccountList();
		Iterator iter = accountList.iterator();
		while (iter.hasNext()) {
			System.out.println((Account) iter.next());
		}
	}

	public static void main(String[] args) throws SQLException {
		ApplicationContext ctx = new FileSystemXmlApplicationContext(
				"classpath:app-context-ibatis.xml");
		AccountDao accountDao = (AccountDao) ctx.getBean("accountDao");
		AccountIbatisDaoTest test = new AccountIbatisDaoTest();
		test.testGetList(accountDao);
	}
}