热门数据库JDBC驱动试用心得 - 编程入门网
作者 佚名技术
来源 NET编程
浏览
发布时间 2012-06-18
| ip; } } //Execute SQL statement, and get the result set. public static ResultSet openQuery(final Statement stat, final String sql) { try { return (stat.executeQuery(sql) ); } catch(SQLException OPEN_QUERY) { … } } //Get the rows cout of result set. //The result set type should be ResultSet type is TYPE_SCROLL_SENSITIVE. public static int getRowsCount(ResultSet rs) { try { int rowsCount = 0; //Backup current row no. int rowNo = rs.getRow(); //Locate last row rs.last(); //Get the rows count rowsCount = rs.getRow(); //Return back original row if(rowNo < 1) //before first row { rs.beforeFirst(); } else // { rs.absolute(rowNo); } return (rowsCount); } catch(SQLException GET_ROWS_COUNT_FAILURE) { … } } //Get the columns count of resut set. public static int getColsCount(final ResultSet rs) { try { ResultSetMetaData rsmd = rs.getMetaData(); return (rsmd.getColumnCount() ); } catch(SQLException GET_COLS_COUNT_FAILURE) { … } } //Get special column name. //Note: The index of column base 1, but not 0. public static String getColName(final ResultSet rs, final int colIndex) { try { ResultSetMetaData rsmd = rs.getMetaData(); return (rsmd.getColumnName(colIndex) ); } catch(SQLException GET_COL_NAME_FAILURE) { … } } //Move the cursor of result set to next row public static boolean moveNext(ResultSet rs) { try { return (rs.next() ); } catch(SQLException MOVE_NEXT_FAILURE) { … } } //Get the retValue of cell by special row number and column number //The result set type should be ResultSet type is TYPE_SCROLL_SENSITIVE. //Note: The index of row and column all base 1, but no 0. public static Object getValueAt(ResultSet rs, final int rowIndex, final int colIndex) { if( (rowIndex < 1) || (colIndex < 1) ) { return (null); } try { //Backup current row no. int rowNo = rs.getRow(); Object retValue = null; //Locate to special row rs.absolute(rowIndex); //Get retValue retValue = rs.getObject(colIndex); //Return back origianl row rs.absolute(rowNo); return (retValue); } catch(SQLException GET_VALUE_FAILURE) { … } } //Get the retValue of cell by special row number and field name //The result set type should be ResultSet type is TYPE_SCROLL_SENSITIVE. //Note: The index of row and column all base 1, but no 0. public static Object getFieldByName(ResultSet rs, final int rowIndex, final String fieldName) { if( (rowIndex < 1) || (fieldName.equals("") == true) ) { return (null); } try { //Backup current row no. int rowNo = rs.getRow(); Object retValue = null; //Locate to special row rs.absolute(rowNo); //Get retValue retValue = rs.getObject(fieldName); //Return back origianl row no. rs.absolute(rowNo); return (retValue); } catch(SQLException GET_FIELD_BY_NAME_FAILURE) { … } } //Get the retValue of cell within current row by special field name //The result set type should be ResultSet type is TYPE_SCROLL_SENSITIVE. //Note: The index of row and column all base 1, but no 0. public static Object getFieldByName(final R |
凌众科技专业提供服务器租用、服务器托管、企业邮局、虚拟主机等服务，公司网站：http://www.lingzhong.cn 为了给广大客户了解更多的技术信息，本技术文章收集来源于网络,凌众科技尊重文章作者的版权，如果有涉及你的版权有必要删除你的文章，请和我们联系。以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢! |
你可能对下面的文章感兴趣
关于热门数据库JDBC驱动试用心得 - 编程入门网的所有评论
