Guest User

Untitled

a guest
Mar 11th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.00 KB | None | 0 0
  1. driver = com.mysql.jdbc.Driver
  2. url = jdbc:mysql://localhost:3306/TestingSystem
  3. user = root
  4. password = admin
  5. charset = utf8
  6.  
  7. private void connect(){
  8. String urlDB = properties.getProperty("url");
  9. connectionInfo.put("user", properties.getProperty("user"));
  10. connectionInfo.put("password", properties.getProperty("password"));
  11. connectionInfo.put("charSet", properties.getProperty("charset"));
  12. try {
  13. Class.forName(properties.getProperty("driver"));
  14. } catch (ClassNotFoundException e) {
  15. log.error("Not found driver for data base");
  16. }
  17. try {
  18. connection = DriverManager.getConnection(urlDB, connectionInfo);
  19. if(connection == null) {
  20. log.error("Connection with data base isn't open.");
  21. } else {
  22. log.info("Connection with data base is open.");
  23. }
  24. } catch (SQLException e) {
  25. log.error("Error connection with data base");
  26. }
  27. }
  28.  
  29. UPDATE basic_data SET data = 'Пример'
  30. WHERE name = 'Пример'
  31.  
  32.  
  33. INSERT INTO test_data_questions(input_data, output_data, id_question)
  34. VALUES('Пример', 'Пример', (SELECT q.id FROM questions q WHERE q.title = 'Пример'))
  35.  
  36. public List<TestData> getTestDataForQuestion(String nameQuestion){
  37. List<TestData> testDataForQuestion = new ArrayList<>();
  38. String query = "SELECT input_data, output_data " +
  39. "FROM test_data_questions " +
  40. "WHERE id_question = (SELECT q.id FROM questions q WHERE q.title = '" + nameQuestion + "')";
  41. ResultSet resultQuery = dataBase.execSelect(query);
  42. try {
  43. while(resultQuery.next()){
  44. String inputData = resultQuery.getString("INPUT_DATA");
  45. String outputData = resultQuery.getString("OUTPUT_DATA");
  46. TestData testData = new TestData(inputData, outputData);
  47. testDataForQuestion.add(testData);
  48. }
  49. } catch (SQLException e) {
  50. log.error("Error is reading test data for Question. Query: " + query);
  51. }
  52. return testDataForQuestion;
  53. }
Add Comment
Please, Sign In to add comment