Store Image (or) Pic into DataBase and Retrieve from Database


Here is an example for How to store image into database and reterive that and display one by one
steps
*****
1. create one temp folder under root
2. save this 3 files into that
3. create database in ms-sql server
4. note : if connection not establishing with this driver , better to use jdbc :-> Odbc :-> driver
5. database code for ms-sqlserver
create table image (uid numeric(6) identity (1001,1), img image )
select * from image
getfile.html
************
<html>
<body>
<form method=”get” action=”./Gettostore.jsp”>
<input type=”file” name=”path” size=”50″/>
<input type=”submit” value=”Submit”/>
</form>
</body>
</html>
Gettostore.jsp
**************
<%@ page language=”java” import=”java.sql.*,java.io.*” errorPage=”" %>
<%
try
{
Connection con = null;
System.setProperty( “jdbc.drivers”, “com.microsoft.jdbc.sqlserver.SQLServerDriver” );
Class.forName( “com.microsoft.jdbc.sqlserver.SQLServerDriver” );
con = DriverManager.getConnection( “jdbc:microsoft:sqlserver://SCALAR6:1433;DatabaseName=JAVATEAM;SelectMethod=cursor;User=sa;Password=ontrack20″ );
PreparedStatement pst = con.prepareStatement(“insert into image(img) values(?)”);
//logo path is a value which is come from file browser
FileInputStream fis=new FileInputStream(request.getParameter ( “path” ) );
byte[] b= new byte[fis.available()+1];
fis.read(b);
pst.setBytes(1,b);
pst.executeUpdate();
pst.close();
con.close();
}
catch(SQLException e)
{
out.println ( e);
}
catch (ClassNotFoundException e)
{
out.println( e );
}
%>
<a href=”./Puttoview.jsp” mce_href=”./Puttoview.jsp”> View from Database </a>
<!– better u to redirect to another page and add this above <a href..> link –>
Puttoview.jsp
*************
<%@ page contentType=”text/html; charset=iso-8859-1″ language=”java” import=”java.io.*,java.sql.*” errorPage=”" %>
<html>
<body>
<a href=”./getfile.html” mce_href=”./getfile.html”> Home </a>
<%
try
{
Connection con = null;
System.setProperty( “jdbc.drivers”, “com.microsoft.jdbc.sqlserver.SQLServerDriver” );
Class.forName( “com.microsoft.jdbc.sqlserver.SQLServerDriver” );
con = DriverManager.getConnection( “jdbc:microsoft:sqlserver://SCALAR6:1433;DatabaseName=JAVATEAM;SelectMethod=cursor;User=sa;Password=ontrack20″ );
PreparedStatement pst = null;
ResultSet rs=null;
FileOutputStream fos;
int i = 0;
%>
<table border=”1″ align=”center” >
<%
pst = con.prepareStatement(“select uid,img from image “); // better to use where uniqueid = ‘value’
rs=pst.executeQuery();
while(rs.next())
{
i = rs.getInt (1);
byte[] b=rs.getBytes(“img”);
fos=new FileOutputStream(“c://tomcat4.1/webapps/ROOT/temp/image” + i + “.jpg”);
fos.write(b);
fos.close();
%>
<tr><td align=”center”><img src=”./image<%=i%>.jpg” mce_src=”./image<%=i%>.jpg” >
<%=i%></td></tr>
<%
}
pst.close();
con.close();
}
catch(SQLException e)
{
out.println ( e);
}
catch (ClassNotFoundException e)
{
out.println( e );
}
%>
</table>
</body>
</html>
//run : http://localhost:8080/temp/getfile.html

Comments

Post a Comment

Popular posts from this blog

What is the difference between asynchronous and synchronous execution?

When you execute something synchronously, you wait for it to finish before moving on to another task. When you execute something asynchronously, you can move on to another task before it finishes. That being said, in the context of computers this translates into executing a process or task on another "thread." A thread is a series of commands (a block of code) that exists as a unit of work. The operating system can manage multiple threads and assign a thread a piece ("slice") of processor time before switching to another thread to give it a turn to do some work. At its core (pardon the pun), a processor can simply execute a command, it has no concept of doing two things at one time. The operating system simulates this by allocating slices of time to different threads. Now, if you introduce multiple cores/processors into the mix, then things CAN actually happen at the same time. The operating system can allocate time to one thread on the first processor, then a
Read more

Yahoo accepting requests for inactive email IDs

Image
Yahoo accepting requests for inactive email IDs SAN FRANCISCO:  Yahoo  is allowing people to place claims on inactive  email  addresses that are being given a second life.  The opportunity to request the identifications began Monday afternoon and will extend through Aug. 7. Up to five different names can be submitted at http://wishlist.yahoo.com .  Yahoo Inc. says a substantial number of old email IDs are being made available, but isn't providing specifics.  The email IDs are being released a month after the Sunnyvale, California, company notified users that they would have 30 days to log into an inactive account if they wanted to keep it.  People awarded the rights to the recycled email addresses will have a 48-hour period to activate the accounts beginning Aug. 15
Read more

Badtameez Dil Lyrics--Yeh Jawaani Hai Deewani Song

Badtameez Dil Lyrics Badtameezee ek bimari hai Ek aisi bimari Jo dheere dheere waqt ke saath Budhaape mein badal jaati hai Main kehta hoon jab tak budhaapa nahi aata Thodi badtameezee hi kar lete hai Paan main pudeena dekha Naak ka nageena dekha Chikni chameli dekhi  Chikna kameena dekha Chaand ne cheater hoke cheat kiya toh Saare taare bole gilli gilli akhaa Pa para para... Meri baat, teri baat Zyada baatein boori baat Thaali mein katora leke Aaloo bhat, Muri bhat Mere peeche kisi ne repeat kiya toh Saala maine tere muh pe maara mukka Ispe bhoot koi chadha hai Theharna jaane naa Ab toh kya buraa kyaa bhalaa hai Fark pehchaane naa Zidd pakad ke khadaa hai kambakht Chhodna jaane naa Badtameez dil, batameez dil, batamiz dil Maane na, maane na Badtameez dil, batameez dil, batamiz dil Maane na, maane na Yeh jo haal hai, sawaal hai, kamaal hai Jaane na jaane na Badtameez dil, battameez dil badtameez dil Maane naa.. Hawa mein Havana dekha Dhimka falaana dekha Seeng ka Singhara khaake She
Read more