In this video, we learn how to insert number of records or data on database table by taking records data as dynamic input, and we are inserting number of data to the database but data we are taking dynamically. how we insert data into database and how i used insert query in our jdbc appliation or java programming
►Query Solved:-
how to insert data in database using java eclipse
insert data into database in java jdbc
inserting data into oracle database using java eclipse
Steps to insert records into a table with INSERT SQL statement using JDBC -
1.Loading and registering database driver to connect our Java application with a database.
2. Creating a connection between the Java program and the Oracle database.
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "system", "uttam");
ocalhost refers to our local computer where the Oracle database server is running.
1521 is the port number to connect to the database.
XE stands for Oracle Express Edition Database.
system is our username to connect to the Oracle database and uttam is the password.
3.Creating a Statement object to excute SQL statements
Statement stmt = con.createStatement();
Creating a Statement object to using createStatement() method of Connection interface.
4.Executing a SQL query using Statement object.
5.Closing the database connection
►Click here to subscribe - / @uttamsoft
►Welcome to Uttamsoft online Training
►Welcome to our YouTube channel Uttamsoft
►Our Some Other Playlist:-
---------------------------------------
► JDBC Tutorials: • JDBC Tutorial
►AWT in Java(GUI):-
• Java GUI | AWT In Java
►Core Java :- • Core Java[Introduction of java]
----------------------------------------------------------------------------------------------------------------------------------------
► Why learn java?
Java is a general-purpose, class-based, object-oriented computer programming language that was designed by James Gosling at Sun Microsystems in 1995.
Java was developed by Sun Microsystems (which is now the subsidiary of Oracle) in the year 1995. James Gosling is known as the father of Java. Before Java, its name was Oak. Since Oak was already a registered company, so James Gosling and his team changed the name from Oak to Java.
----------------------------------------------------------------------------------------------------------------------------------------
►Contact Us:-
Mobile no.:- 942 123 3453
Email-Id: uttamsoftonlinetraining@gmail.com
----------------------------------------------------------------------------------------------------------------------------------------
#uttamsoft #hindi
On this page of the site you can watch the video online Inserting data into oracle database using java eclipse | insert data into database in java jdbc with a duration of hours minute second in good quality, which was uploaded by the user Uttamsoft 23 September 2021, share the link with friends and acquaintances, this video has already been watched 3,890 times on youtube and it was liked by 54 viewers. Enjoy your viewing!