JDBC13 ORM02 Map封装
发布时间:2020-12-15 07:52:54 所属栏目:Java 来源:网络整理
导读:用Map封装一条信息 conn= Utils.getConn(); ps =conn.prepareStatement("select Empname,birthday,salary from emp where id=?" ); ps.setObject( 1,1 ); rs = ps.executeQuery(); while (rs.next()) { row.put( "Empname",rs.getObject(1 ) ); row.put( "bi
用Map封装一条信息 conn=Utils.getConn(); ps=conn.prepareStatement("select Empname,birthday,salary from emp where id=?"); ps.setObject(1,1); rs=ps.executeQuery(); while(rs.next()) { row.put("Empname",rs.getObject(1) ); row.put("birthday",rs.getObject(2)); row.put("salary",rs.getObject(3)); } for(String key:row.keySet()) { System.out.print(row.get(key)); } 用List盛放Map 存储多条信息 conn=Utils.getConn(); ps=conn.prepareStatement("select Empname,salary from emp where id>?"); ps.setObject(1,1); rs=ps.executeQuery(); while(rs.next()) { Map<String,Object>row=new HashMap<>(); row.put("Empname",rs.getObject(1) ); row.put("birthday",rs.getObject(2)); row.put("salary",rs.getObject(3)); list.add(row); } for(Map<String,Object> map:list) { for(String key:map.keySet()) { System.out.print(map.get(key)); } System.out.println(); } (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |