20170725

版权声明:本文为博主原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/qq_36066923/article/details/76083117

传送user对象:


<select id="getUserList" resultType="com.yy.po.User">

select * from jdbc  where userid = 2
</select>



@Test
public void testGetUserlist() throws Exception {
List<User> userList = userdao.getUserList();
for(User user:userList){
System.out.println(user.getUserId());
System.out.println(user.getUsername());
System.out.println(user.getPassword());
System.out.println(user.getSex());
System.out.println(user.getFlag());


}
}


public List<User> getUserList(){
List<User> count =null ;
InputStream is=null;
SqlSession sqlSession=null;

try {
is=Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory factory =new SqlSessionFactoryBuilder().build(is);
sqlSession = factory.openSession();
count= sqlSession.selectList("com.yy.dao.UserDao.getUserList");
} catch (IOException e) {
e.printStackTrace();
}finally{

try {
sqlSession.close();
is.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return count;
}





xml配置后在传user对象:


public List<User> getUserList2(){
List<User> count =null ;
InputStream is=null;
SqlSession sqlSession=null;

try {
is=Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory factory =new SqlSessionFactoryBuilder().build(is);
sqlSession = factory.openSession();
count= sqlSession.selectList("com.yy.dao.UserDao.getUserList2");
} catch (IOException e) {
e.printStackTrace();
}finally{

try {
sqlSession.close();
is.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return count;
}



<select id="getUserList2" resultType="User">
select * from jdbc  where userid = 2
</select>



@Test
public void testGetUserlist2() throws Exception {
List<User> userList = userdao.getUserList2();
for(User user:userList){
System.out.println(user.getUserId());
System.out.println(user.getUsername());
System.out.println(user.getPassword());
System.out.println(user.getSex());
System.out.println(user.getFlag());


}
}



<!-- 别名 -->
<typeAliases>
<typeAlias alias="User" type="com.yy.po.User"/>
</typeAliases>














展开阅读全文

没有更多推荐了,返回首页