Notes

Sure, here's a simple example of how you can create a SQL database using Java and print the table for the employees' information from a CSV file:

Firstly, you'll need to have the CSV file (let's name it "employees.csv") with the structure you described: name, skill, contact, and email.

Next, you'll need the necessary libraries for handling CSV files (like OpenCSV) and JDBC for connecting to the SQL database. Make sure you have these dependencies in your project.

Here's an example code snippet:

```java
import java.io.FileReader;
import java.io.IOException;
import java.sql.*;

public class CSVToSQL {
public static void main(String[] args) {
String jdbcURL = "jdbc:mysql://localhost:3306/employees_database";
String username = "your_username";
String password = "your_password";

try (Connection connection = DriverManager.getConnection(jdbcURL, username, password)) {
String createTableSQL = "CREATE TABLE IF NOT EXISTS employees (" +
"name VARCHAR(255)," +
"skill VARCHAR(255)," +
"contact VARCHAR(255)," +
"email VARCHAR(255)" +
")";

try (Statement statement = connection.createStatement()) {
statement.execute(createTableSQL);

try (CSVReader csvReader = new CSVReader(new FileReader("employees.csv"))) {
String[] record;
while ((record = csvReader.readNext()) != null) {
String name = record[0];
String skill = record[1];
String contact = record[2];
String email = record[3];

String insertSQL = "INSERT INTO employees (name, skill, contact, email) VALUES (?, ?, ?, ?)";
try (PreparedStatement preparedStatement = connection.prepareStatement(insertSQL)) {
preparedStatement.setString(1, name);
preparedStatement.setString(2, skill);
preparedStatement.setString(3, contact);
preparedStatement.setString(4, email);
preparedStatement.executeUpdate();
}
}
}
}

// Print the table contents
String selectSQL = "SELECT * FROM employees";
try (Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(selectSQL)) {
while (resultSet.next()) {
System.out.println(
resultSet.getString("name") + "t" +
resultSet.getString("skill") + "t" +
resultSet.getString("contact") + "t" +
resultSet.getString("email")
);
}
}
} catch (SQLException | IOException e) {
e.printStackTrace();
}
}
}
```

Replace "your_username" and "your_password" with your actual MySQL username and password respectively. Adjust the JDBC URL according to your database setup (for example, change "jdbc:mysql://localhost:3306/employees_database" to match your database URL).

This code creates a table "employees" in the database if it doesn't exist already, inserts the data from the CSV file, and then prints the table contents using `System.out.println`.