Learn Programming

'DerbyDB Creator' is a SQL scripting tool with Graphical User Interface for Apache derby databases.  Apache derby is an RDBMS (Relational Database Management System)  developed by the  Apache Software Foundation  that can be embedded in  Java  programs.   The core of the technology, Derby's database engine, is a full-functioned relationally embedded database-engine, supporting JDBC  and SQL  as programming APIs. Before we move further Have a look at this video which shows the functioning of DerbyDB Creator 1) What is DerbyDB Creator? DerbyDB Creator as a Graphical User Interface to access databases of apache derby and modify the databases by providing various SQL commands for the apache derby database. It is a replacement for 'ij' command-line tool of Apache org. This application has been created using JDBC(Java Database Connectivity) and the interface is created using Java Swing and Java AWT

JDBC -Java Database Connectivity  As the name suggests  It is an  API  that enables us to connect to our databases using java. Using this we can connect, add, update, delete, select -tables,columns,rows,databases i.e. In short we can do everything, we want to do with our databases using java. Now, I won't much talk about the theory, I will help you to understand - how you can apply it. But don't worry I assure you that everything I  have shown here will give you complete understanding about JDBC and after reading this blog you will be able to implement it in any of your projects. So let's begin this. Get the driver for MySQL : To start with MySQL  you will first need a jdbc driver for MySQL, it is called as 'MySQL connector ' . You can find it on this link:   MySQL JDBC Connector Choose the connector of your MySQL version. And choose OS  'platform-independent'. D

So you want to get started with socket programming in java. Here is all you need to know to get started with socket programming in java. For socket programming, there are two terms, called 'server' and 'client'. 'Server' is one that will accept the request and send some response. The client is one which will create request and send it to the server then receive the response came from the server. Now, let's see a small example that can explain the basic scenario of client-server system (network programming). (You can skip the example. If you are aware of it.) Example: In a restaurant, there is a waiter and you, who is a customer. You came to the restaurant for dinner. Now you called the waiter to place an order. So the waiter came to you and took your order then severed your tasty dinner on the table. Now, what is this example? WHY this. Let's