Presentation On How To Create Connection To A Database

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.