Java学习 （十一）mybatis增、删、改、查方法整理

@Test
	public void testMybatis() throws Exception{
		//加载核心配置文件
		String resource = "mybatis-config.xml";
		InputStream in = Resources.getResourceAsStream(resource);
		//创建SqlSessionFactory
		SqlSessionFactory sqlsessionFactory = new SqlSessionFactoryBuilder().build(in);
		//创建SqlSession
		SqlSession sqlSession = sqlsessionFactory.openSession();
		
		UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
		Integer userId = 10;
		User user = userMapper.findUserById(userId);
		System.out.println(user);
		Assert.assertEquals("张小明", user.getUsername());
		
		//sqlSession.selectOne("findUserById", 10);
		//System.out.println(user);
	}
	
	//根据用户名查询，注解必须有
	@Test
	public void testMybatisUsername() throws Exception{
		//加载核心配置文件
		String resource = "mybatis-config.xml";
		InputStream in = Resources.getResourceAsStream(resource);
		//创建SqlSessionFactory
		SqlSessionFactory sqlsessionFactory = new SqlSessionFactoryBuilder().build(in);
		//创建SqlSession
		SqlSession sqlSession = sqlsessionFactory.openSession();
		UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
//方法一：
//		List<User> users = userMapper.findUserByUsername("五");
//		for(User user2 : users){
//			System.out.println(user2);
//		}
	
		//方法二：
//		String username= "王五";
//		User user = userMapper.findUsername(username);
//		System.out.println(user);
//	
		 List<User> list = userMapper.findUserByUsername("张");
	     System.out.println(list.size());

//方法四：	     
//	     //构造查询条件user对象
//	       User user = new User();
//	       user.setId(1);
//	       user.setUsername("管理员");
//	       //传递user对象查询用户列表
//	       List<User>list = userMapper.findUserByUser(user);
//	       //关闭session
//	       session.close();
	}
	
	
	//方法三，插入的对象，不是数据类型
	@Test
	public void testInsertUser() throws Exception {

		   //加载核心配置文件
		   String resource = "mybatis-config.xml";
		   InputStream in = Resources.getResourceAsStream(resource);
		   //创建SqlSessionFactory
			SqlSessionFactory sqlsessionFactory = new SqlSessionFactoryBuilder().build(in);
	       //获取session
	       SqlSession session = sqlsessionFactory.openSession();

	       //获取mapper接口的代理对象
	       UserMapper userMapper = session.getMapper(UserMapper.class);

	       //要添加的数据
	       User user = new User();
	       user.setUsername("张三");
	       user.setBirthday(new Date());
	       user.setSex("1");
	       user.setAddress("北京市");
	       //通过mapper接口添加用户
	       userMapper.insertUser(user);
	       //提交
	       session.commit();
	       //关闭session
	       session.close();

	    }