Package org.nutz.dao.sql

Examples of org.nutz.dao.sql.Criteria.where()

752
753
754
755
756
757
758
759
760
761
762
                PItem[] _cndItems = Pojos.Items.cnd(lnk.createCondition(obj));
                pojo.append(_cndItems);
                if (cnd != null) {
                    if (cnd instanceof Criteria) {
                        Criteria cri = (Criteria)cnd;
                        SqlExpressionGroup seg = cri.where();
                        if (_cndItems.length > 0 && seg != null && !seg.isEmpty()) {
                            seg.setTop(false);
                            pojo.append(Pojos.Items.wrap(" AND "));
                        }
                        pojo.append(cri);
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
     * Github Issue #101
     */
    @Test
    public void query_by_cri_equals_null() {
        Criteria cri = Cnd.cri();
        cri.where().andEquals("name", null);
        List<Pet> pets = dao.query(Pet.class, cri, null);
        assertEquals(0, pets.size());

        cri = Cnd.cri();
        cri.where().andNotEquals("name", null);
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
        cri.where().andEquals("name", null);
        List<Pet> pets = dao.query(Pet.class, cri, null);
        assertEquals(0, pets.size());

        cri = Cnd.cri();
        cri.where().andNotEquals("name", null);
        pets = dao.query(Pet.class, cri, null);
        assertEquals(8, pets.size());
    }

    @Test
View Full Code Here
68
69
70
71
72
73
74
75
76
77
78
        if (dao.meta().isMySql()) {
            dao.insert(Pet.create("A").setNickName("AAA"));
            dao.insert(Pet.create("B").setNickName("B%B"));

            Criteria cri = Cnd.cri();
            cri.where().andLike("alias", "\\%");
            List<Pet> pets = dao.query(Pet.class, cri);
            assertEquals(1, pets.size());
            assertEquals("B", pets.get(0).getName());
        }
    }
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
     * Github Issue #101
     */
    @Test
    public void query_by_cri_equals_null() {
        Criteria cri = Cnd.cri();
        cri.where().andEquals("name", null);
        List<Pet> pets = dao.query(Pet.class, cri, null);
        assertEquals(0, pets.size());

        cri = Cnd.cri();
        cri.where().andNotEquals("name", null);
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
        cri.where().andEquals("name", null);
        List<Pet> pets = dao.query(Pet.class, cri, null);
        assertEquals(0, pets.size());

        cri = Cnd.cri();
        cri.where().andNotEquals("name", null);
        pets = dao.query(Pet.class, cri, null);
        assertEquals(8, pets.size());
    }

    @Test
View Full Code Here
860
861
862
863
864
865
866
867
868
869
870
                PItem[] _cndItems = Pojos.Items.cnd(lnk.createCondition(obj));
                pojo.append(_cndItems);
                if (cnd != null) {
                    if (cnd instanceof Criteria) {
                        Criteria cri = (Criteria) cnd;
                        SqlExpressionGroup seg = cri.where();
                        if (_cndItems.length > 0
                            && seg != null
                            && !seg.isEmpty()) {
                            seg.setTop(false);
                            pojo.append(Pojos.Items.wrap(" AND "));
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.