Computer Project: 2010

Friday, October 29, 2010

CEdit.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>

<title>Customer Edit</title></head>

<body>

<div style="position: absolute; width: 831px; height: 19px; z-index: 3; left: 166px; top: 558px" id="layer7"><div style="position: absolute; width: 148px; height: 219px; z-index: 1; left: -163px; top: -301px;right: 2" id="layer5"><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>

</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>

<a href="CView.jsp">Back</a><div style="position: absolute; width: 1; height: 18; z-index: 1; left: 37px; top: 0px" id="layer3"><img border="0" src="images/htc.gif" width="1" height="18"></div></div><%

Connection con=null;

PreparedStatement ps=null;

ResultSet rs=null;

String Ccode=request.getParameter("Code");

String FName=request.getParameter("EditFName");

String LName=request.getParameter("EditLName");

int rows=0;

FName=FName.trim();

LName=LName.trim();

try{

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

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

ps=con.prepareStatement("Update consumer set FName=?,LName=? where LoginId=?");

ps.setString(1,FName);

ps.setString(2,LName);

ps.setString(3,Ccode);

rows=ps.executeUpdate();

if(rows!=0)

{

<div style="position: absolute; left: 189px; top: 316px; width: 445px; height: 25px; z-index: 5" id="layer9"><font size="4" face="Calibri" color="#0000FF">Data has been Updated successfully. To continue use the back link above.</font></div><div style="border-style:solid; border-color:#FFFFFF; position: absolute; left: 675px; top: 233px; width: 300; height: 300; z-index: 7; " id="layer10"><img border="0" src="images/done.png" width="299" height="300"></div>

}

else

{

<div style="position: absolute; left: 189px; top: 316px; width: 445px; height: 25px; z-index: 5" id="layer9"><font size="4" face="Calibri" color="#0000FF">There are some invalid data::: Please try again</font></div>

}

catch(Exception e)

{

%><div style="position: absolute; left: 189px; top: 316px; width: 445px; height: 25px; z-index: 5" id="layer9"><font size="4" face="Calibri" color="#0000FF">There are some invalid data::: Please try again</font></div>

<%}

finally

{

con.close();

}

</body></html>

CDelete.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>Customer Delete</title> </head>

<body>

</table></div>

Reserved.</font></div><p>

</div>

Connection con=null;

PreparedStatement ps=null;

ResultSet rs=null;

String CLogin;

int rows=0;

CLogin=request.getParameter("Code");

try

{

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

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

ps=con.prepareStatement("Delete from Consumer where LoginId=?");

ps.setString(1,CLogin);

rows=ps.executeUpdate();

if(rows!=0)

{

<font size="4" face="Calibri" color="#0000FF">Data has been Deleted

successfully. To continue use the back link above.</font></div>

}

else

{

<font size="4" face="Calibri" color="#0000FF">There are some invalid data::: Please try again</font></div>

}

catch(Exception e)

{

<font size="4" face="Calibri" color="#0000FF">There are some invalid data::: Please try again</font></div>

}

finally

{

con.close();

}

</body>

</html>

CDescp.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>

<title>Customer Description</title>

</head>

<body>

</table></div>

Reserved.</font></div><p>

</div><%

String SelectF=request.getParameter("Ccode");

Connection con=null;

PreparedStatement ps=null;

ResultSet rs=null;

String Pwd,FName,LName;

SelectF=SelectF.trim();

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

try

{

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

ps=con.prepareStatement("Select * from Consumer where LoginId=?");

ps.setString(1,SelectF);

rs=ps.executeQuery();

<div style="border-style:groove; border-color:#0000FF; position: absolute; left: 857px; top: 418px; width: 111; height: 111; z-index: 7; " id="layer10"><img border="0" src="images/Database.jpg" width="111" height="111"></div><div style="position: absolute; left: 281px; top: 281px; width: 484px; height: 218px; z-index: 5" id="layer9"><%

while(rs.next())

{

Pwd=rs.getString(2);

FName=rs.getString(3);

LName=rs.getString(4);

<tr>

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

</td></tr><tr>

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

<tr>

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

</tr><tr>

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

}

catch(Exception e)

{

<img border="0" src="images/CA9QD8DV.jpg" width="124" height="124"></div><div style="position: absolute; left: 251px; top: 283px; width: 445px; height: 25px; z-index: 5" id="layer9"><table border="0" width="100%"><tr><td><font face="Calibri" size="4" color="#0000FF">Go back and please select a Franchisee to view its details.</td></tr></table></div><%

}finally

{

con.close();

} %></body></html>

CustomerList.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>Customer List</title> </head>

</table></div>

Reserved.</font></div><p>

Connection con=null;

Statement s1=null;

ResultSet rs=null;

String Customer;

try

{

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

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

s1=con.createStatement();

rs=s1.executeQuery("Select LoginId from consumer");

while(rs.next())

{

Customer=rs.getString(1);

                       <input type="radio" name="Ccode" value="<%=Customer%>" checked="checked"> <%=Customer%></div></td></tr>

<%}

              <input type="submit" value="Submit" name="SUBMIT">    <input type="reset" value="Reset" name="Cancel"></td></tr></table <%

}

catch(Exception e)

{

out.println("Error"+e);

}

finally

{con.close();}

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

earn

Friday, October 29, 2010

CEdit.jsp

CDelete.jsp

CDescp.jsp

CustomerList.jsp