mariadbmysqljdbc驱动_Java：jdbc连接数据库MariaDB/Mysql

这里是用的Mysql的分支版本MariaDB&＃xff0c;除了安装的包不同外&＃xff0c;操作基本相同。

本人用的是Archlinux&＃xff0c;也只是安装软件的方式不同。

一、MariaDB

安装MariaDB(参见ArchWiki)

&＃43; [安装](https://wiki.archlinux.org/index.php/Pacman)位于[官方软件源](https://wiki.archlinux.org/index.php/Official_repositories)的[mariadb](https://www.archlinux.org/packages/?name&＃61;mariadb)、[libmariadbclient](https://www.archlinux.org/packages/?name&＃61;libmariadbclient) 和 [mariadb-clients](https://www.archlinux.org/packages/?name&＃61;mariadb-clients)

&＃43; 运行&＃xff1a;

# mysql_install_db --user&＃61;mysql --basedir&＃61;/usr --datadir&＃61;/var/lib/mysql

&＃43; 启动 mysqld[守护进程](https://wiki.archlinux.org/index.php/Daemon)&＃xff0c;运行安装脚本&＃xff0c;然后重新启动守护进程&＃xff1a;(按提示设置MariaDB用户名和密码)

# systemctl start mysqld

# mysql_secure_installation

# systemctl restart mysqld

启动、登录&＃xff0c;建立数据库

启动&＃xff1a;

# systemctl start mysqld

登录&＃xff1a;(这里是用的root用户&＃xff0c;可以把root换为自己的用户名)

$ mysql -p -u root

创建测试用的数据库(登录后)

MariaDB [(none)]> create database test;

二、eclipse建立测试项目

用户名和密码设为自己的。

package test;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.util.Properties;

public class MariaDB {

// The JDBC Connector Class.

private static final String dbClassName &＃61; "org.mariadb.jdbc.Driver";

// Connection string. emotherearth is the database the program

// is connecting to. You can include user and password after this

// by adding (say) ?user&＃61;paulr&password&＃61;paulr. Not recommended!

private static final String CONNECTION &＃61;

"jdbc:mariadb://localhost:3306/emotherearth";

public static void main(String[] args) throws

ClassNotFoundException,SQLException

{

System.out.println(dbClassName);

// Class.forName(xxx) loads the jdbc classes and

// creates a drivermanager class factory

Class.forName(dbClassName);

// Properties for user and password. Here the user and password are both &＃39;paulr&＃39;

Properties p &＃61; new Properties();

p.put("user","root");

p.put("password","123456");

// Now try to connect

Connection c &＃61; DriverManager.getConnection(CONNECTION,p);

System.out.println("It works !");

c.close();

}

}

二、jdbc连接器

方法一&＃xff1a;

直接把jar包导入到项目中&＃xff0c;或导入到系统java库中

右击“项目”→选择Properties&＃xff0c;在弹出的对话框左侧列表中选择Java Build Path&＃xff0c;如下图所示&＃xff1a;选择Add External JARs。

eclipse导入包

$ yaourt mariadb-jdbc

要确保项目里有了Mariadb-Java-Client.jar

三、运行测试

此时运行测试程序,得到&＃xff1a;

org.mariadb.jdbc.Driver

It works !