Connect to Mariadb and mariadb remotely

Connect to Mariadb and mariadb remotely

// This article describes how to connect to the Mariadb database on centos7.

// There is no difference with mysql

Package test. java. mysql; import java. SQL. connection; import java. SQL. driverManager; import java. SQL. SQLException; import java. SQL. statement; public class TestMysql {public static void main (String [] args) {Connection cc = null; String SQL = null; Statement stmt = null; try {Class. forName ("com. mysql. jdbc. driver "); try {cc = DriverManager. getConnection ("jdbc: mysql: // 192.168.14.101/one", "person", "123456"); // IP address Enter your own SQL = "insert into student (id, name) values (1234567, 'Li si ')"; // code for remotely connecting to the mysql database // at the beginning of this error, the port number 3306 is added, and the System is not required during remote connection. out. println ("connection successful"); stmt = cc.createstatement(;;stmt.exe cute (SQL); System. out. println ("inserted successfully");} catch (SQLException e) {e. printStackTrace () ;}} catch (ClassNotFoundException e) {e. printStackTrace ();} finally {if (cc! = Null) {try {cc. close () ;}catch (SQLException e) {e. printStackTrace ();}}}}}

In addition, mysql and mysql use the same jar package as jdbc provided by the mysql official website.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.