Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.Statement;
- public class ConnectAccess {
- static String rutaDB;
- static String user;
- static String pass;
- static String sql;
- public static String getRutaDB() {
- return rutaDB;
- }
- public void setRutaDB(String rutaDB) {
- ConnectAccess.rutaDB = rutaDB;
- }
- public static String getUser() {
- return user;
- }
- public void setUser(String user) {
- ConnectAccess.user = user;
- }
- public static String getPass() {
- return pass;
- }
- public void setPass(String pass) {
- ConnectAccess.pass = pass;
- }
- public static String getSql() {
- return sql;
- }
- public void setSql(String sql) {
- ConnectAccess.sql = sql;
- }
- public void conectar(){
- try{
- Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
- Connection con = DriverManager.getConnection("jdbc:ucanaccess://"+rutaDB,user,pass);
- Statement st = con.createStatement();
- ResultSet rs = st.executeQuery(sql);
- while(rs.next()){
- System.out.println(rs.getString("Usuario"));
- System.out.println(rs.getString("Contraseña"));
- System.out.println(rs.getString("Permiso"));
- }
- }catch(Exception e){
- e.printStackTrace();
- }
- }
- }
- public class Main {
- public static void main(String args[]){
- ConnectAccess ca = new ConnectAccess();
- ca.setRutaDB("C:/Users/USUARIO/Desktop/usuarios.accdb");
- ca.setUser(null);
- ca.setPass(null);
- ca.setSql("SELECT * FROM usuarios WHERE Usuario=admin");
- ca.conectar();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement