Continued:

[addressbook-lib.git] / src / org / mxchange / addressbook / model / addressbook / UserAddressbook.java

diff --git a/src/org/mxchange/addressbook/model/addressbook/UserAddressbook.java b/src/org/mxchange/addressbook/model/addressbook/UserAddressbook.java
index 724b123c6f35109082223ec73f013509bbc1e289..b86baf1c9977e060c2adb930e89a63a235d24f4d 100644 (file)
--- a/src/org/mxchange/addressbook/model/addressbook/UserAddressbook.java
+++ b/src/org/mxchange/addressbook/model/addressbook/UserAddressbook.java
@@ -46,7 +46,8 @@ import org.mxchange.jusercore.model.user.User;
 @Table (name = "addressbooks")
 @NamedQueries (
                {
-                       @NamedQuery (name = "AllUsersAddressbooks", query = "SELECT a FROM addressbooks AS a WHERE a.addressbookUser = :param ORDER BY a.addressbookId ASC")
+                       @NamedQuery (name = "AllUsersAddressbooks", query = "SELECT a FROM addressbooks AS a WHERE a.addressbookUser = :param ORDER BY a.addressbookId ASC"),
+                       @NamedQuery(name = "SearchUserAddressbookName", query = "SELECT a FROM addressbooks AS a WHERE a.addressbookUser = :user AND LOWER(a.addressbookName) LIKE LOWER(:name)")
                }
 )
 public class UserAddressbook implements Addressbook, Comparable<Addressbook> {
@@ -94,12 +95,22 @@ public class UserAddressbook implements Addressbook, Comparable<Addressbook> {
        @Column (name = "addressbook_name", length = 50, nullable = false)
        private String addressbookName;
 
+       /**
+        * Default protected constructor
+        */
+       protected UserAddressbook () {
+       }
+
        /**
         * Public constructor with address book name
         * <p>
         * @param addressbookName Address book name
         */
        public UserAddressbook (final String addressbookName) {
+               // Call default constructor
+               this();
+
+               // Set name
                this.addressbookName = addressbookName;
        }