Connect to MySQL with JDBC

JDBCService

// load the MySQL driver. Alternatively, use the Maven http://mvnrepository.com/artifact/mysql/mysql-connector-java/5.1.33
Class.forName("com.mysql.jdbc.Driver");

// connect to database named openstack_projects on port 3306
String url = "jdbc:mysql://localhost:3306/openstack_projects";
Connection conn = DriverManager.getConnection(url, "root", "");

// make a query
String sql = "select * from projects";
PreparedStatement preparedStatement = conn.prepareStatement(sql);
ResultSet results = preparedStatement.executeQuery();

// do something with the results