How to select records using JDBC PreparedStatement
How to select records from MySQL database using JDBC PreparedStatement to avoid SQL injection.
How to insert a record using JDBC PreparedStatement
How to insert a new record using JDBC PreparedStatement in Java to avoid SQL injection. Example with auto-increment table.
How to create a table using JDBC Statement
How to create a new table from Java using JDBC Statement in simple steps: connect, get the statement, execute and close.
JDBC Statement vs PreparedStatement
JDBC Statement vs PreparedStatement with example. Comparison between around SQL Injection using SELECT query.
How to connect to MySQL with JDBC driver
How to connect to MySQL database with MySQL JDBC driver. Get a new connection using DriverManager class.
If statement vs try catch block
Real live comparison:
If statement is like walking on the cliff, on each step you need to check your stability otherwise you may fall into abyss.
Try/catch block is like walking on the street, you don't have to care about the road on each step, only when there is an obstacle (something exceptional is happening).