QuestionAsk Questions?
naveen kumar gupta
hi i am doing my project in jsp-servlet.i am able to upload successfully any file to oracle database. i want to share a file to specific user , how to write code plzzz help. thank you in advance
here is my code ShowFiles
<html>
<head></head>
<body>
<form name=myname method=get action="ShowUser.jsp">
<table border="1">
<tr><td></td>
<td><b><u>File ID</u></b></td>
<td><b><u>File Description</u></b></td>
<td><b><u>Up Date</u></b></td>
<%--<td><b><u>User Description</u></b></td>--%>
</tr>
<%try
{
int i=0;
HttpSession hs=request.getSession(true);
if(null!=hs.getAttribute("i1"))
{
i=(Integer) hs.getAttribute("i1");
}
Connection con = null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:naveen","naveen","naveen");
ResultSet rs = null;
Statement st=null;
st=con.createStatement();
rs = st.executeQuery("select file_id,file_desc,up_date from files where user_id='"+i+"' ");
while(rs.next()){String id=rs.getString("file_id"); %>
<tr><td><input type="checkbox" name="Check1<%=i%>" value=<%= id %>></td>
<td><%= id %></td>
<td><%= rs.getString("file_desc") %></td>
<td><%= rs.getString("up_date") %></td>
</tr><%
i++;
}
}catch(SQLException e){ out.println(e.getMessage()); } %>
</table>
<input type="submit" value="Select User">
ShowUser
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<%@page import="java.sql.*"%>
<title>JSP Page</title>
</head>
<body>
<form name=myname method=get action="ShareFile">
<table border="1">
<tr><td></td>
<td><b><u>User ID</u></b></td>
<td><b><u>User Name</u></b></td>
<td><b><u>Password</u></b></td>
<td><b><u>User Description</u></b></td>
</tr>
<%try{
Connection con = null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:naveen","naveen","naveen");
ResultSet rs = null;
Statement st=null;
st=con.createStatement();
rs = st.executeQuery("select * from user_det");
int i=0; while(rs.next()){ String id=rs.getString("user_id");%>
<tr><td><input type="checkbox" name="Check2<%=i%>" value=<%= id %>></td>
<td><%= id %></td>
<td><%= rs.getString("user_nm") %></td>
<td><%= rs.getString("password") %></td>
<td><%= rs.getString("user_desc") %></td>
</tr><%
i++;
}
}catch(SQLException e){ out.println(e.getMessage()); } %>
</table>
<input type="submit">
sharefile.java
package BuisnessLogic;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Enumeration;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet(name = "ShareFile", urlPatterns = {"/ShareFile"})
public class ShareFile extends HttpServlet {
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
Connection con = null;
ResultSet rs = null;
Statement st=null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:naveen","naveen","naveen");
st=con.createStatement();
Enumeration<String> paramnames = request.getParameterNames();
while(paramnames.hasMoreElements())
{
String check1 = paramnames.nextElement();
String check2 = paramnames.nextElement();
if((check1.startsWith("Check1"))&&(check2.startsWith("Check2")))
{
st.executeUpdate("insert into share_det(file_id,user_id) values('"+request.getParameter(check1)+"','"+request.getParameter(check2)+"')");
}
}
out.println("File has sent to particular user");
}catch(Exception e){
out.println(e);
out.println(e.getMessage());
} finally {
out.close();
}
}
View Answers
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
