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);
}
|
