<%
try
{ a=request.getParameter("Button1");
if(a.equals("SEARCH DEPARTMENT PROFILE"))
{
String str1= request.getParameter("t1");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c=DriverManager.getConnection ("jdbc:odbc:abc", "root", "data");
Statement s= c.createStatement();
if(str1!="")
{
String sql2="select * from department where dept_id='"+str1+"'";
ResultSet r=s.executeQuery(sql2);
if(r.next())
{
j=r.getString(1);
b=r.getString(2);
d=r.getString(3);
e=r.getString(4);
f=r.getString(5);
}
else
{
%>
<%
}
}
else
{
%>
<%
}
}
}catch(Exception e) {}
%>
|
DEPARTMENT NAME>
DEPARTMENT DOCTOR>
DEPARTMENT HEAD>
PHONE NO>
|
<%
try{
a=request.getParameter("Button1");
String str1= request.getParameter("t1");
String str2= request.getParameter("t2");
String str3= request.getParameter("t3");
String str4= request.getParameter("t4");
String str5= request.getParameter("t5");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c=DriverManager.getConnection ("jdbc:odbc:abc", "root", "data");
Statement s= c.createStatement();
if(a.equals("ADD DEPARTMENT PROFILE"))
{
if(str1!=""&&str2!=""&&str3!=""&&str4!=""&&str5!="")
{
String sql="insert into department values("+str1+",'"+str2+"','"+str3+"','"+str4+"',"+str5+")";
out.println(sql);
s.execute(sql);
%>
<%
}
else
{
%>
<%
}
}
else if(a.equals("DELETE DEPARTMENT PROFILE"))
{
if(str1!="")
{
String sq="select * from department where dept_id="+str1+"";
ResultSet rs1=s.executeQuery(sq);
if(rs1.next())
{
String sql="delete from department where dept_id="+str1+"";
s.execute(sql);
%>
<%
}
else
{
%>
<%
}
}
else
{
%>
<%
}
}
else if(a.equals("EDIT DEPARTMENT PROFILE"))
{
if(str1!="")
{
String sq="select * from department where dept_id="+str1+"";
ResultSet rs1=s.executeQuery(sq);
if(rs1.next())
{
String sql="delete from department where dept_id="+str1+"";
s.execute(sql);
String sql1="insert into department values("+str1+",'"+str2+"','"+str3+"','"+str4+"',"+str5+")";
s.execute(sql1);
%>
<%
}
else
{
%>
<%
}
}
else
{
%>
<%
}
}
}catch(Exception e) {}
%>