• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Connecting MS Access databse to web using JDBC

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have a MS Access database that i wish to connect to the web using JDBC. I have designed a basic web page with a text box and submit button. I wish to be able to query my Access database using the input provided by a user on the web page, and return to the user the information he/she has requested.
I am new to this game and need to know where to start from. I have done a lot of reading around this subject and am confused as I understand there are many ways of doing this.
Obviously my server would need a copy of MS Access and my database. Would i need IIS to be installed on the server as well?
I am a bit confused in terms of where the JAVA coding will go. Will it be on the HTML web page or as a servlet on the server?
All help is greatly appreciated.
 
Ranch Hand
Posts: 732
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
well. basically u will need a web server that supports servlets. IIS wont do, but there is a free one called tomcat u can find at the sun site (http://java.sun.com)
your code to connect to the DB will be either in a servlet (which u will call from a jsp page or html page) or in a bean that u will use inside a jsp page.
i recommend trying to read this site for a little bit more background.
 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Actually, Tomcat is located at http://jakarta.apache.org
All of your Java code will either go into a servlet or a JSP page. I recommend using JSP and calling most of your code from JavaBeans. If you have no clue how to do this then email me and I'll send you some instructions for setting up Tomcat and some source code I have written to do exactly what you want to do. Also, the computer does not have to have MS Access installed on it. You just have to have a copy of the database. If you are using a Windows machine you can use a JDBC-ODBC bridge to connect to your database. Otherwise, you will have to buy a MS Access JDBC driver that is compatible with Linix/UNIX or whatever OS you will be running this application on.
 
Why am I so drawn to cherry pie? I can't seem to stop. Save me tiny ad!
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic