ibatis 单表查询 一对多查询

package com.ibatis; import java.io.Reader; import java.sql.SQLException; import java.util.ArrayList; import java.util.Date; import java.util.List; import org.junit.After; import org.junit.Before; import org.junit.Ignore; import org.junit.Test; import com.ibatis.common.resources.Resources; import com.ibatis.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.client.SqlMapClientBuilder; public class TestHelloIbatis { SqlMapClient sqlMap; @Before public void setUp() throws Exception { Reader reader = Resources.getResourceAsReader("sql-map-config.xml"); sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); } // @Test public void testInsert() throws Exception { User user = new User(); user.setName("zhangsan3"); user.setEmail("zs@163.com"); user.setBirthday(new Date()); try { sqlMap.insert("createUser", user); System.out.println("0000000"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } @Test public void testGetUser() throws SQLException { User user = (User) sqlMap.queryForObject("getUser", "zhangsan1"); System.out.println(user.getId() + " " + user.getEmail()); } @Test public void testGetUser1() throws SQLException { // ArrayList<User> list = (ArrayList<User>) sqlMap.queryForList("getUser_like", "zhangsan"); // System.out.println(list.size()); // for (User user : list) { // System.out.println(user.getId() + " " + user.getEmail()); // } // System.out.println(list); /** * 模糊查询,查询符合指定条件的所有Person对象 * * @param person * @return */ // SqlMapClient sqlMapClient=SqlMapUtil.getSqlMapClient(); sqlMap List<User> personList = new ArrayList<User>(); User user = new User(); user.setName("zhangsan"); try { sqlMap.startTransaction(); personList = sqlMap.queryForList("getUser_like", user); System.out.println(personList); for (User user1 : personList) { System.out.println(user1.getId() + " " + user1.getEmail()); } sqlMap.commitTransaction(); } catch (SQLException e) { e.printStackTrace(); } finally { try { sqlMap.endTransaction(); } catch (SQLException e) { e.printStackTrace(); } } } @Test public void testUpdateUser() throws SQLException { User user = new User(); user.setId(1); user.setName("zhangsan111"); user.setEmail("zs11@163.com"); sqlMap.update("updateUser", user); System.out.println(user.getId() + " " + user.getEmail()); } @Test // @Ignore public void testDeleteUser() throws SQLException { sqlMap.update("deleteUser", 1); } @After public void tearDown() throws Exception { sqlMap = null; } public static void main(String[] args) throws Exception { SqlMapClient sqlMap; Reader reader = Resources.getResourceAsReader("sql-map-config.xml"); sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); // sqlMap.update("deleteUser", 1); // User user = new User(); // user.setId(1); // user.setName("zhangsan111"); // user.setEmail("zs11@163.com"); // sqlMap.update("updateUser", user); // System.out.println(user.getId() + " " + user.getEmail()); // User user = (User) sqlMap.queryForObject("getUser", "zhangsan1"); // System.out.println(user.getId() + " " + user.getEmail()); User user = new User(); // user.setId(5); user.setName("zhangsan2"); user.setEmail("zs@163.com"); user.setBirthday(new Date()); try { sqlMap.insert("createUser", user); System.out.println("0000000"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }