<%-- 
    Document   : my_account
    Created on : 18 Oct, 2013, 11:39:37 PM
    Author     : samsung
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
	<title>Texas Holedem And Video Poker</title>
	<META http-equiv=Content-Type content="text/html; charset=windows-1252">
        <link rel="stylesheet" type="text/css" href="style/main.css">
        <script src="script/reg.js" type="text/javascript" language="JavaScript"></script>
        
</head>
<body topmargin=0 BGCOLOR="black">
<center>
<table cellSpacing=0 cellPadding=0 width=1024 border=0 height=100>
        <tr>
          <td width="30"></td>
          <td height=21><span class="tom">Texas Hold'em and Video Poker</span><br>
          <span class="sub_title">Turn Into The World Of Poker</span>
	  </td>
	</tr>
</table>
<br>
    <br>
                
      <table cellspacing="3" cellpadding="0" width="1024" border="0">
    <tr>
        <td width="712" height="20"></td><td align="right"><span class="footer"><b>Hello,<% out.println(session.getAttribute("uname")); %></b>&nbsp;&nbsp;|&nbsp;&nbsp;<a style="COLOR:white" href="my_account.jsp"><b>My Account</b></a>&nbsp;&nbsp;|&nbsp;&nbsp;<a style="COLOR:white" href="index.jsp"><span class="footer"><b>Logout</b></span></a></td>
   </tr>
    </table>
  
<table cellspacing="3" cellpadding="6" width="1024" border="0">
    <tr>
        <td colspan="2">
            
            <center><span class="reg">My Account</span><br>
            <span class="tf">Check Your Profile!!</span></center><br><br>
        </td>
        </table>
        
        <%
        try
        {
                 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
                 Connection con=DriverManager.getConnection("jdbc:odbc:pubs","sa","best");
                 Statement st=con.createStatement();
                 ResultSet rs = st.executeQuery("Select * from reg where(First_Name='"+session.getAttribute("uname")+"')");
                 while(rs.next())
                 {
                   
        %>
        <table cellspacing="6" cellpadding="6" width="1024" border="0">

                 <tr class="tf"><td align="right" width="512"><b>First Name:<b></td>
                 <td><% out.println(rs.getString(1));%></td></tr>
                 <tr class="tf"><td align="right" width="512"><b>Last Name:<b></td>
                 <td><% out.println(rs.getString(2));%></td></tr>
                 <tr class="tf"><td align="right" width="512"><b>Email-Id:<b></td>
                 <td><% out.println(rs.getString(3));%></td></tr>
                 <tr class="tf"><td align="right" width="512"><b>Password:<b></td>
                 <td><% out.println(rs.getString(4));%></td></tr>
                 <tr class="tf"><td align="right" width="512"><b>Age:<b></td>
                 <td><% out.println(rs.getString(5));%></td></tr>
                 <tr class="tf"><td align="right" width="512"><b>Country:<b></td>
                 <td><% out.println(rs.getString(6));%></td></tr>
                 <tr class="tf"><td align="right" width="512"><b>State:<b></td>
                 <td><% out.println(rs.getString(7));%></td></tr>
                 <tr class="tf"><td align="right" width="512"><b>Postal Code:<b></td>
                 <td><% out.println(rs.getString(8));%></td></tr>
                 <tr class="tf"><td align="right" width="512"><b>Gender:<b></td>
                 <td><% out.println(rs.getString(10));%></td></tr>
                 <tr class="tf"><td colspan="2" align="center">
                 <a href="my_account1.jsp"><img height="50" src="images/edit_logo.jpg" width="150" border="0"></a></td></tr>  
        <%             
                 }
        }
        catch(Exception e)
        {
                out.println(e);
        }
        %>
              
      
</table>
<br>
    <br>
        <br>
            <br>
<table cellSpacing=0 cellPadding=0 width=1024 border=0>
  
    <td></td>
    <td class=bodytext align=middle height=50>
			<strong>
				<span class="footer">
				<a style="COLOR:white" href="index.jsp">Home</a>&nbsp;&nbsp;|&nbsp;&nbsp;
				<a style="COLOR:white" href="registration.jsp">Register</a>&nbsp;&nbsp;|&nbsp;&nbsp;
				<a style="COLOR:white" href="about_game.jsp">About Game</a>&nbsp;&nbsp;|&nbsp;&nbsp;
				<a style="COLOR:white" href="faq.jsp">FAQ</a>&nbsp;&nbsp;|&nbsp;&nbsp;
				<a style="COLOR:white" href="feedback.jsp">Feedback</a>&nbsp;&nbsp;|&nbsp;&nbsp;
				<a style="COLOR:white" href="contact_us.jsp">Contact Us</a>
				
                                 </span>
			</strong>

      	 <tr>
    <td></td>
    <td class=bodytext align=middle height=35>
      <center><span class="tf">&nbsp;© 2010-2014 - GTU</span></center>
		</td>
	</tr>
</table>

</center></body></html>
