Subversion Repositories SmartDukaan

package in.shop2020.mobileapi.serving.services;

import in.shop2020.mobileapi.serving.utils.Utils;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.Calendar;

public class Mysql {
        // JDBC driver name and database URL
        static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
        static final String DB_URL = "jdbc:mysql://%s/user";

        // Database credentials
        static final String USER = "root";
        static final String PASS = "shop2020";

        public static void addAffClicks(long userId, int storeId, String url, String subTag) {
                Connection conn = null;
                PreparedStatement stmt = null;
                try {
                        Class.forName("com.mysql.jdbc.Driver");
                        conn = DriverManager.getConnection(String.format(DB_URL, Utils.getMysqlHost()), USER, PASS);
                        stmt = conn.prepareStatement("INSERT INTO aff_clicks (user_id, store_id, url, subtag, created) values (?, ?, ?, ?, ?)");
                    stmt.setLong(1, userId);
                    stmt.setInt(2, storeId);
                    stmt.setString(3, url);
                    stmt.setString(4, subTag);
                    stmt.setTimestamp(5, new Timestamp(Calendar.getInstance().getTime().getTime()));
                    stmt.executeUpdate();
                } catch (SQLException se) {
                        // Handle errors for JDBC
                        se.printStackTrace();
                } catch (Exception e) {
                        // Handle errors for Class.forName
                        e.printStackTrace();
                } finally {
                        // finally block used to close resources
                        try {
                                if (stmt != null)
                                        stmt.close();
                        } catch (SQLException se2) {
                        }// nothing we can do
                        try {
                                if (conn != null)
                                        conn.close();
                        } catch (SQLException se) {
                                se.printStackTrace();
                        }// end finally try
                }// end try
        }// end main
        
        public static void main (String[] args){
                Mysql.addAffClicks(1, 1, "1", "1");
        }
}// end FirstExample