How to make image slider in java which retrieve image from database?











up vote
-1
down vote

favorite












How do I make an image slider in java which retrieves an image from a database and slides one by one? For a better understanding, I've added an image from the application.
enter image description here



  private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
try {
String sql ="select * from images";
pst=conn.prepareStatement(sql);
rs=pst.executeQuery();
if(rs.next()){
byte imagedata = rs.getBytes("image");
format = new ImageIcon(imagedata);
imageShowIcon.setIcon(format);
}
} catch (SQLException ex) {
System.out.println(ex +"select error");
}

}









share|improve this question




















  • 1




    Hi @Mirwais. Welcome to StackOverflow. The question you have asked is quite broad. Can you share what you have tried? It looks like an Applet based system.
    – Sid
    yesterday










  • 1) if(rs.next()){ .. imageShowIcon.setIcon(format); This code will only result in the last image of the result set being shown. The code needs to do one of a variety of ways of handling multiple images, like keeping a reference to an array or list of images to be shown in a single label, or putting each of the images as elements of a scroll pane. 2) } catch (SQLException ex) { System.out.println(ex +"select error"); } change that to add ex.printStackTrace(); which provides more information with less typing than the println statement..
    – Andrew Thompson
    yesterday

















up vote
-1
down vote

favorite












How do I make an image slider in java which retrieves an image from a database and slides one by one? For a better understanding, I've added an image from the application.
enter image description here



  private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
try {
String sql ="select * from images";
pst=conn.prepareStatement(sql);
rs=pst.executeQuery();
if(rs.next()){
byte imagedata = rs.getBytes("image");
format = new ImageIcon(imagedata);
imageShowIcon.setIcon(format);
}
} catch (SQLException ex) {
System.out.println(ex +"select error");
}

}









share|improve this question




















  • 1




    Hi @Mirwais. Welcome to StackOverflow. The question you have asked is quite broad. Can you share what you have tried? It looks like an Applet based system.
    – Sid
    yesterday










  • 1) if(rs.next()){ .. imageShowIcon.setIcon(format); This code will only result in the last image of the result set being shown. The code needs to do one of a variety of ways of handling multiple images, like keeping a reference to an array or list of images to be shown in a single label, or putting each of the images as elements of a scroll pane. 2) } catch (SQLException ex) { System.out.println(ex +"select error"); } change that to add ex.printStackTrace(); which provides more information with less typing than the println statement..
    – Andrew Thompson
    yesterday















up vote
-1
down vote

favorite









up vote
-1
down vote

favorite











How do I make an image slider in java which retrieves an image from a database and slides one by one? For a better understanding, I've added an image from the application.
enter image description here



  private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
try {
String sql ="select * from images";
pst=conn.prepareStatement(sql);
rs=pst.executeQuery();
if(rs.next()){
byte imagedata = rs.getBytes("image");
format = new ImageIcon(imagedata);
imageShowIcon.setIcon(format);
}
} catch (SQLException ex) {
System.out.println(ex +"select error");
}

}









share|improve this question















How do I make an image slider in java which retrieves an image from a database and slides one by one? For a better understanding, I've added an image from the application.
enter image description here



  private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
try {
String sql ="select * from images";
pst=conn.prepareStatement(sql);
rs=pst.executeQuery();
if(rs.next()){
byte imagedata = rs.getBytes("image");
format = new ImageIcon(imagedata);
imageShowIcon.setIcon(format);
}
} catch (SQLException ex) {
System.out.println(ex +"select error");
}

}






java image swing






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited yesterday









Andrew Thompson

152k27159333




152k27159333










asked yesterday









Mirwais Faizi

14




14








  • 1




    Hi @Mirwais. Welcome to StackOverflow. The question you have asked is quite broad. Can you share what you have tried? It looks like an Applet based system.
    – Sid
    yesterday










  • 1) if(rs.next()){ .. imageShowIcon.setIcon(format); This code will only result in the last image of the result set being shown. The code needs to do one of a variety of ways of handling multiple images, like keeping a reference to an array or list of images to be shown in a single label, or putting each of the images as elements of a scroll pane. 2) } catch (SQLException ex) { System.out.println(ex +"select error"); } change that to add ex.printStackTrace(); which provides more information with less typing than the println statement..
    – Andrew Thompson
    yesterday
















  • 1




    Hi @Mirwais. Welcome to StackOverflow. The question you have asked is quite broad. Can you share what you have tried? It looks like an Applet based system.
    – Sid
    yesterday










  • 1) if(rs.next()){ .. imageShowIcon.setIcon(format); This code will only result in the last image of the result set being shown. The code needs to do one of a variety of ways of handling multiple images, like keeping a reference to an array or list of images to be shown in a single label, or putting each of the images as elements of a scroll pane. 2) } catch (SQLException ex) { System.out.println(ex +"select error"); } change that to add ex.printStackTrace(); which provides more information with less typing than the println statement..
    – Andrew Thompson
    yesterday










1




1




Hi @Mirwais. Welcome to StackOverflow. The question you have asked is quite broad. Can you share what you have tried? It looks like an Applet based system.
– Sid
yesterday




Hi @Mirwais. Welcome to StackOverflow. The question you have asked is quite broad. Can you share what you have tried? It looks like an Applet based system.
– Sid
yesterday












1) if(rs.next()){ .. imageShowIcon.setIcon(format); This code will only result in the last image of the result set being shown. The code needs to do one of a variety of ways of handling multiple images, like keeping a reference to an array or list of images to be shown in a single label, or putting each of the images as elements of a scroll pane. 2) } catch (SQLException ex) { System.out.println(ex +"select error"); } change that to add ex.printStackTrace(); which provides more information with less typing than the println statement..
– Andrew Thompson
yesterday






1) if(rs.next()){ .. imageShowIcon.setIcon(format); This code will only result in the last image of the result set being shown. The code needs to do one of a variety of ways of handling multiple images, like keeping a reference to an array or list of images to be shown in a single label, or putting each of the images as elements of a scroll pane. 2) } catch (SQLException ex) { System.out.println(ex +"select error"); } change that to add ex.printStackTrace(); which provides more information with less typing than the println statement..
– Andrew Thompson
yesterday



















active

oldest

votes











Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














 

draft saved


draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53238151%2fhow-to-make-image-slider-in-java-which-retrieve-image-from-database%23new-answer', 'question_page');
}
);

Post as a guest





































active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes
















 

draft saved


draft discarded



















































 


draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53238151%2fhow-to-make-image-slider-in-java-which-retrieve-image-from-database%23new-answer', 'question_page');
}
);

Post as a guest




















































































Popular posts from this blog

Full-time equivalent

さくらももこ

13 indicted, 8 arrested in Calif. drug cartel investigation