Shibin Varghese
java.lang.UnsupportedOperationException
1 Answer(s)      6 years and 10 months ago
Posted in : JSP-Servlet

Ads

View Answers

November 26, 2009 at 12:46 PM


Hi Friend,

We are providing you the code where we have used MySql database.

Use the following code:

<%@page import="java.io.*"%>
<%@page import="java.sql.*"%>
<%
String connectionURL = "jdbc:mysql://localhost:3306/test";;;
Connection con=null;
Statement stmt = null;
ResultSet rs = null;
Blob image = null;
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root";;);
stmt = con.createStatement();
rs = stmt.executeQuery("select image from image where image_id =1");
if (rs.next()) {
image = rs.getBlob(1);
}
File f=new File("C:\\newImage.jpg");
FileOutputStream fos=new FileOutputStream(f);
InputStream in = image.getBinaryStream();
int length = (int) image.length();
int bufferSize = 1024;
byte[] buffer = new byte[bufferSize];
while ((length = in.read(buffer)) != -1) {
fos.write(buffer, 0, length);
}
out.println("Image is saved into the file.");
in.close();
fos.close();
} catch (Exception e){}
finally {
try {
rs.close();
stmt.close();
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
%>

Hope that it will be helpful for you.
Thanks









Related Tutorials/Questions & Answers:
java.lang.UnsupportedOperationException - JSP-Servlet
java.lang.UnsupportedOperationException   Hi friends, Thank you for the support you have provided to me until now. now I am in a problem.... But now it is giving exception "java.lang.UnsupportedOperationException
how to solve an internet connection problem
how to solve an internet connection problem  when i run my application it give me this error: Exception in thread "AWT-EventQueue-0" java.lang.UnsupportedOperationException: Not yet implemented the problem is that i don`t know
Advertisements
jsf application war file not running in my jboss 6.0 on linux 5.5
Faces Servlet threw exception: java.lang.UnsupportedOperationException

Ads

Advertisement