Java Experiment--a simple song information management system based on swing (i)

Original is not easy, reproduced please indicate the source.

Experiment Six

Experiment Name: Song Management system ( or pet management system)

Experimental purposes: AWT, SWING, JDBC, DATABASE

Experiment Time: (6 hours)

Experimental content:

• Development environment Eclipse + JDK + list/map+sql Server/mysql

• Objects in the system

Song (Song.java): number, song name, language (Chinese/English), category (pop/pop), singer

• system function Description

To manage an existing track:

Find song information (query by song name \ language \ singer \ Category etc.)

Add songs

Delete a Song

• Technical Requirements: jdbc,list/map,awt/swing

A look is a simple management system, if not counted on the user login registration, but also a table, the actual process of tapping the code, the operation of the database is relatively simple, most of the code is the same, just the SQL statement is different. The most difficult part of the process is to use swing to draw the interface and how the data from the database to display in the table, for the table to show the song information, directly with the Java provided by the JTable plus DefaultTableModel to achieve, user management inside the list, You are using a custom class that implements the TableModel interface. Due to the lack of contact with the pan-Java swing, the layout of swing is not very skilled, reference to the textbook and online.

take a look at what to do first:

• Login interface

• Admin Main interface

• Song Management interface (the data shown in the table here uses a class that inherits to DefaultTableModel)

• User management interface (the table shows the data using a custom class that implements the TableModel interface)

Although it is a simple system, but there is no need to prepare, it is prepared to write only a song management, but think about it or to register to add the login. The approximate modules are divided as follows:

1. Users and administrators can log on, but only users can register.
2. Users and administrators can change passwords
3. Users and administrators can query song information based on criteria, such as song name, song language, song classification and singer name.
4. The administrator can modify, delete, and add songs to the song information.
5. Administrators can add, modify, delete, and query users.

Project Source

Java Experiment--a simple song information management system based on swing (i)