How to connect Java with Database MS-Access

Опубликовано: 20 Май 2026
на канале: Learning With Nisa

255

this video contains detail about java connectivity with database (MS-Access).

here is the code wrote on SAVE Button..

String name, city;

name = jTextField1.getText();

System.out.println(name);

city = jTextField2.getText();
System.out.println(city);

try{
Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");//Loading Driver
Connection conn= DriverManager.getConnection("jdbc:ucanaccess://D:\\java\\studentDatabase.accdb");System.out.println("Connected Successfully");

Statement stment = conn .createStatement();
//stment.executeUpdate("INSERT INTO Student (userName , city) VALUES ('nISA1207','SBBU')");
stment.executeUpdate("INSERT INTO Student (username , city) VALUES ('"+name+"','"+city+"')");
System.out.println("Record added successfuly");

jTextField1.setText("");
jTextField2.setText("");