-
Notifications
You must be signed in to change notification settings - Fork 0
/
upsuccess.jsp
40 lines (39 loc) · 1.57 KB
/
upsuccess.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
<%@ page import="java.sql.*"%>
<%@ page language="java" session="true"%>
<%
String action = request.getParameter("action");
if(action.equals("Upload Song")){
String sname = request.getParameter("sname");
session.setAttribute("sname", sname);
String surl = request.getParameter("surl");
session.setAttribute("surl", surl);
String usname = request.getParameter("name");
session.setAttribute("usname", usname);
try{
Class.forName("com.mysql.jdbc.Driver");
String uname = "root";
String pass = "";
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/data",uname,pass);
Statement sts = con.createStatement();
ResultSet rs = sts.executeQuery("Select * from datain where name ='"+usname+"' ");
rs.next();
String email = rs.getString("email");
Statement st = con.createStatement();
String query = "INSERT INTO `upload` (`name`, `email`, `song name`, `url`) VALUES ('"+usname+"', '"+email+"', '"+sname+"', '"+surl+"')";
st.executeUpdate(query);
%>
<script>
alert("Song uploaded succesfully, upload another");
window.location.href = "uploadsongs.jsp?name=<%out.print(usname);%>";
</script>
<%
}
catch(Exception e){
out.println(e);
}
}
else{
String usname = (String)session.getAttribute("usname");
response.sendRedirect("uploadsongs.jsp?name="+usname);
}
%>