package com.mucfc.test;
import java.io.Reader;
import java.util.List;
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.mucfc.model.Customer;
import com.mucfc.model.Ticket;
public class Test {
private static SqlSessionFactory sqlSessionFactory;
private static Reader reader;
static {
try {
reader = Resources.getResourceAsReader("mybatis-config.xml");
sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
} catch (Exception e) {
e.printStackTrace();
}
}
/*
* 一对一关联查询
*/
public static void selectTicketById(int id) {
SqlSession session = null;
try {
session = sqlSessionFactory.openSession();
Ticket ticket = (Ticket) session.selectOne(
"com.mucfc.model.TicketMapper.selectTicketById", id);
if (ticket == null)
System.out.println("null");
else {
System.out.println(ticket);
System.out.println(ticket.getCustomer());
}
} finally {
session.close();
}
}
/*
* 一对多关联查询
*/
public static void selectCustomerByName(String string) {
SqlSession session = null;
try {
session = sqlSessionFactory.openSession();
Customer customer = (Customer) session
.selectOne(
"com.mucfc.model.CustomerMapper.selectCustomerByName",
string);
if (customer == null)
System.out.println("null");
else {
System.out.println(customer);
List<Ticket> tickets = customer.getTickets();
for (Ticket ticket : tickets) {
System.out.println(ticket);
}
}
} finally {
session.close();
}
}
public static void main(String[] args) {
System.out.println("==============一对一查询，根据车票来查顾客===============");
selectTicketById(1);
System.out.println("==============多对一查询，根据顾客来查车票===============");
selectCustomerByName("小王");
}
}
Mybatis实现关联查询一对一和一对多实现
需积分: 31 6 浏览量
2015-05-14
10:08:34
上传
评论 2
收藏 5KB 7Z 举报
MybatisLearningChapter3.7z （15个子文件） 
MybatisLearningChapter3 
.project 399B src com mucfc model TicketMapper.xml 1KB CustomerMapper.xml 1KB Customer.java 1KB Ticket.java 1KB test Test.java 2KB mybatis-config.xml 1KB .settings org.eclipse.jdt.core.prefs 598B .classpath 493B bin com mucfc model Ticket.class 2KB TicketMapper.xml 1KB CustomerMapper.xml 1KB Customer.class 2KB test Test.class 3KB mybatis-config.xml 1KB资源评论
