PreparedStatement problem
Hi! I'm having problems while executing the following class.
It seems that the query1.executeQuery is not working.
What could be wrong? I think that this class has no logical errors..
import java.sql.*;
import java.io.*;
class test{
publicstaticvoid main (String[] argv)throws Exception{
try{
StringdriverClassName ="COM.ibm.db2.jdbc.app.DB2Driver";
Stringurl ="jdbc:db2:TS";
Connection dbConnection=null;
Statement st =null;
ResultSet rs=null;
String user ="db2admin";
String pwd ="db2admin";
Class.forName (driverClassName);
dbConnection = DriverManager.getConnection (url,"","");
PreparedStatement query1;
String insertString ="SELECT COUNT(*) FROM KWDS WHERE KWDS.DE=? ;";
query1 = dbConnection.prepareStatement(insertString);
BufferedReader in=new BufferedReader(
new FileReader("Keyword References Keyword.txt"));
BufferedWriter out =new BufferedWriter(
new OutputStreamWriter(
new FileOutputStream(
new File("Keywords with NGD parameters.txt"))));
String linefeed=null;
String temp;
String count1 =null;
String count2 =null;
String count3 =null;
while((linefeed =in.readLine())!=null)
{
String[] linewords = linefeed.split(" :: ");
query1.setString(1,linewords[0]);
rs = query1.executeQuery();
count1 = rs.getString(1);
System.out.println(count1);
query1.setString(1,linewords[1]);
rs = query1.executeQuery();
count2 = rs.getString(1);
temp=null;
temp=linefeed.concat(" :: ").concat(count1).concat(" :: ").concat(count2);
out.write(temp);
out.newLine();
}
in.close();
out.close();
dbConnection.close();
query1.close();
}catch(Exception e){}
}
}
