JDBC内容大佬们帮一下忙多谢

ajivyskl 2019-06-25 10:38:42

创建了一个返回值为ResultSet的方法获取了结果集之后关闭了ResultSet对象然后return ResultSet报错图二是关闭的一个方法。不管我关闭connection 还是statement 或者resultset 都报错如果参数全部传空就不报错

...全文

62 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

guishuanglin 2019-06-28

打赏
举报


public List<Object[]> findObjectList(String sql, Object[] args) {
		if(sql==null) return null;
		if(logger.isDebugEnabled()) logger.debug(sql);

		//list对象结果
		final List<Object[]> list = new ArrayList<Object[]>(50);

		PreparedStatement pstmt = null;
		ResultSet rs = null;
		Connection con = null;
		try {
			con = this.getConnection();
			pstmt = con.prepareStatement(sql);
			SetStatementParam.setParameter(pstmt, args);
			pstmt.setFetchSize(50);
			rs = pstmt.executeQuery();
			int r = 1;
			int clength = rs.getMetaData().getColumnCount();
			Object[] obj =null;
			//读取数据库数据
			while (rs.next()) {
				r = 1;
				obj = new Object[clength];
				for(int i=0; i<clength; i++){
					obj[i] =rs.getObject(r++); 
				}
				list.add(obj);
			}
		} catch (Exception ex) {
			logger.error("[操作数据库SQL异常]: "+sql, ex);
		} finally {
			//读取数据库数据完成之后, 关闭连接,流,rs
			closeStatement(pstmt);
			closeResultSet(rs);
			releaseConnection(con, this.getDataSource());
		}//返回list对象集合
		return list;
	}

guishuanglin 2019-06-28

打赏
举报

给你一个在用的代码,写了注释: public List<Object[]> findObjectList(String sql, Object[] args) { if(sql==null) return null; if(logger.isDebugEnabled()) logger.debug(sql); //list对象结果 final List<Object[]> list = new ArrayList<Object[]>(50); PreparedStatement pstmt = null; ResultSet rs = null; Connection con = null; try { con = this.getConnection(); pstmt = con.prepareStatement(sql); SetStatementParam.setParameter(pstmt, args); pstmt.setFetchSize(50); rs = pstmt.executeQuery(); int r = 1; int clength = rs.getMetaData().getColumnCount(); Object[] obj =null; //读取数据库数据 while (rs.next()) { r = 1; obj = new Object[clength]; for(int i=0; i<clength; i++){ obj[i] =rs.getObject(r++); } list.add(obj); } } catch (Exception ex) { logger.error("[操作数据库SQL异常]: "+sql, ex); } finally { //读取数据库数据完成之后, 关闭连接,流,rs closeStatement(pstmt); closeResultSet(rs); releaseConnection(con, this.getDataSource()); }//返回list对象集合 return list; }

ajivyskl 2019-06-28

打赏
举报

引用 4 楼 guishuanglin 的回复：


public List<Object[]> findObjectList(String sql, Object[] args) {
		if(sql==null) return null;
		if(logger.isDebugEnabled()) logger.debug(sql);

		//list对象结果
		final List<Object[]> list = new ArrayList<Object[]>(50);

		PreparedStatement pstmt = null;
		ResultSet rs = null;
		Connection con = null;
		try {
			con = this.getConnection();
			pstmt = con.prepareStatement(sql);
			SetStatementParam.setParameter(pstmt, args);
			pstmt.setFetchSize(50);
			rs = pstmt.executeQuery();
			int r = 1;
			int clength = rs.getMetaData().getColumnCount();
			Object[] obj =null;
			//读取数据库数据
			while (rs.next()) {
				r = 1;
				obj = new Object[clength];
				for(int i=0; i<clength; i++){
					obj[i] =rs.getObject(r++); 
				}
				list.add(obj);
			}
		} catch (Exception ex) {
			logger.error("[操作数据库SQL异常]: "+sql, ex);
		} finally {
			//读取数据库数据完成之后, 关闭连接,流,rs
			closeStatement(pstmt);
			closeResultSet(rs);
			releaseConnection(con, this.getDataSource());
		}//返回list对象集合
		return list;
	}

谢谢兄弟笨拙了

guishuanglin 2019-06-26