Hi ,
I have writtten a code in netbeans to remove stop words.I stored tokenized words in one table(three fields) and stop words(one field) in another table.I created a new table named sremoval having three fields to store the output.I used ms access.
But the query is not executing.pls help me.
import java.sql.*;
public class Main {
public static void main(String[] args) {
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbcdbcriver={Microsoft Access Driver " +
"(*.mdb, *.accdb)};DBQ=E:\\Database1.accdb";
Connection con = DriverManager.getConnection(url);
System.out.println("Connected");
Statement s=con.createStatement();
String ttt = "insert into sremoval(d_id,ss_id,term) select document,s_id,word from tokenization where tokenization.word not in (select ww from stopwords)";
s.executeUpdate(ttt);
s.close();
con.close();
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
}