-
Notifications
You must be signed in to change notification settings - Fork 1
/
yes.jsp
53 lines (41 loc) · 1.35 KB
/
yes.jsp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
<%@ page import="java.sql.*,databaseconnection.*"%>
<%@ page import="java.util.date.*,java.util.text.DateFormat.*,java.text.ParseException.*"%>
<%@page import="com.oreilly.servlet.*,java.sql.*,java.lang.*,databaseconnection.*,java.text.SimpleDateFormat,java.util.*,java.io.*,javax.servlet.*, javax.servlet.http.*" %>
<%@ page import = "java.util.Date,java.text.SimpleDateFormat,java.text.ParseException"%>
<%@page import="com.oreilly.servlet.*,java.sql.*,java.lang.*,databaseconnection.*,java.text.SimpleDateFormat,java.util.*,java.io.*,javax.servlet.*, javax.servlet.http.*"%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<%
String mid=request.getQueryString();
//out.print(mid);
String a="NO";
String cl="DUBLICATES";
try
{
Connection conn=database.getconnection();
PreparedStatement ps=conn.prepareStatement("update request1 set status='"+a+"' where filename='"+mid+"'");
ps.executeUpdate();
//response.sendRedirect("seller.jsp");
}
catch(Exception e1)
{
out.println(e1.getMessage());
}
try
{
Connection conn=database.getconnection();
PreparedStatement ps=conn.prepareStatement("update client set status='"+cl+"' where fname='"+mid+"'");
ps.executeUpdate();
}
catch(Exception e1)
{
out.println(e1.getMessage());
}
response.sendRedirect("uploadfiles.jsp");
%>
</body>
</html>