Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private String password = "";
- private String dbName = "dataHC.accdb";
- private String bd = dbName + ";PWD=" + password;
- String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ="+bd+";";
- private Connection conn = null;
- //Connect
- public void connect() {
- try{
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- conn = DriverManager.getConnection(url);
- if (conn != null)
- System.out.println("Conexión a base de datos "+dbName+". listo");
- }catch(SQLException e){
- System.out.println(e);
- }catch(ClassNotFoundException e){
- System.out.println(e);
- }
- }
- String database="C:/Users/GIRI/Desktop/fdsfkdsfj/abc.accdb";
- String url="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + database + ";DriverID=22;READONLY=true";
- try
- {
- String conUrl = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + filepath;
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- con=DriverManager.getConnection(conUrl);
- }
- catch(SQLException s)
- {
- System.out.println(s);
- }
- package dbase.dbconnection;
- import java.sql.*;
- public class MSAccessDbConnect {
- public static void main(String args[]) throws Exception {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- String password = "";
- String dbName = "D:/maven_ejb_train/DATA/EmpTest.accdb";
- String bd = dbName; // + ";PWD=" + password;
- String connURL = "jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ="
- + dbName;
- System.out.println("connURL ===== " + connURL);
- String sql2 = "select * from Employees ";
- Connection conn = DriverManager.getConnection(connURL, "", "");
- System.out.println("aaa 111");
- ResultSet rs = conn.createStatement().executeQuery(sql2);
- System.out.println("aaa 222");
- while (rs.next()) {
- System.out.println("Name: " + rs.getString("EMP_NA") + " ID: "
- + rs.getString("EMP_NO"));
- }
- rs.close();
- conn.close();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement