Advertisement
Guest User

Untitled

a guest
Aug 21st, 2016
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.55 KB | None | 0 0
  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.ResultSet;
  4. import java.sql.Statement;
  5.  
  6. public class ConnectAccess {
  7.  
  8. static String rutaDB;
  9. static String user;
  10. static String pass;
  11. static String sql;
  12.  
  13. public static String getRutaDB() {
  14. return rutaDB;
  15. }
  16. public void setRutaDB(String rutaDB) {
  17. ConnectAccess.rutaDB = rutaDB;
  18. }
  19.  
  20. public static String getUser() {
  21. return user;
  22. }
  23. public void setUser(String user) {
  24. ConnectAccess.user = user;
  25. }
  26.  
  27. public static String getPass() {
  28. return pass;
  29. }
  30. public void setPass(String pass) {
  31. ConnectAccess.pass = pass;
  32. }
  33.  
  34. public static String getSql() {
  35. return sql;
  36. }
  37. public void setSql(String sql) {
  38. ConnectAccess.sql = sql;
  39. }
  40.  
  41.  
  42.  
  43.  
  44. public void conectar(){
  45. try{
  46. Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
  47.  
  48. Connection con = DriverManager.getConnection("jdbc:ucanaccess://"+rutaDB,user,pass);
  49. Statement st = con.createStatement();
  50. ResultSet rs = st.executeQuery(sql);
  51.  
  52. while(rs.next()){
  53. System.out.println(rs.getString("Usuario"));
  54. System.out.println(rs.getString("Contraseña"));
  55. System.out.println(rs.getString("Permiso"));
  56. }
  57.  
  58. }catch(Exception e){
  59. e.printStackTrace();
  60. }
  61. }
  62.  
  63. }
  64.  
  65. public class Main {
  66.  
  67. public static void main(String args[]){
  68.  
  69. ConnectAccess ca = new ConnectAccess();
  70.  
  71. ca.setRutaDB("C:/Users/USUARIO/Desktop/usuarios.accdb");
  72. ca.setUser(null);
  73. ca.setPass(null);
  74. ca.setSql("SELECT * FROM usuarios WHERE Usuario=admin");
  75. ca.conectar();
  76. }
  77.  
  78. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement