1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.sql.rowset.CachedRowSet;
public class Main {
public static void main(String[] args) throws Exception {
CachedRowSet rs;
String ROWSET_IMPL_CLASS = "com.sun.rowset.CachedRowSetImpl";
Class<?> c = Class.forName(ROWSET_IMPL_CLASS);
rs = (CachedRowSet) c.newInstance();
String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:/MaBase.accdb";
rs.setUsername("");
rs.setPassword("");
Connection connection = DriverManager.getConnection(url,"","");
//RECUPERATION D'UN RESULTSET
Statement statement = connection.createStatement(
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_READ_ONLY);
ResultSet resultat = statement.executeQuery("SELECT * FROM Products");
rs.setUrl(url);
rs.setUsername("");
rs.setPassword("");
rs.setType(ResultSet.TYPE_SCROLL_INSENSITIVE);
rs.setConcurrency(ResultSet.CONCUR_UPDATABLE);
rs.setCommand("SELECT * FROM Products");
rs.populate(resultat);
connection.close();
while (rs.next()) {
System.out.println(rs.getString("Produit"));
}
}
} |
Partager