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:地址:上海