Home
Answers
Viewqa
JDBC
i am inserting an image into database but it is showing relative path not absolute path
QuestionAsk Questions?
praveen kumar reddy.y
i am inserting an image into database but it is showing relative path not absolute path
1 Answer(s) 2 years and 7 months ago
Posted in : JDBC
1 Answer(s) 2 years and 7 months ago
Posted in : JDBC
hi my first page.........
<html> <head> <title>Image</title> </head> <body bgcolor="lavender"></p> <form action="addimage.jsp"> Enter your name:<input type="text" name="sname"><br><br> Upload photo:<input type="file" size="50" name="url"><br><br> Father name:<input type="text" name="fname"><br><br> Age:<input type="text" name="age"><br><br> Username:<input type="text" name="usn"><br><br> Password<input type="password" name="pasws"><br><br> Qualification:<input type="text" name="qal"><br><br> Gender:<input type="text" name="gen"><br><br> Phone number:<input type="text" name="pno"><br><br> <input type="submit" value="add"> </form> </body> </html>
then addimage.jsp
<%@ page import="java.io.<em>,java.sql.</em>" %>
<html>
<head><title>Imageadd</title>
</head>
<body>
<%
try
{
String name=request.getParameter("sname");
String url=request.getParameter("url");
System.out.println(url);
String fname=request.getParameter("fname");
String usname=request.getParameter("usn");
String pass=request.getParameter("pasws");
String uage=request.getParameter("age");
String uqal=request.getParameter("qal");
String ugen=request.getParameter("gen");
String upno=request.getParameter("pno");
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:scott/tiger@//localhost:1521/XE","scott","tiger");
PreparedStatement pst = con.prepareStatement("insert into errortab values(?,?,?,?,?,?)");</p>
pst.setString(1,name);
pst.setString(2,fname);
pst.setString(3,uage);
pst.setString(4,uqal);
pst.setString(5,ugen);
pst.setString(6,upno);
pst.executeUpdate();
pst.close();
PreparedStatement ps = con.prepareStatement("insert into dlogin values(?,?,?)");
File file = new File(url);
FileInputStream fs = new FileInputStream(file);
ps.setString(1,usname);
ps.setString(2,pass);
ps.setBinaryStream(3,fs,fs.available());
ps.executeUpdate();
out.println("thank u for registration");
out.println("ur values are inserted into database");
}
catch(Exception e)
{
System.out.println(e);
}
%>
</body>
</html>
when i compiled it i got error "java.io.filenotfoundexception" please go through it and help me....
thanks in advance
View Answers
May 22, 2012 at 10:44 AM
<%@page import="java.sql.,java.io."%> <%
String upload=request.getParameter("upload"); File file = new File("upload"); String str=file.getAbsolutePath();
%>
<%=str%>
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
