Examples with DAO jpa.DAO used on opensource projects

Example 1 with DAO

use of jpa.DAO 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>");
}

Example 2 with DAO

use of jpa.DAO in project ConsoElectric by anakkarsara.

the class DeleteHome method doPost.

public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    EntityManagerFactory factory = Persistence.createEntityManagerFactory("dev");
    EntityManager manager = factory.createEntityManager();
    EntityTransaction tx = manager.getTransaction();
    tx.begin();
    response.setContentType("text/html");
    PrintWriter out = response.getWriter();
    HomeDao hd = new HomeDao();
    hd.deleteById(Long.parseLong(request.getParameter("homeToDelete")));
    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>Maison</th> <th>Surface</th>  <th>Nb pieces</th> <th>Proprietaire</th>");
    DAO test = new DAO(manager);
    for (Home next : test.allHomes()) {
        out.println(" <tr>    <td>" + next.getMyHome() + "</td>   <td>" + next.getSurface() + "</td>   <td>" + next.getNumRooms() + "</td> <td>" + next.getOwner().getFamilyName() + " " + next.getOwner().getFirstName() + "</td></tr>  ");
    }
    out.println("</table> ");
    manager.close();
}

Example 3 with DAO

use of jpa.DAO in project ConsoElectric by anakkarsara.

the class ElectronicDeviceDetails 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();
    edd.createED(request.getParameter("name"), Double.parseDouble(request.getParameter("conso")), test.getPerson(Long.parseLong(request.getParameter("owner"))));
    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>Name</th> <th>Conso</th> <th>Proprietaire</th> </tr>");
    for (ElectronicDevice next : edd.allEDs()) {
        out.println(" <tr>  <td>" + next.getEdName() + "</td>   <td>" + next.getConsoMoy() + "</td>   <td>" + next.getOwner().getFamilyName() + " " + next.getOwner().getFirstName() + "</td>  </tr>  ");
    }
    out.println("</table> ");
}

Example 4 with DAO

use of jpa.DAO 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>");*/
}

Example 5 with DAO

use of jpa.DAO 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();
}