My projects
Simple game backend
2017
Java | Python | C++
Online merchant database design
2022
MySQL | Oracle
Restaurant conversation waiter AI
2021
Azure Machine Learning
3D racing game
2020
C++ | OpenGL
View recognition AI
2021
Azure View Learning
Shopping Cart
2022
React | CSS
Voice navigation system
2021
React | VUI | Google Map API
Mobile position sensor game
2021
React | Google Sensor | CSS
Library System
2023
HTML | CSS | JavaScript | Spring Boot | Java | MongoDB
School System Simulator Project
2023
HTML | CSS | JavaScript | Node.JS | Express.JS | MongoDB
Simple game backend
Java | Python | C++
In the final project of the basic programming course at the university, we will be asked to make some back-end simulators for puzzle games. For example: card games with different rules, matrix games, and games under mathematical models.
I have written a Bingo card game simulator using Python, java, and C++ at the same time. The content requires object-oriented coding thinking to separate a single card and the simulator. A rule and a player are used to create the simulator, and the card will be called by the simulator as an interface. In this way, the implementation of the game by back-end data is realized.
Online merchant database design
MySQL | Oracle
In response to the current development trend of increasing platform merchants on the Internet, we designed and produced a database that can record information with merchants and consumers and view order status. We used Oracle to build a SQL database.
The library is constructed from multiple different tables. There are complex relationships between User, Item, shipment, and history. There are one-to-one, one-to-many, and many-to-many relationships to join different tables. The columns in the table also have different information requirements, such as whether they are unique, whether they can be empty, and the key definition of the columns in the table. Each table has at least one primary key that is a unique value that is not empty. Define foreign keys to facilitate establishing relationships with other lists to select data.
Azure Machine Learning
Restaurant conversation waiter AI
Training an artificial intelligence given a large amount of information enables it to make judgments and respond appropriately. Since I have worked in a restaurant before, I have some understanding of the basic functions of a front desk clerk. And this project can also be extended to front-office services in every industry.
I utilized the Department of Mechanical Services service in Microsoft Azure for research and builds. Our robot can solve most problems. When encountering an unsolvable problem, it will suggest a different way of asking or direct manual service.
3D racing game
C++ | OpenGL
We made a simple racing model game. The car will get extra points if it hits the box while driving on a track with a specified width and length. Finally, the time after reaching 100 points will be recorded and a ranking will be given to everyone.
The game content is not complicated and we developed it using OpenGL. To be honest this is not a good way to develop a game. We need a lot of math based on linear algebra to calculate terrain, perspective and lighting. Changing parameters when the car is moving is also very complex.
View recognition AI
Azure View Learning
Image AI recognition is increasingly accepted by applications. For example, animal and plant identification APP. We need a lot of pictures and time for AI to understand and recognize the characteristics of animals, and to make relatively accurate judgments.
This project still utilizes Microsoft Azure’s Department of Mechanical Engineering platform. We also had a lot of interesting things happen while working on this project. For example, most of the animals we tested could be identified, but the Maine Coon cat was judged to be a lion, and we specially trained the AI for this.
Animals
Fruits
Shopping Cart
React | CSS
Combined with the prevalence of online shopping mentioned in the previous project after covid-19. We have also developed front-end frameworks for small companies.
After entering the web page, click on the shopping cart and we will jump to this page to see it. The status of the item: name, id, quantity, price. There is also the total price at the bottom.
For this development, we used the react framework for the first time instead of the simple html/css/js development model. We don’t pay much attention to the beauty of the page but pay more attention to the transmission of information.
In react, the subclass communicates and changes information with the parent class, and uses ‘fetch’ to obtain changes to the API data on the front end. All in all, it is an exploration of front-end and back-end connections for data transmission.
Voice navigation system
Mobile position sensor game
React | VUI | Google Map API
React | Google Sensor | CSS
VUI is increasingly becoming an important part of our lives. For example, Google, Microsoft and Apple are all working on developing a combination of artificial intelligence and VUI. The main purpose of our project is to provide safe interaction for drivers to temporarily change destination navigation.
A simple front-end game is developed to test mobile location sensing. We set up a box with a small ball inside, which simulates the center of gravity based on the position information sensed by the current screen. Give the ball a speed to start moving. When the ball touches the edge, it will bounce back. If it hits the target point, points will be added to the display board.
This time we used react-speech-recognition and react-google-maps/API in the react framework as libraries for audio input recognition and map connection (need to be imported). This attempt is a step forward in transmitting information in multiple fields and understanding how to use voice for human-computer interaction.
This project was developed using the react framework. We called the react-hook/window-size and react-hook/orientation libraries for ball sensing. It is a novel attempt to make web applications have judgment and location sensing on the mobile terminal. It is a good exploration to provide users with a simpler UI method in the future
Library System
HTML | CSS | JavaScript | Spring Boot | Java | MongoDB
Create a library that can store book information. We expanded the project and transformed it into a book lending system. The administrator needs to create borrowing information, including the book's name, author, borrower's name, time, and frequency. We can delete the book when it is returned, and we can change the time and notes when it is extended.
The back-end system developed by the Springboot/Django framework, the front-end still uses html/css/js (we can also use react to grab the API). This is our first attempt to use java/python for back-end development. We use MongoDB as the database, which greatly simplifies the data retrieval part.
School System Simulator Project
HTML | CSS | JavaScript | Node.JS | Express.JS | MongoDB
link: https://cute-erin-fawn-kit.cyclic.app/
Example:
admin:admin/admin
teacher:t11/t11
student：student/student
Note: Please do not change the username and password of the example so that others cannot use it. Please do not create new users maliciously.
Home Page
For a full stack project, we need to create a school simulation system. In addition to the public page section we also have three private sections for administrators, teachers and students. The personal part requires a username and password to log in. We do not have the right to open registration.
Login Page
When you are allowed to attend this school, the school will send your personal account information. Our administrators can delete, update, insert (add), and select teachers, students, courses, and time schedules. After logging in, teachers can view the courses being taught and the time, course information and students.
Admin Page(schedule)
After logging in, students can only see the courses and course information they are currently studying. Teachers and students have personal homepages with personal details that can be changed. A second confirmation is required when changing the password.
Check schedule
The front-end part uses hbs/css/javascript for development. The backend is developed using the Node.js environment. The database uses MongoDB. This project is relatively comprehensive, with practice on front-end, back-end, database, testing, network security, warehouse management, and network deployment. The requirements for teamwork are also higher, and the time is tight and the content is complex, so the project content still has imperfect parts.