JDBC Tutorial for Beginners #4 : Inserting Data into MySQL Database
This video explains how to insert data into MySQL database from your java program. In this example, I have created a JFrame from which the name to be inserted in to the database will be read.
Using INSERT INTO command in mysql, I have added some example names to the database. From the java program, I have retrieved all the names present in the database. In the end, filtering the data from database is also shown.
SQL Insert command syntax
INSERT INTO TABLE_NAME VALUES ( val1, val2, val3 ..);
In case you want to specify certain coloumns
INSERT INTO TABLE_NAME(col1, col2 ...) VALUES (val1, val2 ...);
This tutorial series covers following topics
■ Connecting Java Program to MySQL Database
■ Inserting data into database
■ Fetching data from database
■ Updating an entry in database
■ Creating a table programmatically
■ Using PreparedStatements
■ Display database contents in JTable
- Genuine Coder
http://www.genuinecoder.com/
