While we believe that this content benefits our community, we have not yet thoroughly reviewed it. If you have any suggestions for improvements, please let us know by clicking the “report an issue“ button at the bottom of the tutorial.
Welcome to JDBC tutorial. Java DataBase Connectivity (JDBC) is one of the most widely used API in enterprise applications. This is because most of the applications use some sort of database connectivity. I have recently posted a lot of JDBC tutorials related to basic JDBC, DataSource and it’s integration with Spring Framework.
This is a index post for all the jdbc tutorials I had posted earlier. If you are new to JDBC then you should go through these JDBC tutorials in order for better understanding.
Statement
and PreparedStatement
. Statement is easy to use but it can lead to SQL injection, that is very common way of hacking any application. This article clearly shows how SQL injection can be performed with SQL Statements and why we should use PreparedStatement
to avoid SQL injection attacks. This article goes further in explaining some of the major benefits we get from using PreparedStatement over Statement such as caching, object oriented programming and elegant looking code.I will be adding more posts in JDBC tutorial, so please bookmark the post for future reference too.
Thanks for learning with the DigitalOcean Community. Check out our offerings for compute, storage, networking, and managed databases.
Thank you very much, Pankaj. I learned a lot from your tutorials. It’s very easy to understand.
- KIRANSINH BORASIA
I was creating a java servlet with database for the feedback form of student and teacher , whether I have to create separate java class file or in the same it will execute
- Manjunath
Can you please tell me how can I connect java gui (created using netbeans) with oracle(sql developer). i.e If I write command on gui it will search on oracle db by connection through sql developer. It will be very greatfull. Thank in advance.
- oracle java connection