Koneksi MySQL Groovy

package com.database

import java.sql.DriverManager
import java.sql.ResultSet

import com.kms.katalon.core.annotation.Keyword
import com.mysql.jdbc.Connection
import com.mysql.jdbc.Statement

public class mysql {
private static Connection connection = null;
/**
* Open and return a connection to database
* @param dataFile absolute file path
* @return an instance of java.sql.Connection
*/
//Establishing a connection to the DataBase
@Keyword
def connectDB(String url, String port, String dbname,  String username, String password) {
//Load driver class for your specific database type
String conn = "jdbc:mysql://" + url + ":" + port + "/" + dbname
//Class.forName("org.sqlite.JDBC")
//String connectionString = "jdbc:sqlite:" + dataFile
if (connection != null && !connection.isClosed()) {
connection.close()
}
connection = DriverManager.getConnection(conn, username, password)
return connection
}
/**
* execute a SQL query on database
* @param queryString SQL query string
* @return a reference to returned data collection, an instance of java.sql.ResultSet
*/
//Executing the constructed Query and Saving results in resultset
@Keyword
def executeQuery(String queryString) {
Statement stm = connection.createStatement()
ResultSet rs = stm.executeQuery(queryString)
return rs
}
//Closing the connection
@Keyword
def closeDatabaseConnection() {
if (connection != null && !connection.isClosed()) {
connection.close()
}
connection = null
}
/**
* Execute non-query (usually INSERT/UPDATE/DELETE/COUNT/SUM...) on database
* @param queryString a SQL statement
* @return single value result of SQL statement
*/
@Keyword
def execute(String queryString) {
Statement stm = connection.createStatement()
boolean result = stm.execute(queryString)
return result
}
}

Koneksi MySQL Groovy


Baca Juga
OVO KakTheo
DONASI VIA OVO Bantu berikan donasi jika artikelnya dirasa bermanfaat. Donasi akan digunakan untuk memperpanjang domain kaktheo.net.

Anda dapat menghubungi saya melalui form kontak kami yang telah disediakan atau dapat menghubungi saya melalui tautan ini. https://bit.ly/kontakkaktheo.

Artikel Terkait

Post a Comment

Subscribe Our Newsletter