Advertisement
Guest User

Untitled

a guest
Mar 2nd, 2016
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. code -
  2.  
  3. FileReader fileReader = new FileReader(outputFile);
  4. BufferedReader bufferedReader = new BufferedReader(fileReader);
  5. String inputLine;
  6. List<String> lineList = new ArrayList<String>();
  7. while ((inputLine = bufferedReader.readLine()) != null) {
  8. lineList.add(inputLine);
  9. }
  10. fileReader.close();
  11.  
  12. Class.forName("com.mysql.jdbc.Driver");
  13.  
  14. Connection con=DriverManager.getConnection(
  15. "jdbc:mysql://localhost:3306/patent","root","india2000");
  16. for (int i = 0;i<outputFile.length();i++)
  17. {
  18. Statement stmt=con.createStatement();
  19.  
  20. ResultSet rs=stmt.executeQuery("insert into patent_uspto_tmp (pinv) values(?)");
  21. rs.getString("outputFile");
  22. while(rs.next())
  23.  
  24. System.out.println("query updated" );
  25.  
  26. }
  27.  
  28. con.close();
  29.  
  30. }catch(Exception e){ System.out.println(e);}
  31.  
  32. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement