-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathSearch.jsp
96 lines (95 loc) · 3.77 KB
/
Search.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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE html>
<html>
<link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
<link rel="preconnect" href="https://fonts.gstatic.com">
<link href="https://fonts.googleapis.com/css2?family=Anton&family=Seymour+One&display=swap" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<link rel="stylesheet" type="text/css" href="Addcart.css">
<link rel="stylesheet" type="text/css" href="https://stackpath.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<title>Search | S-cart</title>
</head>
<body>
<header>
<div class="logo">
<div style="color: red; font-family: 'Seymour One', sans-serif; font-size: 48px;">S</div>
<div style="color:green; font-family:'Seymour One', sans-serif; font-size: 48px;">-</div>
<div style="color: blue; font-family: 'Seymour One', sans-serif; font-size: 48px;">c</div>
<div style="color: rgb(226, 226, 89); font-family: 'Seymour One', sans-serif; font-size: 48px;">a</div>
<div style="color: orange; font-family: 'Seymour One', sans-serif; font-size: 48px;">r</div>
<div style="color: skyblue; font-family: 'Seymour One', sans-serif; font-size: 48px;">t</div>
</div>
<div class="head">
<ul>
<li><a href=""><i class="fa fa-handshake-o" style="color: black;"></i> Help and Support</a></li>
<li><a href=""><i class="fa fa-bell-o" style="color: black;"></i> Notification</a></li>
</ul>
</div>
<div class="search">
<form action="Search.jsp" method="post">
<input type="text" name="search">
<a href="Search.jsp"><button><i class="fa fa-search"></i> Search</button></a></form>
</div>
<%String name = (String)session.getAttribute("name");%>
<div class="acc_cart">
<a href="Myaccount.jsp"><button class="user"><i class="fa fa-user"></i> <%out.print(name); %></button></a>
<a href="Cart.jsp"><button class="cart"><i class="fa fa-shopping-cart"></i> My cart</button></a>
</div>
</header>
<nav>
<a href="Home.jsp"><i class="fa fa-home"></i> Home</a>
<a href="Fashion.jsp"><i class="fa fa-suitcase"></i> Fashion</a>
<a href="Medicine.jsp"><i class="fa fa-medkit"></i> Medicine</a>
<a href="Electronics.jsp"><i class="fa fa-tv"></i> Electronic</a>
<a href="Mobile.jsp"><i class="fa fa-phone"></i> Mobile</a>
<a href="Home-app.jsp"><i class="fa fa-plug"></i> Home-appliences</a>
</nav>
<main>
<table id = cart>
<thead>
<tr>
<th scope="col">Sl.No.</th>
<th scope="col">Product Name</th>
<th scope="col">Price</th>
<th scope="col">Specification</th>
<th scope="col">Specification</th>
<th scope="col">Specification</th>
<th scope="col">Specification</th>
</tr>
</thead>
<tbody>
<%
int i = 0;
try {
String search = request.getParameter("search");
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "system", "root");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from search where uqname like '%"+search+"%' or name like '%"+search+"%'");
while (rs.next()) {
%>
<tr>
<%i = i + 1; %>
<td><%out.println(i); %></td>
<td><%=rs.getString(2) %></td>
<td><%=rs.getString(3) %></td>
<td><%=rs.getString(4) %></td>
<td><%=rs.getString(5) %></td>
<td><%=rs.getString(6) %></td>
<td><%=rs.getString(7) %></td>
</tr>
<%
}
}
catch(Exception e){
System.out.println(e);
}
%>
</tbody>
</table>
</main>
</body>
</html>