public static int searchDelete(Connection conn,String ret_id) throws Exception
{
//System.out.println(ret_id);
st=conn.createStatement();
//System.out.println("Where");
ResultSet rs=st.executeQuery("select * from RETAILER where RETAILERID='"+retid+"'");
//System.out.println("asudhwdioq");
if(rs.next())
{
return 1;
}
else return 0;
}
public static int chk_order(Connection conn,String ret_id) throws Exception
{
int a=0;
System.out.println("Where");
System.out.println(ret_id);
ResultSet rs=st.executeQuery("select * from ORDER_TABLE where RETAILER_ID='"+ret_id+"'");
System.out.println("qwggggg");
if(rs.next()==false)
{
return 2;
}
while(rs.next())
{
System.out.println("qwggggg");
if(rs.getString(4).equals("Allocated"))
{
System.out.println("Girish");
a=0;
break;
}
else a=1;
System.out.println(rs.getString(4));
}
if(a==0)
{
return 0;
}
else return 1;
}
public static int untag(Connection conn,String ret_id) throws Exception
{
st=conn.createStatement();
System.out.println("Delete ho ja");
int k=st.executeUpdate("delete from tag_product_tbl where retailer_id='"+ret_id+"'");
return k;
}
public static int deleteRet(Connection conn,String ret_id) throws Exception
{
st=conn.createStatement();
System.out.println("Delete yahape bhi hoga");
rs=st.executeQuery("select * from retailer where retailer_id='"+ret_id+"'");
rs.next();
String s1=rs.getString(1);
String s2=rs.getString(2);
String s3=rs.getString(3);
String s4=rs.getString(4);
int s5=rs.getInt(5);
String s6=rs.getString(6);
String s7=rs.getString(8);
String s8=rs.getString(9);
System.out.println(s1);
System.out.println(s2);
System.out.println(s3);
System.out.println(s4);
System.out.println(s5);
System.out.println(s6);
System.out.println(s7);
System.out.println(s8);
int a=st.executeUpdate("insert into inactive values('"+s1+"','"+s2+"','"+s3+"','"+s4+"',"+s5+",'"+s6+"')");
System.out.println("a="+a);
int z=st.executeUpdate("delete from retailer where retailer_id='"+ret_id+"'");
System.out.println("hua kya?");
return z;
}