earn

Friday, October 29, 2010

UserList.jsp


    UserList.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 List</title> </head><body><form method="post" action="UDescp.jsp"> <div style="position: absolute; width: 997; height: 178; z-index: 1; left:0px; top: 36px; right: 2; bottom:1024" id="layer4"><div style="position: absolute; width: 181; height: 31; z-index: 1; left: 10px; top: -33px" id="layer1"><img border="0" src="images/logo5.GIF" width="181" height="31"></div><img border="0" src="images/contacttop-img.jpg" width="997" height="178"></div>   <div style="position: absolute; width: 831px; height: 325px; z-index: 2; left: 166px; top: 225px" id="layer6"><img border="0" src="images/bkg.gif" width="831" height="325"></div><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">
<!-- Begin Free-Web-Buttons.com -->
<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">
<a href="Home.jsp" title="Home" style="background-image:url(images/bthyzy6.png);width:153px;height:25px;display:block;"><br/></a></td></tr>
<tr><td style="padding-bottom:15px" title ="Contact Us">
<a href="ContactUs.jsp" title="Contact Us" style="background-image:url(images/btkyzy6.png);width:153px;height:25px;display:block;"><br/></a></td></tr>
<tr><td style="padding-bottom:15px" title ="About Us">
<a href="AboutUs.jsp" title="About Us" style="background-image:url(images/btgyzy6.png);width:153px;height:25px;display:block;"><br/></a></td></tr>
<tr><td style="padding-bottom:15px" title ="User">
<a href="UserList.jsp" title="User.jsp" style="background-image:url(images/btcxzy6.png);width:153px;height:25px;display:block;"><br/></a></td></tr>
<tr><td style="padding-bottom:15px" title ="Add">
<a href="UAdd.jsp" title="Add" style="background-image:url(images/bt5xzy6.png);width:153px;height:25px;display:block;"></a></td></tr>
</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,&nbsp;2009. All RightsReserved.</font></div><p><img border="0" src="images/bg_footer.gif" width="832" height="32"></div><div style="position: absolute; left: 889px; top: 13px; width: 97px; height: 18px; z-index: 4" id="layer2">
<a href="Home.jsp">Home</a>&nbsp;&nbsp;&nbsp;<a href="User.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;
            Statement s1=null;
            ResultSet rs=null;
            String User;
            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 users");
            %>
            <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/imagesArrow.jpg" width="111" height="111"></div>
       <div style="position: absolute; left: 353px; top: 255px; width: 260px; height: 25px; z-index: 5" id="layer9">
           <table border="0" width="100%">
            <%
            while(rs.next())
            {
                User=rs.getString(1);
            %>
            <tr><td nowrap align="left">
              &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="radio" name="Ucode" value="<%=User%>" checked="checked"> <%=User%>
</div></td></tr>
                 <%
            }   
            %>
           <tr><td><br>            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="submit" value="Submit" name="SUBMIT">&nbsp;&nbsp;&nbsp;&nbsp;
                                                <input type="reset" value="Reset" name="Cancel"></td></tr></table>
           <%
            }
            catch(Exception e)
            {
            out.println("Error"+e);
            }
            finally
            { con.close();         
  }            %></form>  </body></html>

No comments:

Post a Comment