mybatis_spring.zip_mybatis整合spring的包

package com.test; import java.io.IOException; import java.io.Reader; import java.util.HashMap; import java.util.List; import java.util.Map; import junit.framework.TestCase; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import com.entity.Role; import com.entity.User; public class MyBaitsTest extends TestCase { public void test01() { // 1.读取SqlMapConfig.xml文件 数据库连接信息 // 映射或sql语句 try { // 得到配置文件上的输入流 Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml"); SqlSessionFactory factory = new SqlSessionFactoryBuilder() .build(reader); SqlSession session = factory.openSession(); List<User> list = session.selectList("com.dao.UserMapper.findAll"); for (User u : list) { System.out.println(u.getId() + u.getName() + u.getPwd()); } User user = session.selectOne("com.dao.UserMapper.findById", 1); System.out.println(user.getId() + user.getName() + user.getPwd()); User u1 = new User(); // u1.setId(101); u1.setName("helloaccp1"); u1.setPwd("hello"); Map map = new HashMap(); map.put("name", "helloaccp1"); map.put("pwd", "hello"); User uu = session.selectOne("com.dao.UserMapper.loginUser", map); if (uu == null) { System.out.println("用户名或密码错误"); } else { System.out.println("用户合法"); } // session.insert("com.dao.UserMapper.insertUser", u1); // session.commit(); System.out.println("增加成功!!"); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public void test02() { try { // 得到配置文件上的输入流 Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml"); SqlSessionFactory factory = new SqlSessionFactoryBuilder() .build(reader); SqlSession session = factory.openSession(); /*User user = session.selectOne("com.dao.UserMapper.findById", 1); System.out.println(user.getName()); Role role=user.getRole(); System.out.println(role.getName()); */ Role role=session.selectOne("com.dao.UserMapper.findRoleMapById",2); System.out.println("角色名:"+role.getName()); for(User u:role.getUsers()){ System.out.println(u.getName()); } } catch (Exception ex) { ex.printStackTrace(); } } }