How to enter data into MySQL DB from TextField in java?

Question

MySQL

Good!
I'm trying to figure out how to work with a MySQL database. So, there is a TextField txtName field

statement.execute("INSERT INTO deftab (name ) VALUE (txtName.getText().toString)");

how to put values ​​in there?

Answer 1

Use PreparedStatement

....
private static final String INSERT = "INSERT INTO deftab (name ) VALUE (?)";
....
public void insert(String name) {
 try (Connection connection = DBConnectionPool.getConnection();
             PreparedStatement ps = connection.prepareStatement(INSERT_NEWS)) {
            ps.setString(1, name);
            ps.execute();
        } catch (SQLException e) {
            e.printStackTrace();
        }
}

*DBConnectionPool - the place from where you will take the connection
To study:
JDBC lesson in
PreparedStatement examples (prepared queries)
How to use the MySQL database in Java
The simplest Connection pool without a DataSource in Java