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