1) MySQL + mysql-connector-java-5.0.6-bin.jar 2) MySQL + JDBC-ODBC ブリッジドライバ 3) Oracle10g + ojdbc14.jar ↓更新時のサンプル 拡張子:txtvbswsfjsphpjavahtmlutf8sjis // ***************************************************** // DB 更新処理 // ***************************************************** public int Execute( String Query ) { ErrorMessage = ""; int nRet; try { nRet = stmt.executeUpdate( Query ); } catch( SQLException e ) { ErrorMessage = e.getMessage(); return -1; } return nRet; }
// ***************************************************** // DB 更新処理 // ***************************************************** public int Execute( String Query ) { ErrorMessage = ""; int nRet; try { nRet = stmt.executeUpdate( Query ); } catch( SQLException e ) { ErrorMessage = e.getMessage(); return -1; } return nRet; }
拡張子:txtvbswsfjsphpjavahtmlutf8sjis import java.sql.*; public class mysql { public static void main(String[] args) { Connection con; Statement stmt; ResultSet rset; // ********************************************************* // MySQL 5.1 // mysql-connector-java-5.0.6-bin.jar // ********************************************************* try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection( "jdbc:mysql://localhost/lightbox" +"?user=root" +"&password=" // ********************************************************* // 以下が無い場合、日本語指定の getString が失敗する // ********************************************************* +"&characterSetResults=sjis" ); 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() ); } } }
import java.sql.*; public class mysql { public static void main(String[] args) { Connection con; Statement stmt; ResultSet rset; // ********************************************************* // MySQL 5.1 // mysql-connector-java-5.0.6-bin.jar // ********************************************************* try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection( "jdbc:mysql://localhost/lightbox" +"?user=root" +"&password=" // ********************************************************* // 以下が無い場合、日本語指定の getString が失敗する // ********************************************************* +"&characterSetResults=sjis" ); 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() ); } } }
拡張子:txtvbswsfjsphpjavahtmlutf8sjis import java.sql.*; public class mysql_odbc { public static void main(String[] args) { Connection con; Statement stmt; ResultSet rset; // ********************************************************* // odbc 用 jdbc // http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-connection-parameters.html // ********************************************************* try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection( "jdbc:odbc:MySQL" +";user=root" +";password=" +";server=localhost" +";database=lightbox" ); 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() ); } } }
import java.sql.*; public class mysql_odbc { public static void main(String[] args) { Connection con; Statement stmt; ResultSet rset; // ********************************************************* // odbc 用 jdbc // http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-connection-parameters.html // ********************************************************* try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection( "jdbc:odbc:MySQL" +";user=root" +";password=" +";server=localhost" +";database=lightbox" ); 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() ); } } }
拡張子:txtvbswsfjsphpjavahtmlutf8sjis 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() ); } } }
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() ); } } }