CRUD

Watch “JSP Part-19 | JSP JDBC with CRUD – Code Optimization, Retrieving Data using Array List (Gujarati)” on YouTube

by

➡️ Retrieving data using Array List (array list of objects)
➡️ Code Optimization

Here, Array List us used to hold the list of object of type EmpBean.

JSP with Bean and Data access object (DAO). JSP is the normal jsp page which uses the bean to store employee information. The DAO file also know an Data Access Layer of our application, contains the code perform database operations such as add, change, delete etc.,

This video demonstrates the best usage of MVC (Model View & Controller) architecture in Java.
➡️ The model here is the EmpBean which holds the employee information.
➡️ The index page is the View which is interface used by client to enter the input and get to view the output.
➡️ The controller here the file which accepts the request from client and sets to bean and bean finally manages the database operation.

CRUD – Create, Read, Update & Delete

With reference to previous video 👉 https://youtu.be/63cIEAnz7Hc which consist of Add operation & Display operation.
and 👉 https://youtu.be/Asi4H3QCHY4 which consist of Delete operation.

In this video the same example has been extended to support Edit/Update operation using display page. The link (url to edit page and ID of record to be updated) has been generated in the display page for to update record.

Once user click the Edit link , the control is transfer to edit.jsp page, where the the ID of the record to be updated is fetch from request object and the other details are set in text boxes so that user can edit the data.

There is a Update (submit) button which transfer user control to the update.jsp page, where all the submitted data is updated into emp table.

#RaviROza #JSPJDBC #CRUD #AdvanceJava #Jdk #Java #Gujarati #ArrayList #CodeOptimizationInJava

OS : Windows 10
Jdk : Version 8
IDE : Eclipse Mars
Server : Apache Tomcat 7

Follow me @
https://raviroza.wordpress.com/
https://raviroza.blogspot.com/
https://www.facebook.com/ravi.oza.it
https://twitter.com/raviozaIT

Subscribe my channel to get latest video notification https://www.youtube.com/user/ravioza101

Watch “JSP Part-18 | JSP JDBC with CRUD (Update operation) (Gujarati)” on YouTube

by

JSP with Bean and Data access object (DAO). JSP is the normal jsp page which uses the bean to store employee information. The DAO file also know an Data Access Layer of our application, contains the code perform database operations such as add, change, delete etc.,

This video demonstrates the best usage of MVC (Model View & Controller) architecture in Java.
➡️ The model here is the EmpBean which holds the employee information.
➡️ The index page is the View which is interface used by client to enter the input and get to view the output.
➡️ The controller here the file which accepts the request from client and sets to bean and bean finally manages the database operation.

CRUD – Create, Read, Update & Delete

With reference to previous video 👉 https://youtu.be/63cIEAnz7Hc which consist of Add operation & Display operation.
and 👉 https://youtu.be/Asi4H3QCHY4 which consist of Delete operation.

In this video the same example has been extended to support Edit/Update operation using display page. The link (url to edit page and ID of record to be updated) has been generated in the display page for to update record.

Once user click the Edit link , the control is transfer to edit.jsp page, where the the ID of the record to be updated is fetch from request object and the other details are set in text boxes so that user can edit the data.

There is a Update (submit) button which transfer user control to the update.jsp page, where all the submitted data is updated into emp table.

RaviROza #MVC #JSPJDBC #CRUD #DAO #AdvanceJava #Jdk #Java #Gujarati

OS : Windows 10
Jdk : Version 8
IDE : Eclipse Mars
Server : Apache Tomcat 7

Follow me @
https://raviroza.wordpress.com/
https://raviroza.blogspot.com/
https://www.facebook.com/ravi.oza.it
https://twitter.com/raviozaIT

Subscribe my channel to get latest video notification https://www.youtube.com/user/ravioza101

Watch “JSP Part-17 | JSP JDBC with CRUD (Delete operation) (Gujarati)” on YouTube

by

JSP with Bean and Data access object (DAO). JSP is the normal jsp page which uses the bean to store employee information. The DAO file also know an Data Access Layer of our application, contains the code perform database operations such as add, change, delete etc.,

This video demonstrates the best usage of MVC architecture in Java.
➡️ The model here is the EmpBean which holds the employee information.
➡️ The index page is the View which is interface used by client to enter the input and get to view the output.
➡️ The controller here the file which accepts the request from client and sets to bean and bean finally manages the database operation.

CRUD – Create, Read, Update & Delete.

With reference to previous video 👉 https://youtu.be/63cIEAnz7Hc which consist of Add operation & Display operation.

In this video the same example has been extended to support Delete operation using display page. The link (url to delete page and ID of record to be deleted) has been generated in the display page for to delete record.

Once user click the Delete link , the control is transfer to delete.jsp page, where the the ID of the record to be deleted is fetch from request object and the same will be deleted from the emp table.

RaviROza #MVC #JSPJDBC #CRUD #DAO #AdvanceJava #Jdk #Java #Gujarati

OS : Windows 10
Jdk : Version 8
IDE : Eclipse Mars
Server : Apache Tomcat 7

Follow me @
https://raviroza.wordpress.com/
https://raviroza.blogspot.com/
https://www.facebook.com/ravi.oza.it
https://twitter.com/raviozaIT

Subscribe my channel to get latest video notification https://www.youtube.com/user/ravioza101

Watch “Servlet Part 21 | CRUD operation in Servlet Using JDBC (Gujarati)” on YouTube

by
#CRUD #Servlet #JDBC #MySql #Eclipse #MySqlWorkbench #ApacheTomcat #Jdk #Java

This video features the CRUD operation using JDBC via servlet only, no JSP page is used to perform any database operation.
CRUD is Create, Read, Update & Delete.

Index.html

<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Servlet with JDBC</title>
</head>
<body>
<form action="AddEmp" method="post">
<h1> Employee Management</h1>
<p> Enter Emp. No : <input type="text" name="txtEno"> </p>
<p> Enter Emp. Name : <input type="text" name="txtEname"> </p>
<p> Enter Emp. Salary : <input type="text" name="txtEsalary"> </p>

<p> DB Operation :
<select name="op">
    <option value="1">Add</option>
    <option value="2">Update</option>
    <option value="3">Delete</option>
    <option value="4">Display</option>
</select>
</p>

<p> <input type="submit" value="Submit"> </p>
</form>
</body>
</html>

AddEmp.java

package servletWithJDBC;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;

@WebServlet("/AddEmp")
public class AddEmp extends HttpServlet 
{
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 
	{			
		response.setContentType("text/html");
		PrintWriter pw = response.getWriter();
		String op = request.getParameter("op");
		Connection conn;
		PreparedStatement pst=null; 
		String url,username,password,qry="";
		url = "jdbc:mysql://localhost:3306/raviroza";
		username="root";
		password="ravi";	
		
		int eno;
		String ename="";
		float esalary;
		try 
		{
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection(url,username,password);			
			
			if(op.equals("1"))
			{
				eno = Integer.parseInt(request.getParameter("txtEno"));
				ename = request.getParameter("txtEname");
				esalary = Float.parseFloat(request.getParameter("txtEsalary"));
				
				qry = "insert into emp values (?,?,?)";
				pst = conn.prepareStatement(qry);
				pst.setInt(1, eno);
				pst.setString(2, ename);
				pst.setFloat(3, esalary);
				pst.executeUpdate();
			}
			else if(op.equals("2"))
			{
				eno = Integer.parseInt(request.getParameter("txtEno"));
				ename = request.getParameter("txtEname");
				esalary = Float.parseFloat(request.getParameter("txtEsalary"));
				
				qry = "update emp set ename=?,esalary=? where eno=?";
				pst = conn.prepareStatement(qry);				
				pst.setString(1, ename);
				pst.setFloat(2, esalary);
				pst.setInt(3, eno);
				pst.executeUpdate();
			}
			else if(op.equals("3"))
			{
				eno = Integer.parseInt(request.getParameter("txtEno"));
				qry = "delete from emp where eno=?";	
				pst = conn.prepareStatement(qry);								
				pst.setInt(1, eno);
				pst.executeUpdate();
			}								
						
			qry = "select * From Emp Order by eno desc";
			ResultSet rs = conn.prepareStatement(qry).executeQuery();
			pw.println("<table border=1>");
			pw.println("<th>Eno.</th>");
			pw.println("<th>Emp. Name</th>");
			pw.println("<th>Emp. Salary</th>");
			while(rs.next())
			{
				pw.println("<tr>");
				pw.println("<td>"+rs.getString("eno")+"</td>");
				pw.println("<td>"+rs.getString("ename")+"</td>");
				pw.println("<td>"+rs.getString("esalary")+"</td>");
				pw.println("</tr>");
			}
						
			pw.println("<h2> Employee Info. updated Successfully ! </h2>");
			pw.println("<a href='index.html'>Back</a>");
			
			pw.close();
			pst.close();
			conn.close();		
		}
		catch (ClassNotFoundException | SQLException e) 
		{
			pw.println("<h2> Driver|SQL Error "+e.toString() +"</h2>");
		}
	}
}

Overall process of example.

It is generally the table operation to create, access, manipulate, and delete the data from a database table.
Here, only a single Servlet is performing all the CRUD operation. Operation is decided by the client by selecting a proper option from list of choices.

When a client/user select the “Add” option, the internal value of that option is checked to perform the add operation, like wise when user/client select the “Update” operation the record is updated with given details.

If user/client decide to delete the record the valid number is given and the delete operation is carried.

Finally, if user decides to display all the record there is an option called “Display” to view all the details of the table.

OS : Windows 10
Jdk : Version 8
IDE : Eclipse Mars
Database : MySQL using MySql Workbench 5.2 CE
Server : Apache Tomcat 7

follow me @
https://raviroza.wordpress.com/
https://twitter.com/raviozaIT
https://www.facebook.com/ravi.oza.it

Subscribe my channel to get latest video notification https://www.youtube.com/user/ravioza101