Guest User

Untitled

a guest
Oct 11th, 2018
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.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. }
  79.  
  80. net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.6 usuario no tiene privilegios suficientes o objeto no encontrado: ADMIN
  81. at net.ucanaccess.jdbc.UcanaccessStatement.executeQuery(UcanaccessStatement.java:211)
  82. at ConnectAccess.conectar(ConnectAccess.java:50)
  83. at Main.main(Main.java:12)
  84. Caused by: java.sql.SQLSyntaxErrorException: usuario no tiene privilegios suficientes o objeto no encontrado: ADMIN
  85. at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
  86. at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
  87. at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
  88. at org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source)
  89. at net.ucanaccess.jdbc.UcanaccessStatement.executeQuery(UcanaccessStatement.java:208)
  90. ... 2 more
  91. Caused by: org.hsqldb.HsqlException: usuario no tiene privilegios suficientes o objeto no encontrado: ADMIN
  92. at org.hsqldb.error.Error.error(Unknown Source)
  93. at org.hsqldb.error.Error.error(Unknown Source)
  94. at org.hsqldb.ExpressionColumn.checkColumnsResolved(Unknown Source)
  95. at org.hsqldb.QueryExpression.resolve(Unknown Source)
  96. at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
  97. at org.hsqldb.ParserCommand.compilePart(Unknown Source)
  98. at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
  99. at org.hsqldb.Session.executeDirectStatement(Unknown Source)
  100. at org.hsqldb.Session.execute(Unknown Source)
  101. ... 5 more
  102.  
  103. public class Main {
  104.  
  105. public static void main(String args[]){
  106.  
  107. ConnectAccess ca = new ConnectAccess();
  108.  
  109. ca.setRutaDB("C:/Users/USUARIO/Desktop/usuarios.accdb");
  110. ca.setUser(null);
  111. ca.setPass(null);
  112. ca.setSql("SELECT * FROM usuarios WHERE Usuario='admin' ");
  113. ca.conectar();
  114. }
  115.  
  116. }
  117.  
  118. public class Main {
  119.  
  120. public static void main(String args[]){
  121.  
  122. ConnectAccess ca = new ConnectAccess();
  123.  
  124. ca.setRutaDB("C:/Users/USUARIO/Desktop/usuarios.accdb");
  125. ca.setUser(null);
  126. ca.setPass(null);
  127. ca.setSql("SELECT * FROM usuarios WHERE Usuario=admin");
  128. ca.conectar();
  129. }
  130.  
  131. }
Add Comment
Please, Sign In to add comment