2015

Here's a step by step explanation how to install MySQL and JDBC and how to use it

<div dir="ltr" style="text-align: left;" trbidi="on">
<ol style="background-color: white; border: 0px; color: #222222; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 19.5px; margin: 0px 0px 1em 30px; padding: 0px;">
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;"><div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
<a href="http://dev.mysql.com/downloads/mysql/" style="border: 0px; color: #0c65a5; cursor: pointer; margin: 0px; padding: 0px; text-decoration: none;">Download</a> and install the MySQL server. Just do it the usual way. Remember the port number whenever you've changed it. It's by default <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">3306</code>.</div>
</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;"><div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
<a href="http://dev.mysql.com/downloads/connector/j/" style="border: 0px; color: #0c65a5; cursor: pointer; margin: 0px; padding: 0px; text-decoration: none;">Download</a> the JDBC driver and put in classpath, extract the ZIP file and put the containing JAR file in the classpath. The vendor-specific JDBC driver is a concrete implementation of the<a href="http://docs.oracle.com/javase/8/docs/api/java/sql/package-summary.html" style="border: 0px; color: #0c65a5; cursor: pointer; margin: 0px; padding: 0px; text-decoration: none;">JDBC API</a> (<a href="http://docs.oracle.com/javase/tutorial/jdbc/index.html" style="border: 0px; color: #0c65a5; cursor: pointer; margin: 0px; padding: 0px; text-decoration: none;">tutorial here</a>).</div>
<div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
If you're using an IDE like Eclipse or Netbeans, then you can add it to the classpath by adding the JAR file as Library to the Build Path in project's properties.</div>
<div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
If you're doing it "plain vanilla" in the command console, then you need to specify the path to the JAR file in the <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">-cp</code> or <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">-classpath</code> argument when executing your Java application.</div>
<pre style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;">java -cp .;/path/to/mysql-connector.jar com.example.YourClass</pre>
<div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
The <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">.</code> is just there to add the current directory to the classpath as well so that it can locate <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">com.example.YourClass</code> and the <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">;</code> is the classpath separator as it is in Windows. In Unix and clones <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">:</code> should be used.</div>
</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;"><div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
Create a <a href="http://dev.mysql.com/doc/refman/5.7/en/create-database.html" style="border: 0px; color: #0c65a5; cursor: pointer; margin: 0px; padding: 0px; text-decoration: none;">database</a> in MySQL. Let's create a database <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">javabase</code>. You of course want World Domination, so let's use UTF-8 as well.</div>
<pre class="default prettyprint prettyprinted" style="background-color: #eeeeee; border: 0px; color: #393318; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; margin: 0px; padding: 0px; white-space: inherit;">CREATE DATABASE javabase DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;</code></pre>
</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;"><div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
<a href="http://dev.mysql.com/doc/refman/5.7/en/adding-users.html" style="border: 0px; color: #0c65a5; cursor: pointer; margin: 0px; padding: 0px; text-decoration: none;">Create an user</a> for Java and <a href="http://dev.mysql.com/doc/refman/5.7/en/grant.html" style="border: 0px; color: #0c65a5; cursor: pointer; margin: 0px; padding: 0px; text-decoration: none;">grant</a> it access. Simply because using <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">root</code> is a bad practice.</div>
<pre class="default prettyprint prettyprinted" style="background-color: #eeeeee; border: 0px; color: #393318; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; margin: 0px; padding: 0px; white-space: inherit;">CREATE USER 'java'@'localhost' IDENTIFIED BY 'password';
GRANT ALL ON javabase.* TO 'java'@'localhost' IDENTIFIED BY 'password';</code></pre>
<div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
Yes, <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">java</code> is the username and <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">password</code> is the password here.</div>
</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;"><div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
<a href="http://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html" style="border: 0px; color: #0c65a5; cursor: pointer; margin: 0px; padding: 0px; text-decoration: none;">Determine</a> the JDBC URL. To connect the MySQL database using Java you need an JDBC URL in the following syntax:</div>
<pre style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;">jdbc:mysql://hostname:port/databasename</pre>
<ul style="border: 0px; list-style: disc; margin: 0px 0px 0px 30px; padding: 0px;">
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;"><div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
<code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">hostname</code>: The hostname where MySQL server is installed. If it's installed at the same machine where you run the Java code, then you can just use <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">localhost</code>. It can also be an IP address like <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">127.0.0.1</code>. If you encounter connectivity problems and using <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">127.0.0.1</code>instead of <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">localhost</code> solved it, then you've a problem in your network/DNS/hosts config.</div>
</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;"><div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
<code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">port</code>: The TCP/IP port where MySQL server listens on. This is by default <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">3306</code>.</div>
</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;"><div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
<code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">databasename</code>: The name of the database you'd like to connect to. That's <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">javabase</code>.</div>
</li>
</ul>
<div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
So the final URL should look like:</div>
<pre style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;">jdbc:mysql://localhost:3306/javabase</pre>
</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;"><div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
<a href="http://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-basic.html" style="border: 0px; color: #0c65a5; cursor: pointer; margin: 0px; padding: 0px; text-decoration: none;">Test the connection</a> to MySQL using Java. Create a simple Java class with a <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">main()</code> method to test the connection.</div>
<pre class="default prettyprint prettyprinted" style="background-color: #eeeeee; border: 0px; color: #393318; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; margin: 0px; padding: 0px; white-space: inherit;">String url = "jdbc:mysql://localhost:3306/javabase";
String username = "java";
String password = "password"

System.out.println("Connecting database...");

try {
 Class.forName("com.mysql.jdbc.Driver");
 System.out.println("Driver loaded!");
} catch (ClassNotFoundException e) {
 throw new IllegalStateException("Cannot find the driver in the classpath!", e);
}</code></pre>
<div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
Note that the <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">newInstance()</code> call is not needed here. It's just to fix the old and buggy <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">org.gjt.mm.mysql.Driver</code>. <a href="http://stackoverflow.com/questions/2092659/what-is-difference-between-class-forname-and-class-forname-newinstance/2093236#2093236" style="border: 0px; color: #0c65a5; cursor: pointer; margin: 0px; padding: 0px; text-decoration: none;">Explanation here</a>. If this line throws <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">ClassNotFoundException</code>, then the JAR file containing the JDBC driver class is simply not been placed in the classpath.</div>
<div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
Note that you don't need to load the driver everytime before connecting. Just only once during application startup is enough.</div>
<div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
If you get a <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">SQLException: Connection refused</code> or <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">Connection timed out</code> or a MySQL specific <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">CommunicationsException: 
Communications link failure</code>, then it means that the DB isn't reachable at all. This can have one or more of the following causes:</div>
<ol style="border: 0px; margin: 0px 0px 0px 30px; padding: 0px;">
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;">IP address or hostname in JDBC URL is wrong.</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;">Hostname in JDBC URL is not recognized by local DNS server.</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;">Port number is missing or wrong in JDBC URL.</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;">DB server is down.</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;">DB server doesn't accept TCP/IP connections.</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;">DB server has run out of connections.</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;">Something in between Java and DB is blocking connections, e.g. a firewall or proxy. </li>
</ol>
<div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
To solve the one or the other, follow the following advices:</div>
<ol style="border: 0px; margin: 0px 0px 0px 30px; padding: 0px;">
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;">Verify and test them with <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">ping</code>.</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;">Refresh DNS or use IP address in JDBC URL instead.</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;">Verify it based on <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">my.cnf</code> of MySQL DB.</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;">Start the DB.</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;">Verify if mysqld is started without the <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">--skip-networking option</code>.</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;">Restart the DB and fix your code accordingly that it closes connections in <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">finally</code>.</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;">Disable firewall and/or configure firewall/proxy to allow/forward the port. </li>
</ol>
<div style="border: 0px; clear: both; margin-bottom: 1em; padding: 0px;">
Note that closing the <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">Connection</code> is extremely important. If you don't close connections and keep getting a lot of them in a short time, then the database may run out of connections and your application may break. Always acquire the <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">Connection</code> in a <a href="https://docs.oracle.com/javase/tutorial/essential/exceptions/tryResourceClose.html" style="border: 0px; color: #0c65a5; cursor: pointer; margin: 0px; padding: 0px; text-decoration: none;"><code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">try-with-resources</code> statement</a>. Or if you're not on Java 7 yet, explicitly close it in <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">finally</code> of a <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">try-finally</code> block. Closing in <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">finally</code> is just to ensure that it get closed as well in case of an exception. This also applies to <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">Statement</code>, <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">PreparedStatement</code> and <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">ResultSet</code>.</div>
</li>
</ol>
<div>
 </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgjbl7NRKBlTRCEmdGuKLygVzJ8uH4HpBUHL4kURhTk4m6VwA4tO8t3J21Q0SxNVRIdqGh8Zfq7qrSqMx2TPvXZ_oEph9Z0LNjJs7IBuOsDG1PMReUHw_aT35SjSLLlD8s2IWQ3VuXEQKN/s1600/DB2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgjbl7NRKBlTRCEmdGuKLygVzJ8uH4HpBUHL4kURhTk4m6VwA4tO8t3J21Q0SxNVRIdqGh8Zfq7qrSqMx2TPvXZ_oEph9Z0LNjJs7IBuOsDG1PMReUHw_aT35SjSLLlD8s2IWQ3VuXEQKN/s1600/DB2.png" /></a></div>
<div>
 </div>
</div>

Here's a step by step explanation how to install MySQL and JDBC and how to use it

Download and install the MySQL server . Just do it the usual way. Remember the port number whenever you've changed it. It's by d...

+ Read more »

How to append content to file in Java

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 16px; line-height: 22.8571px; margin-bottom: 10px;">
FileWritter, a character stream to write characters to file. By default, it will replace all the existing content with new content, however, when you specified a true (boolean) value as the second argument in FileWritter constructor, it will keep the existing content and append the new content in the end of the file.</div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 16px; line-height: 22.8571px; margin-bottom: 10px;">
1. Replace all existing content with new content.</div>
<pre class=" language-java" style="background: rgb(247, 247, 249); border-radius: 0px 0px 4px 4px; border: 1px solid rgb(209, 209, 232); box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: 13px; line-height: 1.5; margin-bottom: 20px; overflow: auto; padding: 1em; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-wrap: normal;"><code class=" language-java" style="background-color: transparent; border-radius: 0px; box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: inherit; line-height: 1.5; padding: 0px; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-spacing: normal;">new FileWriter(file);
</code></pre>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 16px; line-height: 22.8571px; margin-bottom: 10px;">
2. Keep the existing content and append the new content in the end of the file.</div>
<pre class=" language-java" style="background: rgb(247, 247, 249); border-radius: 0px 0px 4px 4px; border: 1px solid rgb(209, 209, 232); box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: 13px; line-height: 1.5; margin-bottom: 20px; overflow: auto; padding: 1em; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-wrap: normal;"><code class=" language-java" style="background-color: transparent; border-radius: 0px; box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: inherit; line-height: 1.5; padding: 0px; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-spacing: normal;">new FileWriter(file,true);
</code></pre>
<h2 style="background-color: white; box-sizing: border-box; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 24px; font-weight: 500; line-height: 1.1; margin-bottom: 10px; margin-top: 40px;">
Append file example</h2>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 16px; line-height: 22.8571px; margin-bottom: 10px;">
A text file named “javaio-appendfile.txt” and contains the following content.</div>
<pre class=" language-bash" style="background: rgb(247, 247, 249); border-radius: 0px 0px 4px 4px; border: 1px solid rgb(209, 209, 232); box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: 13px; line-height: 1.5; margin-bottom: 20px; overflow: auto; padding: 1em; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-wrap: normal;"><code class=" language-bash" style="background-color: transparent; border-radius: 0px; box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: inherit; line-height: 1.5; padding: 0px; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-spacing: normal;">ABC Hello
</code></pre>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 16px; line-height: 22.8571px; margin-bottom: 10px;">
Append new content with new FileWriter(file,true)</div>
<pre class=" language-java" style="background: rgb(247, 247, 249); border-radius: 0px 0px 4px 4px; border: 1px solid rgb(209, 209, 232); box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: 13px; line-height: 1.5; margin-bottom: 20px; overflow: auto; padding: 1em; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-wrap: normal;"><code class=" language-java" style="background-color: transparent; border-radius: 0px; box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: inherit; line-height: 1.5; padding: 0px; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-spacing: normal;">package com.example.file;

import java.io.File;
import java.io.FileWriter;
import java.io.BufferedWriter;
import java.io.IOException;

public class AppendToFileExample 
{
 public static void main( String[] args )
 { 
 try{
 String data = " This content will append to the end of the file";
 
 File file =new File("javaio-appendfile.txt");
 
 //if file doesnt exists, then create it
 if(!file.exists()){
 file.createNewFile();
 }
 
 //true = append file
 FileWriter fileWritter = new FileWriter(file.getName(),true);
 BufferedWriter bufferWritter = new BufferedWriter(fileWritter);
 bufferWritter.write(data);
 bufferWritter.close();
 
 System.out.println("Done");
 
 }catch(IOException e){
 e.printStackTrace();
 }
 }
}</code></pre>
<pre class=" language-java" style="background: rgb(247, 247, 249); border-radius: 0px 0px 4px 4px; border: 1px solid rgb(209, 209, 232); box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: 13px; line-height: 1.5; margin-bottom: 20px; overflow: auto; padding: 1em; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-wrap: normal;"><code class=" language-java" style="background-color: transparent; border-radius: 0px; box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: inherit; line-height: 1.5; padding: 0px; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-spacing: normal;">
</code></pre>
<pre class=" language-java" style="background: rgb(247, 247, 249); border-radius: 0px 0px 4px 4px; border: 1px solid rgb(209, 209, 232); box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: 13px; line-height: 1.5; margin-bottom: 20px; overflow: auto; padding: 1em; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-wrap: normal;"> <div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgceRErJdol2xQVeqJD0FumVQrHbWW4qX3gnxfFyfpSJ_n8Iz5lbo85P5n4PJThTNSQVkNiL9PZMF6npXdbLNa0Too1kDvpDBWXqryPIzq9nEnzs5ps_ePOWAEyVlNxoFF3fDR7yyp5I3vg/s1600/java.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgceRErJdol2xQVeqJD0FumVQrHbWW4qX3gnxfFyfpSJ_n8Iz5lbo85P5n4PJThTNSQVkNiL9PZMF6npXdbLNa0Too1kDvpDBWXqryPIzq9nEnzs5ps_ePOWAEyVlNxoFF3fDR7yyp5I3vg/s1600/java.jpg" /></a></div>
</pre>
</div>

How to append content to file in Java

FileWritter , a character stream to write characters to file. By default, it will replace all the existing content with new content, howev...

+ Read more »

How to write to file in Java – BufferedWriter

<div dir="ltr" style="text-align: left;" trbidi="on">
In Java, <code style="background-color: #f9f2f4; border-radius: 4px; box-sizing: border-box; color: #c7254e; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14.4px; padding: 2px 4px;">BufferedWriter</code> is a character streams class to handle the character data. Unlike bytes stream (convert data into bytes), you can just write the strings, arrays or characters data directly to file. 
 
 
<pre class=" language-java" style="background: rgb(247, 247, 249); border-radius: 0px 0px 4px 4px; border: 1px solid rgb(209, 209, 232); box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: 13px; line-height: 1.5; margin-bottom: 20px; overflow: auto; padding: 1em; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-wrap: normal;"><code class=" language-java" style="background-color: transparent; border-radius: 0px; box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: inherit; line-height: 1.5; padding: 0px; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-spacing: normal;">package com.example;

import java.io.BufferedWriter;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;

String content = "This is the content to write into file";

// if file doesnt exists, then create it
 if (!file.exists()) {
 file.createNewFile();
 }

FileWriter fw = new FileWriter(file.getAbsoluteFile());
 BufferedWriter bw = new BufferedWriter(fw);
 bw.write(content);
 bw.close();

System.out.println("Done");

} catch (IOException e) {
 e.printStackTrace();
 }
 }
}</code></pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjB8fI6UcLYGKsE29v16Tp4WhUbBv1u6hlCBD4GaAhvjPv0Vyl-CQONdHb6D29RK7GF30MMUN94f9NyDSX8Ipv3X-gTZkyYUygEd8xdl236BAs2vEzUsBXyar8Ka36Z6ZZ7O0Q_VySpdc6o/s1600/file.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjB8fI6UcLYGKsE29v16Tp4WhUbBv1u6hlCBD4GaAhvjPv0Vyl-CQONdHb6D29RK7GF30MMUN94f9NyDSX8Ipv3X-gTZkyYUygEd8xdl236BAs2vEzUsBXyar8Ka36Z6ZZ7O0Q_VySpdc6o/s1600/file.jpg" /></a></div>
<pre class=" language-java" style="background: rgb(247, 247, 249); border-radius: 0px 0px 4px 4px; border: 1px solid rgb(209, 209, 232); box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: 13px; line-height: 1.5; margin-bottom: 20px; overflow: auto; padding: 1em; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-wrap: normal;"><code class=" language-java" style="background-color: transparent; border-radius: 0px; box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: inherit; line-height: 1.5; padding: 0px; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-spacing: normal;">
</code></pre>
</div>

How to write to file in Java – BufferedWriter

In Java, BufferedWriter is a character streams class to handle the character data. Unlike bytes stream (convert data into bytes), you can...

+ Read more »

How to write to file in Java – FileOutputStream

<div dir="ltr" style="text-align: left;" trbidi="on">
In Java, <a href="http://docs.oracle.com/javase/1.4.2/docs/api/java/io/FileOutputStream.html" style="background-color: white; box-sizing: border-box; color: #337ab7; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 16px; line-height: 22.8571px; text-decoration: none;" target="_blank">FileOutputStream</a> is a bytes stream class that’s used to handle raw binary data. To write the data to file, you have to convert the data into bytes and save it to file. See below full example. 
 
Example: 
package com.example.io; 
 
import java.io.File; 
import java.io.FileOutputStream; 
import java.io.IOException; 
 
public class WriteFileExample { 
 public static void main(String[] args) { 
 
 FileOutputStream fop = null; 
 File file; 
 String content = "This is the text content"; 
 
 try { 
 
 file = new File("c:/newfile.txt"); 
 fop = new FileOutputStream(file); 
 
 // if file doesnt exists, then create it 
 if (!file.exists()) { 
 file.createNewFile(); 
 } 
 
 // get the content in bytes 
 byte[] contentInBytes = content.getBytes(); 
 
 fop.write(contentInBytes); 
 fop.flush(); 
 fop.close(); 
 
 System.out.println("Done"); 
 
 } catch (IOException e) { 
 e.printStackTrace(); 
 } finally { 
 try { 
 if (fop != null) { 
 fop.close(); 
 } 
 } catch (IOException e) { 
 e.printStackTrace(); 
 } 
 } 
 } 
 
} 
 
An updated JDK7 example, using new “try resource close” method to handle file easily. 
 
 
<pre class=" language-java" style="background: rgb(247, 247, 249); border-radius: 0px 0px 4px 4px; border: 1px solid rgb(209, 209, 232); box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: 13px; line-height: 1.5; margin-bottom: 20px; overflow: auto; padding: 1em; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-wrap: normal;"><code class=" language-java" style="background-color: transparent; border-radius: 0px; box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: inherit; line-height: 1.5; padding: 0px; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-spacing: normal;">package com.example.io;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;

File file = new File("c:/newfile.txt");
 String content = "This is the text content";

try (FileOutputStream fop = new FileOutputStream(file)) {

// if file doesn't exists, then create it
 if (!file.exists()) {
 file.createNewFile();
 }

// get the content in bytes
 byte[] contentInBytes = content.getBytes();

fop.write(contentInBytes);
 fop.flush();
 fop.close();

} catch (IOException e) {
 e.printStackTrace();
 }
 }
}</code></pre>
<pre class=" language-java" style="background: rgb(247, 247, 249); border-radius: 0px 0px 4px 4px; border: 1px solid rgb(209, 209, 232); box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: 13px; line-height: 1.5; margin-bottom: 20px; overflow: auto; padding: 1em; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-wrap: normal;"><code class=" language-java" style="background-color: transparent; border-radius: 0px; box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: inherit; line-height: 1.5; padding: 0px; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-spacing: normal;">
</code></pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjB8fI6UcLYGKsE29v16Tp4WhUbBv1u6hlCBD4GaAhvjPv0Vyl-CQONdHb6D29RK7GF30MMUN94f9NyDSX8Ipv3X-gTZkyYUygEd8xdl236BAs2vEzUsBXyar8Ka36Z6ZZ7O0Q_VySpdc6o/s1600/file.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjB8fI6UcLYGKsE29v16Tp4WhUbBv1u6hlCBD4GaAhvjPv0Vyl-CQONdHb6D29RK7GF30MMUN94f9NyDSX8Ipv3X-gTZkyYUygEd8xdl236BAs2vEzUsBXyar8Ka36Z6ZZ7O0Q_VySpdc6o/s1600/file.jpg" /></a></div>
<pre class=" language-java" style="background: rgb(247, 247, 249); border-radius: 0px 0px 4px 4px; border: 1px solid rgb(209, 209, 232); box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: 13px; line-height: 1.5; margin-bottom: 20px; overflow: auto; padding: 1em; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-wrap: normal;"><code class=" language-java" style="background-color: transparent; border-radius: 0px; box-sizing: border-box; direction: ltr; font-family: Consolas, Monaco, 'Andale Mono', 'Ubuntu Mono', monospace; font-size: inherit; line-height: 1.5; padding: 0px; tab-size: 4; text-shadow: white 0px 1px; word-break: normal; word-spacing: normal;">
</code></pre>
 </div>

How to write to file in Java – FileOutputStream

In Java, FileOutputStream is a bytes stream class that’s used to handle raw binary data. To write the data to file, you have to convert t...

+ Read more »

How to read file in Java – BufferedReader

<div dir="ltr" style="text-align: left;" trbidi="on">
In Java, there are many ways to read a file, here we show you how to use the simplest and most common-used method –BufferedReader 
 
Example: 
package com.example.io; 
 
import java.io.BufferedReader; 
import java.io.FileReader; 
import java.io.IOException; 
 
public class BufferedReaderExample { 
 
 public static void main(String[] args) { 
 
 BufferedReader br = null; 
 
 try { 
 
 String sCurrentLine; 
 
 br = new BufferedReader(new FileReader("C:\\testing.txt")); 
 
 while ((sCurrentLine = br.readLine()) != null) { 
 System.out.println(sCurrentLine); 
 } 
 
 } catch (IOException e) { 
 e.printStackTrace(); 
 } finally { 
 try { 
 if (br != null)br.close(); 
 } catch (IOException ex) { 
 ex.printStackTrace(); 
 } 
 } 
 
 } 
} 
 
.See updated example in JDK 7, which use <code style="background-color: #f9f2f4; border-radius: 4px; box-sizing: border-box; color: #c7254e; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14.4px; padding: 2px 4px;">try-with-resources</code> new feature to close file automatically. 
 
package com.example.io; 
 
import java.io.BufferedReader; 
import java.io.FileReader; 
import java.io.IOException; 
 
public class BufferedReaderExample { 
 
 public static void main(String[] args) { 
 
 try (BufferedReader br = new BufferedReader(new FileReader("C:\\testing.txt"))) 
 { 
 
 String sCurrentLine; 
 
 while ((sCurrentLine = br.readLine()) != null) { 
 System.out.println(sCurrentLine); 
 } 
 
 } catch (IOException e) { 
 e.printStackTrace(); 
 }  
 
 } 
 
} 
 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgceRErJdol2xQVeqJD0FumVQrHbWW4qX3gnxfFyfpSJ_n8Iz5lbo85P5n4PJThTNSQVkNiL9PZMF6npXdbLNa0Too1kDvpDBWXqryPIzq9nEnzs5ps_ePOWAEyVlNxoFF3fDR7yyp5I3vg/s1600/java.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgceRErJdol2xQVeqJD0FumVQrHbWW4qX3gnxfFyfpSJ_n8Iz5lbo85P5n4PJThTNSQVkNiL9PZMF6npXdbLNa0Too1kDvpDBWXqryPIzq9nEnzs5ps_ePOWAEyVlNxoFF3fDR7yyp5I3vg/s1600/java.jpg" /></a></div>
 </div>

How to read file in Java – BufferedReader

In Java, there are many ways to read a file, here we show you how to use the simplest and most common-used method – BufferedReader Exampl...

+ Read more »

Subscribe to: Posts ( Atom )