查询数据库时如何把数据按照字段名和字段值的数据返回

最新推荐文章于 2022-02-07 18:05:28 发布

小瑞

最新推荐文章于 2022-02-07 18:05:28 发布

阅读量2k

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 session hashmap hibernate exception list

本文链接：https://blog.youkuaiyun.com/xiaxiaorui2003/article/details/7261213


		Session session = null;
		Connection conn = null;
		Statement statement = null;

		try {
			session = sessionFactory.openSession();
			conn = session.connection();
			statement = conn.createStatement();
			String cddm = "";
			ResultSet result = statement.executeQuery(sql);
			List list = new ArrayList();
			int j = 0;
			boolean done= true;
			ResultSetMetaData md = result.getMetaData();
			while (result.next()) {
				j++;
				done = true;
				HashMap hm = new HashMap();
				if (done){
					for (int i = 1; i <= md.getColumnCount(); i++) {
						hm.put(md.getColumnName(i).toUpperCase(), result
								.getString(i));
					}
					list.add(hm);
				}
			}
			result.close();
			return (list);
		} catch (SQLException e) {
			throw (new CarelessException("使用Hibernate(SQL)访问数据库时异常", e));
		} finally {

			if (statement != null) {
				try {
					statement.close();
				} catch (Exception e) {
					logger.getLogger().error( "HibernateAccessor exceptionA:" + e );
					logger.getLogger().error(ExceptionMsg.getMsg(e));										
				}
			}


			if (session != null) {
				session.close();
			}
		}