Ява программу по внесению изменений в DB .Пишет ошибку по SQL .

[Ильюха1]

Всем доброго времени суток . Пишу программу по добавлению данных в DB .

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.Statement;

public class DB {

    private final String HOST = "localhost";
    private final String PORT = "3306";
    private final String DB_NAME = "java_bd";
    private final String LOGIN = "root";
    private final String PASS = "root";

    private Connection dbConn=null;

    private Connection getDbConnection() throws ClassNotFoundException,SQLException{
        String connStr="jdbc:mysql://"+HOST+":"+PORT+"/"+DB_NAME;
        Class.forName("com.mysql.cj.jdbc.Driver");

        dbConn=DriverManager.getConnection(connStr, LOGIN,PASS);
        return dbConn;

    }
    public void isConnected()throws ClassNotFoundException,SQLException {
        dbConn = getDbConnection();
        System.out.println(dbConn.isValid(1000));
    }
    public void createTable(String tableName)throws ClassNotFoundException,SQLException{
        String sql= "CREATE TABLE IF NOT EXISTS" + tableName
                +"(id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50), password WARCHAR(100))"
                +"ENGINE=MYISAM;";
        Statement statement = getDbConnection().createStatement();
        statement.executeUpdate(sql);




    }
}

MAIN

import java.sql.SQLException;

public class Main {
    public static void main(String[] args) {
       DB db=new DB();
        try {
            db.createTable("users");

        } catch (SQLException e) {
            e.printStackTrace();
        }catch (ClassNotFoundException e){
            e.printStackTrace();
        }

    }
}

Вот ошибка которую выдаёт редактор.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'EXISTSusers
(id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50), password WARCHA' at line 1

[macomics]

пробел после EXISTS поставьте

String sql= "CREATE TABLE IF NOT EXISTS " + tableName
+"(id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50), password WARCHAR(100))"
+"ENGINE=MYISAM;";

[Ильюха1]

Поставил, не помогло.

[p51x]

и перед ENGINE тоже

[Ильюха1]

Парни прописал вот так не помогло

 import java.sql.Connection;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.Statement;

public class DB {

    private final String HOST = "localhost";
    private final String PORT = "3306";
    private final String DB_NAME = "java_bd";
    private final String LOGIN = "root";
    private final String PASS = "root";

    private Connection dbConn=null;


    private Connection getDbConnection() throws ClassNotFoundException,SQLException{
        String connStr="jdbc:mysql://"+HOST+":"+PORT+"/"+DB_NAME;
        Class.forName("com.mysql.cj.jdbc.Driver");

        dbConn=DriverManager.getConnection(connStr, LOGIN,PASS);
        return dbConn;

    }
    public void isConnected()throws ClassNotFoundException,SQLException {
        dbConn = getDbConnection();
        System.out.println(dbConn.isValid(1000));
    }
    public void createTable(String tableName)throws ClassNotFoundException,SQLException{
        String sql= " CREATE TABLE IF NOT EXISTS " + tableName
                +" (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50), password WARCHAR(100)) "
                +" ENGINE=MYISAM; ";
        Statement statement = getDbConnection().createStatement();
        statement.executeUpdate(sql);




    }
}

[macomics]

password VARCHAR(100)

[Ильюха1]

Спасибо большое . Всё пошло.

[Ильюха1]

Всем привет . Пробую достать из таблице список значений title , и редактор выдал мне похожую ошибку . Два раза проверил вроде всё верно .Не сочтите за наглость .

 import java.sql.*;

public class DB {

    private final String HOST = "localhost";
    private final String PORT = "3306";
    private final String DB_NAME = "java_bd";
    private final String LOGIN = "root";
    private final String PASS = "root";

    private Connection dbConn=null;

    private Connection getDbConnection() throws ClassNotFoundException,SQLException{
        String connStr="jdbc:mysql://"+HOST+":"+PORT+"/"+DB_NAME;
        Class.forName("com.mysql.cj.jdbc.Driver");

        dbConn=DriverManager.getConnection(connStr, LOGIN,PASS);
        return dbConn;

    }
    public void isConnected()throws ClassNotFoundException,SQLException {
        dbConn = getDbConnection();
        System.out.println(dbConn.isValid(1000));
    }
    public void createTable(String tableName)throws ClassNotFoundException,SQLException{
        String sql= " CREATE TABLE IF NOT EXISTS " + tableName
                +" (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50), password VARCHAR(100)) "
                +" ENGINE=MYISAM ";
        Statement statement = getDbConnection().createStatement();
        statement.executeUpdate(sql);

    }
    public void insertArticle (String title , String text , String date , String avtor) throws  SQLException,
            ClassNotFoundException{
        String sql = "INSERT INTO `articles`(title, text, date, avtor) VALUES (?, ?, ?, ?)";
        PreparedStatement prSt=getDbConnection().prepareStatement(sql);
        prSt.setString(1,title);
        prSt.setString(2,text);
        prSt.setString(3,date);
        prSt.setString(4, avtor);
        prSt. executeUpdate();

    }
    public void getArticles(String table) throws SQLException, ClassNotFoundException{
        String sql = "SELECT * FROM" + table;
        Statement statement = getDbConnection().createStatement();
        ResultSet res =statement.executeQuery(sql);
        while(res.next()){
            System.out.println(res.getString("title"));
        }
    }

}

MAIN

public class Main {
    public static void main(String[] args) {
       DB db=new DB();
        try {
            db.getArticles("articles");

        } catch (SQLException e) {
            e.printStackTrace();
        }catch (ClassNotFoundException e){
            e.printStackTrace();
        }

    }
}

[macomics]

пробел после FROM

String sql = "SELECT * FROM " + table;

[Ильюха1]

Спасибо , огромное .