ok here is my problem in the below shown program i am trying to pass data from txt file to a table,but i get error on StringTokenizer method(nexttoken)i am unable to get the output please if anybody can solve my problem of what is actualy wrong with this program.
public class ReadingText {
public static final String Records="Records";
public static void main(String[] args) throws NoSuchElementException {
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc dbc:sap11","sa","");
Statement stmt=conn.createStatement();
BufferedReader in=new BufferedReader(new FileReader("E:\\Records.txt"));
String line=in.readLine();
while(line!=null){
StringTokenizer tk=new StringTokenizer(line);
String First=tk.nextToken("/"),Last=tk.nextToken("/"),Email=tk.nextToken("/"),Phone=tk.nextToken("/");
String query="insert into "+ Records;
query+="values(" + quote(First)+ "," ;
query+=quote(Last)+ ",";
query+=quote(Email)+ ",";
query+=quote(Phone)+ "); ";
stmt.executeQuery(query);
line=in.readLine();
}
in.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
private static String quote(String include) {
return("\"" + include + "\"");
}
}
Thanks in advance!!!
public class ReadingText {
public static final String Records="Records";
public static void main(String[] args) throws NoSuchElementException {
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc dbc:sap11","sa","");
Statement stmt=conn.createStatement();
BufferedReader in=new BufferedReader(new FileReader("E:\\Records.txt"));
String line=in.readLine();
while(line!=null){
StringTokenizer tk=new StringTokenizer(line);
String First=tk.nextToken("/"),Last=tk.nextToken("/"),Email=tk.nextToken("/"),Phone=tk.nextToken("/");
String query="insert into "+ Records;
query+="values(" + quote(First)+ "," ;
query+=quote(Last)+ ",";
query+=quote(Email)+ ",";
query+=quote(Phone)+ "); ";
stmt.executeQuery(query);
line=in.readLine();
}
in.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
private static String quote(String include) {
return("\"" + include + "\"");
}
}
Thanks in advance!!!