tag:blogger.com,1999:blog-2602954672962980775.post8207925115970600837..comments2023-05-28T17:46:56.476+05:30Comments on Harmeet Singh(Taara): Insert and Retrieve Images from MySql Table Using JavaHarmeet Singhhttp://www.blogger.com/profile/04080099010134878242noreply@blogger.comBlogger33125tag:blogger.com,1999:blog-2602954672962980775.post-79985705189609325612018-03-18T00:33:08.233+05:302018-03-18T00:33:08.233+05:30thank you so much sir, it really help and works as...thank you so much sir, it really help and works as it is..Anonymoushttps://www.blogger.com/profile/13508355015981145969noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-8372025589932099882018-02-16T21:33:37.838+05:302018-02-16T21:33:37.838+05:30Hi guys please
Would u plse show me how to store ...Hi guys please <br />Would u plse show me how to store image URL in db and retreve uaing jsp page whithin table <br />Anonymoushttps://www.blogger.com/profile/17161744235083135578noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-10184520617671981142017-04-23T22:13:04.236+05:302017-04-23T22:13:04.236+05:30HI sir...my self kapil kashyap. I am working on ja...HI sir...my self kapil kashyap. I am working on java web application. This is my first project and now i got confused in a case that where i have to store profile image. What is the best way <br />to store and retrieve image in java project. Pls give me suggestion .K Kashyaphttps://www.blogger.com/profile/05043219239127340136noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-80729836862663180162016-11-10T22:51:06.304+05:302016-11-10T22:51:06.304+05:30This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/18270988474344464931noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-49276552042898264112016-10-05T13:36:45.732+05:302016-10-05T13:36:45.732+05:30Uploading image inside mysql database is perfect b...Uploading image inside mysql database is perfect but after downloading image size not proper....<br />how to resole it?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-72783389746350573162016-10-05T13:35:21.853+05:302016-10-05T13:35:21.853+05:30This comment has been removed by the author.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-56409677457749323662016-09-17T22:35:36.718+05:302016-09-17T22:35:36.718+05:30Dear, I saved pic as ur code. But I receive a msg ...Dear, I saved pic as ur code. But I receive a msg as "pic.jpg (no such file or directory)" msg on my compiler, where should I save my pic.jpg file?I dunno how to dohttps://www.blogger.com/profile/12750479255579254391noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-72227704947701274862016-08-15T19:55:09.007+05:302016-08-15T19:55:09.007+05:30This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/02145541732748580247noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-54542707071451595272016-08-10T23:26:45.700+05:302016-08-10T23:26:45.700+05:30This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/02145541732748580247noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-38932796757413124182016-08-08T13:35:18.331+05:302016-08-08T13:35:18.331+05:30Hello @Adam i am not getting you point, which code...Hello @Adam i am not getting you point, which code are you want to use in JSP?Harmeet Singhhttps://www.blogger.com/profile/04080099010134878242noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-28803176636215047122016-08-06T21:48:43.331+05:302016-08-06T21:48:43.331+05:30Hey, I worked brilliantly but I want to Use this F...Hey, I worked brilliantly but I want to Use this File in <b>JSP</b>.<br />But file <strong>should not</strong> to be saved in host(in computer).any suggestions?<br />If you can mail meAnonymoushttps://www.blogger.com/profile/02145541732748580247noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-68088895277125143192016-04-11T04:04:42.032+05:302016-04-11T04:04:42.032+05:30package image.resizing;
import java.awt.Graphics2...package image.resizing;<br /><br />import java.awt.Graphics2D;<br />import java.awt.Image;<br />import java.awt.RenderingHints;<br />import java.awt.Robot;<br />import java.awt.event.ActionEvent;<br />import java.awt.event.ActionListener;<br />import java.awt.image.BufferedImage;<br />import java.io.File;<br />import java.io.FileInputStream;<br />import java.io.FileNotFoundException;<br />import java.io.IOException;<br />import java.util.logging.Level;<br />import java.util.logging.Logger;<br />import javax.imageio.ImageIO;<br />import javax.swing.ImageIcon;<br />import javax.swing.JButton;<br />import javax.swing.JFileChooser;<br />import javax.swing.JFrame;<br />import javax.swing.JLabel;<br />import javax.swing.JOptionPane;<br />import javax.swing.filechooser.FileNameExtensionFilter;<br /><br />/**<br /> *<br /> * @author Pratyush Aaditya<br /> */<br />public class ImageResizing extends JFrame{<br /><br /> /**<br /> * @param args the command line arguments<br /> */<br /> ImageResizing(){<br /> GUI();<br /> }<br /> <br /> public static void main(String[] args) {<br /> ImageResizing ob=new ImageResizing();<br /> }<br /> <br /> private Image resizeImage(int width, int height, Image img){<br /> <br /> BufferedImage resizedImage=new BufferedImage(width,height,BufferedImage.TYPE_INT_RGB);<br /> Graphics2D g2=resizedImage.createGraphics();<br /> g2.setRenderingHint(RenderingHints.KEY_INTERPOLATION, RenderingHints.VALUE_INTERPOLATION_BILINEAR);<br /> boolean drawImage = g2.drawImage(img, 0, 0, width, height, null);<br /> return resizedImage;<br /> }<br /> <br /> private File filechooser(){<br /> File selectedFile=null;<br /> String path=System.getProperty("user.home");<br /> JFileChooser chooser=new JFileChooser(path);<br /> //Only file will be selected. Not Folders.<br /> chooser.setFileSelectionMode(JFileChooser.FILES_ONLY);<br /> //Only images will be selected not all.<br /> String [] typeOfFile={"jpg", "png", "jpeg"};<br /> String descriptionOfFile="Images only!!!";<br /> chooser.setFileFilter(new FileNameExtensionFilter(descriptionOfFile, typeOfFile));<br /> chooser.setAcceptAllFileFilterUsed(false); //All files not allowed.<br /> int result=chooser.showOpenDialog(this);<br /> if(result==JFileChooser.APPROVE_OPTION){<br /> selectedFile=chooser.getSelectedFile();<br /> }<br /> return selectedFile;<br /> }<br /> <br /> private void GUI(){<br /> setVisible(true);<br /> setSize(600,500);<br /> setLayout(null);<br /> setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);<br /> setLocationRelativeTo(null);<br /> <br /> JLabel imageLabel=new JLabel();<br /> imageLabel.setBounds(0,0,getWidth(),getHeight()-70);<br /> add(imageLabel);<br /> <br /> JButton resizeButton=new JButton("Resize pic");<br /> resizeButton.setBounds(400,434,180,20);<br /> add(resizeButton);<br /> <br /> File file=filechooser();<br /> if (file!=null) {<br /> System.out.println("Selected File is : "+file.getName());<br /> ImageIcon img=new ImageIcon(file.getAbsolutePath());<br /> imageLabel.setIcon(img);<br /> }else{<br /> System.out.println("Not selected!");<br /> }<br /> <br /> resizeButton.addActionListener(new ActionListener(){<br /> @Override<br /> public void actionPerformed(ActionEvent e) {<br /> if(file!=null){<br /> try {<br /> Image im=ImageIO.read(file);<br /> im=resizeImage(getWidth(),getHeight()-70, im);<br /> //ImageIO.write(im, "png", new File("D:\\scrn.png"));<br /> imageLabel.setIcon(new ImageIcon(im));<br /> } catch (IOException ex) {<br /> System.out.println(ex);<br /> }<br /> }else{JOptionPane.showMessageDialog(null, "No File Selected");}<br /> }<br /> <br /> });<br /> }<br />}<br />Anonymoushttps://www.blogger.com/profile/05981256950255275733noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-48358085531857492162016-04-11T04:00:50.690+05:302016-04-11T04:00:50.690+05:30just add repaint(); at the last of your code.just add repaint(); at the last of your code.Anonymoushttps://www.blogger.com/profile/05981256950255275733noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-44264596552124963952016-03-19T19:24:10.179+05:302016-03-19T19:24:10.179+05:30i have follow your code it compile successfully by...i have follow your code it compile successfully by image do not showAnonymoushttps://www.blogger.com/profile/02092407438993958594noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-17774112080476953982016-02-20T12:58:10.728+05:302016-02-20T12:58:10.728+05:30I followed the above code, there is no error msg i...I followed the above code, there is no error msg is appearing, but it;s not getting store in to the database. please help ASAP..Anonymoushttps://www.blogger.com/profile/12148230983400120994noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-73758312397185514522016-02-20T12:55:21.911+05:302016-02-20T12:55:21.911+05:30Image is not getting store in the My sql DB, anyon...Image is not getting store in the My sql DB, anyone please help me ? Anonymoushttps://www.blogger.com/profile/12148230983400120994noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-40213118507493063912016-01-06T11:51:53.232+05:302016-01-06T11:51:53.232+05:30sir can i resize any image by using mysql or java ...sir can i resize any image by using mysql or java OR connecting both each other.<br />If we can please let me know sir i want to make a project sit.<br />thankyuभांडhttps://www.blogger.com/profile/02095372319642105310noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-36878539702635022782015-11-19T17:57:01.266+05:302015-11-19T17:57:01.266+05:30use longblob for img datatypeuse longblob for img datatypeAnonymoushttps://www.blogger.com/profile/09826577813118301716noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-52863389421728875612015-07-22T11:34:49.441+05:302015-07-22T11:34:49.441+05:30After Insertion done successfully put filepath as ...After Insertion done successfully put filepath as null otherwise it take same file again and again.Ramkiihttps://www.blogger.com/profile/08241248643857541901noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-57934157119805040622015-05-25T02:47:51.336+05:302015-05-25T02:47:51.336+05:30thanks so much works great !thanks so much works great !Anonymoushttps://www.blogger.com/profile/00732535392562624533noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-5673899246724384352015-05-01T20:54:18.421+05:302015-05-01T20:54:18.421+05:30harmeet sir ! according to your code, where should...harmeet sir ! according to your code, where should be placed my image before inserting??Anonymoushttps://www.blogger.com/profile/13671116690045756272noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-76540553402974043332015-04-15T01:27:54.152+05:302015-04-15T01:27:54.152+05:30Hi, anybody can help me on how to save/ retrieve i...Hi, anybody can help me on how to save/ retrieve image using Java Servlets from MySQL DB in JSP / HTML5 as view ?Unknownhttps://www.blogger.com/profile/04506485254843586202noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-46498538350859307222015-03-26T00:58:29.817+05:302015-03-26T00:58:29.817+05:30really helpful stuff really helpful stuff Anonymoushttps://www.blogger.com/profile/07337934250386821235noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-15412020861999765562015-03-08T18:10:16.065+05:302015-03-08T18:10:16.065+05:30Also , there are 5 variable types with respect to ...Also , there are 5 variable types with respect to blob. blob, medium blob ,large blob,block blob and page blob , which allow storage of 65kb , 16mb and 4.2gb,200gb , 1TB respectivelyullas sharmahttps://www.blogger.com/profile/09463429497009548145noreply@blogger.comtag:blogger.com,1999:blog-2602954672962980775.post-39832036867966048122015-03-08T18:02:24.470+05:302015-03-08T18:02:24.470+05:30your source is good. but this part :
InputStream i...your source is good. but this part :<br />InputStream in = rs.getBinaryStream(1);<br />while ((c = in.read()) > -1) {<br /> f.write(c);<br /> }<br />is very costly especially if the image is big. i tried above approach and it took about 27 seconds to write one file of 7.2MB.<br /><br />I found an alternative approach as below : <br /><br />Blob b=rs.getBlob(2); <br /> byte barr[]=b.getBytes(1,(int)b.length());<br /> FileOutputStream fout=new FileOutputStream("./sample/sample.jpg");<br /> fout.write(barr);<br /><br />This is significantly faster. It took about 0.1 seconds to write the same image of 7.2MB.ullas sharmahttps://www.blogger.com/profile/09463429497009548145noreply@blogger.com