Package cat.quickdb.date200912.model

Examples of cat.quickdb.date200912.model.Person

93
94
95
96
97
98
99
100
101
102
103
    }
  }
 
  public Person findPerson( int id )
  {
    Person person = new Person();
   
    for (Person tmp : listPerson)
    {
      if ( tmp.getId()==id )
      {
View Full Code Here
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
 
  public Person getNewPerson()
  {
    int id=0;
   
    Person person = new Person();
   
    try
    {
      model.Connect();
      id=model.MaxId();
      model.Disconnect();
    }
    catch (Exception e)
    {
      e.printStackTrace();
    }
    person.setId(id+1);

    return person;
  }
View Full Code Here
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
    return person;
  }
 
  public Person newPerson( HttpServletRequest request )
  {
    Person person = new Person();
    ArrayList<Phone> phones = new ArrayList<Phone>();
    String phone = "phone[0].phone";;
    int i=0;
   
    person.setId( Integer.parseInt(request.getParameter("id")) );
    person.setFistname(request.getParameter("fistname"));
    person.setSurname(request.getParameter("surname"));
    person.setAge( Integer.parseInt(request.getParameter("age")) );
   
    while(request.getParameter(phone)!=null)
    {
      phones.add(new Phone( request.getParameter(phone) ));
      phone = "phone["+i+"].phone";
      i++;
    }
   
    if (!phones.isEmpty())
    {
      phones.remove(0);
    }
   
    person.setPhone(phones);
   
    return person;
  }
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
  @Override
  public Person Read(int id) throws SQLException
  {
    statement = connection.createStatement();
    Person person=null;
    ArrayList<Phone> phones = null;
   
    query="SELECT * FROM PERSONS WHERE ID="+id+";";
    result = statement.executeQuery(query);
    result.next();
   
    if (result.getRow()==1)
    {
      person = new Person();  
      person.setId(result.getInt("ID"));
      person.setFistname(result.getNString("FISTNAME"));
      person.setSurname(result.getNString("SURNAME"));
      person.setAge(result.getInt("AGE"));
     
      Statement statementPhone = connection.createStatement();

      query="SELECT * FROM PHONES WHERE PERSONID="+id+";";
      ResultSet resultPhone = statementPhone.executeQuery(query);
      phones = new ArrayList<Phone>();
     
      while (resultPhone.next())
      { 
        Phone phone = new Phone();
        phone.setPhone(resultPhone.getNString("PHONE"));
        phones.add(phone);
      }
      statementPhone.close();
      person.setPhone(phones);
    }
    statement.close();
    return person;
  }
View Full Code Here
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
  public ArrayList<Person> ReadAll() throws SQLException
  {
    statement = connection.createStatement();
    ArrayList<Person> list = new ArrayList<Person>();
    ArrayList<Phone> phones;
    Person person;
   
    query="SELECT * FROM PERSONS;";
    result = statement.executeQuery(query);
 
    while ( result.next() )
    {  
      person = new Person();
      person.setId(result.getInt("ID"));
      person.setFistname(result.getNString("FISTNAME"));
      person.setSurname(result.getNString("SURNAME"));
      person.setAge(result.getInt("AGE"));
     
      phones = new ArrayList<Phone>();
     
      query="SELECT * FROM PHONES WHERE PERSONID="+person.getId()+";";
      Statement statementPhone = connection.createStatement();
      ResultSet resultPhone = statementPhone.executeQuery(query);
     
      while (resultPhone.next())
      { 
        Phone phone = new Phone();
        phone.setPhone(resultPhone.getNString("PHONE"));
        phones.add(phone);
      }
      resultPhone.close();
      person.setPhone(phones);
      list.add(person);
    }
    statement.close();
    return list;
  }
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
 
  private List<Person> createList() {
    List<Person> rv = new ArrayList<Person>();
   
    {
      Person p = new Person("Tom","Schindl");
      p.setStreet("Bahnhofstrasse 1");
      p.setZip("6020");
      p.setCity("Innsbruck");
      rv.add(p); 
    }
   
    {
      Person p = new Person("John","Doe");
      p.setStreet("Mainstreet 1");
      p.setZip("E10E4");
      p.setCity("San Francisco");
      rv.add(p);
    }
   
    return rv;
  }
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
                QuickDBTests.user, QuickDBTests.pass, QuickDBTests.scheme);
    }

    @Test
    public void testBinding(){
        Bind b = new Bind();
        Bind2 b2 = new Bind2();

        b.setDescription("description");
        b2.setName("name binding2");

        Assert.assertTrue(b.save());
        Assert.assertTrue(b2.save());

        Bind bind = new Bind();
        admin.obtain(bind, "description = 'description'");
        Assert.assertEquals("description", bind.getDescription());
        Bind2 bind2 = new Bind2();
        admin.obtain(bind2, "name = 'name binding2'");
        Assert.assertEquals("name binding2", bind2.getName());
    }
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
    }

    @Test
    public void testBinding(){
        Bind b = new Bind();
        Bind2 b2 = new Bind2();

        b.setDescription("description");
        b2.setName("name binding2");

        Assert.assertTrue(b.save());
        Assert.assertTrue(b2.save());

        Bind bind = new Bind();
        admin.obtain(bind, "description = 'description'");
        Assert.assertEquals("description", bind.getDescription());
        Bind2 bind2 = new Bind2();
        admin.obtain(bind2, "name = 'name binding2'");
        Assert.assertEquals("name binding2", bind2.getName());
    }
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
        Assert.assertEquals(null, t2.getPruebaIgnore());
    }

    @Test
    public void testModifyCollection(){
        Collection1 test = new Collection1();
        test.setName("name");

        Collection2 t1 = new Collection2();
        t1.setDescription("description1");
        Collection2 t2 = new Collection2();
        t2.setDescription("description2");
        Collection2 t3 = new Collection2();
        t3.setDescription("description3");
        ArrayList array = new ArrayList();
        array.add(t1);
        array.add(t2);
        array.add(t3);

        test.setCollection2(array);

        Assert.assertTrue(admin.save(test));

        Assert.assertTrue(admin.obtain(test, "name = 'name'"));

        Collection2 t = new Collection2();
        t.setDescription("description added");
        test.getCollection2().add(t);

        Assert.assertTrue(admin.modify(test));

        Collection1 tt = new Collection1();
        Assert.assertTrue(admin.obtain(tt, "name = 'name'"));
        Assert.assertEquals("description added",
                ((Collection2)tt.getCollection2().get(tt.getCollection2().size()-1)).getDescription());
        Assert.assertTrue(admin.delete(test));
    }
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
    @Test
    public void testModifyCollection(){
        Collection1 test = new Collection1();
        test.setName("name");

        Collection2 t1 = new Collection2();
        t1.setDescription("description1");
        Collection2 t2 = new Collection2();
        t2.setDescription("description2");
        Collection2 t3 = new Collection2();
        t3.setDescription("description3");
        ArrayList array = new ArrayList();
        array.add(t1);
        array.add(t2);
        array.add(t3);

        test.setCollection2(array);

        Assert.assertTrue(admin.save(test));

        Assert.assertTrue(admin.obtain(test, "name = 'name'"));

        Collection2 t = new Collection2();
        t.setDescription("description added");
        test.getCollection2().add(t);

        Assert.assertTrue(admin.modify(test));

        Collection1 tt = new Collection1();
View Full Code Here
TOP

Related Classes of cat.quickdb.date200912.model.Person

  • at.bestsolution.efxclipse.runtime.examples.e4.parts.PersonListPart
  • cat.quickdb.date200912.model.Bind
  • cat.quickdb.date200912.model.Bind2
  • cat.quickdb.date200912.model.Collection1
  • cat.quickdb.date200912.model.Collection2
  • cat.quickdb.date200912.model.Delete1
  • cat.quickdb.date200912.model.Delete2
  • cat.quickdb.date200912.model.Name2
  • cat.quickdb.date200912.model.Names
  • cat.quickdb.date200912.model.Obj1
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.