How to connect a desktop java application and an online mysql database and execute query?


Problem :

I am trying to create an desktop application for shop. I can create create desktop app and database individually but I dont know how to connect them and how to execute query from desktop. May be for executing query I should use php but I dont know how. My database have been created in hosting site using cpanel.



Solution :

You need some kind of APIs on the server side. First learn about RESTful APIs and build your server accordingly. Decide a PHP framework to do this with ease.

Next design your desktop application in JAVA which has

  1. Ability to connect to your APIs ( Give Credentials use OAuth2 or something.)

  2. Store data locally and Sync it whenever Internet Connectivity is available ( Resolve conflicts when syncing )

This will need lots of research and efforts. Happy Coding!


Mysql Tutorials

Mysql Howto..

Mysql how to select max id group by another id where boolean is false

How safe is to set relationships to delete on cascade?

How to implement Temporal Upward Compatibility in MySQL?

How do I connect webapp VB/LINQ to a MySQL database server on a Linux

how to multiple insert and delete using foreach

How to set $variable as a DATE_FORMAT in MySQL

SQL - how to replace a range of datetimes with a single, future datetime?

is there a mysql limit as to how many people can request data from database?

How to increase the MySQL variable count

How to compare two comma-separated string lists using MySQL

How to write the Mysql binary log position of master when doing a mysqldump from slave?

how to get incremental backup for mysql using shellscript

How do I connect to a MySQL Database in Python the right way?

How to get data from mysql database only for this year

How to pull info from a dynamic dropdown of array to post in another table

PHP & MySQL how to display data question

How do I access an object method inside a List?

How to optimise a query containing joins and subqueries

How to extract uuid inserted into a row as a primary key via a trigger

How do I properly structure my relational mySQL database

php/mysql how to change and organize the value of fields after update

How to write JAVA CLASS and PHP API to post and read from an existing MySQL database

PHP: how to resolve a dynamic property of an object that is multiple levels deep

How can I get emacs sql-mode to use the mysql config file (.my.cnf)?

How do I properly iterate through a mysqli_fetch_array (procedural)?

How to get Rank in mysql? [duplicate]

how to import data from text file without any delimiter or separator?

Regexp - How to find capital letters in MySQL only

How to give custom configurations for the mysql my.ini file in a shared database environment

Set WinForm Show Date from MySQL