20170725
来源:互联网 发布:网络舆情管理系统 编辑:程序博客网 时间:2024/06/10 05:05
传送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>
- 20170725
- 20170725
- 20170725
- 20170725
- 20170725 JQuery学习入门
- 20170725 jQuery语法简介
- 20170725考试总结
- 自练题20170725
- 20170725——学习总结
- 20170725 用Jquery修改CSS
- 20170725——按键输入实验
- 项目开发记录——全民矿工20170725
- 20170725使用linux的GDB打印STL(vector,map,set..................)
- ACMer永远不退役—20170725网络赛题解
- 20170725Linux下Makefile之三_动态链接库与静态链接库
- CSDN日报20170725——《新的开始,从研究生到入职亚马逊》
- vue-router嵌套
- shell学习(二)
- Android如何调用第三方SO库
- 异步消息处理机制Handler源码解析
- Git提交遇到的一个问题
- 20170725
- 源码剖析---------webbench(测压工具)
- View详解【一】
- Java中的进制转换
- Vs 2015-2017好用插件
- Android多屏幕适配
- int类型的数据长度
- LINUX下面JDK的安装
- KazaQ's Socks