|
Personal Info
|
<%
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
// con = DriverManager.getConnection("jdbc:mysql://localhost/lexnet2_lexadmin","lexnet2_lexnet2","test");
con = DriverManager.getConnection("jdbc:mysql://localhost/iitDB","root","91don699629");
st=con.createStatement();
String image="";
//out.println("name :" + name + " Pass : " + pass);
rs=st.executeQuery("select name,username,desi,class1,add1,telo,telh,mail1,mail2,education,researchint,publications, profile, sponspro,research,courses,others from adminfac where username='"+name+"' and password ='"+pass+"'");
if(rs.next())
{
names = rs.getString("name");
desi = rs.getString("desi");
class1 = rs.getString("class1");
add1 = rs.getString("add1");
telo = rs.getString("telo");
telh = rs.getString("telh");
mail1 = rs.getString("mail1");
mail2 = rs.getString("mail2");
f= new File(application.getRealPath(".")+ "/iit/Photo/"+ name+"/personal");
f.mkdirs();
//out.println(f.toString());
String fr[] = f.list();
if(fr.length>0)
image = "Photo/"+name+"/personal/"+fr[0];
else
image = "images/default.bmp";
%>
| Name : |
<%=names %> |
|
| Designation : |
<%
if (desi!=null ){ out.println(desi); } else {out.println("");}
%>
|
| |
<% if (class1!=null ){ out.println(class1); } else {out.println("");} %>
|
| Address : |
<% if (add1!=null ){ out.println(add1); } else {out.println("");} %>
|
| Tel : |
<% if (telo!=null ){ out.println(telo + "(Off). " ); } else {out.println(""); }
if (telh!=null ){ out.println(telh + "(Res). " ); } else {out.println(""); }
%>
|
| Email
Id (s) : |
<% if (mail1!=null ){ out.println(mail1 + "" ); } else {out.println(""); }
if (mail2!=null ){ out.println(", " +mail2 + "" ); } else {out.println("");}
%>
|
|
|
Research
Interests
|
<%
researchint = rs.getString("researchint");
String fstr="";
if( !rs.wasNull() )
{
fstr= researchint;
}
else{
fstr= "Not Available";
}
f= new File(application.getRealPath(".")+ "/iit/Photo/"+ name+"/research/rs1");
f.mkdirs();
//out.println(f.toString());
String fr1[] = f.list();
if(fr1.length>0)
rsi1 = "Photo/"+name+"/research/rs1/"+fr1[0];
else
rsi1 = "images/default.bmp";
%>
|
|
<%
f= new File(application.getRealPath(".")+ "/iit/Photo/"+ name+"/research/rs2");
f.mkdirs();
//out.println(f.toString());
String fr2[] = f.list();
if(fr2.length>0)
rsi2 = "Photo/"+name+"/research/rs2/"+fr2[0];
else
rsi2 = "images/default.bmp";
%>
|
|
|
Educational
Background
|
|
<%
education = rs.getString("education");
String estr="";
if( !rs.wasNull() )
{
estr = education;
}
else{
estr="Not Available";
}
%>
|
Career Profile
|
|
<%
profile = rs.getString("profile");
String pstr="";
if( !rs.wasNull() )
{
pstr = profile;
}
else{
pstr="Not Available";
}
%>
|
Sponsored Projects / Collaborations
|
|
<%
sponspro = rs.getString("sponspro");
String sstr="";
if( !rs.wasNull() )
{
sstr = sponspro;
}
else{
sstr="Not Available";
}
%>
|
|
Publications / Patents / Conferences
/ Invited Lectures
|
<%
publication = rs.getString("publicationS");
String pubstr="";
if( !rs.wasNull() )
{
pubstr = publication;
}
else{
pubstr="Not Available";
}
f= new File(application.getRealPath(".")+ "/iit/Photo/"+ name+"/publication/pub1");
f.mkdirs();
//out.println(f.toString());
String fr3[] = f.list();
if(fr3.length>0)
pub1 = "Photo/"+name+"/publication/pub1/"+fr3[0];
else
pub1 = "images/default.bmp";
%>
|
|
<%
f= new File(application.getRealPath(".")+ "/iit/Photo/"+ name+"/publication/pub2");
f.mkdirs();
//out.println(f.toString());
String fr4[] = f.list();
if(fr4.length>0)
pub2 = "Photo/"+name+"/publication/pub2/"+fr4[0];
else
pub2 = "images/default.bmp";
%>
|
|
|
Research Group
|
|
<%
research = rs.getString("research");
String resstr="";
if( !rs.wasNull() )
{
resstr = research ;
}
else{
resstr="Not Available";
}
%>
|
Courses
|
|
<%
courses = rs.getString("courses");
String cstr="";
if( !rs.wasNull() )
{
cstr = courses ;
}
else{
cstr="Not Available";
}
f= new File(application.getRealPath(".")+ "/iit/files/"+ name+"/courses");
f.mkdirs();
//out.println(f.toString());
String fr5[] = f.list();
%>
Courses Files :
|
|
Others
|
|
<%
other = rs.getString("otherS");
String ostr="";
if( !rs.wasNull() )
{
ostr = other ;
}
else{
ostr="Not Available";
}
%>
|
<%
}
else{
response.sendRedirect("invalid.jsp");
}
con.close();
}
catch(SQLException sqle){
System.err.println(sqle.getMessage());
out.println(sqle.getMessage());
}
catch (ClassNotFoundException cnfe){
System.err.println(cnfe.getMessage());
}
catch (Exception e){
e.printStackTrace();
out.println(e.getMessage());
out.println("sql Exexption");
}
%>
|
|
