J2EE, Core Java, Spring, Servlets, JSP, JDBC, Hibernate, CSS, JavaScript, JQuery, Interview questions
Hello Friends,
This is the simple example for executing the SQL statements to INSERT, UPDATE or DELETE any records from the database using JDBC. In the below code I have explained all the three operations. When we insert, update or delete any records from the database we are updating the database, hence we use the executeUpdate() function with the Statement.
Continue reading “JDBC – Insert, Update and Delete example.”
Hello Friends,
One of the significant characteristic of any programming language is its connectivity with the database and its operations. Java supports many options to connect to the database and one of the most used database is MySql. JDBC (Java Data Base Connectivity) is used for connecting the java code with the database and it provides cross-DBMS connectivity to a wide range of SQL databases and access to other tabular data sources, such as spreadsheets or flat files. This tutorial shows the jdbc and mySql connection establishment and its use.
Hello Friends,
You may have come across “java.lang.ClassNotFoundException: com.mysql.jdbc.Driver” error/exception while working with java and JDBC. The error occurs mainly when we try to connect to the mySql database from our java code. The error message itself give the clear indication about what we are missing. It says that it is unable to find the Class – “com.mysql.jdbc.Driver”. Continue reading “Error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver”
Hello Friends,
This is one of my tutorials regarding the MySql primary and foreign keys. In this tutor I will be focusing on one of the main aspect of any database i.e. keys. Database keys are mostly used while accessing the database itself of its tables from any other source like web-application or simple code. This helps the developer to retrieve or manipulate the data from or in the database from the application itself using simple queries. Continue reading “MySQL Primary and Foreign keys.”
Hello Friends,
This is one of my tutorial related to MySQL database. While using MySql database you may have come across this issue to import your data from one place to another. But how to do that when the data we have is smaller in size but what when the data is heavy. In such case Mysql provides the option to export your data as a dump (.sql file) and then import the same data into new server or new system. The import and export of MySQL database not only is important to recover the data when disaster strikes, but also provides an easy way to migrate or move to another server, such as when switching web hosting providers. Continue reading “Import/Export sql Dump into Mysql.”
Hello Friends,
This is another tutorial for some of the basic points to remember for using MySQL Database.
MySQL is a client-server Database management system, and so to use MySQL we need a client, an application that we will use to interact with MySQL is its command prompt.(giving it commands to be executed).
Every MySQL installation comes with a simple command-line utility called mysql. This utility does not have any drop-down menus, fancy user interfaces, mouse support, or anything like that. Continue reading “MySql Command Prompt-Tips and Tricks.”
Hello Friends,
This is one of my tutorials related to database. You all must be familiar with MySQL, but still for those who have not learned about this, for them I will recall it in short.
MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases.The most important feature of this is that it is open-source i.e. it does not require any licence to use. I can be easily downloaded from the internet for personal use. Hence some of the free software projects that require a full-featured database management system often use MySQL. Continue reading “MySql Installation”