Search in sources :

Example 1 with Person

use of entities.Person in project kripton by xcesco.

the class Person2DAOImpl method selectOne.

/**
 * <h2>Select SQL:</h2>
 *
 * <pre>SELECT id, alias_parent_id, city, birth_city, birth_day, value, name, surname FROM person WHERE name like ${data.name} || '%' ORDER BY #{DYNAMIC_ORDER_BY}</pre>
 *
 * <h2>Projected columns:</h2>
 * <dl>
 * 	<dt>id</dt><dd>is associated to bean's property <strong>id</strong></dd>
 * 	<dt>alias_parent_id</dt><dd>is associated to bean's property <strong>parentId</strong></dd>
 * 	<dt>city</dt><dd>is associated to bean's property <strong>city</strong></dd>
 * 	<dt>birth_city</dt><dd>is associated to bean's property <strong>birthCity</strong></dd>
 * 	<dt>birth_day</dt><dd>is associated to bean's property <strong>birthDay</strong></dd>
 * 	<dt>value</dt><dd>is associated to bean's property <strong>value</strong></dd>
 * 	<dt>name</dt><dd>is associated to bean's property <strong>name</strong></dd>
 * 	<dt>surname</dt><dd>is associated to bean's property <strong>surname</strong></dd>
 * </dl>
 *
 * <h2>Method's parameters and associated dynamic parts:</h2>
 * <dl>
 * <dt>orderBy</dt>is part of order statement resolved at runtime. In above SQL it is displayed as #{DYNAMIC_ORDER_BY}</dd>
 * </dl>
 *
 * <h2>Query's parameters:</h2>
 * <dl>
 * 	<dt>${data.name}</dt><dd>is binded to method's parameter <strong>bean.name</strong></dd>
 * </dl>
 *
 * @param bean
 * 	is used as ${data}
 * @param orderBy
 * 	is used as <strong>dynamic ORDER BY statement</strong> and it is formatted by ({@link StringUtils#format})
 * @return collection of bean or empty collection.
 */
@Override
public List<Person> selectOne(Person bean, String orderBy) {
    KriptonContentValues _contentValues = contentValues();
    StringBuilder _sqlBuilder = sqlBuilder();
    _sqlBuilder.append("SELECT id, alias_parent_id, city, birth_city, birth_day, value, name, surname FROM person");
    // generation CODE_001 -- BEGIN
    // generation CODE_001 -- END
    String _sortOrder = orderBy;
    // manage WHERE arguments -- BEGIN
    // manage WHERE statement
    String _sqlWhereStatement = " WHERE name like ? || '%'";
    _sqlBuilder.append(_sqlWhereStatement);
    // manage WHERE arguments -- END
    // generation order - BEGIN
    String _sqlOrderByStatement = StringUtils.ifNotEmptyAppend(_sortOrder, " ORDER BY ");
    _sqlBuilder.append(_sqlOrderByStatement);
    // generation order - END
    String _sql = _sqlBuilder.toString();
    // add where arguments
    _contentValues.addWhereArgs(bean.getName());
    String[] _sqlArgs = _contentValues.whereArgsAsArray();
    try (Cursor _cursor = database().rawQuery(_sql, _sqlArgs)) {
        ArrayList<Person> resultList = new ArrayList<Person>(_cursor.getCount());
        Person resultBean = null;
        if (_cursor.moveToFirst()) {
            int index0 = _cursor.getColumnIndex("id");
            int index1 = _cursor.getColumnIndex("alias_parent_id");
            int index2 = _cursor.getColumnIndex("city");
            int index3 = _cursor.getColumnIndex("birth_city");
            int index4 = _cursor.getColumnIndex("birth_day");
            int index5 = _cursor.getColumnIndex("value");
            int index6 = _cursor.getColumnIndex("name");
            int index7 = _cursor.getColumnIndex("surname");
            do {
                resultBean = new Person();
                resultBean.id = _cursor.getLong(index0);
                if (!_cursor.isNull(index1)) {
                    resultBean.parentId = _cursor.getLong(index1);
                }
                if (!_cursor.isNull(index2)) {
                    resultBean.city = _cursor.getLong(index2);
                }
                if (!_cursor.isNull(index3)) {
                    resultBean.birthCity = _cursor.getString(index3);
                }
                if (!_cursor.isNull(index4)) {
                    resultBean.birthDay = DateUtils.read(_cursor.getString(index4));
                }
                if (!_cursor.isNull(index5)) {
                    resultBean.value = _cursor.getLong(index5);
                }
                if (!_cursor.isNull(index6)) {
                    resultBean.setName(_cursor.getString(index6));
                }
                if (!_cursor.isNull(index7)) {
                    resultBean.setSurname(_cursor.getString(index7));
                }
                resultList.add(resultBean);
            } while (_cursor.moveToNext());
        }
        return resultList;
    }
}
Also used : KriptonContentValues(com.abubusoft.kripton.android.sqlite.KriptonContentValues) ArrayList(java.util.ArrayList) Cursor(android.database.Cursor) Person(sqlite.feature.contentprovider.kripton35.entities.Person)

Example 2 with Person

use of entities.Person in project kripton by xcesco.

the class PersonDAOImpl method selectOne.

/**
 * <h2>Select SQL:</h2>
 *
 * <pre>SELECT id, alias_parent_id, city, birth_city, birth_day, value, name, surname FROM person WHERE name like ${nameTemp} || '%' GROUP BY id HAVING id=2 ORDER BY id, #{DYNAMIC_ORDER_BY}</pre>
 *
 * <h2>Projected columns:</h2>
 * <dl>
 * 	<dt>id</dt><dd>is associated to bean's property <strong>id</strong></dd>
 * 	<dt>alias_parent_id</dt><dd>is associated to bean's property <strong>parentId</strong></dd>
 * 	<dt>city</dt><dd>is associated to bean's property <strong>city</strong></dd>
 * 	<dt>birth_city</dt><dd>is associated to bean's property <strong>birthCity</strong></dd>
 * 	<dt>birth_day</dt><dd>is associated to bean's property <strong>birthDay</strong></dd>
 * 	<dt>value</dt><dd>is associated to bean's property <strong>value</strong></dd>
 * 	<dt>name</dt><dd>is associated to bean's property <strong>name</strong></dd>
 * 	<dt>surname</dt><dd>is associated to bean's property <strong>surname</strong></dd>
 * </dl>
 *
 * <h2>Method's parameters and associated dynamic parts:</h2>
 * <dl>
 * <dt>orderBy</dt>is part of order statement resolved at runtime. In above SQL it is displayed as #{DYNAMIC_ORDER_BY}</dd>
 * </dl>
 *
 * <h2>Query's parameters:</h2>
 * <dl>
 * 	<dt>${nameTemp}</dt><dd>is binded to method's parameter <strong>nameValue</strong></dd>
 * </dl>
 *
 * @param nameValue
 * 	is binded to <code>${nameTemp}</code>
 * @param orderBy
 * 	is used as <strong>dynamic ORDER BY statement</strong> and it is formatted by ({@link StringUtils#format})
 * @return collection of bean or empty collection.
 */
@Override
public List<Person> selectOne(String nameValue, String orderBy) {
    KriptonContentValues _contentValues = contentValues();
    StringBuilder _sqlBuilder = sqlBuilder();
    _sqlBuilder.append("SELECT id, alias_parent_id, city, birth_city, birth_day, value, name, surname FROM person");
    // generation CODE_001 -- BEGIN
    // generation CODE_001 -- END
    String _sortOrder = orderBy;
    // manage WHERE arguments -- BEGIN
    // manage WHERE statement
    String _sqlWhereStatement = " WHERE name like ? || '%'";
    _sqlBuilder.append(_sqlWhereStatement);
    // manage WHERE arguments -- END
    // manage GROUP BY statement
    String _sqlGroupByStatement = " GROUP BY id";
    _sqlBuilder.append(_sqlGroupByStatement);
    // manage HAVING statement
    String _sqlHavingStatement = " HAVING id=2";
    _sqlBuilder.append(_sqlHavingStatement);
    // generation order - BEGIN
    String _sqlOrderByStatement = " ORDER BY id" + StringUtils.ifNotEmptyAppend(_sortOrder, ", ");
    _sqlBuilder.append(_sqlOrderByStatement);
    // generation order - END
    String _sql = _sqlBuilder.toString();
    // add where arguments
    _contentValues.addWhereArgs((nameValue == null ? "" : nameValue));
    String[] _sqlArgs = _contentValues.whereArgsAsArray();
    // log section BEGIN
    if (_context.isLogEnabled()) {
        // manage log
        Logger.info(_sql);
        // log for where parameters -- BEGIN
        int _whereParamCounter = 0;
        for (String _whereParamItem : _contentValues.whereArgs()) {
            Logger.info("==> param%s: '%s'", (_whereParamCounter++), StringUtils.checkSize(_whereParamItem));
        }
    // log for where parameters -- END
    }
    // log section END
    try (Cursor _cursor = database().rawQuery(_sql, _sqlArgs)) {
        // log section BEGIN
        if (_context.isLogEnabled()) {
            Logger.info("Rows found: %s", _cursor.getCount());
        }
        // log section END
        ArrayList<Person> resultList = new ArrayList<Person>(_cursor.getCount());
        Person resultBean = null;
        if (_cursor.moveToFirst()) {
            int index0 = _cursor.getColumnIndex("id");
            int index1 = _cursor.getColumnIndex("alias_parent_id");
            int index2 = _cursor.getColumnIndex("city");
            int index3 = _cursor.getColumnIndex("birth_city");
            int index4 = _cursor.getColumnIndex("birth_day");
            int index5 = _cursor.getColumnIndex("value");
            int index6 = _cursor.getColumnIndex("name");
            int index7 = _cursor.getColumnIndex("surname");
            do {
                resultBean = new Person();
                resultBean.id = _cursor.getLong(index0);
                if (!_cursor.isNull(index1)) {
                    resultBean.parentId = _cursor.getLong(index1);
                }
                if (!_cursor.isNull(index2)) {
                    resultBean.city = _cursor.getLong(index2);
                }
                if (!_cursor.isNull(index3)) {
                    resultBean.birthCity = _cursor.getString(index3);
                }
                if (!_cursor.isNull(index4)) {
                    resultBean.birthDay = DateUtils.read(_cursor.getString(index4));
                }
                if (!_cursor.isNull(index5)) {
                    resultBean.value = _cursor.getLong(index5);
                }
                if (!_cursor.isNull(index6)) {
                    resultBean.setName(_cursor.getString(index6));
                }
                if (!_cursor.isNull(index7)) {
                    resultBean.setSurname(_cursor.getString(index7));
                }
                resultList.add(resultBean);
            } while (_cursor.moveToNext());
        }
        return resultList;
    }
}
Also used : KriptonContentValues(com.abubusoft.kripton.android.sqlite.KriptonContentValues) ArrayList(java.util.ArrayList) Cursor(android.database.Cursor) Person(sqlite.feature.contentprovider.kripton35.entities.Person)

Example 3 with Person

use of entities.Person in project kripton by xcesco.

the class PersonDAOImpl method selectBean.

/**
 * <h2>Select SQL:</h2>
 *
 * <pre>SELECT id, alias_parent_id, city, birth_city, birth_day, value, name, surname FROM person</pre>
 *
 * <h2>Projected columns:</h2>
 * <dl>
 * 	<dt>id</dt><dd>is associated to bean's property <strong>id</strong></dd>
 * 	<dt>alias_parent_id</dt><dd>is associated to bean's property <strong>parentId</strong></dd>
 * 	<dt>city</dt><dd>is associated to bean's property <strong>city</strong></dd>
 * 	<dt>birth_city</dt><dd>is associated to bean's property <strong>birthCity</strong></dd>
 * 	<dt>birth_day</dt><dd>is associated to bean's property <strong>birthDay</strong></dd>
 * 	<dt>value</dt><dd>is associated to bean's property <strong>value</strong></dd>
 * 	<dt>name</dt><dd>is associated to bean's property <strong>name</strong></dd>
 * 	<dt>surname</dt><dd>is associated to bean's property <strong>surname</strong></dd>
 * </dl>
 *
 * @return collection of bean or empty collection.
 */
@Override
public List<Person> selectBean() {
    KriptonContentValues _contentValues = contentValues();
    // query SQL is statically defined
    String _sql = SELECT_BEAN_SQL1;
    // add where arguments
    String[] _sqlArgs = _contentValues.whereArgsAsArray();
    // log section BEGIN
    if (_context.isLogEnabled()) {
        // manage log
        Logger.info(_sql);
        // log for where parameters -- BEGIN
        int _whereParamCounter = 0;
        for (String _whereParamItem : _contentValues.whereArgs()) {
            Logger.info("==> param%s: '%s'", (_whereParamCounter++), StringUtils.checkSize(_whereParamItem));
        }
    // log for where parameters -- END
    }
    // log section END
    try (Cursor _cursor = database().rawQuery(_sql, _sqlArgs)) {
        // log section BEGIN
        if (_context.isLogEnabled()) {
            Logger.info("Rows found: %s", _cursor.getCount());
        }
        // log section END
        ArrayList<Person> resultList = new ArrayList<Person>(_cursor.getCount());
        Person resultBean = null;
        if (_cursor.moveToFirst()) {
            int index0 = _cursor.getColumnIndex("id");
            int index1 = _cursor.getColumnIndex("alias_parent_id");
            int index2 = _cursor.getColumnIndex("city");
            int index3 = _cursor.getColumnIndex("birth_city");
            int index4 = _cursor.getColumnIndex("birth_day");
            int index5 = _cursor.getColumnIndex("value");
            int index6 = _cursor.getColumnIndex("name");
            int index7 = _cursor.getColumnIndex("surname");
            do {
                resultBean = new Person();
                resultBean.id = _cursor.getLong(index0);
                if (!_cursor.isNull(index1)) {
                    resultBean.parentId = _cursor.getLong(index1);
                }
                if (!_cursor.isNull(index2)) {
                    resultBean.city = _cursor.getLong(index2);
                }
                if (!_cursor.isNull(index3)) {
                    resultBean.birthCity = _cursor.getString(index3);
                }
                if (!_cursor.isNull(index4)) {
                    resultBean.birthDay = DateUtils.read(_cursor.getString(index4));
                }
                if (!_cursor.isNull(index5)) {
                    resultBean.value = _cursor.getLong(index5);
                }
                if (!_cursor.isNull(index6)) {
                    resultBean.setName(_cursor.getString(index6));
                }
                if (!_cursor.isNull(index7)) {
                    resultBean.setSurname(_cursor.getString(index7));
                }
                resultList.add(resultBean);
            } while (_cursor.moveToNext());
        }
        return resultList;
    }
}
Also used : KriptonContentValues(com.abubusoft.kripton.android.sqlite.KriptonContentValues) ArrayList(java.util.ArrayList) Cursor(android.database.Cursor) Person(sqlite.feature.contentprovider.kripton35.entities.Person)

Example 4 with Person

use of entities.Person in project ConsoElectric by anakkarsara.

the class AddHome method doGet.

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    EntityManagerFactory factory = Persistence.createEntityManagerFactory("dev");
    EntityManager manager = factory.createEntityManager();
    DAO test = new DAO(manager);
    EntityTransaction tx = manager.getTransaction();
    tx.begin();
    response.setContentType("text/html");
    PrintWriter out = response.getWriter();
    out.println("<h2><a href=\"index.html\">Retour page d'acueil</a></h2>");
    out.println("<FORM Method=\"POST\" Action=\"/HomesInfo\">\r\n" + "		<table border = 1 cellpadding = \"10\" align = \"center\">\r\n" + "		<tr> <td>Maison : 	</td>	<td> <INPUT type=text size=20 name=myhome></td> </tr>\r\n" + "		<tr> <td>Surface : </td>	<td>	<INPUT type=text size=20 name=surface></td> </tr>\r\n" + "		<tr> <td>Nombre de pieces : 	</td>	<td>	<INPUT type=text size=20 name=nbpce></td> </tr>\r\n");
    out.println("<td>Proprietaire</td><td><SELECT name=\"owner\" size=\"1\">");
    for (Person p : test.listPersons()) {
        out.println("<option value = \"" + p.getId() + "\">" + p.getFirstName() + " " + p.getFamilyName() + "</option>");
    }
    out.println("				</td></tr><tr ><td colspan = \"2\" align = \"right\"><INPUT type=submit value=Send></td>\r\n");
    out.println("		</table>\r\n" + "		</FORM>");
}
Also used : EntityTransaction(javax.persistence.EntityTransaction) EntityManager(javax.persistence.EntityManager) DAO(jpa.DAO) EntityManagerFactory(javax.persistence.EntityManagerFactory) Person(entities.Person) PrintWriter(java.io.PrintWriter)

Example 5 with Person

use of entities.Person in project ConsoElectric by anakkarsara.

the class PersonDetails method doPost.

public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    EntityManagerFactory factory = Persistence.createEntityManagerFactory("dev");
    EntityManager manager = factory.createEntityManager();
    DAO test = new DAO(manager);
    EntityTransaction tx = manager.getTransaction();
    tx.begin();
    response.setContentType("text/html");
    PrintWriter out = response.getWriter();
    if (!request.getParameter("firstname").isEmpty()) {
        test.createPerson(request.getParameter("firstname"), request.getParameter("familyname"), request.getParameter("email"));
        tx.commit();
    }
    out.println("<h2><a href=\"index.html\">Retour page d'acueil</a></h2>");
    out.println("<table border = 2 cellpadding = \"10\" cellspacing = \"10\" align= \"center\">  <tr>  <th>Prenom</th> <th>Nom</th>  <th>Email</th> ");
    for (Person next : test.listPersons()) {
        out.println(" <tr>    <td>" + next.getFirstName() + "</td>   <td>" + next.getFamilyName() + "</td>   <td>" + next.getMail() + "</td> </tr>  ");
    }
    out.println("</table> ");
    manager.close();
/*out.println("<HTML>\n<BODY>\n" +
				"<H1>List des personnes : </H1>\n" +
				"<UL>\n" +			
		" <LI>Firstname: "
				+ request.getParameter("firstname") + "\n" +
				" <LI>Familyname: "
				+ request.getParameter("familyname") + "\n" +
				" <LI>Email: "
				+ request.getParameter("email") + "\n" +
				"</UL>\n" +				
		"</BODY></HTML>");*/
}
Also used : EntityTransaction(javax.persistence.EntityTransaction) EntityManager(javax.persistence.EntityManager) DAO(jpa.DAO) EntityManagerFactory(javax.persistence.EntityManagerFactory) Person(entities.Person) PrintWriter(java.io.PrintWriter)

Aggregations

Cursor (android.database.Cursor)8 KriptonContentValues (com.abubusoft.kripton.android.sqlite.KriptonContentValues)8 ArrayList (java.util.ArrayList)8 Person (sqlite.feature.contentprovider.kripton35.entities.Person)8 Person (entities.Person)7 PrintWriter (java.io.PrintWriter)6 EntityTransaction (javax.persistence.EntityTransaction)6 EntityManager (javax.persistence.EntityManager)5 EntityManagerFactory (javax.persistence.EntityManagerFactory)5 DAO (jpa.DAO)5 PersonDao (dao.PersonDao)1 DELETE (javax.ws.rs.DELETE)1 Path (javax.ws.rs.Path)1 Produces (javax.ws.rs.Produces)1