1st create table in phpMyAdmin
2. Start payra server
3. right click on payara server->view admin console ->
jdbc-> jdbc connection pool
->
Pool Name:
Resource Type : javax.sql.DataSource
Database Driver Vendor:
com.mysql.cj.jdbc.MysqlDataSource
Next-->
Datasource Classname:
com.mysql.cj.jdbc.MysqlDatSource
Addtiional Property:-->
URL : jdbc:mysql://localhost:3306/exdb?useSSL=false
user : root
password : root
driverClass : com.mysql.cj.jdbc.Driver
4.JDBC Resources
JNDI Name: jdbc/test3
Pool Name:
----->ok
5.
Project Creation
---> other sources ->src->meta Inf -> persistence.xml
-->
jdbc/test3
6.Source Package right click -> new java Package -> name : entity
-->entity --> right click -> other search entity -> in persistence -> entity classes from database
---> select server datasource : --- jdbc/test3 --> test connection -> next -> finish
Select tables and add--->
Than next --> finish
7.Right click on Source Package -> new java package -->
name : ejb --> right click on ejb --> new --> other search session --> select Session Bean
---> ejb name --> finish (2 tables 2 file)
8.departmentEJB code:----
@PersistenceContext(unitName = "my_persistence_unit")
private EntityManager em;
public List getDepartments()
{
return em.createNamedQuery("Department.findAll").getResultList();
}
public Department getDepartment(int id)
{
return em.createNamedQuery("Department.findByDid",Department.class)
.setParameter("did", id)
.getSingleResult();
}
9. employeeEJB code
@PersistenceContext(unitName = "my_persistence_unit")
private EntityManager em;
public List getEmployees()
{
return em.createNamedQuery("Employee.findAll").getResultList();
}
public void addEmployee(Employee e)
{
em.persist(e);
}
10.Create New Package --> name: servlet
Right click servlet -> new -> servlet
Name : emplyeeServlet
first Create EJB Variables : -->
write below the class line
@EJB
private departmentEJB dejb;
@EJB
private employeeEJB ejb;
---->
Click on last "+" icon (HTTP SERVLET METHODS)
doGet--->
(for display)
List department = dejb.getDepartments();
List employee = ejb.getEmployees();
request.setAttribute("department", department);
request.setAttribute("employee", employee);
request.getRequestDispatcher("employees.jsp").forward(request, response);
---------->
Insert code:---
doPost -->
for insert
String ename = request.getParameter("ename");
int salary = Integer.parseInt(request.getParameter("salary"));
int did = Integer.parseInt(request.getParameter("did"));
Employee e = new Employee();
e.setEname(ename);
e.setSalary(salary);
e.setDid(did);
ejb.addEmployee(e);
List department = dejb.getDepartments();
List employee = ejb.getEmployees();
request.setAttribute("department", department);
request.setAttribute("employee", employee);
request.getRequestDispatcher("employees.jsp").forward(request, response);
11. Create jsp file--
Right Click on Web Pages Folder ------>
name it empolyees
import these packages At Top:0-------
<%@page import="entity.Department" %>//entity
<%@page import="entity.Employee" %>//entity
<%@page import="java.util.*" %>
write this bellow tag
<%
List department=(Vector)request.getAttribute("department");
List employee=(Vector)request.getAttribute("employee");
%>
than write in body tage Insert Form Code:----
Add Employee
After Form Write This For Display "
| Empolyee Name |
Salary |
department |
<%
if(employee != null)
{
for(Employee e:employee)
{
%>
| <%= e.getEname() %> |
<%= e.getSalary()%> |
<%= e.getDid()%> |
<%
}
}
%>
"
12.Delete Employee
employeeEJB:---
public void deleteEmp(int id)
{
em.remove(em.createNamedQuery("Employee.findByEid",Employee.class).setParameter("eid", id).getSingleResult());
}
---------->
Servlet --> Write In doGet
String action = request.getParameter("action");
if(action != null && action.equals("delete"))
{
String id = request.getParameter("id");
ejb.deleteEmp(Integer.parseInt(id));
}
--------->
In JSP Tag--->
Action |
Delete
|