JavaFX 8 Tutorial 49 - Image and Database





The code written in this tutorial is :



private FileInputStream fis;





        Button button = new Button("Save");

        button.setFont(Font.font("SanSerif", 15));

        button.setOnAction(e ->{

            try{

                String query = "INSERT INTO UserDatabase ( Image) VALUES(?)";

                pst = conn.prepareStatement(query);



                fis = new FileInputStream(file);// file is selected using filechooser which is in last tutorial

                pst.setBinaryStream(11, (InputStream)fis, (int)file.length());



                pst.execute();

               

                pst.close();

                clearFields();

            }catch(Exception e1){

                label.setText("SQL Error");

                System.err.println(e1);

            }

});








Comments

Post a Comment

Popular posts from this blog

JavaFX 8 Tutorial 64 Spring Boot CRUD with FXML

Image
JavaFX Spring Boot App The application frontend created using JavaFX and backend services are implemented using Spring Boot. The app demonstrate simple CRUD operation and switching between two scenes with Login and User Dashboard view. Getting Started: Clone the project in your workspace using command - git clone  https://github.com/RamAlapure/JavaFXSpringBootApp.git Then import as maven project into eclipse. Check Java 8 configuration if there is any error. Update project as maven if dependencies are not resolved. Create a schema javafx in your mysql database or open configuration file application.properties from resources directory and change schema name to your schema name and also change username and password. If all goes well just run Main.java
Read more

JavaFX 8 Tutorial 62 - Jasper Report

Image
JavaFX 8 Tutorial 62 – Jasper Report Steps: 1.    Download Jasper Report Jar Link - https://sourceforge.net/projects/jasperreports/files/jasperreports/JasperReports%206.2.0/ 2.    Download iReport Plugin for Netbeans Link – http://plugins.netbeans.org/plugin/4425/ireport 3.    To install iReport Plugin go to -> Tools -> Plugin -> Dowloaded -> Add Plugins. 4.    Add Database jar (in my case its sqlite-jdbc.jar ) and Project Jar ( User_Info_App.jar ) to iReport classpath, to do so go to -> Tools -> Options -> select iReport -> Add Database  and Project jar. 5.    On welcome to iReport Page click on step 1 -> create new Database JDBC Connection -> Give ·        Name – Demo ·        JDBC Driver – org.sqlite.JDBC ·        JDBC URL - jdbc:sqlite:C:\Users\RAM ALAPURE\Documents\NetBeansProjects\User Info App\Us...
Read more

JavaFX 8 Tutorial 51 - Export Database to Excel

Image
The code written in this tutorial is : private Button exportToXL; exportToXL = new Button("Export To Excel");         exportToXL.setFont(Font.font("Sanserif", 15));         exportToXL.setOnAction( e->{             try {                 String query = "Select * from UserDatabase";                 pst = conn.prepareStatement(query);                 rs = pst.executeQuery();                                 //Apache POI Jar Link-                 //http://a.mbbsindia.com/poi/release/bin/poi-bin-3.13-20150929.zip                 XSSFWorkbook wb = new XSSFWorkbook();//for earlier version use HSSF           ...
Read more