Advanced Java and Web Technologies for JNTUK
Blog providing beginner tutorials on different web technologies like HTML, CSS, Javascript, PHP, MYSQL, XML, Java Beans, Servlets, JSP and AJAX

02/06/2015 Categories: JDBC. No Comments on Connecting to and Displaying data from MYSQL in XAMPP

This article explains about how to connect to a MYSQL database provided by XAMPP using Servlet and JDBC.

 

Following are assumed to be already installed and working on your system:

  • Linux or Windows operating system
  • XAMPP
  • Eclipse IDE

 

This tutorial assumes that the user has previous experience in working with MYSQL DBMS or using phpmyadmin and knowledge of writing programs in Java using JDBC. Now let’s start with the actual process.

 

Open XAMPP’s homepage by typing the URL: http://localhost/

 

Click phpmyadmin link available in the left-hand side menu. Default username for MYSQL database is root and password is empty. By default a database will be available by the name test.

 

Create a table named users with two columns name and pass. Insert some dummy data into the table.

 

Next step is to download the MYSQL’s ConnectorJ driver (jar file) available here. Next, add the mysql-connector-java-3.1.14-bin.jar file to the lib folder available in the WEB-INF folder of the project in Eclipse.

 

Now, insert the following Java code in a servlet file:

 

 

Run the above servlet to see the data from the users table on the webpage.

The entire project in WAR format is available for download here.

Suryateja Pericherla

Suryateja Pericherla

Hello, I am Suryateja Pericherla working as an Asst. Professor in CSE department at Vishnu Institute of Technology. I write articles to share my knowledge and make people knowledgeable regarding certain topics.
Suryateja Pericherla

Latest posts by Suryateja Pericherla (see all)

Related Links:

Note: Do you have a question on this article or have a suggestion to make this article better? You can ask or suggest us by filling in the below form. After commenting, your comment will be held for moderation and will be published in 24-48 hrs.

Leave a Reply

Scroll Up
Thank you for visiting startertutorials.com! If you like this website do share with your friends by clicking on the social icons available on the left hand side.

As the domain name is quite large to remember, use this short domain to visit this site. Short domain: stuts.me