Computer Project

Friday, October 29, 2010

CView.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">

<title>Customer View</title> </head> <body><form action="CViewMode.jsp"><div style="position: absolute; width: 997; height: 178; z-index: 1; left:0px; top: 36px; right: 2; bottom:1024" id="layer1">

Reserved.</font></div><p><img border="0" src="images/bg_footer.gif" width="832" height="32"></div> <br><div style="position: absolute; width: 309px; height: 28px; z-index: 4; left: 303px; top: 358px" id="layer9" align="center">

<option value="Delete">DELETE </option>

</select>        

</form>

</div>

</body>

</html>

Customer.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">

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

</table></div>

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

<font face="Calibri" size="4" color="#0000FF">This allows the Administrator

to view, edit and add Customers.</font><p><font face="Calibri" size="4" color="#0000FF">Only administrators have access to this page.</font></p><p><font face="Calibri" size="4" color="#0000FF">To perform each task please use the menus alongside.</font></div>

</body>

</html>

UEdit.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.*"%>

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

<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 pwd=request.getParameter("EditPwd");

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 users set Pwd=?, FName=?,LName=?");

ps.setString(1,pwd);

ps.setString(2,FName);

ps.setString(3,LName);

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>

UDelete.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>User Delete</title> </head>

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

earn

Friday, October 29, 2010

CView.jsp

Customer.jsp

UEdit.jsp

UDelete.jsp