Advertisement
Guest User

Untitled

a guest
Aug 11th, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.37 KB | None | 0 0
  1. run:
  2. Starting ChromeDriver (v2.9.248315) on port 15621
  3. Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/http/entity/ContentType
  4. at org.openqa.selenium.remote.HttpCommandExecutor$EntityWithEncoding.<init>(HttpCommandExecutor.java:411)
  5. at org.openqa.selenium.remote.HttpCommandExecutor.execute(HttpCommandExecutor.java:306)
  6. at org.openqa.selenium.remote.service.DriverCommandExecutor.execute(DriverCommandExecutor.java:66)
  7. at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:568)
  8. at org.openqa.selenium.remote.RemoteWebDriver.startSession(RemoteWebDriver.java:240)
  9. at org.openqa.selenium.chrome.ChromeDriver.startSession(ChromeDriver.java:181)
  10. at org.openqa.selenium.remote.RemoteWebDriver.<init>(RemoteWebDriver.java:126)
  11. at org.openqa.selenium.remote.RemoteWebDriver.<init>(RemoteWebDriver.java:139)
  12. at org.openqa.selenium.chrome.ChromeDriver.<init>(ChromeDriver.java:160)
  13. at org.openqa.selenium.chrome.ChromeDriver.<init>(ChromeDriver.java:149)
  14. at org.openqa.selenium.chrome.ChromeDriver.<init>(ChromeDriver.java:106)
  15. at pocmandi.PocMandi.main(PocMandi.java:32)
  16. Caused by: java.lang.ClassNotFoundException: org.apache.http.entity.ContentType
  17. at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
  18. at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
  19. at java.security.AccessController.doPrivileged(Native Method)
  20. at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
  21. at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
  22. at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
  23. at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
  24. ... 12 more
  25.  
  26. package pocmandi;
  27.  
  28. import com.gargoylesoftware.htmlunit.BrowserVersion;
  29. import java.util.StringTokenizer;
  30. import org.openqa.selenium.By;
  31. import org.openqa.selenium.WebDriver;
  32. import org.openqa.selenium.WebElement;
  33. import org.openqa.selenium.firefox.FirefoxDriver;
  34. import org.openqa.selenium.htmlunit.HtmlUnitDriver;
  35. import org.openqa.selenium.support.ui.Select;
  36. import java.sql.*;
  37. import org.openqa.selenium.chrome.ChromeDriver;
  38. public class PocMandi {
  39.  
  40. Statement st = null;
  41. Connection cn = null;
  42.  
  43. public static void main(String args[]) throws InterruptedException, ClassNotFoundException, SQLException {
  44.  
  45. int j = 0;
  46. String htmlTableText = null;
  47. System.setProperty("webdriver.chrome.driver", "C:\Users\SHAKTI\Desktop\JarFiles\chromedriver_win32\chromedriver.exe");
  48. WebDriver driver = new ChromeDriver();
  49. String commodity = "Jo";
  50. String commo[] = {"Paddy", "Rice", "Jwar", "Barley", "Corn", "Wheat", "Jo", "Bejhar", "Jai", "Urad", "Moong", "Chana", "Matar"};
  51. for (String com : commo) {
  52. String sDate = "27/03/2014";
  53. String url = "http://www.upmandiparishad.in/commodityWiseAll.aspx";
  54. driver.get(url);
  55. Thread.sleep(5000);
  56.  
  57. new Select(driver.findElement(By.id("ctl00_ContentPlaceHolder1_ddl_commodity"))).selectByVisibleText(com);
  58. driver.findElement(By.id("ctl00_ContentPlaceHolder1_txt_rate")).sendKeys(sDate);
  59.  
  60. Thread.sleep(3000);
  61. driver.findElement(By.id("ctl00_ContentPlaceHolder1_btn_show")).click();
  62. Thread.sleep(5000);
  63.  
  64. WebElement findElement = driver.findElement(By.id("ctl00_ContentPlaceHolder1_GridView1"));
  65. // WebElement find=driver.findElement(By.id("ctl00_ContentPlaceHolder1_ddl_commodity"));
  66. htmlTableText = findElement.getText();
  67. // String html=find.getText();
  68. // do whatever you want now, This is raw table values.
  69. htmlTableText = htmlTableText.replace("S.No.DistrictMarketPrice", "");
  70. htmlTableText = htmlTableText.replaceAll("\s(\d+\s[A-Z])", "n$1");
  71. htmlTableText = htmlTableText.replaceAll("(?=(.*?[ ]){4,}).*?[nr]", "");
  72. htmlTableText = htmlTableText.replace("S.No. District Market Price", "");
  73. System.out.println(htmlTableText);
  74.  
  75. String s[] = htmlTableText.split("");
  76. StringTokenizer str = new StringTokenizer(htmlTableText);
  77. while (str.hasMoreTokens()) // for(int i=0;i<s.length;i++)
  78. // if(str.hasMoreElements())
  79. {
  80. String no = str.nextElement().toString();
  81.  
  82. String city = str.nextElement().toString();
  83. String mandi = str.nextElement().toString();
  84. String price = str.nextElement().toString();
  85. Class.forName("com.mysql.jdbc.Driver");
  86. Connection cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mandi", "root", "");
  87. //insert them into the database
  88. PreparedStatement ps = cn.prepareStatement("insert into commoditydemo values(?,?,?,?,?,?)");
  89. ps.setString(1, no);
  90. ps.setString(2, city);
  91. ps.setString(3, mandi);
  92. ps.setString(4, price);
  93. ps.setString(5, com);
  94. ps.setString(6, "0");
  95. j = ps.executeUpdate();
  96. cn.close();
  97.  
  98. }
  99. }
  100. driver.close();
  101. driver.quit();
  102. if (j == 1) {
  103. System.out.println("data inserted");
  104. } else {
  105. System.out.println("not inserted");
  106. }
  107. }
  108. }
  109.  
  110. @Test
  111. public void test1() throws Exception {
  112. System.setProperty("webdriver.chrome.driver", "t:\Others\chromedriver.exe");
  113. WebDriver driver = new ChromeDriver();
  114.  
  115. String url = "http://www.upmandiparishad.in/commodityWiseAll.aspx";
  116.  
  117. driver.get(url);
  118. Thread.sleep(5000);
  119.  
  120. new Select(driver.findElement(By.id("ctl00_ContentPlaceHolder1_ddl_commodity"))).selectByVisibleText("Paddy");
  121. Thread.sleep(5000);
  122.  
  123. driver.findElement(By.id("ctl00_ContentPlaceHolder1_txt_rate")).sendKeys("27/03/2014");
  124. Thread.sleep(5000);
  125.  
  126. driver.findElement(By.id("ctl00_ContentPlaceHolder1_btn_show")).click();
  127. Thread.sleep(5000);
  128.  
  129. driver.close();
  130.  
  131. <dependency>
  132. <groupId>org.apache.httpcomponents</groupId>
  133. <artifactId>httpcore</artifactId>
  134. <version>4.3</version>
  135. </dependency>
  136.  
  137. <dependency>
  138. <groupId>org.seleniumhq.selenium</groupId>
  139. <artifactId>selenium-java</artifactId>
  140. <version>2.53.0</version>
  141. </dependency>
  142.  
  143. <dependency>
  144. <groupId>org.seleniumhq.selenium</groupId>
  145. <artifactId>selenium-java</artifactId>
  146. <version>3.4.0</version>
  147. </dependency>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement