如何将 mysql 与 Basex 连接? [英] How to connect mysql with Basex?

问题描述

我有一个使用 Mysql 作为数据库的应用程序，它使用了很多 XML/HTML.我想在 BaseX 中处理 mysql 数据并通过它更新数据库.有没有简单的方法连接数据库?我检查了 http://docs.basex.org/wiki/SQL 但它不起作用.你能给我一个简单的例子，我必须做什么才能连接?我收到错误 发生 SQL 异常:'找不到适用于 jdbc:mysql://localhost:3306/test' 的驱动程序这是我的代码:

I have a application with Mysql as Database which is using a lot XML/HTML. I would like to process mysql data in BaseX and update database through it. Is there any simple way to connect Database? I checked http://docs.basex.org/wiki/SQL but it is not working. Can you please give me simple example what I have to do to connect? I got error An SQL exception occurred: 'No suitable driver found for jdbc:mysql://localhost:3306/test' here is my code:

let $conn := sql:connect("jdbc:mysql://localhost:3306/test")
return sql:execute($conn, "SELECT * FROM coffees WHERE price < 10")

我应该将 mysql jdbc 连接器 (mysql-connector-java-5.1.34-bin.jar) 放在 basex 的什么位置以使其工作?谢谢

Where should I put mysql jdbc connector (mysql-connector-java-5.1.34-bin.jar) in basex to make it work? Thanks

推荐答案

首先下载最新版本的mysql jdbc驱动.这是5.1.36，里面有.jar文件，解压jar文件放到BaseX安装文件夹的lib目录下.在 Windows 中它是

First download latest version of mysql jdbc driver. Here is 5.1.36, inside this, there is .jar file, extract jar file and put in BaseX installation folder's lib directory. In windows it is

C:\Program Files (x86)\BaseX\lib

重新启动服务器或 GUI.对于 GUI，您应该关闭所有内容，最好从 bin 目录的 basexgui

Restart the server or GUI. for GUI you should close everything, better to open from bin directory's basexgui

sql:init("com.mysql.jdbc.Driver"),
let $con := sql:connect('jdbc:mysql://localhost:3306/DB_NAME', 'DB_USER', 'DB_PASSWORD')
return sql:execute($con, "select version()")

详细查询BaseX 文档

这篇关于如何将 mysql 与 Basex 连接?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！