【问题收录】ubuntu下weka链接mysql数据库

3.由于weka是基于java开发的,在Linux(Ubuntu平台)Java通过JDBC连接MySQL数据库,我们还要进行以后的操作,,步骤如下:

下载jdbc:mysql-connector-java-5.1.18.tar.gz

解压jdbc:tar-zxvfmysql-connector-java-5.1.18.tar.gz

配置jdbc:cpmysql-connector-java-5.1.18-bin.jar /usr/local/jdk1.8.0_25/jre/lib/ext/

这一步很关键不要忘记,否则会出错。

配置

用归档器打开weka.jar\experiment里找到DatabaseUtils.props

# General information on database access can be found here:# ## Version: $Revision: 11144 $# The comma-separated list of jdbc drivers to use#jdbcDriver=RmiJdbc.RJDriver,jdbc.idbDriver#jdbcDriver=jdbc.idbDriver#jdbcDriver=RmiJdbc.RJDriver,jdbc.idbDriver,org.gjt.mm.mysql.Driver,com.mckoi.JDBCDriver,org.hsqldb.jdbcDriver#jdbcDriver=org.gjt.mm.mysql.DriverjdbcDriver=com.mysql.jdbc.Driver# The url to the experiment database#jdbcURL=jdbc:rmi://expserver/jdbc:idb=experiments.prp#jdbcURL=jdbc:idb=experiments.prp#jdbcURL=jdbc:mysql://mysqlserver/usernamejdbcURL=jdbc:mysql://localhost:3306/database_name# the method that is used to retrieve values from the db# (java datatype + RecordSet.<method>)# string, getString() = 0; –> nominal# boolean, getBoolean() = 1; –> nominal# double, getDouble() = 2; –> numeric# byte, getByte() = 3; –> numeric# short, getByte()= 4; –> numeric# int, getInteger() = 5; –> numeric# long, getLong() = 6; –> numeric# float, getFloat() = 7; –> numeric# date, getDate() = 8; –> date# text, getString() = 9; –> string# time, getTime() = 10; –> date# the original conversion: <column type>=<conversion>#char=0#varchar=0#longvarchar=0#binary=0#varbinary=0#longvarbinary=0#bit=1#numeric=2#decimal=2#tinyint=3#smallint=4#integer=5#bigint=6#real=7#float=2#double=2#date=8#time=10#timestamp=8#mysql-conversionCHAR=0TEXT=0VARCHAR=0LONGVARCHAR=9BINARY=0VARBINARY=0LONGVARBINARY=9BIT=1NUMERIC=2DECIMAL=2FLOAT=2DOUBLE=2TINYINT=3SMALLINT=4#SHORT=4SHORT=5INTEGER=5BIGINT=6LONG=6REAL=7DATE=8TIME=10TIMESTAMP=8#mappings for table creationCREATE_STRING=TEXTCREATE_INT=INTCREATE_DOUBLE=DOUBLECREATE_DATE=DATETIMEDateFormat=yyyy-MM-dd HH:mm:ss#database flagscheckUpperCaseNames=falsecheckLowerCaseNames=falsecheckForTable=truesetAutoCommit=truecreateIndex=false# All the reserved keywords for this databaseKeywords=\ AND,\ ASC,\ BY,\ DESC,\ FROM,\ GROUP,\ INSERT,\ ORDER,\ SELECT,\ UPDATE,\ WHERE# The character to append to attribute names to avoid exceptions due to# clashes between keywords and attribute namesKeywordsMaskChar=_#flags for loading and saving instances using DatabaseLoader/SavernominalToStringLimit=50idColumn=auto_generated_id

添加红色的部分.

jdbcURL=jdbc:mysql://localhost:3306/database_name 《==这个部位根据你的需求自己改变。

保存,更新即可。

时间慢慢的流淌,人生有风雨阳光,

【问题收录】ubuntu下weka链接mysql数据库

相关文章:

你感兴趣的文章:

标签云: