---
title: "PreparedStatement 查询大容量数据内存溢出解决"
author: "mywebcode"
date: "2011-10-27T16:28:00Z"
tags: []
slug: "preparedstatement"
draft: false
lastmod: "2013-05-08T10:38:48Z"
id: 1863290
url: "https://mywebcode.iteye.com/blog/1863290"
---

PreparedStatement ps = con.prepareStatement(sql,  
ResultSet.TYPE\_SCROLL\_INSENSITIVE, ResultSet.CONCUR\_READ\_ONLY);

ResultSet rs = ps.executeQuery();

在使用PreparedStatement 查询大容量数据时内存溢出,只需在prepareStatement方法中加上ResultSet.TYPE\_SCROLL\_INSENSITIVE, ResultSet.CONCUR\_READ\_ONLY即可