Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- removing duplicate records in list
- public ArrayList loadData() throws ClassNotFoundException, SQLException {
- ArrayList userList = new ArrayList();
- String url = "";
- String dbName = "";
- String userName = "";
- String password = "";
- Connection con = null;
- Class.forName("org.apache.derby.jdbc.ClientDriver");
- con = DriverManager.getConnection(url + dbName, userName, password);
- PreparedStatement ps = null;
- try {
- String name;
- String fatherName;
- int Id;
- String filePath;
- int age;
- String address;
- String query = "SELECT NAME,FATHERNAME,AGE,ADDRESS,ID,FILEPATH FROM USER_INFORMATION ,USER_PHOTO WHERE ID=USER_ID";
- ps = con.prepareStatement(query);
- ResultSet rs = ps.executeQuery();
- while (rs.next()) {
- name = rs.getString(1);
- fatherName = rs.getString(2);
- age = rs.getInt(3);
- address = rs.getString(4);
- Id = rs.getInt(5);
- filePath=rs.getString(6);
- /* if(flag)
- {
- prev=Id;
- flag=false;
- }
- else if(Id==prev)
- {
- TEMP=TEMP+";"+filePath;
- }*/
- //PhotoList = PhotoList(Id, con);
- UserData list = new UserData();
- list.setName(name);
- list.setFatherName(fatherName);
- list.setAge(age);
- list.setAddress(address);
- list.setId(Id);
- // list.setFilePath(filePath);
- userList.add(list);
- }
- ps.close();
- con.close();
- } catch (Exception e) {
- e.printStackTrace();
- }
- ArrayList al = new ArrayList();
- HashSet hs = new HashSet();
- hs.addAll(userList);
- al.clear();
- al.addAll(hs);
- return al;
- }
- public class UserData {
- private String name;
- private String fatherName;
- private int Id;
- //private String filePath;
- private int age;
- private String address;
- public UserData()
- {
- }
- public UserData(String name, String fatherName,int Id, int age,String address)
- {
- this.name = name;
- this.fatherName = fatherName;
- this.Id = Id;
- //this.filePath=filePath;
- this.age=age;
- this.address=address;
- }
- //GETTER AND SETTER..
- public int hashCode() {
- return (name + fatherName+ Id + filePath + age + address).hashCode();
- }
- public boolean equals(Object obj) {
- return ( hashCode() == obj.hashCode() );
- }
- UserData u1 = new UserData("Foo", "bar",1, 1,"baz");
- UserData u2 = new UserData("Foo", "bar",1, 1,"baz");
- 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