|
import java.sql.*;
import oracle.jdbc.pool.OracleDataSource;
public class oracle10g {
public static void main(String[] args) {
Connection con;
Statement stmt;
ResultSet rset;
// *********************************************************
// ojdbc14.jar
// Classes for use with JDK 1.4 and 5.0. It contains the JDBC driver
// classes, except classes for NLS support in Oracle Object and
// Collection types.
// *********************************************************
try {
OracleDataSource ods = new OracleDataSource();
ods.setUser("lightbox");
ods.setPassword("lightbox");
ods.setURL("jdbc:oracle:oci:@//localhost/XE");
con = ods.getConnection();
stmt = con.createStatement();
rset = stmt.executeQuery ( "select * from 社員マスタ" );
ResultSetMetaData rm = rset.getMetaData();
int nCols = rm.getColumnCount();
String[] data = new String[nCols];
int i;
while( rset.next() ) {
System.out.print( rset.getString( "氏名" ) + ":" );
for( i = 0; i < nCols; i++ ) {
data[i] = rset.getString( i+1 );
if ( i != 0 ) {
System.out.print( "," );
}
System.out.print( data[i] );
}
System.out.println( );
}
stmt.close();
con.close();
}
catch (Exception e) {
System.out.println( e.getMessage() );
}
}
}
| |