-
Notifications
You must be signed in to change notification settings - Fork 0
/
Database .sql
48 lines (42 loc) · 1.79 KB
/
Database .sql
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
CREATE DATABASE login_system;
USE login_system;
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) UNIQUE NOT NULL,
password VARCHAR(50) NOT NULL
);
INSERT INTO users (username, password) VALUES
('user1', 'password1'),
('user2', 'password2');
import java.sql.*;
public class DatabaseConnector {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/login_system";
String username = "your_username";
String password = "your_password";
try (Connection connection = DriverManager.getConnection(url, username, password)) {
System.out.println("Connected to the database.");
// Authenticate user
String inputUsername = "user1";
String inputPassword = "password1";
boolean isAuthenticated = authenticateUser(connection, inputUsername, inputPassword);
if (isAuthenticated) {
System.out.println("Login successful!");
} else {
System.out.println("Invalid username or password.");
}
} catch (SQLException e) {
System.err.println("Error connecting to the database: " + e.getMessage());
}
}
public static boolean authenticateUser(Connection connection, String username, String password) throws SQLException {
String query = "SELECT * FROM users WHERE username = ? AND password = ?";
try (PreparedStatement statement = connection.prepareStatement(query)) {
statement.setString(1, username);
statement.setString(2, password);
try (ResultSet resultSet = statement.executeQuery()) {
return resultSet.next(); // True if a row is found, indicating successful authentication
}
}
}
}