1 / 17

Presentation On How To Create Connection To A Database

This guide outlines the step-by-step process to create a connection to a database using Microsoft Access. Begin by opening Access and creating a new blank database. Next, define your table structure in Design View, set the column names and data types, and save your changes. Afterward, configure the Data Source using the ODBC Data Sources in the Control Panel. Finally, learn to execute queries using Java's JDBC and SQL commands to manipulate and retrieve data from your newly created database.

yuma
Download Presentation

Presentation On How To Create Connection To A Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Presentation On How To Create Connection To A Database

  2. 1) Open “Microsoft Access” And select on “Blank Database”.

  3. 2) A Blank Database will appear. 3) Right Click On Table1 : Table. 4) Select the “Design View” Option.

  4. 5) A Save As Dialog Box will Open. Enter the desired Name And Click on OK. 6) (This name will be used in SQL Query such as : String sql = “select * from StudInfo”;

  5. 7) Enter the Column names and their Data Types according to the requirement.

  6. 8) Close the StudInfo Table. 9) Click on “Yes” to save the changes to the table.

  7. 10) Double Click on the StudInfo : Table 11) Insert the values into the table. 12) Save the database using Ctrl + S. 13) Close the database.

  8. 14) Open Control Panel

  9. 15) Open Administrative Tools.

  10. 16) Double Click on Data Sources (ODBC)

  11. 17) From the Window that Appears, click on “Add…”

  12. 18) From The “Create New Data Source” Window Click on “Microsoft Access Driver(*.mdb, *.accdb)” 19) And then click on Finish.

  13. 20) Enter the “Data Source Name”. (This name will be used in getConnection() method like, Connection con = DriverManager.getConnection(“jdbc:odbc:StudentDatabase1”); 21) Select the database that you created by selecting on “Select” option. Click on OK. After this step, connection to the database will be created.

  14. A Sample Program to display the contents of database. 1

  15. Continued…

  16. Output Of The Program.

  17. Functions To Execute Queries : ResultSet executeQuery(String sql) throws SQLException : To execute queries such as static SELECT int executeUpdate(String sql) throws SQLException : To execute Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement. boolean execute(String sql) throws SQLException : To execute SQL statement like create table.

More Related