package org.wso2.carbon.business.messaging.hl7.store; import org.apache.axiom.om.OMElement; import org.apache.synapse.MessageContext; public class JDBCUtils { public static String getTableExistsQuery(String tableName) { return "SHOW TABLES LIKE '" + tableName + "';"; } public static String getCreateTableQuery(String tableName) { return "CREATE TABLE "+tableName+" (id INT AUTO_INCREMENT, messageId VARCHAR(50), message TEXT, timestamp TIMESTAMP, PRIMARY KEY (id));"; } public static String setMessage(String tableName, String messageId, String message) { return "INSERT INTO "+tableName+" (messageId, message) " + "VALUES (?, ?);"; } }