package servlet;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;

/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
/**
*
* @author
*/
public class DatabaseConnection {

private Connection conn;// = null;
public DatabaseConnection() {
   conn = null;
}

public Connection connect(String database){
   try{
         Class.forName("com.mysql.jdbc.Driver");
         conn = DriverManager.getConnection("jdbc:mysql://localhost/" + database,"root", "");

   }catch(ClassNotFoundException e){
   } catch (SQLException e) {
   }
   return conn;
}

public ResultSet query(PreparedStatement stmt){
   ResultSet rs = null;
   try {
         rs = stmt.executeQuery();
   } catch (SQLException ex) {
         Logger.getLogger(DatabaseConnection.class.getName()).log(Level.SEVERE, null, ex);
   }
   return rs;
}
public void close(){
   try {
         if (conn != null)
            conn.close();
   } catch (SQLException ex) {
         Logger.getLogger(DatabaseConnection.class.getName()).log(Level.SEVERE, null, ex);

Task #1 - Why does this command fail? S CREATE (1 : Actor {name :...