-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathVotingSystem.java
More file actions
63 lines (53 loc) · 2.62 KB
/
Copy pathVotingSystem.java
File metadata and controls
63 lines (53 loc) · 2.62 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
package System;
import Users.Admin;
import Users.User;
import java.sql.*;
public class VotingSystem {
User user;
public static Admin authorization(String login, String password) throws SQLException {
String query = "SELECT name, id FROM election.administrate WHERE login = " + "'" + login + "' AND password = '" + password + "'";
if (BDateMySql.query(query).next()) {
int id = BDateMySql.query(query).getInt("id");
System.out.println("Администратор " + login);
return new Admin(login, password, id);
} else {
System.out.println("Неверные login или password");
}
return null;
}
public User addUser(String name,String login,String password) throws SQLException {
String query = "SELECT Login FROM election.voters WHERE Login = " + "'" + login + "'";
if (BDateMySql.query(query).next()) {
System.out.println("Уже есть такой");
} else {
BDateMySql.update("INSERT INTO election.voters (Name, Login, Password) VALUES ('" + name + "' , '" + login + "' , '" + password + "')");
User user = new User(name, login, password);
this.user=user;
}
return user;
}
public boolean findUser(String Login,String Password) throws SQLException {
String guery = "SELECT Login,Password FROM election.voters WHERE Login = " + " '"+ Login +"' AND Password ='" +Password+ "' ";
if(BDateMySql.query(guery).next()){
int id = BDateMySql.query(guery).getInt("id");
String name =BDateMySql.query(guery).getString("Name");
System.out.print("Найден пользователь : " + id + name + Login);
return true;
} else{
System.out.print("Такой пользователь не зарегестрирован");
return false;
}
}
public void getResalts() throws SQLException {
String guery = "SELECT MAX(voices) FROM election.candidate ";
ResultSet id = BDateMySql.query(guery);
String gueryLost = "SELECT * FROM election.candidate WHERE Voices = '"+id+"' ";
while (BDateMySql.query(guery).next()) {
int idCan = BDateMySql.query(guery).getInt("Namber");
String name = BDateMySql.query(guery).getString("NameCandidate");
int voices = BDateMySql.query(guery).getInt("Voices");
System.out.print("В выборах победил : " + idCan + name + " с количеством голосов - " + voices);
BDateMySql.closeConnection();
}
}
}