Guest User

Untitled

a guest
Feb 25th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.55 KB | None | 0 0
  1. public void insertUserData(String SQLiteName, String SQLiteSurname,
  2. String SQLitePosition, double SQLiteSalary,
  3. double SQLiteExperience) {
  4. try {
  5. sqlQuery = "INSERT INTO MainEmployeeData(Name, Surname, Position, Salary, Experience)" +
  6. "VALUES('" + SQLiteName + "', '" + SQLiteSurname + "', '" + SQLitePosition + "', " +
  7. "'" + SQLiteSalary + "', '" + SQLiteExperience + "')";
  8.  
  9. boolSqlQuery = "SELECT Name, Surname " + "FROM MainEmployeeData WHERE Name = "" +
  10. SQLiteName + "" AND Surname = "" + SQLiteSurname + """;
  11. trueAnswer = "Data was successfully saved!";
  12. falseAnswer = "Record with such parameters already exists!";
  13. existenceCheckerInsertion(boolSqlQuery, sqlQuery, trueAnswer, falseAnswer);
  14. } catch (Exception e) {
  15. System.out.println(e.getMessage());
  16. }
  17. }
  18.  
  19. public void deleteEmployeeData(String employeeName, String employeeSurname) {
  20. try {
  21. trueAnswer = "Data was successfully deleted!";
  22. falseAnswer = "No record with such parameters exists!";
  23.  
  24. boolSqlQuery = "SELECT Name, Surname FROM MainEmployeeData WHERE Name = "" +
  25. employeeName + "" AND Surname = "" + employeeSurname + """;
  26.  
  27. sqlQuery = "DELETE FROM MainEmployeeData WHERE Name = "" + employeeName + """ +
  28. "AND Surname = "" + employeeSurname + """;
  29.  
  30. recordExistenceChecker(boolSqlQuery, sqlQuery, trueAnswer,
  31. falseAnswer);
  32. } catch (Exception e) {
  33. System.out.println(e.getMessage());
  34. }
  35. }
  36.  
  37. public <E> void modifyEmployeeDataInDB(String getParameterToBeModified,
  38. E getOldParameter, E getNewParameter) {
  39. try {
  40. trueAnswer = "Data was successfully changed!";
  41. falseAnswer = "No record with such parameter found!";
  42.  
  43. boolSqlQuery = "SELECT " + getParameterToBeModified + " FROM MainEmployeeData" +
  44. " WHERE " + getParameterToBeModified + " = " + """ + getOldParameter + """;
  45.  
  46. sqlQuery = "UPDATE MainEmployeeData SET " + getParameterToBeModified +
  47. " = "" + getNewParameter + "" WHERE " + getParameterToBeModified +
  48. " = " + """ + getOldParameter + """;
  49.  
  50. recordExistenceChecker(boolSqlQuery, sqlQuery, trueAnswer,
  51. falseAnswer);
  52. } catch (Exception e) {
  53. System.out.println(e.getMessage());
  54. }
  55. }
  56.  
  57. private void recordExistenceChecker(String getBoolSqlQuery,
  58. String getSqlQuery,
  59. String getTrueAnswer,
  60. String getFalseAnswer) throws SQLException {
  61. stmt = connect.createStatement();
  62. stmt.execute(getBoolSqlQuery);
  63.  
  64. ResultSet rs = stmt.getResultSet();
  65.  
  66. if (rs.next()) {
  67. stmt.execute(getSqlQuery);
  68. System.out.print(getTrueAnswer);
  69. stmt.close();
  70. } else {
  71. System.out.println(getFalseAnswer);
  72. }
  73.  
  74. stmt.close();
  75. }
  76.  
  77. private void existenceCheckerInsertion(String getBoolSqlQuery,
  78. String getSqlQuery,
  79. String getTrueAnswer,
  80. String getFalseAnswer) throws SQLException {
  81. stmt = connect.createStatement();
  82. stmt.execute(getBoolSqlQuery);
  83. ResultSet rs = stmt.getResultSet();
  84.  
  85. if (!rs.next()) {
  86. stmt.execute(getSqlQuery);
  87. System.out.print(getTrueAnswer);
  88. stmt.close();
  89. } else {
  90. System.out.println(getFalseAnswer);
  91. }
  92.  
  93. stmt.close();
  94. }
Add Comment
Please, Sign In to add comment