This repository was archived by the owner on Aug 25, 2026. It is now read-only.
Repository navigation
Expand file tree
/
Copy pathconMySQL.java
More file actions
99 lines (82 loc) · 4.05 KB
/
Copy pathconMySQL.java
File metadata and controls
99 lines (82 loc) · 4.05 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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
import java.sql.*;
public class conMySQL {
static final String url = "jdbc:mysql://IP_SV:3306/DATABASE"; // Change IP_SV and DATABASE
static final String user = "USERNAME"; // Change USERNAME
static final String password = "PASSWORD"; // Change PASSWORD
public static String[] result;
public static String[] getResult() {
return result;
}
public static void selectQuery(String query) {
if (!query.toUpperCase().contains("SELECT") || query.toUpperCase().contains("DELETE") || query.toUpperCase().contains("UPDATE") || query.toUpperCase().contains("INSERT") || query.toUpperCase().contains("TRUNCATE") || query.toUpperCase().contains("ALTER")){
System.out.println("You should only execute SELECT queries.");
return;
}
try {
Class.forName("com.mysql.cj.jdbc.Driver");
Connection conexion = DriverManager.getConnection(url, user, password);
Statement statement = conexion.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
ResultSet resultSet = statement.executeQuery(query);
ResultSetMetaData rsmd = resultSet.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
resultSet.last();
int numberOfRows = resultSet.getRow();
resultSet.beforeFirst();
result = new String[numberOfRows * numberOfColumns];
int index = 0;
while (resultSet.next()) {
for (int i = 0; i < numberOfColumns; i++) {
result[index++] = resultSet.getString(i + 1);
}
}
conexion.close();
} catch (Exception e) {
System.out.println(e);
}
}
public static void insertQuery(String query) {
if (!query.toUpperCase().contains("INSERT") || query.toUpperCase().contains("DELETE") || query.toUpperCase().contains("UPDATE") || query.toUpperCase().contains("TRUNCATE") || query.toUpperCase().contains("ALTER")) {
System.out.println("You should only execute INSERT queries.");
return;
}
try {
Class.forName("com.mysql.cj.jdbc.Driver");
Connection conexion = DriverManager.getConnection(url, user, password);
Statement statement = conexion.createStatement();
statement.executeUpdate(query);
conexion.close();
} catch (Exception e) {
System.out.println(e);
}
}
public static void deleteQuery(String query) {
if (!query.toUpperCase().contains("DELETE") || query.toUpperCase().contains("UPDATE") || query.toUpperCase().contains("INSERT") || query.toUpperCase().contains("TRUNCATE") || query.toUpperCase().contains("ALTER")) {
System.out.println("You should only execute DELETE queries.");
return;
}
try {
Class.forName("com.mysql.cj.jdbc.Driver");
Connection conexion = DriverManager.getConnection(url, user, password);
Statement statement = conexion.createStatement();
statement.executeUpdate(query);
conexion.close();
} catch (Exception e) {
System.out.println(e);
}
}
public static void updateQuery(String query) {
if (!query.toUpperCase().contains("UPDATE") || query.toUpperCase().contains("DELETE") || query.toUpperCase().contains("INSERT") || query.toUpperCase().contains("TRUNCATE") || query.toUpperCase().contains("ALTER")){
System.out.println("You should only execute UPDATE queries.");
return;
}
try {
Class.forName("com.mysql.cj.jdbc.Driver");
Connection conexion = DriverManager.getConnection(url, user, password);
Statement statement = conexion.createStatement();
statement.executeUpdate(query);
conexion.close();
} catch (Exception e) {
System.out.println(e);
}
}
}