i'm working on a hotel reservation system as a college project, and i've got a few questions...
some background info:
it's not actually being done for any real life company.
it's intended to be used within a hotel by hotel staff, primarily at the reception desk.
i'm producing it as a java application, with a mysql database. it needs to be platform independent (might run on windows/linux/mac).
hypothetically, there's the future possibility of a web application to go along with it, accessing the same database.
Q1) for the application to connect to mysql, it needs to use the JDBC driver. does the JDBC driver need to be on A) the client machines running the java application, B) the machine running mysql, or C) both? (i'm assuming A or C). Also, is it bundled with the JRE or would it have to be installed separately? i did google but i've not found the answer yet!
Q2) how would you suggest that the configuration information is stored? (connection string, mysql username, mysql password). it probably needs encrypting, but also, more importantly, how do i control editing? should i only allow windows users with admin rights? but then what about linux/mac...
Q3) i'm pretty lost on how authentication/authorisation might be implemented in a real life application like this. is the application having it's own system the best/only way?
what about interacting with active directory? what about active directory or alternatives on linux/mac?
what about smart cards?
what about the web application tying in to this? should staff be able to use the same login as with the application and have access to similar/same functionality that the java application provides, or should the web app only be for customers to make their own reservations?
Question
+theblazingangel MVC
i'm working on a hotel reservation system as a college project, and i've got a few questions...
some background info:
it's not actually being done for any real life company.
it's intended to be used within a hotel by hotel staff, primarily at the reception desk.
i'm producing it as a java application, with a mysql database. it needs to be platform independent (might run on windows/linux/mac).
hypothetically, there's the future possibility of a web application to go along with it, accessing the same database.
Q1) for the application to connect to mysql, it needs to use the JDBC driver. does the JDBC driver need to be on A) the client machines running the java application, B) the machine running mysql, or C) both? (i'm assuming A or C). Also, is it bundled with the JRE or would it have to be installed separately? i did google but i've not found the answer yet!
Q2) how would you suggest that the configuration information is stored? (connection string, mysql username, mysql password). it probably needs encrypting, but also, more importantly, how do i control editing? should i only allow windows users with admin rights? but then what about linux/mac...
Q3) i'm pretty lost on how authentication/authorisation might be implemented in a real life application like this. is the application having it's own system the best/only way?
what about interacting with active directory? what about active directory or alternatives on linux/mac?
what about smart cards?
what about the web application tying in to this? should staff be able to use the same login as with the application and have access to similar/same functionality that the java application provides, or should the web app only be for customers to make their own reservations?
Link to comment
Share on other sites
2 answers to this question
Recommended Posts