Guest User

Untitled

a guest
Jul 31st, 2018
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.62 KB | None | 0 0
  1. removing duplicate records in list
  2. public ArrayList loadData() throws ClassNotFoundException, SQLException {
  3. ArrayList userList = new ArrayList();
  4. String url = "";
  5. String dbName = "";
  6. String userName = "";
  7. String password = "";
  8. Connection con = null;
  9. Class.forName("org.apache.derby.jdbc.ClientDriver");
  10. con = DriverManager.getConnection(url + dbName, userName, password);
  11. PreparedStatement ps = null;
  12. try {
  13. String name;
  14. String fatherName;
  15. int Id;
  16. String filePath;
  17. int age;
  18. String address;
  19. String query = "SELECT NAME,FATHERNAME,AGE,ADDRESS,ID,FILEPATH FROM USER_INFORMATION ,USER_PHOTO WHERE ID=USER_ID";
  20. ps = con.prepareStatement(query);
  21. ResultSet rs = ps.executeQuery();
  22. while (rs.next()) {
  23. name = rs.getString(1);
  24. fatherName = rs.getString(2);
  25. age = rs.getInt(3);
  26. address = rs.getString(4);
  27. Id = rs.getInt(5);
  28. filePath=rs.getString(6);
  29. /* if(flag)
  30. {
  31. prev=Id;
  32. flag=false;
  33. }
  34. else if(Id==prev)
  35. {
  36. TEMP=TEMP+";"+filePath;
  37. }*/
  38. //PhotoList = PhotoList(Id, con);
  39. UserData list = new UserData();
  40. list.setName(name);
  41. list.setFatherName(fatherName);
  42. list.setAge(age);
  43. list.setAddress(address);
  44. list.setId(Id);
  45. // list.setFilePath(filePath);
  46. userList.add(list);
  47. }
  48. ps.close();
  49. con.close();
  50. } catch (Exception e) {
  51. e.printStackTrace();
  52. }
  53. ArrayList al = new ArrayList();
  54. HashSet hs = new HashSet();
  55. hs.addAll(userList);
  56. al.clear();
  57. al.addAll(hs);
  58. return al;
  59. }
  60.  
  61. public class UserData {
  62.  
  63. private String name;
  64. private String fatherName;
  65. private int Id;
  66. //private String filePath;
  67. private int age;
  68. private String address;
  69. public UserData()
  70. {
  71.  
  72. }
  73.  
  74. public UserData(String name, String fatherName,int Id, int age,String address)
  75. {
  76. this.name = name;
  77. this.fatherName = fatherName;
  78. this.Id = Id;
  79. //this.filePath=filePath;
  80. this.age=age;
  81. this.address=address;
  82. }
  83. //GETTER AND SETTER..
  84.  
  85. public int hashCode() {
  86. return (name + fatherName+ Id + filePath + age + address).hashCode();
  87. }
  88.  
  89. public boolean equals(Object obj) {
  90. return ( hashCode() == obj.hashCode() );
  91. }
  92.  
  93. UserData u1 = new UserData("Foo", "bar",1, 1,"baz");
  94.  
  95. UserData u2 = new UserData("Foo", "bar",1, 1,"baz");
  96.  
  97. String query = "SELECT NAME,FATHERNAME,AGE,ADDRESS,ID,FILEPATH FROM USER_INFORMATION ,USER_PHOTO WHERE ID=USER_ID";
Add Comment
Please, Sign In to add comment