Unknown column 'Accessoires' in 'where clause' ??????

[acil_farhat]

public int rechercheParCat(String test) {
        int idcat = 0;
        try {
            String query = "SELECT id_cat FROM categorie WHERE titre="+test;
            PreparedStatement pst = cnx2.prepareStatement(query);
//            pst.setString(1, test);
            ResultSet rs = pst.executeQuery(query);
            idcat = rs.getInt(1);
        } catch (SQLException ex) {
            System.err.println(ex.getMessage());
        }

        return idcat;
    }

}

i have this erreur while i have Accessoires in table categorieas u can see in the pictures 

help me please

output:

0
Unknown column 'Accessoires' in 'where clause'
 

[Ress]

Try like this:

"SELECT id_cat FROM categorie WHERE titre='"+ test + "'";