mysql resultmap_mybatis学习之<resultMap>标签和动态sql

packagecom.itheima.test;importjava.io.IOException;importjava.io.InputStream;importjava.util.ArrayList;importjava.util.List;importorg.apache.ibatis.io.Resources;importorg.apache.ibatis.session.SqlSession;importorg.apache.ibatis.session.SqlSessionFactory;importorg.apache.ibatis.session.SqlSessionFactoryBuilder;importorg.junit.Test;importcom.itheima.po.Customer;importcom.itheima.utils.MybatisUtils;//mybatis入门程序测试

public classMybatisTest {

@Testpublic voidfindCustomerByNameAndJobs() {

SqlSession sqlsession=MybatisUtils.getSqlSession();

Customer customer=newCustomer();

customer.setUsername("sam");

customer.setJobs("doctor");

List customers=sqlsession.selectList("com.itheima.mapper.CustomerMapper.findCustomerByNameAndJobs", customer);for(Customer customer2 : customers) {

System.out.println(customer2);

}

sqlsession.close();

}

@Testpublic voidfindCustomerByNameOrJobs() {

SqlSession sqlsession=MybatisUtils.getSqlSession();

Customer customer=newCustomer();//customer.setUsername("sam");//customer.setJobs("doctor");

List customers=sqlsession.selectList("com.itheima.mapper.CustomerMapper.findCustomerByNameOrJobs", customer);for(Customer customer2 : customers) {

System.out.println(customer2);

}

sqlsession.close();

}

@Testpublic voidupdateCustomer() {

SqlSession sqlsession=MybatisUtils.getSqlSession();

Customer customer=newCustomer();

customer.setId(1);

customer.setUsername("DaMing");

customer.setJobs("doctor");

customer.setPhone("123456");int row=sqlsession.update("com.itheima.mapper.CustomerMapper.updateCustomer", customer);if(row>0) {

System.out.println("更新成功");

}else{

System.out.println("更新失败");

}

sqlsession.commit();

sqlsession.close();

}//编号批量查询

@Testpublic voidfindCustomerByIds() {

SqlSession sqlsession=MybatisUtils.getSqlSession();

List integers=new ArrayList();

integers.add(1);

integers.add(3);

integers.add(5);

List customers= sqlsession.selectList("com.itheima.mapper.CustomerMapper.findCustomerByIds", integers);for(Customer customer : customers) {

System.out.println(customer);

}

sqlsession.close();

}public voidfindCustomerByName() {

SqlSession sqlsession=MybatisUtils.getSqlSession();

Customer customer=newCustomer();

customer.setUsername("j");

List customers=sqlsession.selectList("com.itheima.mapper.CustomerMapper.findCustomerByName",customer);for(Customer customer2 : customers) {

System.out.println(customer2);

}

sqlsession.close();

}

}