6. ½Ó×ÅÎÒÔÚÎļþ·¾¶cn/com/sharpxiajun/dao/sqlmap/ϱàдÁËUSERS.xmlÅäÖÃÎļþ£¬ÄÚÈÝÈçÏ£º
< xml version="1.0" encoding="UTF-8" >
http://ibatis.apache.org/dtd/sql-map-2.dtd">
ÀïÃæÎÒֻдÁËÒ»¸ö²éѯ·½·¨£¬parameterClass="java.util.Map"´ú±í´«Èë²ÎÊýÊÇmap£¬resultClass="java.util.HashMap"±íʾ·µ»ØµÄ½á¹ûÊÇÒ»¸ömap£¬ÕâÀïÕýºÃÓ¦ÓÃÁËÎÒǰһƪ²©ÎÄÀïÃæÌ¸µ½µÄ¸÷¸öÂß¼²ãÓÃmapÀ´×öΪ´«ÊäµÄ½éÖÊ¡£
7. È»ºóÎÒÔÚ·¾¶cn.com.sharpxiajun.daoϱàд½Ó¿ÚUsersDao£¬ÄÚÈÝÈçÏ£º
package cn.com.sharpxiajun.dao;
import java.util.List;
import java.util.Map;
public interface UsersDao {
public static final String QUERY_USERS_SQL = "USERS.queryUserList";
public List
}
ÔÚ·¾¶cn.com.sharpxiajun.dao.implÏÂʵÏÖÁËUsersDaoImpl½Ó¿Ú£¬´úÂëÈçÏ£º
package cn.com.sharpxiajun.dao.impl;
import java.util.List;
import java.util.Map;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.context.annotation.Scope;
import org.springframework.orm.ibatis.SqlMapClientTemplate;
import org.springframework.stereotype.Repository;
import cn.com.sharpxiajun.dao.UsersDao;
@SuppressWarnings("unchecked")
@Scope("prototype")
@Repository("usersDao")
public class UsersDaoImpl implements UsersDao {
@Autowired
@Qualifier("sqlMapClientTemplate")
private SqlMapClientTemplate sqlMapClientTemplate = null;
public List
}
@Scope("prototype")£º¶àÏß³Ì, Éú³É¶à¸öʵÀý¡£
@Repository("usersDao")½«UsersDaoImpl×¢²áΪspringµÄbean¶ÔÏó£¬Repository±êǩֻÓÃÓÚdao²ã£¬ÒòΪRepository±êÇ©ÀïÃæ»¹·â×°ÁËdao²ãÅ׳öµÄÒì³£ÀàÐÍ¡£
8. дºÃÁËdao²ãÎÒ½ÓÏÂÀ´±àдÁËSqlMapConfig.xmlÎļþ£¬ÄÚÈÝÈçÏ£º
< xml version="1.0" encoding="UTF-8" >
http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
useStatementNamespaces="true"/>
9. ×îºóÎÒÃDZàд¸ÃUserDaoµ¥Ôª²âÊÔÀ࣬´úÂëÈçÏ£º
package cn.com.sharpxiajun.junittest.dao;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.AbstractTransactionalJUnit4SpringContextTests;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import org.springframework.test.context.transaction.TransactionConfiguration;
import cn.com.sharpxiajun.dao.UsersDao;
import junit.framework.TestCase;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations={"classpath:conf/applicationContext.xml"})
@TransactionConfiguration(defaultRollback = false)
public class UsersDaoImplTest extends AbstractTransactionalJUnit4SpringContextTests{
@Autowired
private UsersDao usersDao;
public UsersDaoImplTest()
{
System.out.println("³õʼ»¯²âÊÔÀà....");
}
@Before
public void setUp() throws Exception
{
System.out.println("²âÊÔ¿ªÊ¼....");
}
@After
public void tearDown() throws Exception
{
System.out.println("²âÊÔ½áÊø!!");
}
@Test
public void testQu