Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2016
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.82 KB | None | 0 0
  1. public void DodajObrisiPristupe(JTable tabela, JComboBox<String> korisnickoime)
  2. {
  3. DefaultTableModel model = (DefaultTableModel)tabela.getModel();
  4.  
  5. for (int i = 0; i < model.getRowCount(); i++)
  6. {
  7. String serijskibroj = model.getValueAt(i, 2).toString();
  8. boolean pristup = (Boolean)model.getValueAt(i, 4);
  9.  
  10. if(ProveriDaLiPostojiPristup(serijskibroj, korisnickoime.getSelectedItem().toString()) == true)
  11. {
  12. if(pristup == false)
  13. ObrisiPristup(serijskibroj, korisnickoime.getSelectedItem().toString());
  14. }
  15.  
  16. else
  17. {
  18. if(pristup == true)
  19. DodajPristup(serijskibroj, korisnickoime.getSelectedItem().toString());
  20. }
  21. }
  22. }
  23.  
  24. public boolean ProveriDaLiPostojiPristup(String serijskibroj, String korisnickoime)
  25. {
  26. Connection c = null;
  27. Statement stmt = null;
  28.  
  29. try {
  30.  
  31. Class.forName("org.sqlite.JDBC");
  32. c = DriverManager.getConnection("jdbc:sqlite:" + naziv + ".db");
  33.  
  34. stmt = c.createStatement();
  35.  
  36. ResultSet rs = stmt.executeQuery("SELECT * FROM PRISTUPI;");
  37.  
  38. while(rs.next())
  39. {
  40. if(Decrypt(rs.getString("korisnickoime")).equals(korisnickoime) && Decrypt(rs.getString("vage")).equals(serijskibroj))
  41. return true;
  42. }
  43.  
  44. rs.close();
  45. stmt.close();
  46. c.close();
  47. }
  48. catch ( Exception e ) {
  49.  
  50. System.err.println( e.getClass().getName() + ": " + e.getMessage() );
  51. System.exit(0);
  52. }
  53.  
  54. return false;
  55. }
  56.  
  57. public void DodajPristup(String serijskibroj, String korisnickoime)
  58. {
  59. Connection c = null;
  60. Statement stmt = null;
  61.  
  62. try {
  63.  
  64. Class.forName("org.sqlite.JDBC");
  65. c = DriverManager.getConnection("jdbc:sqlite:" + naziv + ".db");
  66.  
  67. stmt = c.createStatement();
  68.  
  69. String sql = "INSERT INTO PRISTUPI (KORISNICKOIME,VAGE) " +
  70. "VALUES ('" + Encrypt(korisnickoime) + "', '" + Encrypt(serijskibroj) + "');";
  71. stmt.executeUpdate(sql);
  72.  
  73. stmt.close();
  74. c.close();
  75. }
  76. catch ( Exception e ) {
  77.  
  78. System.err.println( e.getClass().getName() + ": " + e.getMessage() );
  79. System.exit(0);
  80. }
  81. }
  82.  
  83. public void ObrisiPristup(String serijskibroj, String korisnickoime)
  84. {
  85. Connection c = null;
  86. Statement stmt = null;
  87.  
  88. try {
  89.  
  90. Class.forName("org.sqlite.JDBC");
  91. c = DriverManager.getConnection("jdbc:sqlite:" + naziv + ".db");
  92.  
  93. stmt = c.createStatement();
  94.  
  95. String sql = "DELETE from PRISTUPI where KORISNICKOIME = '" + Encrypt(korisnickoime) + "' AND VAGE = '" + Encrypt(serijskibroj) + "';";
  96. stmt.executeUpdate(sql);
  97.  
  98. stmt.close();
  99. c.close();
  100. }
  101. catch ( Exception e ) {
  102.  
  103. System.err.println( e.getClass().getName() + ": " + e.getMessage() );
  104. System.exit(0);
  105. }
  106. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement