java连接 oracle 遍历ResultSet,结果集耗尽

最新推荐文章于 2021-04-03 06:01:19 发布

三叔二少爷

最新推荐文章于 2021-04-03 06:01:19 发布

阅读量1.9w

点赞数

分类专栏： java oracle

本文链接：https://blog.csdn.net/breaker892902/article/details/39397579

版权

java连接oracle数据库

Connection conn = null;

Statement stmt = null;
ResultSet rs = null;
String url="jdbc:oracle:thin:@192.239.99.109:1521:orcl";

	      try {
	            Class.forName("oracle.jdbc.driver.OracleDriver");
	            conn = DriverManager.getConnection(url, "g4studio", "g4studio");
	            stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
	            		ResultSet.CONCUR_UPDATABLE);
	            rs = stmt.executeQuery("SELECT * FROM GEO_ENTITY_RECOG where STMC like '%"+searchName+"%'");
	            ResultSetMetaData m=rs.getMetaData();
	            int columns=m.getColumnCount();
	            rs.beforeFirst();//将结果集指针指回到开始位置
	            while(rs.next())
	            {
	             for(int i=1;i<=columns;i++)
	             {