Program 1
<%--
Document : InsertProduct
Created on : Nov 6, 2023, 1:22:08 PM
Author : admin
--%>
<%@page import="dao.ProductDAO"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@include file="header.jsp"%>
<!DOCTYPE html>
<%!
int pid;
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert JSP Page</title>
<script language="javascript">
function validate()
{
var pname,pqty,pamt;
pname=document.getElementById("PRODNAME").value;
pqty=document.getElementById("PRODQTY").value;
pamt=document.getElementById("PRODAMT").value;
if(pname=="")
{
alert("Product name can't be blank");
document.getElementById("PRODNAME").focus();
return false;
}
if(pname!="")
{
var asci;
for(i=0;i<pname.length;i++)
{
asci=pname.charCodeAt(i)
if(!((asci>=65&&asci<=91)||(asci>=97 && asci<=122)||asci==32))
{
alert("Only Character allowed in Name field....")
return false;
}
}
}
if(pqty=="")
{
alert("Product Qty can't be blank");
document.getElementById("PRODQTY").focus();
return false;
}
if(pamt=="")
{
alert("Product Amount can't be blank");
document.getElementById("PRODAMT").focus();
return false;
}
if(pqty<0 || pqty>5000)
{
alert("Product Qty between 0 to 5000 only");
document.getElementById("PRODQTY").focus();
return false;
}
if(pamt<0)
{
alert("Product Amount is invalid pls check");
document.getElementById("PRODAMT").focus();
return false;
}
return true;
}
</script>
</head>
<body>
<%
for(int i=1;i<=15;i++)
out.println("<br>");
ProductDAO pd=new ProductDAO();
pid=pd.autoIncrement();
%>
<center>
<font color="F19A15" size="7">Insert Product Page</font>
<br>
<form method="post" action="InsertData.jsp">
<table border="1">
<tr>
<th>Product Id</th>
<td><input type="text" name="txtid" id="PRODID" value=<%=pid%>></td>
</tr>
<tr>
<th>Product Name</th>
<td><input type="text" name="txtname" id="PRODNAME"></td>
</tr>
<tr>
<th>Quantity</th>
<td><input type="text" name="txtqty" id="PRODQTY"></td>
</tr>
<tr>
<th>Amount</th>
<td><input type="text" name="txtamt" id="PRODAMT"></td>
</tr>
<tr>
<th>Type of Product</th>
<td>
<input type="radio" name="rdtype" value="Solid">Solid
<input type="radio" name="rdtype" value="Liquid">Liquid
<input type="radio" name="rdtype" value="Gas">Gas
</td>
</tr>
<tr>
<td></td>
<td>
<input type="submit" value="Submit" onclick="return validate();">
<input type="reset" value="Reset">
</td>
</tr>
</table>
</form>
</center>
</body>
</html>
Program 2
<%--
Document : InsertData
Created on : Nov 6, 2023, 2:11:09 PM
Author : admin
--%>
<%@page import="dao.ProductDAO"%>
<%@page import="model.Product"%>
<%@page import="connection.MyConnection"%>
<%@page import="java.sql.Connection"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@include file="header.jsp"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<center>
<%
for(int i=1;i<=15;i++)
out.println("<br>");
%>
<%
int pid,pamount,pqty;
String pname,ptype;
pid=Integer.parseInt(request.getParameter("txtid"));
pname=request.getParameter("txtname");
pqty=Integer.parseInt(request.getParameter("txtqty"));
pamount=Integer.parseInt(request.getParameter("txtamt"));
ptype=request.getParameter("rdtype");
Product P=new Product();
P.setProdid(pid);
P.setProdname(pname);
P.setProdqty(pqty);
P.setProdamt(pamount);
P.setProdtype(ptype);
ProductDAO pd=new ProductDAO();
try
{
if(pd.insertProduct(P))
out.println("<h2>Record inserted.........</h2>");
}
catch(Exception e)
{
out.println(e);
}
%>
</center>
</body>
</html>
Program 3
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
<meta name="generator" content="Web Page Maker">
<style type="text/css">
/*----------Text Styles----------*/
.ws6 {font-size: 8px;}
.ws7 {font-size: 9.3px;}
.ws8 {font-size: 11px;}
.ws9 {font-size: 12px;}
.ws10 {font-size: 13px;}
.ws11 {font-size: 15px;}
.ws12 {font-size: 16px;}
.ws14 {font-size: 19px;}
.ws16 {font-size: 21px;}
.ws18 {font-size: 24px;}
.ws20 {font-size: 27px;}
.ws22 {font-size: 29px;}
.ws24 {font-size: 32px;}
.ws26 {font-size: 35px;}
.ws28 {font-size: 37px;}
.ws36 {font-size: 48px;}
.ws48 {font-size: 64px;}
.ws72 {font-size: 96px;}
.wpmd {font-size: 13px;font-family: 'Arial';font-style: normal;font-weight: normal;}
/*----------Para Styles----------*/
DIV,UL,OL /* Left */
{
margin-top: 0px;
margin-bottom: 0px;
}
</style>
<script language="JavaScript1.4" type="text/javascript">
<!--
function jsPlay(soundobj) {
var thissound= eval("document."+soundobj);
try {
thissound.Play();
}
catch (e) {
thissound.DoPlay();
}
}
//-->
</script>
<script language="javascript" type="text/javascript">
<!--
function MM_swapImgRestore() {
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() {
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) {
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() {
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>
<body>
<div id="nav10d" style="position:absolute; left:198px; top:185px; z-index:0"><a onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('nav10','','images/nav60392960a.gif',1)" href="header.jsp"><img name="nav10" onLoad="MM_preloadImages('images/nav60392960a.gif')" alt="" border=0 src="images/nav60392960i.gif"></a></div>
<div id="nav11d" style="position:absolute; left:369px; top:185px; z-index:0"><a onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('nav11','','images/nav60392961a.gif',1)" href="InsertProduct.jsp"><img name="nav11" onLoad="MM_preloadImages('images/nav60392961a.gif')" alt="" border=0 src="images/nav60392961i.gif"></a></div>
<div id="nav12d" style="position:absolute; left:540px; top:185px; z-index:0"><a onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('nav12','','images/nav60392962a.gif',1)" href="SearchProduct.jsp"><img name="nav12" onLoad="MM_preloadImages('images/nav60392962a.gif')" alt="" border=0 src="images/nav60392962i.gif"></a></div>
<div id="nav13d" style="position:absolute; left:711px; top:185px; z-index:0"><a onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('nav13','','images/nav60392963a.gif',1)" href="deleteProduct.jsp"><img name="nav13" onLoad="MM_preloadImages('images/nav60392963a.gif')" alt="" border=0 src="images/nav60392963i.gif"></a></div>
<div id="nav14d" style="position:absolute; left:882px; top:185px; z-index:0"><a onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('nav14','','images/nav60392964a.gif',1)" href="SearchAll.jsp"><img name="nav14" onLoad="MM_preloadImages('images/nav60392964a.gif')" alt="" border=0 src="images/nav60392964i.gif"></a></div>
<div id="nav15d" style="position:absolute; left:1053px; top:185px; z-index:0"><a onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('nav15','','images/nav60392965i_3.gif',1)" href="UpdateProduct.jsp"><img name="nav15" onLoad="MM_preloadImages('images/nav60392965a.gif')" alt="" border=0 src="images/nav60392965i.gif"></a></div>
<div id="nav16d" style="position:absolute; left:1224px; top:185px; z-index:0"><a onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('nav16','','images/nav60392966a.gif',1)" href="#"><img name="nav16" onLoad="MM_preloadImages('images/nav60392966a.gif')" alt="" border=0 src="images/nav60392966i.gif"></a></div>
<div id="nav17d" style="position:absolute; left:1395px; top:185px; z-index:0"><a onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('nav17','','images/nav60392967a.gif',1)" href="#"><img name="nav17" onLoad="MM_preloadImages('images/nav60392967a.gif')" alt="" border=0 src="images/nav60392967i.gif"></a></div>
<div id="nav18d" style="position:absolute; left:1566px; top:185px; z-index:0"><a onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('nav18','','images/nav60392968a.gif',1)" href="#"><img name="nav18" onLoad="MM_preloadImages('images/nav60392968a.gif')" alt="" border=0 src="images/nav60392968i.gif"></a></div>
<div id="image1" style="position:absolute; overflow:hidden; left:46px; top:10px; width:184px; height:155px; z-index:1"><img src="images/123.jpg" alt="" title="" border=0 width=184 height=155></div>
<div id="image2" style="position:absolute; overflow:hidden; left:1571px; top:17px; width:184px; height:155px; z-index:2"><img src="images/123.jpg" alt="" title="" border=0 width=184 height=155></div>
<div id="text1" style="position:absolute; overflow:hidden; left:279px; top:49px; width:1285px; height:90px; z-index:3">
<div class="wpmd">
<div><font color="#FF9900" class="ws48"> Data Flair Product Management System</font></div>
</div></div>
</body>
</html>
Program 4
package dao;
import connection.MyConnection;
import java.sql.*;
import model.Product;
import java.util.*;
public class ProductDAO
{
public static boolean checkLogin(String user,String pass) throws Exception
{
Connection con=null;
con=MyConnection.getConnection();
PreparedStatement ps=null;
String sql;
ResultSet rs=null;
sql="select * from productlogin where username=? and password=?";
ps=con.prepareStatement(sql);
ps.setString(1, user);
ps.setString(2, pass);
rs=ps.executeQuery();
if(rs.next())
return true;
return false;
}
public boolean updateProduct(Product P) throws Exception
{
Connection con=null;
con=MyConnection.getConnection();
PreparedStatement ps=null;
String sql;
sql="update product set pname=?,qty=?,amount=?,type=? where pid=?";
ps=con.prepareStatement(sql);
ps.setString(1, P.getProdname());
ps.setInt(2, P.getProdqty());
ps.setInt(3, P.getProdamt());
ps.setString(4, P.getProdtype());
ps.setInt(5, P.getProdid());
if(ps.executeUpdate()>0)
return true;
return false;
}
public boolean insertProduct(Product P) throws Exception
{
Connection con=null;
con=MyConnection.getConnection();
PreparedStatement ps=null;
String sql;
sql="insert into product values(?,?,?,?,?)";
ps=con.prepareStatement(sql);
ps.setInt(1, P.getProdid());
ps.setString(2, P.getProdname());
ps.setInt(3, P.getProdqty());
ps.setInt(4,P.getProdamt());
ps.setString(5, P.getProdtype());
if(ps.executeUpdate()>0)
return true;
return false;
}
public int autoIncrement() throws Exception
{
Connection con=null;
con=MyConnection.getConnection();
PreparedStatement ps=null;
ResultSet rs=null;
String sql;
int prodid=101;
sql="select max(pid) from product";
ps=con.prepareStatement(sql);
rs=ps.executeQuery();
if(rs.next())
{
prodid=rs.getInt(1);
++prodid;
}
return prodid;
}
public ArrayList<Product> searchAll()throws Exception
{
Connection con=null;
con=MyConnection.getConnection();
PreparedStatement ps=null;
ResultSet rs=null;
String sql;
sql="select * from product";
ps=con.prepareStatement(sql);
rs=ps.executeQuery();
ArrayList<Product>list=new ArrayList<Product>();
while(rs.next())
{
Product P=new Product();
P.setProdid(rs.getInt(1));
P.setProdname(rs.getString(2));
P.setProdqty(rs.getInt(3));
P.setProdamt(rs.getInt(4));
P.setProdtype(rs.getString(5));
list.add(P);
P=null;
}
return list;
}
public Product searchProduct(int prodid) throws Exception
{
Connection con=null;
con=MyConnection.getConnection();
PreparedStatement ps=null;
ResultSet rs=null;
String sql;
sql="select * from product where pid=?";
ps=con.prepareStatement(sql);
ps.setInt(1, prodid);
rs=ps.executeQuery();
Product P=new Product();
if(rs.next())
{
P.setProdid(rs.getInt(1));
P.setProdname(rs.getString(2));
P.setProdqty(rs.getInt(3));
P.setProdamt(rs.getInt(4));
P.setProdtype(rs.getString(5));
}
else
P=null;
return P;
}
public boolean deleteRecord(int pid) throws Exception
{
Connection con=null;
con=MyConnection.getConnection();
PreparedStatement ps=null;
ResultSet rs=null;
String sql;
sql="delete from product where pid=?";
ps=con.prepareStatement(sql);
ps.setInt(1, pid);
if(ps.executeUpdate()>0)
return true;
return false;
}
}
Program 5
<%--
Document : index
Created on : Nov 15, 2023, 4:13:53 PM
Author : admin
--%>
<%@page import="dao.ProductDAO"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<center>
<form method="post" action="index.jsp">
<table border="1">
<tr>
<th>User Name</th>
<td><input type="text" name="txtuser"></td>
</tr>
<tr>
<th>Password</th>
<td><input type="password" name="txtpass"></td>
</tr>
<tr>
<td></td>
<td>
<input type="submit" value="Login">
<input type="reset" value="Reset">
</td>
</tr>
</table>
<%
String user=null,pass=null;
user=request.getParameter("txtuser");
pass=request.getParameter("txtpass");
if(user!=null&& pass!=null)
{
if(ProductDAO.checkLogin(user, pass))
response.sendRedirect("header.jsp");
else
out.println("<font color=red size=5>Invalid user id or password</font>");
}
%>
</center>
</body>
</html>
