[queryviewer-devel] queryviewer/src/net/sourceforge/queryviewer JDBCConnectionImpl.java,1.2,1.3

[<av...@us...>]

Update of /cvsroot/queryviewer/queryviewer/src/net/sourceforge/queryviewer
In directory sc8-pr-cvs1:/tmp/cvs-serv28997/src/net/sourceforge/queryviewer

Modified Files:
	JDBCConnectionImpl.java 
Log Message:
modification du performQuery pour pouvoir effectuer ET des select ET tout autre opération SQL!


Index: JDBCConnectionImpl.java
===================================================================
RCS file: /cvsroot/queryviewer/queryviewer/src/net/sourceforge/queryviewer/JDBCConnectionImpl.java,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** JDBCConnectionImpl.java	17 Jun 2003 00:20:36 -0000	1.2
--- JDBCConnectionImpl.java	27 Jun 2003 11:01:44 -0000	1.3
***************
*** 76,95 ****
  		try {
  			java.sql.Statement stmt = this.connection.createStatement();
! 			java.sql.ResultSet rs = stmt.executeQuery(queryString);
! 			String [] title = getColumnNames(rs.getMetaData());
! 			java.util.ArrayList ar = new java.util.ArrayList();
! 			ar.add(title);
! 			int cols = title.length;
! 			while(rs.next()) {
! 				String[] row=new String[cols];
! 				for(int i=0; i<cols; i++) {
! 					row[i]=rs.getString(i+1);
! 				}
! 				ar.add(row);
! 			}
! 			if(!ar.isEmpty()) {
! 				data=new String[ar.size()][cols];
! 				data=(String[][])ar.toArray(data);
! 			}
  		} catch(SQLException sqlex) {
  			throw new QueryException(sqlex);
--- 76,105 ----
  		try {
  			java.sql.Statement stmt = this.connection.createStatement();
!       if ( stmt.execute( queryString ) ) {
!         // resultset
!         java.sql.ResultSet rs = stmt.getResultSet();
!         String [] title = getColumnNames(rs.getMetaData());
!         java.util.ArrayList ar = new java.util.ArrayList();
!         ar.add(title);
!         int cols = title.length;
!         while(rs.next()) {
!           String[] row=new String[cols];
!           for(int i=0; i<cols; i++) {
!             row[i]=rs.getString(i+1);
!           }
!           ar.add(row);
!         }
!         if(!ar.isEmpty()) {
!           data=new String[ar.size()][cols];
!           data=(String[][])ar.toArray(data);
!         }
!       } // end of if ()
!       else {
!         // int
!         int count = stmt.getUpdateCount();
!         String scount = String.valueOf( count );
!         data = new String[][] { { "Nombre de fiches mises a jour..." }, { scount } };
!       } // end of if () else
!       
  		} catch(SQLException sqlex) {
  			throw new QueryException(sqlex);
***************
*** 109,112 ****
--- 119,123 ----
  		title=new String[col];
  		for(int i=0; i<col; i++) {
+       // le comptage des colonnes commence à 1
  			title[i]=metaData.getColumnName(i+1);
  		}