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();
}
}