Monday 1 October 2012

How to use MSAccess as Database

// siddhu vydyabhushana // 4 comments

Microsoft Access is one of the part of  MSOFFICE  .It is a database management system from microsoft that combines the relational microsoft jet database engine with a graphical user interface and software development tools. we can also use this as oracle ,mysql database.... in first i used this one but present i addicted to php......for beginners it is very useful  and interesting no use to write code for creating tables.....................


Login and Regisration Using Jsp:-


NAME YOUR DATABASE:  open MSACCESS in microsoft office 
                              
         START->>>MICROSOFT OFFICE-->>msaccess

after that choose blank database and save it with example.accddb extension


CREATE TABLE :   After RIGHT CLICK ON table1 and take Design View to create table.there is no need to write commands create table.


after clicking design view u can edit like this

and rename table1 with whatever u like 

u create table and save the database in certain folder i am going explain to place it in tomcat   server.for example if u name as example.accdb...u need to place it in
folder of web apps


CONFIGURATION: 
                         Go to Control Panel -->and choose small icons instead of lage->> at next 
click on Administrative Tools   and select Data Sources


Click on Add to add database ---------------------------------------------------------



add *.mdb ,*.accdb Microsoft Access Driver and Finish.

in Data Source Name u choose name Whatever u like it will be used to call database in jsp.

                                                   
Connection con=DriverManager.getConnection("jdbc:odbc:example","","");


on 4 line Database:
                                Select and set path where database was u successfully configured 
if u have any doubts regarding to this topic leave doubts..





Siddhu vydyabhushana please subscribe to get this type posts to ur mail ...





4 comments:

  1. sir please
    send me a complete user name and password inserting to the ms access database with complete jsp code

    ReplyDelete
  2. We are offering website design in affordable price or website and much more........

    App Buzz

    ReplyDelete
  3. SMS marketing has become very common but it is mostly a just blowing in this site Professional SMS Marketing chose to partner with professional

    ReplyDelete