Knowledge base Creation

[xiong]

My goal is to create an Access database (or similar) and upload it to our website, then create a front end for it. Ideally, by using very simple search commands a list will be generated for matching records, and can be displayed on request. Think a very simple MS KB setup.

I know there are great tools out there for doing it, but as is usually the case, I've been given the project without a budget.

Any thoughts and ideas would be appreciated.

 

[sedj]

Are you looking for a tool to do this for you, or are you wanting to know how to write the code yourself ?

 

[xiong]

A good freeware tool would be great, but I'm most likely going to write it myself. (and get a good bit of scripting education in the process, I'm sure)

 

[sedj]

Well, I'm not sure about a tool ...

To create a website driven off a backend db "by hand" you need several components

FRONT END :
A servlet container (Tomcat/Resin) to hold your JSP/Servlets and display the db data

BACK END :
DB with ODBC/JDBC datasource config set up

The JSP/Servlets communicate with the db via a JDBC connection.

Reading :

http://developer.java.sun.com/developer/onlineTraining/Database/JDBC20Intro/

http://java.sun.com/j2ee/1.4/docs/tutorial/doc/

http://java.sun.com/j2ee/tutorial/1_3-fcs/doc/JSPIntro.html