Admin: 1 версия

2010-06-01T06:34:12Z

1 версия

в 18:01, 31 мая 2010

2010-05-31T18:01:44Z

Новая страница

== Connect to a database via JDBC-ODBC ==



<source lang="java">

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
public class Main {
public static void main(String args[]) throws Exception {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager
.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=c:/access.mdb");
ResultSet rs = c.createStatement().executeQuery("select objet from Employee");
while (rs.next()) {
System.out.println(rs.getString("objet"));
}
rs.close();
c.close();
}
}

</source>



== Create a connection to MS Access database ==



<source lang="java">

import java.sql.Connection;
import java.sql.DriverManager;
public class Main {
// private static final String URL = "jdbc:odbc:TestDB";
private static final String USERNAME = "admin";
private static final String PASSWORD = "welcome";
private static final String DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
private static final String URL = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\Database\\testdb.mdb;}";
public static void main(String[] args) throws Exception {
Class.forName(DRIVER);
Connection connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);
connection.close();
}
}

</source>

← Предыдущая	Версия 06:34, 1 июня 2010
(нет различий)

Java/Database SQL JDBC/Access - История изменений

Admin: 1 версия

в 18:01, 31 мая 2010