javaee-问题

chapter8

使用mybatis进行数据的精确查询、模糊查询
https://blog.csdn.net/qq_42023080/article/details/105696731

JavaEE MyBatis与Spring的整合——基于mapper接口方式开发（教材学习笔记）

https://blog.csdn.net/qq_40788630/article/details/83784210?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522161944517816780366576644%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fblog.%2522%257D&request_id=161944517816780366576644&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2_blogfirst_rank_v2~rank_v29-18-83784210.nonecase&utm_term=JavaEE+

JavaEE MyBatis关联映射之一对一（教材学习笔记）
https://blog.csdn.net/qq_40788630/article/details/83586568

《JavaEE企业级应用开发教程(Spring+SpringMVC+MyBatis)》_课后习题
https://wenku.baidu.com/view/a07cc44ca100a6c30c22590102020740be1ecd34.html

问题0：
https://blog.csdn.net/weixin_44915419/article/details/106174053

//正确的代码
package com.itheima.test;
 
import java.awt.print.Printable;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;

import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import com.itheima.po.Customer;
import com.itheima.util.MybatisUtils;

/**
 * 
 * @根据客户姓名和职业组合条件查询客户信息列表
 */
public class MybatisTest {
	
	@Test

	public void findCustomerByNameAndJobsTest() {
	//获取SqlSession

	SqlSession sqlSession = MybatisUtils.getSession();

	//创建Customer对象，封装需要组合查询的条件

	Customer customer = new Customer();

	customer.setUsername("jack");

	customer.setJobs("teacher");

	//执行SqlSession的查询方法，返回结果集

	List<Customer> customers = sqlSession.selectList("com.itheima.mapper.CustomerMapper.findCustomerByNameAndJobs", customer);

	//输出结果

	for (Customer customer2 : customers) {
	System.out.println(customer2);

	}

	//关闭SqlSession

	sqlSession.close();
	
	}
}

//错误的代码

package com.itheima.test;
 
import java.awt.print.Printable;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;

import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import com.itheima.po.Customer;
import com.itheima.utils.MybatisUtils;
 
public class MybatisTest {
	/**
	 * 
	 * @根据客户姓名和职业组合条件查询客户信息列表
	 */

	@Test
	public void findCustomerByNameAndJobsTest()throws IOException {
        //
		System.out.println( "0");
		SqlSession session = MybatisUtils.getSession();
		System.out.println( "1");
		//
		Customer customer =new Customer();
		customer.setUsername("jack1");
		System.out.println( 2);
		
		//2sqlSession执行映射文件中定义的SQL，并返回映射结果集
		List<Customer> customers = session.selectList("com.itheima.mapper.CustomerMapper.findCustomerByNameJobs", customer);
		System.out.println( 3);

		//打印输出结果
		for(Customer customer2 :customers) {
			System.out.println( customer2);
		}
		
		//5.关闭SqlSession
		session.close();
	}
}

问题2
：https://blog.csdn.net/u014800380/article/details/81609067

问题3：
https://blog.csdn.net/qq_37503483/article/details/81223968