

{"id":135734,"date":"2024-05-10T10:50:53","date_gmt":"2024-05-10T05:20:53","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=135734"},"modified":"2024-05-10T11:04:17","modified_gmt":"2024-05-10T05:34:17","slug":"advanced-java-product-management-system-part-8","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/advanced-java-product-management-system-part-8\/","title":{"rendered":"Advanced Java Project &#8211; Product Management System Part-8"},"content":{"rendered":"<h3>Program 1<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">&lt;%-- \r\n    Document   : InsertProduct\r\n    Created on : Nov 6, 2023, 1:22:08 PM\r\n    Author     : admin\r\n--%&gt;\r\n\r\n&lt;%@page import=\"dao.ProductDAO\"%&gt;\r\n&lt;%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%&gt;\r\n&lt;%@include file=\"header.jsp\"%&gt;\r\n&lt;!DOCTYPE html&gt;\r\n&lt;%! \r\n   int pid;\r\n%&gt;\r\n&lt;html&gt;\r\n    &lt;head&gt;\r\n        &lt;meta http-equiv=\"Content-Type\" content=\"text\/html; charset=UTF-8\"&gt;\r\n        &lt;title&gt;Insert JSP Page&lt;\/title&gt;\r\n        &lt;script language=\"javascript\"&gt;\r\n            function validate()\r\n            {\r\n              var pname,pqty,pamt;\r\n              pname=document.getElementById(\"PRODNAME\").value;\r\n              pqty=document.getElementById(\"PRODQTY\").value;\r\n              pamt=document.getElementById(\"PRODAMT\").value;\r\n              \r\n              if(pname==\"\")\r\n              {    \r\n                  alert(\"Product name can't be blank\");\r\n                  document.getElementById(\"PRODNAME\").focus();\r\n                  return false;   \r\n              }\r\n              \r\n              if(pname!=\"\")\r\n              {\r\n                  var asci;\r\n                  for(i=0;i&lt;pname.length;i++)\r\n                  {\r\n                      asci=pname.charCodeAt(i)\r\n                      if(!((asci&gt;=65&amp;&amp;asci&lt;=91)||(asci&gt;=97 &amp;&amp; asci&lt;=122)||asci==32))\r\n                      {\r\n                          alert(\"Only Character allowed in Name field....\")\r\n                          return false;\r\n                      }\r\n                  }   \r\n              }    \r\n              \r\n              \r\n              if(pqty==\"\")\r\n              {    \r\n                  alert(\"Product Qty can't be blank\");\r\n                  document.getElementById(\"PRODQTY\").focus();\r\n                  return false;   \r\n              }\r\n             \r\n              if(pamt==\"\")\r\n              {    \r\n                  alert(\"Product Amount can't be blank\");\r\n                  document.getElementById(\"PRODAMT\").focus();\r\n                  return false;   \r\n              }\r\n              if(pqty&lt;0 || pqty&gt;5000)\r\n              {    \r\n                  alert(\"Product Qty between 0 to 5000 only\");\r\n                  document.getElementById(\"PRODQTY\").focus();\r\n                  return false;   \r\n              }\r\n              \r\n              if(pamt&lt;0)\r\n              {    \r\n                  alert(\"Product Amount is invalid pls check\");\r\n                  document.getElementById(\"PRODAMT\").focus();\r\n                  return false;   \r\n              }\r\n              return true;\r\n            }\r\n        &lt;\/script&gt;      \r\n    &lt;\/head&gt;\r\n    &lt;body&gt;\r\n        &lt;% \r\n           for(int i=1;i&lt;=15;i++)\r\n               out.println(\"&lt;br&gt;\");\r\n           ProductDAO pd=new ProductDAO();\r\n           pid=pd.autoIncrement();\r\n        %&gt;\r\n          &lt;center&gt;\r\n             &lt;font color=\"F19A15\" size=\"7\"&gt;Insert Product Page&lt;\/font&gt;\r\n             &lt;br&gt;\r\n             &lt;form method=\"post\" action=\"InsertData.jsp\"&gt;\r\n                &lt;table border=\"1\"&gt;  \r\n                &lt;tr&gt;\r\n                 &lt;th&gt;Product Id&lt;\/th&gt;    \r\n                 &lt;td&gt;&lt;input type=\"text\" name=\"txtid\" id=\"PRODID\" value=&lt;%=pid%&gt;&gt;&lt;\/td&gt;    \r\n                &lt;\/tr&gt;   \r\n                &lt;tr&gt;\r\n                 &lt;th&gt;Product Name&lt;\/th&gt;    \r\n                 &lt;td&gt;&lt;input type=\"text\" name=\"txtname\" id=\"PRODNAME\"&gt;&lt;\/td&gt;    \r\n                &lt;\/tr&gt;   \r\n               &lt;tr&gt;\r\n                 &lt;th&gt;Quantity&lt;\/th&gt;    \r\n                 &lt;td&gt;&lt;input type=\"text\" name=\"txtqty\" id=\"PRODQTY\"&gt;&lt;\/td&gt;    \r\n               &lt;\/tr&gt;   \r\n              \r\n                &lt;tr&gt;\r\n                 &lt;th&gt;Amount&lt;\/th&gt;    \r\n                 &lt;td&gt;&lt;input type=\"text\" name=\"txtamt\" id=\"PRODAMT\"&gt;&lt;\/td&gt;    \r\n               &lt;\/tr&gt;   \r\n                \r\n                &lt;tr&gt;\r\n                 &lt;th&gt;Type of Product&lt;\/th&gt;    \r\n                 &lt;td&gt;\r\n                     &lt;input type=\"radio\" name=\"rdtype\" value=\"Solid\"&gt;Solid\r\n                     &lt;input type=\"radio\" name=\"rdtype\" value=\"Liquid\"&gt;Liquid\r\n                     &lt;input type=\"radio\" name=\"rdtype\" value=\"Gas\"&gt;Gas\r\n                 &lt;\/td&gt;    \r\n               &lt;\/tr&gt;   \r\n               &lt;tr&gt;\r\n                   &lt;td&gt;&lt;\/td&gt;\r\n                   &lt;td&gt;\r\n                       &lt;input type=\"submit\" value=\"Submit\" onclick=\"return validate();\"&gt;\r\n                       &lt;input type=\"reset\" value=\"Reset\"&gt;\r\n                   &lt;\/td&gt;\r\n               &lt;\/tr&gt;\r\n                &lt;\/table&gt;      \r\n              &lt;\/form&gt;    \r\n          &lt;\/center&gt;\r\n    &lt;\/body&gt;\r\n&lt;\/html&gt;<\/pre>\n<h3>Program 2<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">&lt;%-- \r\n    Document   : InsertData\r\n    Created on : Nov 6, 2023, 2:11:09 PM\r\n    Author     : admin\r\n--%&gt;\r\n\r\n&lt;%@page import=\"dao.ProductDAO\"%&gt;\r\n&lt;%@page import=\"model.Product\"%&gt;\r\n&lt;%@page import=\"connection.MyConnection\"%&gt;\r\n&lt;%@page import=\"java.sql.Connection\"%&gt;\r\n&lt;%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%&gt;\r\n&lt;%@include file=\"header.jsp\"%&gt;\r\n&lt;!DOCTYPE html&gt;\r\n\r\n   \r\n   \r\n&lt;html&gt;\r\n    &lt;head&gt;\r\n        &lt;meta http-equiv=\"Content-Type\" content=\"text\/html; charset=UTF-8\"&gt;\r\n        &lt;title&gt;JSP Page&lt;\/title&gt;\r\n    &lt;\/head&gt;\r\n    &lt;body&gt;\r\n        &lt;center&gt;\r\n        &lt;% \r\n           for(int i=1;i&lt;=15;i++)\r\n               out.println(\"&lt;br&gt;\");\r\n        %&gt;\r\n        \r\n       &lt;% \r\n            int pid,pamount,pqty;\r\n            String pname,ptype;\r\n            pid=Integer.parseInt(request.getParameter(\"txtid\"));\r\n            pname=request.getParameter(\"txtname\");\r\n            pqty=Integer.parseInt(request.getParameter(\"txtqty\"));\r\n            pamount=Integer.parseInt(request.getParameter(\"txtamt\"));\r\n            ptype=request.getParameter(\"rdtype\");\r\n            Product P=new Product();\r\n            P.setProdid(pid);\r\n            P.setProdname(pname);\r\n            P.setProdqty(pqty);\r\n            P.setProdamt(pamount);\r\n            P.setProdtype(ptype);\r\n            ProductDAO pd=new ProductDAO();\r\n          try\r\n          {   \r\n            if(pd.insertProduct(P))\r\n                out.println(\"&lt;h2&gt;Record inserted.........&lt;\/h2&gt;\");\r\n          }\r\n          catch(Exception e)\r\n          {\r\n              out.println(e);\r\n          }   \r\n       %&gt;\r\n       &lt;\/center&gt;\r\n    &lt;\/body&gt;\r\n&lt;\/html&gt;<\/pre>\n<h3>Program 3<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">&lt;!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"&gt;\r\n&lt;html&gt;\r\n&lt;head&gt;\r\n&lt;title&gt;Untitled&lt;\/title&gt;\r\n&lt;meta http-equiv=\"content-type\" content=\"text\/html; charset=iso-8859-1\"&gt;\r\n&lt;meta name=\"generator\" content=\"Web Page Maker\"&gt;\r\n\r\n&lt;style type=\"text\/css\"&gt;\r\n\/*----------Text Styles----------*\/\r\n.ws6 {font-size: 8px;}\r\n.ws7 {font-size: 9.3px;}\r\n.ws8 {font-size: 11px;}\r\n.ws9 {font-size: 12px;}\r\n.ws10 {font-size: 13px;}\r\n.ws11 {font-size: 15px;}\r\n.ws12 {font-size: 16px;}\r\n.ws14 {font-size: 19px;}\r\n.ws16 {font-size: 21px;}\r\n.ws18 {font-size: 24px;}\r\n.ws20 {font-size: 27px;}\r\n.ws22 {font-size: 29px;}\r\n.ws24 {font-size: 32px;}\r\n.ws26 {font-size: 35px;}\r\n.ws28 {font-size: 37px;}\r\n.ws36 {font-size: 48px;}\r\n.ws48 {font-size: 64px;}\r\n.ws72 {font-size: 96px;}\r\n.wpmd {font-size: 13px;font-family: 'Arial';font-style: normal;font-weight: normal;}\r\n\/*----------Para Styles----------*\/\r\nDIV,UL,OL \/* Left *\/\r\n{\r\n margin-top: 0px;\r\n margin-bottom: 0px;\r\n}\r\n&lt;\/style&gt;\r\n\r\n\r\n&lt;script language=\"JavaScript1.4\" type=\"text\/javascript\"&gt;\r\n&lt;!--\r\nfunction jsPlay(soundobj) {\r\n var thissound= eval(\"document.\"+soundobj);\r\n try {\r\n     thissound.Play();\r\n }\r\n catch (e) {\r\n     thissound.DoPlay();\r\n }\r\n}\r\n\/\/--&gt;\r\n&lt;\/script&gt;\r\n\r\n&lt;script language=\"javascript\" type=\"text\/javascript\"&gt;\r\n&lt;!--\r\nfunction MM_swapImgRestore() {\r\n  var i,x,a=document.MM_sr; for(i=0;a&amp;&amp;i&lt;a.length&amp;&amp;(x=a[i])&amp;&amp;x.oSrc;i++) x.src=x.oSrc;\r\n}\r\n\r\nfunction MM_preloadImages() {\r\n  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();\r\n    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i&lt;a.length; i++)\r\n    if (a[i].indexOf(\"#\")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}\r\n}\r\n\r\nfunction MM_findObj(n, d) {\r\n  var p,i,x;  if(!d) d=document; if((p=n.indexOf(\"?\"))&gt;0&amp;&amp;parent.frames.length) {\r\n    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}\r\n  if(!(x=d[n])&amp;&amp;d.all) x=d.all[n]; for (i=0;!x&amp;&amp;i&lt;d.forms.length;i++) x=d.forms[i][n];\r\n  for(i=0;!x&amp;&amp;d.layers&amp;&amp;i&lt;d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);\r\n  if(!x &amp;&amp; d.getElementById) x=d.getElementById(n); return x;\r\n}\r\n\r\nfunction MM_swapImage() {\r\n  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i&lt;(a.length-2);i+=3)\r\n   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}\r\n}\r\n\r\n\/\/--&gt;\r\n&lt;\/script&gt;\r\n\r\n&lt;\/head&gt;\r\n\r\n&lt;body&gt;\r\n\r\n&lt;div id=\"nav10d\" style=\"position:absolute; left:198px; top:185px; z-index:0\"&gt;&lt;a onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('nav10','','images\/nav60392960a.gif',1)\" href=\"header.jsp\"&gt;&lt;img name=\"nav10\" onLoad=\"MM_preloadImages('images\/nav60392960a.gif')\" alt=\"\" border=0 src=\"images\/nav60392960i.gif\"&gt;&lt;\/a&gt;&lt;\/div&gt;\r\n&lt;div id=\"nav11d\" style=\"position:absolute; left:369px; top:185px; z-index:0\"&gt;&lt;a onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('nav11','','images\/nav60392961a.gif',1)\" href=\"InsertProduct.jsp\"&gt;&lt;img name=\"nav11\" onLoad=\"MM_preloadImages('images\/nav60392961a.gif')\" alt=\"\" border=0 src=\"images\/nav60392961i.gif\"&gt;&lt;\/a&gt;&lt;\/div&gt;\r\n&lt;div id=\"nav12d\" style=\"position:absolute; left:540px; top:185px; z-index:0\"&gt;&lt;a onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('nav12','','images\/nav60392962a.gif',1)\" href=\"SearchProduct.jsp\"&gt;&lt;img name=\"nav12\" onLoad=\"MM_preloadImages('images\/nav60392962a.gif')\" alt=\"\" border=0 src=\"images\/nav60392962i.gif\"&gt;&lt;\/a&gt;&lt;\/div&gt;\r\n&lt;div id=\"nav13d\" style=\"position:absolute; left:711px; top:185px; z-index:0\"&gt;&lt;a onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('nav13','','images\/nav60392963a.gif',1)\" href=\"deleteProduct.jsp\"&gt;&lt;img name=\"nav13\" onLoad=\"MM_preloadImages('images\/nav60392963a.gif')\" alt=\"\" border=0 src=\"images\/nav60392963i.gif\"&gt;&lt;\/a&gt;&lt;\/div&gt;\r\n&lt;div id=\"nav14d\" style=\"position:absolute; left:882px; top:185px; z-index:0\"&gt;&lt;a onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('nav14','','images\/nav60392964a.gif',1)\" href=\"SearchAll.jsp\"&gt;&lt;img name=\"nav14\" onLoad=\"MM_preloadImages('images\/nav60392964a.gif')\" alt=\"\" border=0 src=\"images\/nav60392964i.gif\"&gt;&lt;\/a&gt;&lt;\/div&gt;\r\n&lt;div id=\"nav15d\" style=\"position:absolute; left:1053px; top:185px; z-index:0\"&gt;&lt;a onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('nav15','','images\/nav60392965i_3.gif',1)\" href=\"UpdateProduct.jsp\"&gt;&lt;img name=\"nav15\" onLoad=\"MM_preloadImages('images\/nav60392965a.gif')\" alt=\"\" border=0 src=\"images\/nav60392965i.gif\"&gt;&lt;\/a&gt;&lt;\/div&gt;\r\n&lt;div id=\"nav16d\" style=\"position:absolute; left:1224px; top:185px; z-index:0\"&gt;&lt;a onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('nav16','','images\/nav60392966a.gif',1)\" href=\"#\"&gt;&lt;img name=\"nav16\" onLoad=\"MM_preloadImages('images\/nav60392966a.gif')\" alt=\"\" border=0 src=\"images\/nav60392966i.gif\"&gt;&lt;\/a&gt;&lt;\/div&gt;\r\n&lt;div id=\"nav17d\" style=\"position:absolute; left:1395px; top:185px; z-index:0\"&gt;&lt;a onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('nav17','','images\/nav60392967a.gif',1)\" href=\"#\"&gt;&lt;img name=\"nav17\" onLoad=\"MM_preloadImages('images\/nav60392967a.gif')\" alt=\"\" border=0 src=\"images\/nav60392967i.gif\"&gt;&lt;\/a&gt;&lt;\/div&gt;\r\n&lt;div id=\"nav18d\" style=\"position:absolute; left:1566px; top:185px; z-index:0\"&gt;&lt;a onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('nav18','','images\/nav60392968a.gif',1)\" href=\"#\"&gt;&lt;img name=\"nav18\" onLoad=\"MM_preloadImages('images\/nav60392968a.gif')\" alt=\"\" border=0 src=\"images\/nav60392968i.gif\"&gt;&lt;\/a&gt;&lt;\/div&gt;\r\n\r\n&lt;div id=\"image1\" style=\"position:absolute; overflow:hidden; left:46px; top:10px; width:184px; height:155px; z-index:1\"&gt;&lt;img src=\"images\/123.jpg\" alt=\"\" title=\"\" border=0 width=184 height=155&gt;&lt;\/div&gt;\r\n\r\n&lt;div id=\"image2\" style=\"position:absolute; overflow:hidden; left:1571px; top:17px; width:184px; height:155px; z-index:2\"&gt;&lt;img src=\"images\/123.jpg\" alt=\"\" title=\"\" border=0 width=184 height=155&gt;&lt;\/div&gt;\r\n\r\n&lt;div id=\"text1\" style=\"position:absolute; overflow:hidden; left:279px; top:49px; width:1285px; height:90px; z-index:3\"&gt;\r\n&lt;div class=\"wpmd\"&gt;\r\n&lt;div&gt;&lt;font color=\"#FF9900\" class=\"ws48\"&gt;&amp;nbsp; Data Flair Product Management System&lt;\/font&gt;&lt;\/div&gt;\r\n&lt;\/div&gt;&lt;\/div&gt;\r\n\r\n&lt;\/body&gt;\r\n&lt;\/html&gt;<\/pre>\n<h3>Program 4<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">package dao;\r\nimport connection.MyConnection;\r\nimport java.sql.*;\r\nimport model.Product;\r\nimport java.util.*;\r\npublic class ProductDAO \r\n{\r\n         public static boolean checkLogin(String user,String pass) throws Exception\r\n         {\r\n             Connection con=null;\r\n             con=MyConnection.getConnection();\r\n             PreparedStatement ps=null;\r\n             String sql;\r\n             ResultSet rs=null;\r\n             sql=\"select * from productlogin where username=? and password=?\";\r\n             ps=con.prepareStatement(sql);\r\n             ps.setString(1, user);\r\n             ps.setString(2, pass);\r\n             rs=ps.executeQuery();\r\n             if(rs.next())\r\n                 return true;\r\n             \r\n            return false; \r\n         }\r\n        public boolean updateProduct(Product P) throws Exception\r\n        {\r\n             Connection con=null;\r\n             con=MyConnection.getConnection();\r\n             PreparedStatement ps=null;\r\n             String sql;\r\n             sql=\"update product set pname=?,qty=?,amount=?,type=? where pid=?\";\r\n             ps=con.prepareStatement(sql);\r\n             ps.setString(1, P.getProdname());\r\n             ps.setInt(2, P.getProdqty());\r\n             ps.setInt(3, P.getProdamt());\r\n             ps.setString(4, P.getProdtype());\r\n             ps.setInt(5, P.getProdid());\r\n             if(ps.executeUpdate()&gt;0)\r\n                 return true;\r\n         \r\n             return false;\r\n        }        \r\n    \r\n         public boolean insertProduct(Product P) throws Exception\r\n         {\r\n             Connection con=null;\r\n             con=MyConnection.getConnection();\r\n             PreparedStatement ps=null;\r\n             String sql;\r\n             sql=\"insert into product values(?,?,?,?,?)\";\r\n             ps=con.prepareStatement(sql);\r\n             ps.setInt(1, P.getProdid());\r\n             ps.setString(2, P.getProdname());\r\n             ps.setInt(3, P.getProdqty());\r\n             ps.setInt(4,P.getProdamt());\r\n             ps.setString(5, P.getProdtype());\r\n             if(ps.executeUpdate()&gt;0)\r\n                 return true;\r\n                    return false; \r\n         }\r\n         public int autoIncrement() throws Exception\r\n         {\r\n             Connection con=null;\r\n             con=MyConnection.getConnection();\r\n             PreparedStatement ps=null;\r\n             ResultSet rs=null;\r\n             String sql;\r\n             int prodid=101;\r\n             sql=\"select max(pid) from product\";\r\n             ps=con.prepareStatement(sql);\r\n             rs=ps.executeQuery();\r\n             if(rs.next())\r\n             {   \r\n                 prodid=rs.getInt(1);\r\n                 ++prodid;\r\n             }    \r\n             return prodid;    \r\n         }\r\n     public ArrayList&lt;Product&gt; searchAll()throws Exception\r\n     {\r\n             Connection con=null;\r\n             con=MyConnection.getConnection();\r\n             PreparedStatement ps=null;\r\n             ResultSet rs=null;\r\n             String sql;\r\n             sql=\"select * from product\";\r\n             ps=con.prepareStatement(sql);\r\n             rs=ps.executeQuery();\r\n             ArrayList&lt;Product&gt;list=new ArrayList&lt;Product&gt;();\r\n             while(rs.next())\r\n             {\r\n               Product P=new Product(); \r\n               P.setProdid(rs.getInt(1));\r\n               P.setProdname(rs.getString(2));\r\n               P.setProdqty(rs.getInt(3));\r\n               P.setProdamt(rs.getInt(4));\r\n               P.setProdtype(rs.getString(5));\r\n               list.add(P);\r\n               P=null;\r\n             }\r\n             \r\n         return list;      \r\n       }\r\n      public Product searchProduct(int prodid) throws Exception\r\n      {\r\n             Connection con=null;\r\n             con=MyConnection.getConnection();\r\n             PreparedStatement ps=null;\r\n             ResultSet rs=null;\r\n             String sql;\r\n             sql=\"select * from product where pid=?\";\r\n             ps=con.prepareStatement(sql);\r\n             ps.setInt(1, prodid);\r\n             rs=ps.executeQuery();\r\n             Product P=new Product();\r\n             if(rs.next())\r\n             {\r\n               P.setProdid(rs.getInt(1));\r\n               P.setProdname(rs.getString(2));\r\n               P.setProdqty(rs.getInt(3));\r\n               P.setProdamt(rs.getInt(4));\r\n               P.setProdtype(rs.getString(5));\r\n             }\r\n             else\r\n                 P=null;\r\n           return P;  \r\n      }\r\n      public boolean deleteRecord(int pid) throws Exception\r\n      {\r\n             Connection con=null;\r\n             con=MyConnection.getConnection();\r\n             PreparedStatement ps=null;\r\n             ResultSet rs=null;\r\n             String sql;\r\n             sql=\"delete from product where pid=?\";\r\n             ps=con.prepareStatement(sql);\r\n             ps.setInt(1, pid);\r\n             if(ps.executeUpdate()&gt;0)\r\n                 return true;\r\n             \r\n          return false;\r\n      }\r\n      \r\n}<\/pre>\n<h3>Program 5<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">&lt;%-- \r\n    Document   : index\r\n    Created on : Nov 15, 2023, 4:13:53 PM\r\n    Author     : admin\r\n--%&gt;\r\n\r\n&lt;%@page import=\"dao.ProductDAO\"%&gt;\r\n&lt;%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%&gt;\r\n&lt;!DOCTYPE html&gt;\r\n&lt;html&gt;\r\n    &lt;head&gt;\r\n        &lt;meta http-equiv=\"Content-Type\" content=\"text\/html; charset=UTF-8\"&gt;\r\n        &lt;title&gt;JSP Page&lt;\/title&gt;\r\n    &lt;\/head&gt;\r\n    &lt;body&gt;\r\n       &lt;center&gt; \r\n           &lt;form method=\"post\" action=\"index.jsp\"&gt;\r\n         &lt;table border=\"1\"&gt;\r\n             &lt;tr&gt;\r\n                 &lt;th&gt;User Name&lt;\/th&gt;\r\n                 &lt;td&gt;&lt;input type=\"text\" name=\"txtuser\"&gt;&lt;\/td&gt;\r\n             &lt;\/tr&gt;\r\n             &lt;tr&gt;\r\n                 &lt;th&gt;Password&lt;\/th&gt;\r\n                 &lt;td&gt;&lt;input type=\"password\" name=\"txtpass\"&gt;&lt;\/td&gt;\r\n             &lt;\/tr&gt;\r\n             &lt;tr&gt;\r\n                 &lt;td&gt;&lt;\/td&gt;\r\n                 &lt;td&gt;\r\n                     &lt;input type=\"submit\" value=\"Login\"&gt;\r\n                     &lt;input type=\"reset\" value=\"Reset\"&gt;\r\n                 &lt;\/td&gt;\r\n             &lt;\/tr&gt;\r\n         &lt;\/table&gt;\r\n          &lt;% \r\n             String user=null,pass=null;\r\n             user=request.getParameter(\"txtuser\");\r\n             pass=request.getParameter(\"txtpass\");\r\n             if(user!=null&amp;&amp; pass!=null)\r\n             {\r\n                   if(ProductDAO.checkLogin(user, pass))\r\n                       response.sendRedirect(\"header.jsp\");\r\n                   else\r\n                     out.println(\"&lt;font color=red size=5&gt;Invalid user id or password&lt;\/font&gt;\"); \r\n             }\r\n                     \r\n          %&gt;  \r\n         &lt;\/center&gt;    \r\n    &lt;\/body&gt;\r\n&lt;\/html&gt;<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Program 1 &lt;%&#8211; Document : InsertProduct Created on : Nov 6, 2023, 1:22:08 PM Author : admin &#8211;%&gt; &lt;%@page import=&#8221;dao.ProductDAO&#8221;%&gt; &lt;%@page contentType=&#8221;text\/html&#8221; pageEncoding=&#8221;UTF-8&#8243;%&gt; &lt;%@include file=&#8221;header.jsp&#8221;%&gt; &lt;!DOCTYPE html&gt; &lt;%! int pid; %&gt; &lt;html&gt; &lt;head&gt; &lt;meta&#46;&#46;&#46;<\/p>\n","protected":false},"author":86671,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31448],"tags":[31873,31871,31962,31960,31872,31915,31961],"class_list":["post-135734","post","type-post","status-publish","format-standard","hentry","category-advanced-java-tutorials","tag-advanced-java","tag-advanced-java-practical","tag-advanced-java-product-management-system","tag-advanced-java-product-management-system-project","tag-advanced-java-program","tag-advanced-java-project","tag-product-management-system-project"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Advanced Java Project - Product Management System Part-8 - DataFlair<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/advanced-java-product-management-system-part-8\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Advanced Java Project - Product Management System Part-8 - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Program 1 &lt;%-- Document : InsertProduct Created on : Nov 6, 2023, 1:22:08 PM Author : admin --%&gt; &lt;%@page import=&quot;dao.ProductDAO&quot;%&gt; &lt;%@page contentType=&quot;text\/html&quot; pageEncoding=&quot;UTF-8&quot;%&gt; &lt;%@include file=&quot;header.jsp&quot;%&gt; &lt;!DOCTYPE html&gt; &lt;%! int pid; %&gt; &lt;html&gt; &lt;head&gt; &lt;meta&#046;&#046;&#046;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/advanced-java-product-management-system-part-8\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-10T05:20:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-10T05:34:17+00:00\" \/>\n<meta name=\"author\" content=\"TechVidvan Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"TechVidvan Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Advanced Java Project - Product Management System Part-8 - DataFlair","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/advanced-java-product-management-system-part-8\/","og_locale":"en_US","og_type":"article","og_title":"Advanced Java Project - Product Management System Part-8 - DataFlair","og_description":"Program 1 &lt;%-- Document : InsertProduct Created on : Nov 6, 2023, 1:22:08 PM Author : admin --%&gt; &lt;%@page import=\"dao.ProductDAO\"%&gt; &lt;%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%&gt; &lt;%@include file=\"header.jsp\"%&gt; &lt;!DOCTYPE html&gt; &lt;%! int pid; %&gt; &lt;html&gt; &lt;head&gt; &lt;meta&#46;&#46;&#46;","og_url":"https:\/\/data-flair.training\/blogs\/advanced-java-product-management-system-part-8\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2024-05-10T05:20:53+00:00","article_modified_time":"2024-05-10T05:34:17+00:00","author":"TechVidvan Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"TechVidvan Team","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/advanced-java-product-management-system-part-8\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/advanced-java-product-management-system-part-8\/"},"author":{"name":"TechVidvan Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/0e594f928e31fc96628ac40f6ae74f49"},"headline":"Advanced Java Project &#8211; Product Management System Part-8","datePublished":"2024-05-10T05:20:53+00:00","dateModified":"2024-05-10T05:34:17+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/advanced-java-product-management-system-part-8\/"},"wordCount":14,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"keywords":["advanced java","advanced java practical","advanced java product management system","advanced java product management system project","advanced java program","advanced java project","product management system project"],"articleSection":["Advanced Java Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/advanced-java-product-management-system-part-8\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/advanced-java-product-management-system-part-8\/","url":"https:\/\/data-flair.training\/blogs\/advanced-java-product-management-system-part-8\/","name":"Advanced Java Project - Product Management System Part-8 - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"datePublished":"2024-05-10T05:20:53+00:00","dateModified":"2024-05-10T05:34:17+00:00","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/advanced-java-product-management-system-part-8\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/advanced-java-product-management-system-part-8\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/advanced-java-product-management-system-part-8\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Advanced Java Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/advanced-java-tutorials\/"},{"@type":"ListItem","position":3,"name":"Advanced Java Project &#8211; Product Management System Part-8"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/0e594f928e31fc96628ac40f6ae74f49","name":"TechVidvan Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c89190da3d4010c71ba476b618ab10fdc2335c82cdfa0ad5002d98d0f2473444?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c89190da3d4010c71ba476b618ab10fdc2335c82cdfa0ad5002d98d0f2473444?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c89190da3d4010c71ba476b618ab10fdc2335c82cdfa0ad5002d98d0f2473444?s=96&d=mm&r=g","caption":"TechVidvan Team"},"description":"TechVidvan Team provides high-quality content &amp; courses on AI, ML, Data Science, Data Engineering, Data Analytics, programming, Python, DSA, Android, Flutter, full stack web dev, MERN, and many latest technology.","url":"https:\/\/data-flair.training\/blogs\/author\/test001\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/135734","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/86671"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=135734"}],"version-history":[{"count":4,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/135734\/revisions"}],"predecessor-version":[{"id":137039,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/135734\/revisions\/137039"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=135734"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=135734"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=135734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}