/
Bungus
/
ShoesIS
Обзор
Документация
Войти
/
Bungus
/
ShoesIS
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
main
exportToHTML/com/example/obuv/DBHandler.java.html
72 строки
7 KB
Шоин Максим
Добавлен проект ИС магазина обуви
28 май 2026, 14:47
28 май 2026, 14:47
383b797
Код
Авторство
О чём код?
<html> <head> <title>DBHandler.java</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <style type="text/css"> .s0 { color: #cf8e6d;} .s1 { color: #bcbec4;} .s2 { color: #bcbec4;} .s3 { color: #6aab73;} .s4 { color: #7a7e85;} .s5 { color: #2aacb8;} </style> </head> <body bgcolor="#1e1f22"> <table CELLSPACING=0 CELLPADDING=5 COLS=1 WIDTH="100%" BGCOLOR="#606060" > <tr><td><center> <font face="Arial, Helvetica" color="#000000"> DBHandler.java</font> </center></td></tr></table> <pre><span class="s0">package </span><span class="s1">com</span><span class="s2">.</span><span class="s1">example</span><span class="s2">.</span><span class="s1">obuv</span><span class="s2">;</span> <span class="s0">import </span><span class="s1">java</span><span class="s2">.</span><span class="s1">sql</span><span class="s2">.*;</span> <span class="s0">public class </span><span class="s1">DBHandler </span><span class="s2">{</span> <span class="s0">private </span><span class="s1">Connection connection</span><span class="s2">;</span> <span class="s0">public void </span><span class="s1">DBConnection</span><span class="s2">() {</span> <span class="s0">try </span><span class="s2">{</span> <span class="s1">Class</span><span class="s2">.</span><span class="s1">forName</span><span class="s2">(</span><span class="s3">"org.postgresql.Driver"</span><span class="s2">);</span> <span class="s1">String url </span><span class="s2">= </span><span class="s3">"jdbc:postgresql://localhost:5432/shoes_shop"</span><span class="s2">;</span> <span class="s1">String user </span><span class="s2">= </span><span class="s3">"postgres"</span><span class="s2">;</span> <span class="s1">String password </span><span class="s2">= </span><span class="s3">"1111"</span><span class="s2">; </span><span class="s4">// Замените на ваш пароль</span> <span class="s1">connection </span><span class="s2">= </span><span class="s1">DriverManager</span><span class="s2">.</span><span class="s1">getConnection</span><span class="s2">(</span><span class="s1">url</span><span class="s2">, </span><span class="s1">user</span><span class="s2">, </span><span class="s1">password</span><span class="s2">);</span> <span class="s1">System</span><span class="s2">.</span><span class="s1">out</span><span class="s2">.</span><span class="s1">println</span><span class="s2">(</span><span class="s3">"Подключение к БД успешно!"</span><span class="s2">);</span> <span class="s2">} </span><span class="s0">catch </span><span class="s2">(</span><span class="s1">Exception e</span><span class="s2">) {</span> <span class="s1">System</span><span class="s2">.</span><span class="s1">out</span><span class="s2">.</span><span class="s1">println</span><span class="s2">(</span><span class="s3">"Ошибка подключения к БД: " </span><span class="s2">+ </span><span class="s1">e</span><span class="s2">);</span> <span class="s1">e</span><span class="s2">.</span><span class="s1">printStackTrace</span><span class="s2">();</span> <span class="s2">}</span> <span class="s2">}</span> <span class="s0">public </span><span class="s1">ResultSet executeQuery</span><span class="s2">(</span><span class="s1">String query</span><span class="s2">) </span><span class="s0">throws </span><span class="s1">SQLException </span><span class="s2">{</span> <span class="s0">if </span><span class="s2">(</span><span class="s1">connection </span><span class="s2">== </span><span class="s0">null </span><span class="s2">|| </span><span class="s1">connection</span><span class="s2">.</span><span class="s1">isClosed</span><span class="s2">()) {</span> <span class="s1">System</span><span class="s2">.</span><span class="s1">out</span><span class="s2">.</span><span class="s1">println</span><span class="s2">(</span><span class="s3">"Connection is not available"</span><span class="s2">);</span> <span class="s0">return null</span><span class="s2">;</span> <span class="s2">}</span> <span class="s1">PreparedStatement stmt </span><span class="s2">= </span><span class="s1">connection</span><span class="s2">.</span><span class="s1">prepareStatement</span><span class="s2">(</span><span class="s1">query</span><span class="s2">);</span> <span class="s0">return </span><span class="s1">stmt</span><span class="s2">.</span><span class="s1">executeQuery</span><span class="s2">();</span> <span class="s2">}</span> <span class="s0">public void </span><span class="s1">closeConnection</span><span class="s2">() {</span> <span class="s0">if </span><span class="s2">(</span><span class="s1">connection </span><span class="s2">!= </span><span class="s0">null</span><span class="s2">) {</span> <span class="s0">try </span><span class="s2">{</span> <span class="s1">connection</span><span class="s2">.</span><span class="s1">close</span><span class="s2">();</span> <span class="s1">System</span><span class="s2">.</span><span class="s1">out</span><span class="s2">.</span><span class="s1">println</span><span class="s2">(</span><span class="s3">"Соединение закрыто"</span><span class="s2">);</span> <span class="s2">} </span><span class="s0">catch </span><span class="s2">(</span><span class="s1">SQLException e</span><span class="s2">) {</span> <span class="s1">e</span><span class="s2">.</span><span class="s1">printStackTrace</span><span class="s2">();</span> <span class="s2">}</span> <span class="s2">}</span> <span class="s2">}</span> <span class="s0">public int </span><span class="s1">executeUpdate</span><span class="s2">(</span><span class="s1">String query</span><span class="s2">) </span><span class="s0">throws </span><span class="s1">SQLException </span><span class="s2">{</span> <span class="s0">if </span><span class="s2">(</span><span class="s1">connection </span><span class="s2">== </span><span class="s0">null </span><span class="s2">|| </span><span class="s1">connection</span><span class="s2">.</span><span class="s1">isClosed</span><span class="s2">()) {</span> <span class="s1">System</span><span class="s2">.</span><span class="s1">out</span><span class="s2">.</span><span class="s1">println</span><span class="s2">(</span><span class="s3">"Connection is not available"</span><span class="s2">);</span> <span class="s0">return </span><span class="s5">0</span><span class="s2">;</span> <span class="s2">}</span> <span class="s0">try </span><span class="s2">(</span><span class="s1">Statement stmt </span><span class="s2">= </span><span class="s1">connection</span><span class="s2">.</span><span class="s1">createStatement</span><span class="s2">()) {</span> <span class="s0">return </span><span class="s1">stmt</span><span class="s2">.</span><span class="s1">executeUpdate</span><span class="s2">(</span><span class="s1">query</span><span class="s2">);</span> <span class="s2">}</span> <span class="s2">}</span> <span class="s2">}</span></pre> </body> </html>