Gfrktyl

I have MySQL DB table my_dictionary, containing soundex_code,word, translation

Also, I have a csv file containing sentences separated by ','. Each sentence contains a set of words separated by ' '.

I would like to read each word from the csv file and compare it with values of the column soundex_code from my_dictionary. And return its equivalent 'translation'
I started this code but I didn't know how to point on each word from my csv file and compare it.

import java.sql.*;



public class dbConnection {



    public static void main (String  args) throws Exception {  

        String url = "jdbc:mysql://localhost:3306/dictionary";  

        String user = "root";   

        String password = "";

        String query = "select translation from my_dictionary where soundex_code='3tl00'";



        Class.forName("com.mysql.cj.jdbc.Driver");

        Connection con = DriverManager.getConnection(url, user, password);



        Statement st = con.createStatement();

        ResultSet rs = st.executeQuery(query);

        rs.next();

        String name = rs.getString("translation");





        System.out.println(name);

        st.close();

        con.close();



    }



}