Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.io.BufferedWriter;
- import java.io.FileWriter;
- import java.io.IOException;
- import java.sql.*;
- public class schemaCheck {
- private static String server = ""; //задается в параметре запуска
- private static String port = "5432";
- private static String username = "postgres";
- private static String password = "postgres";
- private static String dbName = "postgres";
- private static String driverName = "org.postgresql.Driver";
- private static Boolean programTask = Boolean.valueOf(true);
- //Проверка входных параметров
- //Если их нет то заменяет на заданные по умолчанию
- public static void main(String[] arrstring) throws ClassNotFoundException {
- if (!arrstring[0].equals("")) {
- server = arrstring[0];
- }
- if (!arrstring[1].equals("")) {
- port = arrstring[1];
- }
- if (!arrstring[2].equals("")) {
- username = arrstring[2];
- }
- if (!arrstring[3].equals("")) {
- password = arrstring[3];
- }
- if (arrstring.length == 6) {
- if (!arrstring[4].equals("")) {
- dbName = arrstring[4];
- }
- programTask = Boolean.valueOf(false);
- }
- String string = "jdbc:postgresql://" + server + ":" + port + "/";
- connect(string + dbName, driverName, username, password);
- }
- private static void connect(String string, String string2, String string3, String string4) throws ClassNotFoundException {
- Class.forName(string2);
- try {
- Connection var12 = DriverManager.getConnection(string, string3, string4);
- Statement statement = var12.createStatement();
- String string8;
- if (programTask.booleanValue()) {
- string8 = "select datname from pg_database where datname not like 'postgres' and datname not like 'template%' order by datname;";
- ResultSet resultSet = statement.executeQuery(string8);
- try {
- BufferedWriter var11 = new BufferedWriter(new FileWriter(server + ".txt"));
- var11.write(String.format("Параметры для подключения к БД: \n", new Object[0]));
- var11.write(String.format("azk.db.url=%-30s <ИМЯ БД> \n", new Object[]{string}));
- var11.write(String.format("azk.db.user=postgres \n", new Object[0]));
- var11.write(String.format("azk.db.password=postgres \n\n", new Object[0]));
- var11.write(String.format("Доступные БД \n", new Object[0]));
- var11.write(String.format("%-30s %-30s \n", new Object[]{"<ИМЯ БД>", "<ВЕРСИЯ>"}));
- while (resultSet.next()) {
- String string6 = resultSet.getString("datname");
- var11.write(String.format("%-30s\n", new Object[]{string6}));
- }
- var12.close();
- var11.close();
- } catch (IOException var111) {
- var111.printStackTrace();
- }
- }
- } catch (SQLException var121) {
- System.out.println(var121.toString());
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement