How do you create an employee table using Java?

Question

Accepted Answer

Creating an employee table in Java involves using JDBC to connect to a database and execute SQL commands.

JDBC Connection: Use JDBC to establish a connection to your database. Example: `Connection conn = DriverManager.getConnection(url, user, password);`
SQL Statement: Write an SQL statement to create the employee table. Example: `String sql = "CREATE TABLE Employee (id INT PRIMARY KEY, name VARCHAR(100), age INT, department VARCHAR(50))";`
Execute Statement: Use a Statement object to execute the SQL command. Example: `Statement stmt = conn.createStatement(); stmt.executeUpdate(sql);`
Error Handling: Implement try-catch blocks to handle SQL exceptions. Example: `catch (SQLException e) { e.printStackTrace(); }`
Close Resources: Always close the connection and statement objects in a finally block to prevent resource leaks.

Interview Questions Asked to Senior Engineer at Other Companies