Sun Jan 09, 2011 2:28 pm
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<body bgcolor=568945>
<center><span style="background-color:green;font-size:45;border-style:solid;">Virtual Medical Home</h1></span></center>
<%!
String funame,query;
String fpwd;
Connection con;
Statement st;
ResultSet rs;
%>
<%
funame=request.getParameter("uname");
fpwd=request.getParameter("pwd");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("Jdbc:Odbc:vmh");
st=con.createStatement();
query="select * from login where uid='"+funame+"' and pwd='"+fpwd+"' ";
rs=st.executeQuery(query);
if(rs.next())
{
String role=rs.getString(3);
%>
<h1>WelCome <font face="Comic Sans MS" color=purple><%=rs.getString(1)%></font></h1>
<%
session.setAttribute("funame", funame);
session.setAttribute("role", role);
%>
<%
if(funame.equals("patient"))
{
%>
<%@include file="patientpage.html"%>
<%
}
else if(funame.equals("admin"))
{
%>
<%@include file="adminpage.html"%>
<%
}
%>
<%
}
else
{
%>
<h1><%=funame%> Invalid User</h1>
<%
}
}
catch(Exception e)
{
out.println(e);
}%>
</body> Sun Jan 09, 2011 3:52 pm
Sun Jan 09, 2011 4:46 pm
Mon Jan 10, 2011 2:16 pm
Mon Jan 10, 2011 10:56 pm
Tue Jan 11, 2011 1:35 pm
Tue Jan 11, 2011 2:27 pm
<%@include file="yourfile.jsp" %>
Thu Jan 13, 2011 2:54 pm
Thu Jan 13, 2011 4:20 pm
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com
Powered by phpBB © phpBB Group.