Mysql.java

package com.statusParser;

import java.sql.*;
import java.util.Properties;

public class Mysql {
    private static final String CHARSET = "UTF-8";
    private static String serverName = "localhost";
    private static String portNumber = "3306";
    private static String userName = "root";
    private static String password = "";
    private static String database = "StatusParser";

    public static void setServerName(String serverNameNew) {
        Mysql.serverName = serverNameNew;
    }

    public static void setPortNumber(String portNumberNew) {
        Mysql.portNumber = portNumberNew;
    }

    public static void setUserName(String userNameNew) {
        Mysql.userName = userNameNew;
    }

    public static void setPassword(String passwordNew) {
        Mysql.password = passwordNew;
    }

    public static void setDatabase(String databaseNew) {
        Mysql.database = databaseNew;
    }


    private Connection conn = getConnection();

    private Connection getConnection() {
        Connection conn = null;
        Properties connectionProps = new Properties();
        connectionProps.put("user", this.userName);
        connectionProps.put("password", this.password);
        try {
            conn = DriverManager.getConnection("jdbc:mysql://" + this.serverName + ":" + this.portNumber + "/" + this.database + "?characterEncoding=" + this.CHARSET, connectionProps);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        System.out.println(conn);
        return conn;
    }

    public void sentData(int postId, String text, String img, int likes) {
        try {
            PreparedStatement pst = conn.prepareStatement("insert into posts (postId, text, img, likes) values (?, ?, ?, ?)");

            pst.setInt(1, postId);
            pst.setString(2, text);
            pst.setString(3, img);
            pst.setInt(4, likes);

            pst.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

}