mybatis ----数据级联查询(多对一)(二)
2014-11-24 00:38:36
·
作者:
·
浏览: 1
* ,commit,rollback,close等方法
* @return
*/
private static SqlSessionFactory getSessionFactory(){
SqlSessionFactory sessionFactory=null;
String resource="configuration.xml";
try {
sessionFactory=new SqlSessionFactoryBuilder().build(Resources.getResourceAsReader(resource));
} catch (IOException e) {
e.printStackTrace();
}
return sessionFactory;
}
/**
* main 方法
* @param args
*/
public static void main(String[] args) {
SqlSession session=getSessionFactory().openSession();
try {
IUserDao userDao=session.getMapper(IUserDao.class);
//传入用户的id=1
List
listArticle=userDao.getUserArticles(1);
for(Article article:listArticle){
System.out.println(article.getTitle()+":"+article.getContent()+
":作者是:"+article.getUser().getUserName()+":地址:"+
article.getUser().getUserAddress());
}
} catch (Exception e) {
e.printStackTrace();
}
finally{
session.close();
}
}
}
运行后结果如下:
test_title:text_content:作者是:summer:地址:上海
test_title_2:text_content_2:作者是:summer:地址:上海
test_title_3:text_content_3:作者是:summer:地址:上海
test_title_4:text_content_4:作者是:summer:地址:上海