Computer Project

Wednesday, May 23, 2012

PViewMode.jsp

<%@page contentType="text/html"%>

<%@page pageEncoding="UTF-8"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

"http://www.w3.org/TR/html4/loose.dtd">

<%@ page language="java" import="java.sql.*"%>

<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Product View Mode</title>

<!--

function valid(form)

{

var field1=form.EditProduct;

EditProduct=field1.value;

if(EditProduct.length==0)

{

alert("The Product Descrition Field Cannot Be Left Blank");

field1.focus();

return false;

}

//-->

</SCRIPT> </head>

<body>

Connection con=null;

Statement s=null;

ResultSet rs=null;

String ViewModeSelected=request.getParameter("ViewMode");

ViewModeSelected=ViewModeSelected.trim();

</table></div>

<div style="position: absolute; width: 361px; height: 18px; z-index: 1; left: 194px; top: 20px" id="layer8" align="center"><font size="3">Copyright © SureVac Call Management, 2009. All Rights Reserved.</font></div><p><img border="0" src="images/bg_footer.gif" width="832" height="32"></div>

if(ViewModeSelected.equals("ListAll"))

{

<b><font color="#0000FF" size="4" face="Calibri">To view all the products

use the following link.</font></b><p><b>

ListAll</a></font></b></div>

}

else if(ViewModeSelected.equals("Delete"))

{

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

// con=DriverManager.getConnection("jdbc:odbc:ds","sa","niit");

con=DriverManager.getConnection("jdbc:odbc:SureVacCallDS","sa","P@ssw0rd");

s=con.createStatement();

rs=s.executeQuery("Select code from Product");

<tr>

To delete a product select any one from the drop down list.</font></b></td>

while(rs.next())

{

}

</select></p>

</tr>

<tr>

</tr></table></div>

}

catch(Exception e)

{

out.println("There are some invalid data::: "+"\n"+e);

}

finally

{

con.close();

}

</form>

}

else if(ViewModeSelected.equals("Edit"))

{

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

// con=DriverManager.getConnection("jdbc:odbc:ds","sa","niit");

con=DriverManager.getConnection("jdbc:odbc:SureVacCallDS","sa","P@ssw0rd");

s=con.createStatement();

rs=s.executeQuery("Select code from Product");

<tr>

To edit a product select any one from the drop down list.</font></b></td>

</tr>

<tr>

while(rs.next())

{

}

</select>      

</td>

</tr>

</table>

</div>

}

catch(Exception e)

{

out.println("There are some invalid data::: "+"\n"+e);

}

finally

{

con.close();

}

</form>

}

else

{

<b><font color="#0000FF" size="4" face="Calibri">To view all the products

use the following link.</font></b><p><b>

ListAll</a></font></b></div>

}

</body>

</html>

PAdd.jsp

<%@page contentType="text/html"%>

<%@page pageEncoding="UTF-8"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

"http://www.w3.org/TR/html4/loose.dtd">

<%@ page language="java" import="java.sql.*"%><html><head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<title>Product Add</title>

<!--

function valid(form)

{

var field1=form.ProdId;

var field2=form.Descp;

ProdId=field1.value;

Descp=field2.value;

if(ProdId.length==0)

{

alert("The ProductId Field Cannot Be Left Blank");

field1.focus();

return false;

}

else if(Descp.length==0)

{

alert("The Description Field Cannot Be Left Blank");

field2.focus();

return false;

}

//-->

</SCRIPT>

</head>

<body>

Reserved.</font></div>

<p>

<br>

Connection con=null;

Statement s;

ResultSet rs=null;

int ctr;

String code,codeval;

String finalcode;

String fcode;

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

// con=DriverManager.getConnection("jdbc:odbc:ds","sa","niit");

con=DriverManager.getConnection("jdbc:odbc:SureVacCallDS","sa","P@ssw0rd");

s=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

rs=s.executeQuery("Select code from Product");

if(rs.last()==true)

{

code=rs.getString(1).toString();

codeval=code.substring(1,4);

ctr=Integer.parseInt(codeval);

if((ctr>=1)&&(ctr<9))

{

ctr=ctr+1;

finalcode="P00"+ctr;

fcode=finalcode;

</table>

</div>

<tr>

<b><font color="#0000CC"><font size="4">Product Code</font>: </font></b>

</td>

<INPUT TYPE="TEXT" NAME="ProdId" size="4" maxlength="4" VALUE="<%=fcode%>" READONLY="readonly"></td>

</tr>

<tr>

<b>Product Description:</b></font></td>

</tr>

<tr>

</font></b> </div>

}

else if((ctr>=9)&&(ctr<99))

{

ctr=ctr+1;

finalcode="P0"+ctr;

fcode=finalcode;

<div style="position: absolute; width: 148px; height: 217px; z-index: 1; left: -380px; top: -19px;right: 2" id="layer2"><style>#web-buttons-idhyzy6 a{display:block;color:transparent;} #web-buttons-idhyzy6 a:hover{background-position:left bottom;}a#web-buttons-idhyzy6a {display:none}</style><table id="web-buttons-idhyzy6" width=0 cellpadding=0 cellspacing=0 border=0><tr><td style="padding-bottom:15px" title ="Home">

<b><font color="#0000CC"><font size="4">Product Code</font>: </font></b></td>

<td height="54" width="156" align="left"><INPUT TYPE="TEXT" NAME="ProdId" size="4" maxlength="4" VALUE="<%=fcode%>" READONLY="readonly"></td>

</tr>

<tr>

<font color="#0000CC" size="4" face="Calibri"><b>Product Description:</b></font></td><td width="156" height="48"><INPUT TYPE="text" NAME="Descp"></td>

</tr><tr>

<td>

</tr></table></font></b> </div>

}

else

{

out.println("Try again");

}

catch(Exception e)

{

out.println("There are some invalid data::: "+"\n"+e);

}

finally

{

con.close();

}

%></form></body></html>

FAdd.jsp

<%@page contentType="text/html"%>

<%@page pageEncoding="UTF-8"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

"http://www.w3.org/TR/html4/loose.dtd"><%@ page language="java" import="java.sql.*"%>

<title>Franchisee Add</title> <SCRIPT LANGUAGE="JAVASCRIPT">

<!--

function valid(form)

{

var field1=form.FCode;

var field2=form.FName;

var field3=form.FAdd;

var field4=form.FPhone;

FCode=field1.value;

FName=field2.value;

FAdd=field3.value;

FPhone=field4.value;

if(FCode.length==0)

{

alert("The Franchisee Code Field Cannot Be Left Blank");

field1.focus();

return false;

}

else if(FName.length==0)

{

alert("The Franchisee Name Field Cannot Be Left Blank");

field2.focus();

return false;

}

else if(FAdd.length==0)

{

alert("The Franchisee Address Field Cannot Be Left Blank");

field3.focus();

return false;

}

else if(FPhone.length==0)

{

alert("The Franchisee Phone Field Cannot Be Left Blank");

field4.focus();

return false;

}

//-->

</SCRIPT></head>

</table> </div><div style="position: absolute; width: 361px; height: 18px; z-index: 1; left: 194px; top: 20px" id="layer8" align="center"><font size="3">Copyright © SureVac Call Management, 2009. All Rights Reserved.</font></div>

</div>

Connection con=null;

Statement s;

ResultSet rs=null;

int ctr;

String code,codeval;

String finalcode;

String fcode;

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

// con=DriverManager.getConnection("jdbc:odbc:ds","sa","niit");

con=DriverManager.getConnection("jdbc:odbc:SureVacCallDS","sa","P@ssw0rd");

s=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

rs=s.executeQuery("Select code from Company");

if(rs.last()==true)

{

code=rs.getString(1).toString();

codeval=code.substring(1,4);

ctr=Integer.parseInt(codeval);

if((ctr>=1)&&(ctr<9))

{

ctr=ctr+1;

finalcode="F00"+ctr;

fcode=finalcode;

<table border="0" width="100%" style="border-collapse: collapse"><tr><td width="150" align="left" height="40" valign="top"><font face="Calibri" size="4" color="#0000FF">Franchisee Code :</font></td>

<input type="text" name="FCode" value="<%=fcode%>" READONLY="readonly">

</td>

</tr>

<tr>

<font face="Calibri" size="4" color="#0000FF">Franchisee

Name :</font></td>

</td>

</tr>

<tr>

<font face="Calibri" size="4" color="#0000FF">Franchisee

Address :</font></td>

</td></tr><tr>

<font face="Calibri" size="4" color="#0000FF">Franchisee

Phone :</font></td><td align="left" height="43" valign="top"><input type="text" name="FPhone" size="20" maxlength="11"></td></tr><tr><td width="150" align="left" valign="top">

</tr>

</table>

</div>

}

else if((ctr>=9)&&(ctr<99))

{

ctr=ctr+1;

finalcode="F0"+ctr;

fcode=finalcode;

<font face="Calibri" size="4" color="#0000FF">Franchisee Code :</font></td>

<input type="text" name="FCode" value="<%=fcode%>" READONLY="readonly">

</td></tr><tr>

<font face="Calibri" size="4" color="#0000FF">Franchisee

Name :</font></td>

</td></tr><tr>

<font face="Calibri" size="4" color="#0000FF">Franchisee

Address :</font></td>

<font face="Calibri" size="4" color="#0000FF">Franchisee

Phone :</font></td>

</tr>

<tr>

</div>

}

else

{

out.println("Try again");

}

catch(Exception e)

{

out.println("There are some invalid data::: "+"\n"+e);

}

finally

{

con.close();

}

<</body></html>

earn

Wednesday, May 23, 2012

PViewMode.jsp

PAdd.jsp

FAdd.jsp