JDBCUtils.java

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 (?, ?);";
    }





}