Creating JDBC SQL Statements. Displaying Records from a MySQL Database

Wednesday Sep 10th 2003 by DatabaseJournal.com Staff
Share:

Learn how to create and execute JDBC SQL Statements and display records from a table in a MySQL Database. This article covers topics such as creating databases and tables in MySQL. All code is explained in detail.

[From Stardeveloper.com]

Overview
In this tutorial following topics will be covered:

  • What are JDBC SQL Statements?
  • What are different types of JDBC SQL Statements?
  • How to create and execute JDBC SQL Statements?
  • Basics of creating databases and tables in MySQL.
  • How to display records from a table in MySQL?

In the previous articles we learned that we obtain a java.sql.Connection object which represents a database connection from java.sql.DriverManager class. We learned that to properly connect to a database we need to have a properly installed JDBC driver, and we did that by installing Connector/J JDBC driver for MySQL. We also learned that after loading JDBC driver we have to correctly specify a database URL to DriverManager to obtain a connection.

We'll now move on to learn how to create and execute JDBC SQL Statements.

The article continues at http://stardeveloper.com/articles/display.html?article=2003091001&page=1

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved