 |
|
 |
Personal Info And Contact Details
|
<%
String name1;
//String name=request.getParameter("username");
//String pass=request.getParameter("password");
//session.putValue("name1",name);
//session.putValue("sid",session.getId());
String name="chandru";
Connection con;
ResultSet rs,rs1,rs2,rs3,rs4,rs5,rs6,rs7;
Statement st,st1,st2,st3,st4,st5,st6,st7;
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost/lexnet2_lexadmin","lexnet2_lexnet2","test");
st=con.createStatement();
st1=con.createStatement();
st2=con.createStatement();
st3=con.createStatement();
st4=con.createStatement();
st5=con.createStatement();
st6=con.createStatement();
st7=con.createStatement();
rs=st.executeQuery("select name,username,desi,class1,add1,telo,telh,mail1,mail2 from adminfac where username='"+name+"'");
rs1=st1.executeQuery("select researchint from adminfac where username='"+name+"'");
rs2=st2.executeQuery("select publications from adminfac where username='"+name+"'");
rs3=st3.executeQuery("select profile from adminfac where username='"+name+"'");
rs4=st4.executeQuery("select sponspro from adminfac where username='"+name+"'");
rs5=st5.executeQuery("select research from adminfac where username='"+name+"'");
rs6=st6.executeQuery("select courses from adminfac where username='"+name+"'");
rs7=st7.executeQuery("select others from adminfac where username='"+name+"'");
if(rs.next())
{
%>
<% out.println(rs.getString("name")); %>
<% out.println(rs.getString("desi")); %>
<% out.println(rs.getString("class1")); %>
Room No
<% out.println(rs.getString("add1")); %>
Tel: <% out.println(rs.getString("telo")); %>
(O) ; <% out.println(rs.getInt("telh")); %>(R)
<% out.println(rs.getString("mail1")); %>
<% out.println(rs.getString("mail2")); %> |
Research
Interests
|
<%
if(rs1.next())
{
%>
|
<% out.println(rs1.getString("researchint")); %> |
<%
}
%>
Publications / Patents / Conferences / Invited Lectures
|
<%
if(rs2.next())
{
%>
|
<% out.println(rs2.getString("publications")); %>
|
<%
}
%>
Career
Profile
|
<%
if(rs3.next())
{
%>
|
<% out.println(rs3.getString("profile")); %>
|
<%
}
%>
Sponsored
Projects / Collaborations
|
<%
if(rs4.next())
{
%>
|
<% out.println(rs4.getString("sponspro")); %>
|
<%
}
%>
Research
Group
|
<%
if(rs5.next())
{
%>
|
<% out.println(rs5.getString("research")); %>
|
<%
}
%>
Courses
|
<%
if(rs6.next())
{
%>
|
<% out.println(rs6.getString("courses")); %>
|
<%
}
%>
OthersCourses
|
<%
if(rs7.next())
{
%>
|
<% out.println(rs7.getString("others")); %>
|
<%
}
%>
<%
}
else{
response.sendRedirect("invalid.jsp");
}
con.close();
}
catch(SQLException sqle){
System.err.println(sqle.getMessage());
}
catch (ClassNotFoundException cnfe){
System.err.println(cnfe.getMessage());
}
catch (Exception e){
out.println(e.getMessage());
out.println("sql Exexption");
}
%>
|
|
|