com.spend.spendService.SearchText.java Source code

Introduction

Here is the source code for com.spend.spendService.SearchText.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.spend.spendService;

import java.io.File;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import java.util.Timer;
import java.util.TimerTask;
import javax.xml.bind.JAXBContext;
import javax.xml.bind.JAXBException;
import javax.xml.bind.Unmarshaller;
import org.apache.commons.io.IOUtils;

/**
 *
 * @author elif_
 */
public class SearchText {

    private String connectionUrl;
    private Connection con;
    private String searchQuery;

    public void main() {
        connectionJdbc();
        Search();
    }

    private void Search() {
        try {
            TimerTask timertask = new TimerTask() {
                public void run() {
                    try {
                        String[] seList = getSearchEngineNamesArray();
                        /* get search queries from keywords table */
                        PreparedStatement psmt = con.prepareStatement("SELECT searchKeyword FROM keywords");
                        ResultSet rs = psmt.executeQuery();
                        while (rs.next()) {
                            searchQuery = rs.getString("searchKeyword");
                            /* insert search queries into searchqueue table */
                            for (Object se : seList) {
                                PreparedStatement psmt1 = con.prepareStatement(
                                        "INSERT INTO searchqueue(searchText,disabled,searchEngineName) VALUES(?,0,?);");
                                psmt1.setString(1, searchQuery);
                                psmt1.setString(2, se.toString());
                                psmt1.executeUpdate();
                                psmt1.close();
                            }
                        }
                    } catch (Exception ex) {
                        System.out.println("SearchText.java timertask run function SQL ERROR " + ex.getMessage());
                    }
                }
            };
            Timer timer = new Timer();
            DateFormat dateformat = new SimpleDateFormat("dd-MM-yyyy HH:mm:ss");
            Date date = dateformat.parse("20-07-2017 00:00:00"); // set time and date
            timer.schedule(timertask, date, 1000 * 60 * 60 * 24); // for 24 hour 1000*60*60*24
        } catch (Exception ex) {
            System.out.println("SearchText.java Search function ERROR " + ex.getMessage());
        }
    }

    private String[] getSearchEngineNamesArray() {
        try {
            List<SearchEngine> selist = getSearchEnginesFromXml().getSearchEngines();
            String[] seNames = new String[selist.size()];
            int i = 0;
            for (SearchEngine se : selist) {
                seNames[i++] = se.name;
            }
            return seNames;
        } catch (Exception ex) {
            System.out.println("SeacrhText.java getSearchEngineNamesArray function ERROR " + ex.getMessage());
            String[] seNames = { "ERROR" };
            return seNames;
        }
    }

    private SearchEngines getSearchEnginesFromXml() {
        try {
            File file = new File("SearchEngines.xml");
            JAXBContext jaxbContext = JAXBContext.newInstance(SearchEngines.class);
            Unmarshaller jaxbUnmarshaller = jaxbContext.createUnmarshaller();
            SearchEngines searchEngineList = (SearchEngines) jaxbUnmarshaller.unmarshal(file);
            return searchEngineList;
        } catch (JAXBException ex) {
            System.out.println("SearchText.java getSearchEnginesFromXml function ERROR " + ex.getMessage());
            ex.printStackTrace();
        }
        return null;
    }

    private void connectionJdbc() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            connectionUrl = getConnectionString();
            con = DriverManager.getConnection(connectionUrl);
        } catch (Exception ex) {
            System.out.println("SearchText.java connectionJdbc function ERROR" + ex.getMessage());
        }
    }

    private String getConnectionString() {
        String fileString;
        try {
            FileInputStream inputStream = new FileInputStream("db.conf");
            String HostName = "", Port = "", Username = "", Password = "", Schema = "";
            fileString = IOUtils.toString(inputStream);
            for (String s : fileString.split("\n")) {
                try {
                    String label = s.split(" ")[0];
                    String text = s.split(" ")[1];

                    switch (label) {
                    case "Hostname":
                        HostName = text;
                        break;
                    case "Port":
                        Port = text;
                        break;
                    case "Username":
                        Username = text;
                        break;
                    case "Password":
                        Password = text;
                        break;
                    case "Schema":
                        Schema = text;
                        break;
                    }
                } catch (Exception ex) {
                    System.out.println(ex.getMessage());
                }
            }
            inputStream.close();
            return "jdbc:mysql://" + HostName + ":" + Port + "/" + Schema + "?user=" + Username + "&password="
                    + Password;

        } catch (Exception ex) {
            System.out.println("SearchText.java getConnectionString function ERROR " + ex.getMessage());
            return "jdbc:mysql://localhost/crawler?user=root&password=62217769";
        }
    }
}