20170725

传送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>