public JSONObject removeTestQuestion(JSONRPC2Request req, HttpServletRequest request)
throws Exception, SQLException {
JSONObject jsonResult = new JSONObject();
// set retrievers
Map<String, Object> params = req.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
Map<String, Object> tParams = np.getMap("test");
NamedParamsRetriever testNp = new NamedParamsRetriever(tParams);
Map<String, Object> qParams = np.getMap("question");
NamedParamsRetriever questNp = new NamedParamsRetriever(qParams);
MySQLDAO dao = new MySQLDAO();
Test t = dao.loadTest(testNp.getInt(("id")));
dao = new MySQLDAO();
Question q = dao.loadQuestion(questNp.getInt("id"));
User u = getCurrentUser(request);
if (u.getId() == t.getOwnerId()) {
dao = new MySQLDAO();
t = dao.deleteTestQuestion(t, q);
} else {
throw new Exception("no privileges : you do not own this test");
}
JSONObject jsonTest = t.toJSONObject();
JSONObject jsonQuestion = q.toJSONObject();
jsonResult.put("test", jsonTest);
jsonResult.put("question", jsonQuestion);
return jsonResult;
}
public JSONObject loadTestAndAllQuestions(JSONRPC2Request req, HttpServletRequest request)
throws Exception {
JSONObject jsonResult = new JSONObject();
JSONArray jsonAllQuestions = new JSONArray();
JSONObject jsonTest = new JSONObject();
// retrievers
Map<String, Object> params = req.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
Map<String, Object> tParams = np.getMap("test");
NamedParamsRetriever testNp = new NamedParamsRetriever(tParams);
int tid = testNp.getInt("id");
// get data from DB
MySQLDAO dao = new MySQLDAO();
Test t = dao.loadTest(tid);
QuestionsList allQuestions = QuestionController.loadAllQuestions();
// set result
jsonTest = t.toJSONObject();
jsonAllQuestions = allQuestions.toJSONArray();
jsonResult.put("test", jsonTest);
jsonResult.put("questions", jsonAllQuestions);
return jsonResult;
}
public JSONObject checkTest(JSONRPC2Request req, HttpServletRequest request)
throws JSONRPC2Error, Exception {
JSONObject jsonResult = new JSONObject();
JSONArray jsonWrongQuestions = new JSONArray();
QuestionsList wrongQuestions = new QuestionsList();
// retrievers
Map<String, Object> params = req.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
Map<String, Object> tParams = np.getMap("test");
NamedParamsRetriever testNp = new NamedParamsRetriever(tParams);
// get guessed questions values
QuestionsList guessQuestions = new QuestionsList();
List<Object> questions = testNp.getList("questions");
for (Object q : questions) {
// set new retriever for each question
NamedParamsRetriever questNp = new NamedParamsRetriever((Map<String, Object>) q);
// retrieve values
String answer = questNp.getString("answer");
String body = questNp.getString("body");
int id = questNp.getInt("id");
// create question with the values and add it to the guessed questions
Question quest = new Question();
quest.setId(id);
quest.setBody(body);
quest.setAnswer(answer);
guessQuestions.add(quest);
}
// get test
int tid = testNp.getInt("id");
MySQLDAO dao = new MySQLDAO();
Test t = dao.loadTest(tid);
// get true questions
MySQLDAO questionsDao = new MySQLDAO();
QuestionsList trueQuestions = questionsDao.loadQuestionsByTest(tid);
// cycle through questions and find these with same id
for (Question tq : trueQuestions) {
for (Question gq : guessQuestions) {
if (tq.getId() == gq.getId()) {
// if answers are different, than there is mistake
System.out.println("id match!");
if (!tq.getAnswer().equals(gq.getAnswer())) {
System.out.println("Wrong question!");
wrongQuestions.add(gq);
}
}
}
}
jsonWrongQuestions = wrongQuestions.toJSONArray();
jsonResult.put("test", t);
jsonResult.put("wrongQuestions", jsonWrongQuestions);
return jsonResult;
}
public User getCurrentUser(HttpServletRequest request) {
// get session user
HttpSession session = request.getSession();
String userMail = (String) session.getAttribute("user");
try {
MySQLDAO dao = new MySQLDAO();
User u = new User();
u = dao.loadUser(userMail);
return u;
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return null;
}
public JSONObject addTestQuestion(JSONRPC2Request req, HttpServletRequest request)
throws Exception, SQLException {
JSONObject jsonResult = new JSONObject();
// set retrievers
Map<String, Object> params = req.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
Map<String, Object> tParams = np.getMap("test");
NamedParamsRetriever testNp = new NamedParamsRetriever(tParams);
Map<String, Object> qParams = np.getMap("question");
NamedParamsRetriever questNp = new NamedParamsRetriever(qParams);
int tid = testNp.getInt(("id"));
int qid = questNp.getInt(("id"));
// load test and question
MySQLDAO dao = new MySQLDAO();
Test t = dao.loadTest(tid);
dao = new MySQLDAO();
Question q = dao.loadQuestion(qid);
// load current user
User u = getCurrentUser(request);
if (u.getId() == t.getOwnerId()) {
// check for duplicates
boolean duplicate = false;
for (Question quest : t.getQuestions()) {
if (quest.getId() == qid) {
duplicate = true;
}
}
if (!duplicate) {
dao = new MySQLDAO();
t = dao.saveTestQuestion(t, q);
}
} else {
throw new Exception("no privileges : you do not own this test!");
}
// set result
JSONObject jsonTest = t.toJSONObject();
JSONObject jsonQuestion = q.toJSONObject();
jsonResult.put("test", jsonTest);
jsonResult.put("question", jsonQuestion);
return jsonResult;
}
public JSONObject loginUser(
HttpServletRequest request, HttpServletResponse response, JSONRPC2Request jsonReq)
throws Exception {
// define new json for the result
JSONObject jsonLogin = new JSONObject();
// get user info
Map<String, Object> params = jsonReq.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
String password = PassEncript.PassHash(np.getString("password"));
System.out.println("input pass " + password);
String email = np.getString("email");
// establish connection
MySQLDAO dao = new MySQLDAO();
// get user by email
User u = new User();
u = dao.loadUser(email);
if (!(u.getEmail().equals(email))) {
throw new Exception("incorrect email");
} else {
// check if password is correct
if (u.getPassword().equals(password)) {
// create sesssion and cookies
HttpSession session = request.getSession();
session.setAttribute("pass", TimeEncrpyt.TimeHash());
System.out.println("session pass: "******"pass").toString());
session.setAttribute("user", email);
System.out.println("session user: "******"user").toString());
session.setMaxInactiveInterval(30 * 60);
Cookie pass = new Cookie("pass", TimeEncrpyt.TimeHash());
System.out.println("cookie pass: "******"user", u.toJSONObject());
return jsonLogin;
} else {
throw new Exception("password missmatch");
}
}
}
public JSONArray loadQuestionsByTest(JSONRPC2Request req, HttpServletRequest request)
throws Exception, JSONRPC2Error {
JSONArray jsonTestQuestions = new JSONArray();
// get testId
Map<String, Object> params = req.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
Map<String, Object> tParams = np.getMap("test");
NamedParamsRetriever testNp = new NamedParamsRetriever(tParams);
int testId = testNp.getInt("id");
// get test questions
MySQLDAO dao = new MySQLDAO();
QuestionsList qByTest = dao.loadQuestionsByTest(testId);
// set result
jsonTestQuestions = qByTest.toJSONArray();
return jsonTestQuestions;
}
@Override
public void start(Stage primaryStage) {
try {
BorderPane root = new BorderPane();
Text t = new Text("Hello FX"); // set text here
root.setCenter(t);
Scene scene = new Scene(root, 400, 400);
scene
.getStylesheets()
.add(getClass().getResource("application.css").toExternalForm()); // Ooohh, CSS
primaryStage.setScene(scene);
primaryStage.show();
System.out.print("Loading db...");
// try out the db connectivity
MySQLDAO dao = new MySQLDAO();
dao.readDataBase();
} catch (Exception e) {
e.printStackTrace();
}
}
public JSONObject loadQuestion(JSONRPC2Request req, HttpServletRequest request) throws Exception {
JSONObject jsonResult = new JSONObject();
JSONObject jsonQuestion = new JSONObject();
// set retrievers
Map<String, Object> params = req.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
Map<String, Object> qParams = np.getMap("question");
NamedParamsRetriever questNp = new NamedParamsRetriever(qParams);
int qid = questNp.getInt("id");
// load question
MySQLDAO dao = new MySQLDAO();
Question q = dao.loadQuestion(qid);
// set result
jsonQuestion = q.toJSONObject();
jsonResult.put("question", jsonQuestion);
return jsonResult;
}
public JSONObject registerUser(JSONRPC2Request request, JSONRPC2Response response)
throws Exception {
@SuppressWarnings("unused")
JSONRPC2ParamsType paramsType = request.getParamsType();
Map<String, Object> params = request.getNamedParams();
NamedParamsRetriever np = new NamedParamsRetriever(params);
JSONObject jsonRegistration = new JSONObject();
// create new user
User u = new User();
// set params
u.setName(np.getString("name"));
u.setEmail(np.getString("email"));
u.setPassword(PassEncript.PassHash(np.getString("password")));
// add user
MySQLDAO dao = new MySQLDAO();
dao.insertUser(u);
jsonRegistration.put("user", u.toJSONObject());
return jsonRegistration;
}