Techalert

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQdqG_6rcBc0hvK-NlGc9Y8PS88L1jV6hw9BleEx7eV-0ph875P5QS8D65bHNraU1uPnUlMBp3Mwz0wzrwDDdmTsc-7vzBMaqMG7XIGRwcW1krLHDHmXh5wF2eiYdH1tttwUKtZslEH_s/s1600/java.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQdqG_6rcBc0hvK-NlGc9Y8PS88L1jV6hw9BleEx7eV-0ph875P5QS8D65bHNraU1uPnUlMBp3Mwz0wzrwDDdmTsc-7vzBMaqMG7XIGRwcW1krLHDHmXh5wF2eiYdH1tttwUKtZslEH_s/s1600/java.jpg" width="319" /></a></div>
I have played around with database connectivity with Java for MySQL, Oracle and SQLite. I thought I would share some simple connection setup code with the world.</div>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
You will need to download and add the appropriate JARs to your project and or your class path, as well as having a database to connect to, unless you are using SQLite in which case the database is local.</div>
<h3 style="background-color: white; border: 0px; clear: both; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 1.142857143rem; line-height: 1.846153846; margin: 1.714285714rem 0px; padding: 0px; text-align: center; vertical-align: baseline;">
MySQL</h3>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
First up is MySQL connectivity. This first snippet will check you have loaded the JDBC driver correctly.</div>
<pre class="wp-code-highlight prettyprint prettyprinted" style="background-color: white; border: 1px solid rgb(204, 204, 204); color: #666666; font-family: Consolas, Monaco, 'Lucida Console', monospace; font-size: 12px; line-height: 16px; margin-bottom: 6px; margin-top: 6px; overflow: auto; padding: 2px 7px; vertical-align: baseline; width: 591.421875px; word-wrap: normal;">import java.sql.*;
public class MySqlLoadDriver {
 public static void main(String [] args) {
 Connection con = null;
 try {

// Load the MySQL JDBC driver
 Class.forName("com.mysql.jdbc.Driver") ;
 System.out.println("MySQL JDBC driver loaded ok.");

} catch (Exception e) {
 System.err.println("Exception: "+e.getMessage());
 }
 }
}</pre>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
The following snippet will set up a connection to the database. Where the host in the example is set to localhost so you may change this to point to your database address or tunnel in to your database using a client like Putty. Also change username and password to your database username and password.</div>
<pre class="wp-code-highlight prettyprint prettyprinted" style="background-color: white; border: 1px solid rgb(204, 204, 204); color: #666666; font-family: Consolas, Monaco, 'Lucida Console', monospace; font-size: 12px; line-height: 16px; margin-bottom: 6px; margin-top: 6px; overflow: auto; padding: 2px 7px; vertical-align: baseline; width: 591.421875px; word-wrap: normal;">import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class SimpleConnection;
{

static public void main(String args[])
 {

Class.forName("com.mysql.jdbc.Driver") ;
 System.out.println("MySQL JDBC driver loaded ok.");
 con = DriverManager.getConnection(
 "jdbc:mysql://127.0.0.1:3306/","username", "password");
 System.out.println("Connected with host:port/database.");
 con.close();

}</pre>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
 </div>
<h3 style="background-color: white; border: 0px; clear: both; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 1.142857143rem; line-height: 1.846153846; margin: 1.714285714rem 0px; padding: 0px; text-align: center; vertical-align: baseline;">
Oracle</h3>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
Oracle has a two types of connection I have played with Oracle Call Interface and Oracle’s JDBC Thin driver uses Java sockets to connect directly to Oracle. It provides its own TCP/IP version of Oracle’s SQL*Net protocol. Because it is 100% Java, this driver is platform independent and can also run from a Web Browser. Depending on which one you want to use comment out or delete the other line. In the example I am using the OJDBC Thin Driver not the Oracle Call Interface.</div>
<pre class="wp-code-highlight prettyprint prettyprinted" style="background-color: white; border: 1px solid rgb(204, 204, 204); color: #666666; font-family: Consolas, Monaco, 'Lucida Console', monospace; font-size: 12px; line-height: 16px; margin-bottom: 6px; margin-top: 6px; overflow: auto; padding: 2px 7px; vertical-align: baseline; width: 591.421875px; word-wrap: normal;">import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

{
 Connection con = null;

try
 {
 Class.forName ("oracle.jdbc.OracleDriver");
 System.out.println("Oracle JDBC driver loaded ok.");
 con = DriverManager.getConnection(

//"jdbc:oracle:oci7:@//localhost:1521/ORCL","username", "password");
 "jdbc:oracle:thin:@//192.168.104.11:1521/ORCL","username", "password");
 System.out.println("Success!!");
 System.out.println("Connected with host:port/database.");
 con.close();
 }
 catch (Exception e)
 {
 System.err.println("Exception: "+e.getMessage());
 }
 }
}</pre>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
 </div>
<h3 style="background-color: white; border: 0px; clear: both; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 1.142857143rem; line-height: 1.846153846; margin: 1.714285714rem 0px; padding: 0px; text-align: center; vertical-align: baseline;">
SQLite</h3>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
Finally the creation and testing of an SQLite Database, adding in a few things with a simple query.</div>
<pre class="wp-code-highlight prettyprint prettyprinted" style="background-color: white; border: 1px solid rgb(204, 204, 204); color: #666666; font-family: Consolas, Monaco, 'Lucida Console', monospace; font-size: 12px; line-height: 16px; margin-bottom: 6px; margin-top: 6px; overflow: auto; padding: 2px 7px; vertical-align: baseline; width: 591.421875px; word-wrap: normal;">import java.sql.*;

public static void main(String[] args) throws Exception {

Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db");
 Statement stat = conn.createStatement();
 stat.executeUpdate("drop table if exists people;");
 stat.executeUpdate("create table people (name, occupation);");
 PreparedStatement prep = conn.prepareStatement("insert into people values (?, ?);");
 prep.setString(1, "Gandhi");
 prep.setString(2, "politics");
 prep.addBatch();
 prep.setString(1, "Turing");
 prep.setString(2, "computers");
 prep.addBatch();
 prep.setString(1, "Wittgenstein");
 prep.setString(2, "smartypants");
 prep.addBatch();
 conn.setAutoCommit(false);
 prep.executeBatch();
 conn.setAutoCommit(true);
 ResultSet rs = stat.executeQuery("select * from people;");

while (rs.next()) {
 System.out.println("name = " + rs.getString("name"));
 System.out.println("job = " + rs.getString("occupation"));
 }

rs.close();
 conn.close();

Java Database Connectivity – MySQL, Oracle and SQLite

I have played around with database connectivity with Java for MySQL, Oracle and SQLite. I thought I would share some simple connection s...