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/
Watch video JDBC Tutorial for Beginners #4 : Inserting Data into MySQL Database online without registration, duration hours minute second in high quality. This video was added by user Genuine Coder 22 February 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 33,668 once and liked it 271 people.