Connect Java and Ms Access Database using UcanAccess!! смотреть онлайн

In this video, you will get to know how to connect #MS_Access database with #Java.
You have to download some jar files

Below are the links for the jar files:

1. Ucanaccess jar file : https://goo.gl/3yZRMS
2. hsqldb jar file: https://goo.gl/oFUiwK
3. jackcess jar file: https://goo.gl/ZQy8eJ
4. commons-logging jar file: https://goo.gl/ZAfu3F
5. commons-lang jar file: https://goo.gl/qfy9pu


Then you have to add these jar files to your java libraries folder and follow the steps shown in the video, after following all the steps you will be able to connect your java program to MS Access database.
Thanks
Don't forget to like this video and Do subscribe to #webtechtalkies


Code hints
//files to import:

import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/** * * @author Taranjeet */

try {                 Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");         
String path= "Your Path.....................";  String ur = "jdbc:ucanaccess://"+path;  Connection con = DriverManager.getConnection(ur);                 try {                    
Statement st = con.createStatement();                     /**Your database Table name */ ResultSet rs = st.executeQuery("SELECT * FROM cars"); /*here cars is a table select your own table here*/        
             while(rs.next()){                         System.out.print(rs.getString(1));       System.out.println(" "+rs.getString(2));} }catch(Exception ex){                    System.out.println("error occured "+ex);                   } }catch(Exception x){                    System.out.println("error occured"+x);             }}                    
//enjoy :)