/
houpsyu
/
Demo
Обзор
Документация
Войти
/
houpsyu
/
Demo
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
src/main/java/CreateTable.java
44 строки
1 KB
demo
1
12 янв 2026, 17:48
12 янв 2026, 17:48
89b65aa
Код
Авторство
О чём код?
import java.sql.Connection; import java.sql.SQLException; import java.sql.Statement; public class CreateTable { // SQL statement to create a sample table private static final String CREATE_TABLE_SQL = "CREATE TABLE IF NOT EXISTS users (" + "id SERIAL PRIMARY KEY," + "username VARCHAR(50) NOT NULL UNIQUE," + "email VARCHAR(100) NOT NULL UNIQUE," + "created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP," + "is_active BOOLEAN DEFAULT TRUE" + ")"; public static void main(String[] args) { Connection connection = null; Statement statement = null; try { // Get database connection connection = DatabaseConnection.getConnection(); statement = connection.createStatement(); // Execute the create table statement statement.execute(CREATE_TABLE_SQL); System.out.println("Table 'users' created successfully!"); } catch (SQLException e) { System.err.println("Error creating table: " + e.getMessage()); e.printStackTrace(); } finally { // Close resources try { if (statement != null) statement.close(); if (connection != null) connection.close(); } catch (SQLException e) { System.err.println("Error closing resources: " + e.getMessage()); e.printStackTrace(); } } } }