http://dev.mysql.com/downloads/connector/j/
At Linux Box:
nano JDBCExample.java
import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException; public class JDBCExample { public static void main(String[] argv) { System.out.println("-------- MySQL JDBC Connection Testing ------------"); try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { System.out.println("Where is your MySQL JDBC Driver?"); e.printStackTrace(); return; } System.out.println("MySQL JDBC Driver Registered!"); Connection connection = null; try { connection = DriverManager .getConnection("jdbc:mysql://192.168.0.64:3306/classicmodels","root", "password"); } catch (SQLException e) { System.out.println("Connection Failed! Check output console"); e.printStackTrace(); return; } if (connection != null) { System.out.println("You made it, take control your database now!"); } else { System.out.println("Failed to make connection!"); } } }
javac -classpath .:mysql-connector-java-5.1.34-bin.jar JDBCExample.java java -classpath .:mysql-connector-java-5.1.34-bin.jar JDBCExample
copy mysql-connector-java-5.1.34-bin.jar and JDBCExample.class into Yun.
root@Arduino:/mnt/sda1# jamvm -classpath .:mysql-connector-java-5.1.34-bin.jar JDBCExample -------- MySQL JDBC Connection Testing ------------ MySQL JDBC Driver Registered! You made it, take control your database now!
Comments powered by CComment