1. create database & access
CREATE DATABASE testdb;
CREATE USER 'luceeuser'@'%' IDENTIFIED BY 'Password123!';
GRANT ALL PRIVILEGES ON testdb.* TO 'luceeuser'@'%';
FLUSH PRIVILEGES;
CREATE TABLE IF NOT EXISTS test_table (
id INT AUTO_INCREMENT PRIMARY KEY,
pesan VARCHAR(255)
);
INSERT INTO test_table (pesan) VALUES ('Halo dari Lucee di CentOS 9!');
SELECT * FROM test_table ORDER BY id DESC LIMIT 5;
2. setup new dsn mariadb
https://github.com/cfsimplicity/lucee-mariadb
download https://codeload.github.com/cfsimplicity/lucee-mariadb/zip/refs/heads/main
3. setup new dsn mysql
4. run test.cfm (using mariadb driver)
http://10.10.10.17:8888/test.cfm
5. run belimaria.cfm (using mariadb driver)
http://10.10.10.17:8888/belimaria.cfm
6. run belimysql.cfm (using mariadb driver)
http://10.10.10.17:8888/belimysql.cfm
7. file cfm test.cfm
[root@teguhth ROOT]# pwd
/data/y/tomcat/webapps/ROOT
[root@teguhth ROOT]#
[root@teguhth ROOT]# cat test.cfm
<cfsetting showdebugoutput="true">
<cftry>
<!--- TEST KONEKSI --->
<cfquery name="testKoneksi" datasource="MariaDBTest">
SELECT NOW() AS waktuServer;
</cfquery>
<cfoutput>
<h2>Koneksi MariaDB via Lucee: BERHASIL</h2>
<p>Waktu Server MariaDB: #testKoneksi["waktuServer"]#</p>
</cfoutput>
<!--- TEST INSERT --->
<cfquery datasource="MariaDBTest">
CREATE TABLE IF NOT EXISTS test_table (
id INT AUTO_INCREMENT PRIMARY KEY,
pesan VARCHAR(255)
);
</cfquery>
<cfquery datasource="MariaDBTest">
INSERT INTO test_table (pesan) VALUES ('Halo dari Lucee di CentOS 9!');
</cfquery>
<!--- TEST SELECT --->
<cfquery name="data" datasource="MariaDBTest">
SELECT * FROM test_table ORDER BY id DESC LIMIT 5;
</cfquery>
<h3>Data Terbaru:</h3>
<cfoutput query="data">
#id#. #pesan#<br>
</cfoutput>
<cfcatch type="any">
<h2 style="color:red;">ERROR</h2>
<cfdump var="#cfcatch#">
</cfcatch>
</cftry>
[root@teguhth ROOT]#
8. file cfm belimaria.cfm
[root@teguhth ROOT]# pwd
/data/y/tomcat/webapps/ROOT
[root@teguhth ROOT]#
[root@teguhth ROOT]# cat belimaria.cfm
<cfsetting showdebugoutput="true">
<cftry>
<!-- Tes koneksi -->
<cfquery name="testKoneksi" datasource="MariaDBTest">
SELECT
NOW() AS waktuServer,
@@hostname AS hostname,
@@version AS version;
</cfquery>
<cfoutput>
<h2>Koneksi MariaDB via Lucee: BERHASIL - Start</h2>
<p>Waktu Server MariaDB: #DateTimeFormat(testKoneksi.waktuServer, "yyyy-MM-dd HH:mm:ss")#</p>
<p>Hostname MariaDB: #testKoneksi.hostname#</p>
<p>Version MariaDB: #testKoneksi.version#</p>
</cfoutput>
<!-- Query pembelian -->
<cfquery name="data" datasource="MariaDBTest">
SELECT
KODE_PEMBELIAN,
KODE_BARANG,
KODE_CUSTOMER,
TANGGAL_PEMBELIAN,
JUMLAH_PEMBELIAN
FROM pembelian;
</cfquery>
<h3>Data Pembelian:</h3>
<table border="1" cellpadding="6" cellspacing="0" style="border-collapse:collapse;">
<tr>
<th>KODE_PEMBELIAN</th>
<th>KODE_BARANG</th>
<th>KODE_CUSTOMER</th>
<th>TANGGAL_PEMBELIAN</th>
<th>JUMLAH_PEMBELIAN</th>
</tr>
<cfoutput query="data">
<tr>
<td>#KODE_PEMBELIAN#</td>
<td>#KODE_BARANG#</td>
<td>#KODE_CUSTOMER#</td>
<td>#DateTimeFormat(data.TANGGAL_PEMBELIAN, "yyyy-mm-dd HH:mm:ss")#</td>
<td>#JUMLAH_PEMBELIAN#</td>
</tr>
</cfoutput>
</table>
<!-- Tes koneksi -->
<cfquery name="testKoneksiend" datasource="MariaDBTest">
SELECT NOW() AS waktuServer;
</cfquery>
<cfoutput>
<h2>Koneksi MariaDB via Lucee: BERHASIL - End </h2>
<p>Waktu Server MariaDB: #DateTimeFormat(testKoneksiend.waktuServer, "yyyy-mm-dd HH:mm:ss")#</p>
</cfoutput>
<!-- Error handler -->
<cfcatch type="any">
<h2 style="color:red;">ERROR</h2>
<cfdump var="#cfcatch#">
</cfcatch>
</cftry>
[root@teguhth ROOT]#
9. file cfm belimysql.cfm
[root@teguhth ROOT]# pwd
/data/y/tomcat/webapps/ROOT
[root@teguhth ROOT]#
[root@teguhth ROOT]# cat belimysql.cfm
<cfsetting showdebugoutput="true">
<cftry>
<!-- Tes koneksi -->
<cfquery name="testKoneksi" datasource="mysqltest">
SELECT NOW() AS waktuServer;
</cfquery>
<cfoutput>
<h2>Koneksi MariaDB via Lucee: BERHASIL - Start</h2>
<p>Waktu Server MariaDB: #DateTimeFormat(testKoneksi.waktuServer, "yyyy-mm-dd HH:mm:ss")#</p>
</cfoutput>
<!-- Query pembelian -->
<cfquery name="data" datasource="mysqltest">
SELECT
KODE_PEMBELIAN,
KODE_BARANG,
KODE_CUSTOMER,
TANGGAL_PEMBELIAN,
JUMLAH_PEMBELIAN
FROM pembelian;
</cfquery>
<h3>Data Pembelian:</h3>
<table border="1" cellpadding="6" cellspacing="0" style="border-collapse:collapse;">
<tr>
<th>KODE_PEMBELIAN</th>
<th>KODE_BARANG</th>
<th>KODE_CUSTOMER</th>
<th>TANGGAL_PEMBELIAN</th>
<th>JUMLAH_PEMBELIAN</th>
</tr>
<cfoutput query="data">
<tr>
<td>#KODE_PEMBELIAN#</td>
<td>#KODE_BARANG#</td>
<td>#KODE_CUSTOMER#</td>
<td>#DateTimeFormat(data.TANGGAL_PEMBELIAN, "yyyy-mm-dd HH:mm:ss")#</td>
<td>#JUMLAH_PEMBELIAN#</td>
</tr>
</cfoutput>
</table>
<!-- Tes koneksi -->
<cfquery name="testKoneksiend" datasource="mysqltest">
SELECT NOW() AS waktuServer;
</cfquery>
<cfoutput>
<h2>Koneksi MariaDB via Lucee: BERHASIL - End </h2>
<p>Waktu Server MariaDB: #DateTimeFormat(testKoneksiend.waktuServer, "yyyy-mm-dd HH:mm:ss")#</p>
</cfoutput>
<!-- Error handler -->
<cfcatch type="any">
<h2 style="color:red;">ERROR</h2>
<cfdump var="#cfcatch#">
</cfcatch>
</cftry>
[root@teguhth ROOT]#
No comments:
Post a Comment