<%!String a="",b="",d="",e="",f="",g="",h="",i="",j=""; %>
MEDICINE ID>
|
MEDICINE DETAILS
|
<%
try
{ a=request.getParameter("Button1");
if(a.equals("SEARCH MEDICINE 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 medicine where med_code='"+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);
g=r.getString(6);
h=r.getString(7);
}
else
{
%>
<%
}
}
else
{
%>
<%
}
}
}catch(Exception e) {}
%>
|
MEDICINE NAME>
MANUFACTURER>
DATE OF MANUFACTURE>
MEDICINE TYPE>
EXPIRY DATE>
BATCH 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");
String str6= request.getParameter("t6");
String str7= request.getParameter("t7");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c=DriverManager.getConnection ("jdbc:odbc:abc", "root", "data");
Statement s= c.createStatement();
if(a.equals("ADD MEDICINE PROFILE"))
{
if(str1!=""&&str2!=""&&str3!=""&&str4!=""&&str5!=""&&str6!=""&&str7!="")
{
String sql="insert into medicine values("+str1+",'"+str2+"','"+str3+"','"+str4+"','"+str5+"','"+str6+"',"+str7+")";
out.println(sql);
s.execute(sql);
%>
<%
}
else
{
%>
<%
}
}
else if(a.equals("DELETE MEDICINE PROFILE"))
{
if(str1!="")
{
String sq="select * from medicine where med_code="+str1+"";
ResultSet rs1=s.executeQuery(sq);
if(rs1.next())
{
String sql="delete from medicine where med_code="+str1+"";
s.execute(sql);
%>
<%
}
else
{
%>
<%
}
}
else
{
%>
<%
}
}
else if(a.equals("EDIT MEDICINE PROFILE"))
{
if(str1!="")
{
String sq="select * from medicine where med_code="+str1+"";
ResultSet rs1=s.executeQuery(sq);
if(rs1.next())
{
String sql="delete from medicine where med_code="+str1+"";
s.execute(sql);
String sql1="insert into medicine values("+str1+",'"+str2+"','"+str3+"','"+str4+"','"+str5+"','"+str6+"',"+str7+")";
s.execute(sql1);
%>
<%
}
else
{
%>
<%
}
}
else
{
%>
<%
}
}
}catch(Exception e) {}
%>
|