GINPRO / SQLの窓と銀プログラマ

Connection con;
Statement stmt;
ResultSet rset;

//	String connectionString =
//		"jdbc:odbc:Provider=MSDASQL" +
//		";Driver={MySQL ODBC 5.2w Driver}" +
//		";SERVER=localhost" + 
//		";DATABASE=lightbox" +
//		";UID=root" +
//		";PWD=trustno1" +
//		";Charset=sjis" +
//		";";	

String connectionString = "jdbc:mysql://localhost/lightbox?" +
"user=root&password=パスワード";

try {
	con = DriverManager.getConnection(connectionString);
	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() ) {
		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() );
}