-
Notifications
You must be signed in to change notification settings - Fork 0
/
SqlConnection.java
47 lines (43 loc) · 1.36 KB
/
SqlConnection.java
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
import java.sql.*;
import java.sql.DriverManager;
public class SqlConnection {
// Класс для работы с PostreSQL
static final String URL = "jdbc:postgresql://127.0.0.1:5432/gui";
static final String name = "maxim";
static final String password = "12345";
Statement st;
Connection conn;
private Connection getConnection(){
// Подключение к бд
conn = null;
try {
conn = DriverManager.getConnection(URL, name, password);
return conn;
} catch (SQLException e) {
System.out.println("Connection Failed");
e.printStackTrace();
}
return null;
}
public ResultSet getData(String query){
// Получени Данных по запросу
ResultSet result = null;
try{
st = getConnection().createStatement();
result = st.executeQuery(query);
return result;
} catch (SQLException e){
e.printStackTrace();
}
return null;
}
public void InsertData(String query) throws SQLException {
// Вставка данных в бд по запросу
try{
st = getConnection().createStatement();
st.executeUpdate(query);
} catch (SQLException e){
throw new SQLException();
}
}
}