dormitory

dormitory

introduce

After officially entering Java EE, the dormitory management system I did when learning jsp and servlets did not use any framework. (Produced in August 2019)

bilibili: https://www.bilibili.com/video/BV1TE411f7rt?spm_id_from=333.999.0.0

You can add students (name, student number, department, major, room) and dormitory number testing.

Software Architecture

jsp + servlet + tomcat 8.5

Installation tutorial

1. Execute domitory.sql in the home directory in mysql. (Import database and part of data)
2. Put the two jar packages under the extra library in the home directory into the lib folder under the local tomcat root directory. (If it is mysql8.0, please change the connection jar yourself)
3. This article uses tomcat's built-in data source. You need to replace the context.xml in the home directory into the conf folder in the local tomcat root directory, or configure the data source yourself - modify the context.xml in the conf folder in the local tomcat root directory, and add (name="dormitoryDBPC" not to modify it, otherwise you need to modify the DButil.java in the source code)

< Resource name = " dormitoryDBPC " auth = " Container " type = " javax.sql.DataSource "

               maxTotal = " 100 " maxIdle = " 30 " maxWaitMillis = " 10000 "

               username = " root " password = " 12345 " driverClassName = " com.mysql.jdbc.Driver "

               url = " jdbc:mysql://localhost:3306/dormitory?characterEncoding=utf8 &amp; useSSL=false " />

Instructions for use

1. Import ideas and configure tomcat to run.
2. Or directly deploy dorm.war in the home directory to the webapp under tomcat for access.

Participate in contribution

None