use of sqlite.feature.contentprovider.kripton35.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>");*/
}
use of sqlite.feature.contentprovider.kripton35.entities.Person in project ConsoElectric by anakkarsara.
the class PersonDetails 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("<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> ");
tx.commit();
manager.close();
}
use of sqlite.feature.contentprovider.kripton35.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 ${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();
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;
}
}
use of sqlite.feature.contentprovider.kripton35.entities.Person in project kripton by xcesco.
the class Person2DAOImpl 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();
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;
}
}
use of sqlite.feature.contentprovider.kripton35.entities.Person in project kripton by xcesco.
the class Person2DAOImpl method selectAll.
/**
* <h2>Select SQL:</h2>
*
* <pre>SELECT id, alias_parent_id, city, birth_city, birth_day, value, name, surname FROM person WHERE #{DYNAMIC_WHERE} ORDER BY name asc, #{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>where</dt><dd>is part of where conditions resolved at runtime. In above SQL it is displayed as #{DYNAMIC_WHERE}</dd>
* <dt>order</dt>is part of order statement resolved at runtime. In above SQL it is displayed as #{DYNAMIC_ORDER_BY}</dd>
* </dl>
*
* @param where
* is used as <strong>dynamic WHERE statement</strong> and it is formatted by ({@link StringUtils#format})
* @param args
* is binded to <code>${args}</code>
* @param order
* 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> selectAll(String where, String[] args, String order) {
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
// initialize dynamic where
String _sqlDynamicWhere = where;
// initialize dynamic where args
String[] _sqlDynamicWhereArgs = args;
// generation CODE_001 -- END
String _sortOrder = order;
// manage WHERE arguments -- BEGIN
// manage WHERE statement
String _sqlWhereStatement = StringUtils.ifNotEmptyAppend(_sqlDynamicWhere, " WHERE ");
_sqlBuilder.append(_sqlWhereStatement);
// manage WHERE arguments -- END
if (StringUtils.hasText(_sqlDynamicWhere) && _sqlDynamicWhereArgs != null) {
for (String _arg : _sqlDynamicWhereArgs) {
_contentValues.addWhereArgs(_arg);
}
}
// generation order - BEGIN
String _sqlOrderByStatement = " ORDER BY name asc" + StringUtils.ifNotEmptyAppend(_sortOrder, ", ");
_sqlBuilder.append(_sqlOrderByStatement);
// generation order - END
String _sql = _sqlBuilder.toString();
// add where arguments
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;
}
}
Aggregations