Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>From my libraries omino roundabout, the two methods you'll need... I need them everywhere. The resource reader is relative to a class, at least to know which jar to read. But the path can start with / to force it back to the top. Enjoy!</p> <p>(You'll have to make our own top level wrapper to look for "file:" and "classpath:".)</p> <p>see also <a href="http://code.google.com/p/omino-roundabout/" rel="nofollow">http://code.google.com/p/omino-roundabout/</a></p> <pre><code> public static String readFile(String filePath) { File f = new File(filePath); if (!f.exists()) return null; String result = ""; try { FileReader in = new FileReader(f); boolean doing = true; char[] bunch = new char[10000]; int soFar = 0; while (doing) { int got = in.read(bunch, 0, bunch.length); if (got &lt;= 0) doing = false; else { String k = new String(bunch, 0, got); result += k; soFar += got; } } } catch (Exception e) { return null; } // Strip off the UTF-8 front, if present. We hate this. EF BB BF // see http://stackoverflow.com/questions/4897876/reading-utf-8-bom-marker for example. // Mysteriously, when I read those 3 chars, they come in as 212,170,248. Fine, empirically, I'll strip that, too. if(result != null &amp;&amp; result.length() &gt;= 3) { int c0 = result.charAt(0); int c1 = result.charAt(1); int c2 = result.charAt(2); boolean leadingBom = (c0 == 0xEF &amp;&amp; c1 == 0xBB &amp;&amp; c2 == 0xBF); leadingBom |= (c0 == 212 &amp;&amp; c1 == 170 &amp;&amp; c2 == 248); if(leadingBom) result = result.substring(3); } // And because I'm a dictator, fix up the line feeds. result = result.replaceAll("\\r\\n", "\n"); result = result.replaceAll("\\r","\n"); return result; } static public String readResource(Class&lt;?&gt; aClass,String srcResourcePath) { if(aClass == null || srcResourcePath==null || srcResourcePath.length() == 0) return null; StringBuffer resultB = new StringBuffer(); URL resourceURL = null; try { resourceURL = aClass.getResource(srcResourcePath); } catch(Exception e) { /* leave result null */ } if(resourceURL == null) return null; // sorry. try { InputStream is = resourceURL.openStream(); final int BLOCKSIZE = 13007; byte[] bytes = new byte[BLOCKSIZE]; int bytesRead = 0; while(bytesRead &gt;= 0) { bytesRead = is.read(bytes); if(bytesRead &gt; 0) { char[] chars = new char[bytesRead]; for(int i = 0; i &lt; bytesRead; i++) chars[i] = (char)bytes[i]; resultB.append(chars); } } } catch(IOException e) { return null; // sorry } String result = resultB.toString(); return result; } </code></pre> <p>(edit -- removed a stray reference to OmString, to keep it standalone here.)</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to implement a universal file loader in Java?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USdavid van brink
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTDownMod
    1. COIt is rarely a good idea to use `FileReader`, or anything that uses the default character encoding. Your comment about bizarre behavior with Unicode BOMs should be a hint that you aren't handling encodings properly. Also, why do these two fairly long methods have names that sound like they do similar thing yet share no common logic? You may want to consider having them both create an `InputStream` which they then pass to a common private helper method.
      singulars
      1. PO
      1. USLaurence Gonsalves
    2. COHi @Laurence -- thanks for looking, & your comments are well-taken & appreciated. Thanks for the encoding pointer. Your note about shared inner helper method makes sense. Why are they like this now? They were written at far different times, get heavy use, and, well, until a test fails, it's off my radar.
      singulars
      1. PO
      1. USdavid van brink
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload