基于swing的java系统_Java实验--基于Swing的简单的歌曲信息管理系统(四)

比眉伴天荒 2022-11-02 13:30 156阅读 0赞

原创不易，转载请注明出处。

上一篇《Java实验--基于Swing的简单的歌曲信息管理系统(三) 》中，我们绘制了登录、注册和管理员主界面，本篇主要讲解歌曲管理界面。第一次涉及到对表格的操作，参见的教材上的代码，具体代码如下：

![8f900a89c6347c561fdf2122f13be562.png][]

![961ddebeb323a10fe0623af514929fc1.png][]

packagetest.swing;importjava.awt.BorderLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.awt.event.MouseAdapter;importjava.awt.event.MouseEvent;importjavax.swing.JButton;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JPanel;importjavax.swing.JScrollPane;importjavax.swing.JTable;importjavax.swing.JTextField;importjavax.swing.ListSelectionModel;importjavax.swing.table.DefaultTableModel;public class ExampleFrame\_06 extendsJFrame \{/\*\*\*\*/

private static final long serialVersionUID = 1L;private DefaultTableModel tableModel;//定义表格模型对象

private JTable table;//定义表格对象

privateJTextField aTextField;privateJTextField bTextField;public static voidmain(String args\[\]) \{

ExampleFrame\_06 frame= newExampleFrame\_06();

frame.setVisible(true);

\}publicExampleFrame\_06() \{super();

setTitle("维护表格模型");

setBounds(100, 100, 500, 375);

setDefaultCloseOperation(JFrame.EXIT\_ON\_CLOSE);final JScrollPane scrollPane = newJScrollPane();

getContentPane().add(scrollPane, BorderLayout.CENTER);

String\[\] columnNames= \{ "A", "B" \};//定义表格列名数组

String\[\]\[\] tableValues = \{ \{ "A1", "B1" \}, \{ "A2", "B2"\},

\{"A3", "B3" \} \};//定义表格数据数组//创建指定表格列名和表格数据的表格模型

tableModel = newDefaultTableModel(tableValues, columnNames);

table= new JTable(tableModel);//创建指定表格模型的表格//table.setRowSorter(new TableRowSorter(tableModel));//设置表格的排序器//设置表格的选择模式为单选

table.setSelectionMode(ListSelectionModel.SINGLE\_SELECTION);//为表格添加鼠标事件监听器

table.addMouseListener(newMouseAdapter() \{//发生了点击事件

public voidmouseClicked(MouseEvent e) \{//获得被选中行的索引

int selectedRow =table.getSelectedRow();//从表格模型中获得指定单元格的值

Object oa = tableModel.getValueAt(selectedRow, 0);//从表格模型中获得指定单元格的值

Object ob = tableModel.getValueAt(selectedRow, 1);

aTextField.setText(oa.toString());//将值赋值给文本框

bTextField.setText(ob.toString());//将值赋值给文本框

\});

scrollPane.setViewportView(table);final JPanel panel = newJPanel();

getContentPane().add(panel, BorderLayout.SOUTH);

panel.add(new JLabel("A："));

aTextField= new JTextField("A4", 10);

panel.add(aTextField);

panel.add(new JLabel("B："));

bTextField= new JTextField("B4", 10);

panel.add(bTextField);final JButton addButton = new JButton("添加");

addButton.addActionListener(newActionListener() \{public voidactionPerformed(ActionEvent e) \{

String\[\] rowValues=\{ aTextField.getText(),

bTextField.getText() \};//创建表格行数组

tableModel.addRow(rowValues);//向表格模型中添加一行

int rowCount = table.getRowCount() + 1;

aTextField.setText("A" +rowCount);

bTextField.setText("B" +rowCount);

\});

panel.add(addButton);final JButton updButton = new JButton("修改");

updButton.addActionListener(newActionListener() \{public voidactionPerformed(ActionEvent e) \{int selectedRow = table.getSelectedRow();//获得被选中行的索引

if (selectedRow != -1) \{//判断是否存在被选中行

tableModel.setValueAt(aTextField.getText(),

selectedRow,0);//修改表格模型当中的指定值

tableModel.setValueAt(bTextField.getText(),

selectedRow,1);//修改表格模型当中的指定值

\});

panel.add(updButton);final JButton delButton = new JButton("删除");

delButton.addActionListener(newActionListener() \{public voidactionPerformed(ActionEvent e) \{int selectedRow = table.getSelectedRow();//获得被选中行的索引

if (selectedRow != -1)//判断是否存在被选中行//从表格模型当中删除指定行

tableModel.removeRow(selectedRow);

\});

panel.add(delButton);

创建表格，使用JTable即可，表格中的数据一般使用java swing提供的DefaultTableModel即可，DefaultTableModel有如下构造方法，通过这种方式，可以设置表头和表格中的数据。然后再创建JTable时，把DefaultTableModel传入即可，再把表格给放入滚动面板JScrollPane就完成了。

![792f1a3ad4452761b3e36f68b18c5db7.png][]

创建表格的具体代码如下所示：

packagetest.swing;importjava.awt.BorderLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.awt.event.MouseAdapter;importjava.awt.event.MouseEvent;importjavax.swing.JButton;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JPanel;importjavax.swing.JScrollPane;importjavax.swing.JTable;importjavax.swing.JTextField;importjavax.swing.ListSelectionModel;importjavax.swing.table.DefaultTableModel;importjavax.swing.table.TableRowSorter;public class ExampleFrame\_06 extendsJFrame \{/\*\*\*\*/

private static final long serialVersionUID = 1L;private DefaultTableModel tableModel;//定义表格模型对象

private JTable table;//定义表格对象

privateJTextField aTextField;privateJTextField bTextField;public static voidmain(String args\[\]) \{

ExampleFrame\_06 frame= newExampleFrame\_06();

frame.setVisible(true);

\}publicExampleFrame\_06() \{super();

setTitle("维护表格模型");

setBounds(100, 100, 500, 375);

setDefaultCloseOperation(JFrame.EXIT\_ON\_CLOSE);final JScrollPane scrollPane = newJScrollPane();

getContentPane().add(scrollPane, BorderLayout.CENTER);

String\[\] columnNames= \{ "A", "B" \};//定义表格列名数组

String\[\]\[\] tableValues = \{ \{ "A1", "B1" \}, \{ "A2", "B2"\}, \{"A3", "B3" \} \};//定义表格数据数组//创建指定表格列名和表格数据的表格模型

tableModel = newDefaultTableModel(tableValues, columnNames);

table= new JTable(tableModel);//创建指定表格模型的表格

table.setRowSorter(new TableRowSorter(tableModel));//设置表格的排序器//设置表格的选择模式为单选

table.setSelectionMode(ListSelectionModel.SINGLE\_SELECTION);

scrollPane.setViewportView(table);

我们给表格填充一些数据，再加一些按钮(添加、修改、删除)和输入框(用来输入数据)，来对表格中的数据进行增改删操作。(代码部分参见上面的教材源码)让最终的界面看起来如下所示：

![84802ec2b5259aaf78a31d221201d83c.png][]

这里我们为表格添加鼠标事件监听器，想要得到的效果就是，当我们选中表格中的某一行时，将表格中的数据给显示在下面的输入框中。具体做法，先通过JTable的getSelectedRow()方法获取选中的行，再通过DefaultTableModel中的getValueAt(行,列)获取单元格里面的值，再将获取到的值赋到文本框即可。代码如下：

//为表格添加鼠标事件监听器

table.addMouseListener(newMouseAdapter() \{//发生了点击事件

public voidmouseClicked(MouseEvent e) \{//获得被选中行的索引

int selectedRow =table.getSelectedRow();//从表格模型中获得指定单元格的值

Object oa = tableModel.getValueAt(selectedRow, 0);//从表格模型中获得指定单元格的值

Object ob = tableModel.getValueAt(selectedRow, 1);

aTextField.setText(oa.toString());//将值赋值给文本框

bTextField.setText(ob.toString());//将值赋值给文本框

\});

添加一行，我们为添加按钮给添加监听器，输入从文本框中获取，使用DefaultTableModel中的addRow(String\[\] rowValues)，来进行添加。具体代码如下

addButton.addActionListener(newActionListener() \{public voidactionPerformed(ActionEvent e) \{

String\[\] rowValues=\{ aTextField.getText(), bTextField.getText() \};//创建表格行数组

tableModel.addRow(rowValues);//向表格模型中添加一行

int rowCount = table.getRowCount() + 1;

aTextField.setText("A" +rowCount);

bTextField.setText("B" +rowCount);

\});

修改，都是先获取改行类容(需要检验改行是否在表格中存在)，再进行修改。先为修改按钮给添加事件监听器，在使用DefaultTableModel中的为单元格赋值方法setValueAt(值,行号,列号)即可，具体代码如下：

updButton.addActionListener(newActionListener() \{public voidactionPerformed(ActionEvent e) \{int selectedRow = table.getSelectedRow();//获得被选中行的索引

if (selectedRow != -1) \{//判断是否存在被选中行

tableModel.setValueAt(aTextField.getText(), selectedRow,0);//修改表格模型当中的指定值

tableModel.setValueAt(bTextField.getText(), selectedRow,1);//修改表格模型当中的指定值

\});

删除就比较简单了，先获取到行号，判断该行号是否有效，再使用DefaultTableModel提供的removeRow(行号)，即可，具体代码如下。

delButton.addActionListener(newActionListener() \{public voidactionPerformed(ActionEvent e) \{int selectedRow = table.getSelectedRow();//获得被选中行的索引

if (selectedRow != -1)//判断是否存在被选中行//从表格模型当中删除指定行

tableModel.removeRow(selectedRow);

\});

其实，这里的难点就是如何显示数据，根据教材的代码，能够大致模仿写出，然后就根据就把后台的数据显示出来就好了。为了实现让表格里面的行为不可编辑的状态，所以自己定义一个类，继承至DefaultTableMode，重写了isCellEditable方法，设置为了false。其他的都没有变。如果当时静下心再想想，可能就会重写很多的方法(还好这些在用户管理里面做了)，使用的时候也会更简单，代码也会更少。

其它的部分还有就是根据条件搜索，下面的JRadioButton和搜索框中显示的提示消息相对应等，之前考虑的是点击添加、删除、修改按钮，是弹出一个新的窗体来进行，无奈当时试了几次也不行(还好用户管理里面是这样实现的)，只有模仿书上面的例子来做了，在表格的下面多增加了一排，里面包含了歌曲信息的输入框和增加、修改、删除的按钮，模仿例子来实现的。

设计图如下，歌曲管理的窗体(它是一个JInterFrame)出现在之前的DeskPanel面板中，歌曲管理的窗体中，有一个主面板用来存放所有的子面板，采用了边界布局模式。主面板的上部(NORTH)放的是一个子面板，主要用来存放搜索框和一行单选按钮；主面板的中部(CENTER)主要是用来放了一个滚动面板，用它来放一个表格；主面板的下部(SOUTH)放了一个子面板，主要用来存放一系列的输入框和几个按钮。

![6c1e5dd5e03b39efbb3c11ce4a2e2e4b.png][]

单选按钮处理，因为是单选按钮，所以需要把这些单选按钮给放入一个ButtonGroup中。其中表格的数据是从数据中查找出来的，再把List数据类型给转换成了二位数组类型，其实这里应该在Service层做。为了使单元格为不可编辑状态，在网上找了很久都没有找到办法，索性就定义了一个内部类(继承至DefaultTableModel)，重写了isCellEditable方法，让其不可编辑，界面布局代码如下所示：

![8f900a89c6347c561fdf2122f13be562.png][]

![961ddebeb323a10fe0623af514929fc1.png][]

/\*\*\* 管理员--管理歌曲信息界面

\*\*/

public class AdminSongManageView extendsJInternalFrame \{/\*\*\*\*/

private static final long serialVersionUID = 1L;private JPanel panelMain; //主面板

private JPanel panelTop; //主面板的上部

private JPanel panelSearch; //搜索面板

private JLabel labKey; //关键字

private JTextField tfSearch; //搜索框

private JButton btnSearch; //查找按钮

private JPanel panelSearchType; //按什么查找

private ButtonGroup buttonGroup = newButtonGroup();private JRadioButton\[\] btnSearchTypes = new JRadioButton\[4\]; //条件，如歌名，语言，类别，歌手

privateJLabel labSearch;private JScrollPane panelTable; //表格面板

private myTableModel tableModel;//定义表格模型对象

private JTable table;//定义表格对象

private JPanel panelBottom; //底部面板，包括输入框，添加、删除、修改

privateJLabel labName;privateJLabel labLanguage;privateJLabel labCategory;privateJLabel labSinger;private JTextField tfName; //输入歌曲名字

private JTextField tfLanguage; //输入语言

private JTextField tfCategory; //输入类别

private JTextField tfSinger; //歌手

private JButton btnAdd; //添加按钮

private JButton btnEdit; //修改按钮

private JButton btnDelete; //删除按钮

privateSongService songService;publicAdminSongManageView() \{

songService= newSongServiceImpl();

init();

\}/\*\*\* 初始化各组件\*/

private voidinit() \{this.setTitle("歌曲管理");this.setSize(new Dimension(750, 550));this.setIconifiable(true); //窗体最小化

this.setClosable(true); //可被关闭

this.setDefaultCloseOperation(DISPOSE\_ON\_CLOSE); //退出

panelMain = new JPanel(newBorderLayout());

panelTop= new JPanel(new GridLayout(2, 1, 0, 0));

panelTop.setLocation(0, 20);

panelSearch= newJPanel();

panelSearch.setPreferredSize(new Dimension(750, 30));

labKey= new JLabel("关键字");

tfSearch= new JTextField("请输入歌名",20);

tfSearch.setPreferredSize(new Dimension(100, 20));

btnSearch= new JButton("查找");

btnSearch.setPreferredSize(new Dimension(60, 20));

panelSearch.add(newJLabel());

panelSearch.add(labKey);

panelSearch.add(tfSearch);

panelSearch.add(newJLabel());

panelSearch.add(btnSearch);

panelSearch.add(newJLabel());

panelTop.add(panelSearch);

panelSearchType= newJPanel();

panelSearchType.setPreferredSize(new Dimension(750, 30));

labSearch= new JLabel("查询");

panelSearchType.add(labSearch);

btnSearchTypes\[0\] = new JRadioButton("歌名", true);

btnSearchTypes\[1\] = new JRadioButton("语言");

btnSearchTypes\[2\] = new JRadioButton("类别");

btnSearchTypes\[3\] = new JRadioButton("歌手");//System.out.println("名字"+btnSearchTypes\[1\].getText());

for(JRadioButton jRadioButton : btnSearchTypes) \{

buttonGroup.add(jRadioButton);

panelSearchType.add(jRadioButton);

panelTop.add(panelSearchType);

panelMain.add(panelTop, BorderLayout.NORTH);

String\[\] columnNames= \{ "id", "歌名", "语言", "类别", "歌手"\};//从数据库中查询所有数据

List songs =songService.findAll();

System.out.println(songs);

String\[\]\[\] tableValues= new String\[songs.size()\]\[5\];for (int i = 0; i < songs.size(); i++) \{

tableValues\[i\]\[0\] =songs.get(i).getId();

tableValues\[i\]\[1\] =songs.get(i).getName();

tableValues\[i\]\[2\] =songs.get(i).getLanguage();

tableValues\[i\]\[3\] =songs.get(i).getCategory();

tableValues\[i\]\[4\] =songs.get(i).getSinger();//System.out.println(tableValues\[i\]\[0\]);

tableModel= newmyTableModel(tableValues, columnNames);

tableModel.isCellEditable(0, 0);

table= newJTable(tableModel);

table.setRowHeight(20); //设置行高

table.getTableHeader().setBackground(Color.GRAY); //表头颜色

table.setLocation(20, 80);

table.setSelectionMode(ListSelectionModel.SINGLE\_SELECTION);//只能选中单行

panelTable = newJScrollPane(table);

panelTable.setBorder(BorderFactory.createTitledBorder("歌曲信息"));

panelMain.add(panelTable, BorderLayout.CENTER);

panelBottom= newJPanel();

labName= new JLabel("歌名");

tfName= new JTextField(8);

labLanguage= new JLabel("语言");

tfLanguage= new JTextField(8);

labCategory= new JLabel("类别");

tfCategory= new JTextField(8);

labSinger= new JLabel("歌手");

tfSinger= new JTextField(8);

panelBottom.add(labName);

panelBottom.add(tfName);

panelBottom.add(labLanguage);

panelBottom.add(tfLanguage);

panelBottom.add(labCategory);

panelBottom.add(tfCategory);

panelBottom.add(labSinger);

panelBottom.add(tfSinger);

btnAdd= new JButton("增加");

btnEdit= new JButton("修改");

btnDelete= new JButton("删除");

panelBottom.add(btnAdd);

panelBottom.add(btnEdit);

panelBottom.add(btnDelete);

panelMain.add(panelBottom, BorderLayout.SOUTH);this.getContentPane().add(panelMain);this.setVisible(true);//System.out.println("1234");

\}/\*\*\* myTableModel，继承DefaultTableModel，

\* 只重写了isCellEditable，让其不可编辑

\*\*/

private class myTableModel extendsDefaultTableModel \{/\*\*\*\*/

private static final long serialVersionUID = 1L;publicmyTableModel(Object\[\]\[\] data, Object\[\] columnNames) \{super(data, columnNames);//TODO Auto-generated constructor stub

\}//让表格不可编辑，重写了DefaultTableModel中的方法

public boolean isCellEditable(int row, intcolumn) \{return false;

实际效果如下图所示：

![b46f6813bc8721a00035a948d5ab52c3.png][]

同理，为表格添加鼠标点击事件，具体代码如下所示：

![8f900a89c6347c561fdf2122f13be562.png][]

![961ddebeb323a10fe0623af514929fc1.png][]

table.addMouseListener(newMouseAdapter() \{//发生了点击事件

public voidmouseClicked(MouseEvent e) \{//获得被选中行的索引

int selectedRow =table.getSelectedRow();//从表格模型中获得指定单元格的值//Object id = tableModel.getValueAt(selectedRow, 0);

Object name = tableModel.getValueAt(selectedRow, 1);

Object language= tableModel.getValueAt(selectedRow, 2);

Object category= tableModel.getValueAt(selectedRow, 3);

Object singer= tableModel.getValueAt(selectedRow, 4);

tfName.setText(name.toString());

tfLanguage.setText(language.toString());

tfCategory.setText(category.toString());

tfSinger.setText(singer.toString());

\});

增加、修改、删除和前面的类似，只是要涉及到对数据库的操作了。代码如下所示：

![8f900a89c6347c561fdf2122f13be562.png][]

![961ddebeb323a10fe0623af514929fc1.png][]

/\*\*\* 添加一行\*/

private voidaddTableRow() \{

btnAdd.addActionListener(newActionListener() \{public voidactionPerformed(ActionEvent e) \{//String\[\] rowValues = \{"add",tfName.getText(),tfLanguage.getText(),//tfCategory.getText(),tfSinger.getText()\};

String name =tfName.getText().trim();

String language=tfLanguage.getText().trim();

String category=tfCategory.getText();

String singer=tfSinger.getText();if (name.equals("") || name == null

|| language.equals("") || language == null

|| category.equals("") || category == null

|| singer.equals("") || singer == null) \{

JOptionPane.showMessageDialog(panelTable,"不能为空", "信息提示框", JOptionPane.INFORMATION\_MESSAGE);return;

Song song= newSong(Common.getUuid(),name,language, category, singer);

String\[\] rowValues= new String\[5\];if(songService.addSong(song)) \{

JOptionPane.showMessageDialog(panelMain,"添加成功", "信息提示框", JOptionPane.INFORMATION\_MESSAGE);

rowValues\[0\] =song.getId();

rowValues\[1\] =song.getName();

rowValues\[2\] =song.getLanguage();

rowValues\[3\] =song.getCategory();

rowValues\[4\] =song.getSinger();//将输入框清空

tfName.setText("");

tfCategory.setText("");

tfSearch.setText("");

tfLanguage.setText("");//将新增的行加入表格中

tableModel.addRow(rowValues);

\}else\{

JOptionPane.showMessageDialog(panelTable,"添加失败", "信息提示框", JOptionPane.INFORMATION\_MESSAGE);

\});

\}/\*\*\* 修改信息\*/

private voideditTableRow() \{

btnEdit.addActionListener(newActionListener() \{public voidactionPerformed(ActionEvent e) \{int selectedRow = table.getSelectedRow(); //获取被选中行的索引

Song song = newSong();if (selectedRow != -1) \{ //判断是否存在被选中行//System.out.println(tableModel.getValueAt(selectedRow, 0));

song.setId(tableModel.getValueAt(selectedRow, 0).toString());

song.setName(tfName.getText());

song.setLanguage(tfLanguage.getText());

song.setCategory(tfCategory.getText());

song.setSinger(tfSinger.getText());if(songService.updateSong(song)) \{

song=songService.findById(song.getId());

JOptionPane.showMessageDialog(panelMain,"修改成功", "信息提示框", JOptionPane.INFORMATION\_MESSAGE);

tableModel.setValueAt(song.getId(), selectedRow,0);

tableModel.setValueAt(song.getName(), selectedRow,1);

tableModel.setValueAt(song.getLanguage(), selectedRow,2);

tableModel.setValueAt(song.getCategory(), selectedRow,3);

tableModel.setValueAt(song.getSinger(), selectedRow,4);

\}else\{

JOptionPane.showMessageDialog(panelTable,"修改失败", "信息提示框", JOptionPane.INFORMATION\_MESSAGE);

\});

\}/\*\*\* 删除一条信息\*/

private voiddeleteTableRow() \{

btnDelete.addActionListener(newActionListener() \{public voidactionPerformed(ActionEvent e) \{int selectedRow = table.getSelectedRow(); //获取被选中行的索引

if (selectedRow != -1) \{

String id= tableModel.getValueAt(selectedRow, 0).toString();if(songService.deletSong(id)) \{

JOptionPane.showMessageDialog(panelMain,"删除成功", "信息提示框", JOptionPane.INFORMATION\_MESSAGE);//将输入框清空

tfName.setText("");

tfCategory.setText("");

tfSearch.setText("");

tfLanguage.setText("");

tableModel.removeRow(selectedRow);

\}else\{

JOptionPane.showMessageDialog(panelTable,"删除失败", "信息提示框", JOptionPane.INFORMATION\_MESSAGE);

\});

现在只剩下了对查询的处理。

为了实现，当我们点击下面的单选按钮，搜索输入框中提示相应的消息，所以需要为单选按钮添加事件监听器，代码如下所示：

/\*\*\* 获取勾选框中的值，将该值的信息给放入到tfsearch中，用作提示信息\*/

private voidgetSearchTypeValue() \{for(JRadioButton jRadioButton : btnSearchTypes) \{

jRadioButton.addActionListener(newActionListener() \{public voidactionPerformed(ActionEvent e) \{

jRadioButton.setSelected(true); //将该jRadioButton设置为选中状态

String type =jRadioButton.getText();

tfSearch.setText("请输入" +type);//System.out.println(type);

\});

我们还需要为搜索输入框给加一个光标进入的事件，当光标移入时，我们把提示信息给清空(之前一直再想为什么java swing中没有html中的placeholder属性)，具体代码如下：

/\*\*\* 处理输入框的提示消息处理，当光标进入search输入框时，将输入框清空\*/

private voiddisplayMessage() \{

tfSearch.addFocusListener(newFocusAdapter() \{public voidfocusGained(FocusEvent e) \{

tfSearch.setText("");

\});

下面就是具体的查询了，再把查询到数据显示在表中之前，我们需要先使用DefaultTableModel中的setRowCount(0)，将表格清空(其实是设置表格的行数为0行，以达到清空的目的)。所以把该步骤给提取了出来，单独封装成一个方法，具体代码如下所示：

//查询时使用，清空表格数据，再重新添加行

private void fillSonginfoToTable(Listsongs) \{//判断一下是否有数据

if(songs.isEmpty()) \{

JOptionPane.showMessageDialog(panelMain,"Sorry, 未查询到数据，请从新输入", "信息提示框", JOptionPane.INFORMATION\_MESSAGE);

tableModel.setRowCount(0); //将表格清空

String\[\]\[\] tableValues = new String\[songs.size()\]\[5\];//重新装填数据

for (int j = 0; j < songs.size(); j++) \{

tableValues\[j\]\[0\] =songs.get(j).getId();

tableValues\[j\]\[1\] =songs.get(j).getName();

tableValues\[j\]\[2\] =songs.get(j).getLanguage();

tableValues\[j\]\[3\] =songs.get(j).getCategory();

tableValues\[j\]\[4\] =songs.get(j).getSinger();

tableModel.addRow(tableValues\[j\]);

至于查询，就是为查询按钮给添加事件监听器，按照单选框按钮的值和搜索输入框中的值进行查询，调用service层中的方法就行了，比较简单，具体代码如下：

![8f900a89c6347c561fdf2122f13be562.png][]

![961ddebeb323a10fe0623af514929fc1.png][]

btnSearch.addActionListener(newActionListener() \{public voidactionPerformed(ActionEvent e) \{

List songs = null;

String type= "歌名";for (int i = 0; i < btnSearchTypes.length; i++) \{if(btnSearchTypes\[i\].isSelected()) \{

type=btnSearchTypes\[i\].getText();

\}if ("歌名".equals(type)) \{

String name=tfSearch.getText();

System.out.println("name:" +name);

songs=songService.findByName(name);//System.out.println("查询出来的"+songs);

\} else if ("歌手".equals(type)) \{

String singer=tfSearch.getText();

songs=songService.findBySinger(singer);//System.out.println("查询出来的"+songs);

\} else if ("语言".equals(type)) \{

String language=tfSearch.getText();

songs=songService.findBylanguage(language);//System.out.println("查询出来的"+songs);

\} else if ("类别".equals(type)) \{

String category=tfSearch.getText();

songs=songService.findByCategory(category);//System.out.println("查询出来的"+songs);

\} else\{

JOptionPane.showMessageDialog(panelMain,"请选择查询类型", "信息提示框", JOptionPane.INFORMATION\_MESSAGE);

fillSonginfoToTable(songs);

\});

歌曲管理业务层的接口和实现类的完整代码如下：

SongService.java，接口

![8f900a89c6347c561fdf2122f13be562.png][]

![961ddebeb323a10fe0623af514929fc1.png][]

packageshiyan6.service;importjava.util.List;importshiyan6.entity.Song;public interfaceSongService \{/\*\*\* 显示所有歌曲

\*@return

\*/ListfindAll();/\*\*\* 通过id查找信息

\*@return

\*/Song findById(String id);/\*\*\* 按条件歌曲名查询歌曲

\*@paramcondition

\*@return

\*/ListfindByName(String name);/\*\*\* 按语言查询歌曲

\*@paramlanguage

\*@return

\*/ListfindBylanguage(String language);/\*\*\* 根据歌手来查询歌曲

\*@paramsinger

\*@return

\*/ListfindBySinger(String singer);/\*\*\* 格局歌曲类别来查询歌曲

\*@paramcategory

\*@return

\*/ListfindByCategory(String category);/\*\*\* 删除歌曲

\*@paramid

\*@return

\*/

booleandeletSong(String id);/\*\*\* 添加歌曲

\*@paramsong

\*@return

\*/

booleanaddSong(Song song);/\*\*\* 修改歌曲

\*@paramsong

\*@return

\*/

booleanupdateSong(Song song);

SongServiceImpl.java，实现类

![8f900a89c6347c561fdf2122f13be562.png][]

![961ddebeb323a10fe0623af514929fc1.png][]

packageshiyan6.service;importjava.util.List;importshiyan6.dao.SongDao;importshiyan6.dao.SongDaoImpl;importshiyan6.entity.Song;public class SongServiceImpl implementsSongService \{privateSongDao songDao;publicSongServiceImpl() \{

songDao= newSongDaoImpl();

@Overridepublic ListfindAll() \{returnsongDao.findAll();

@OverridepublicSong findById(String id) \{returnsongDao.findById(id);

@Overridepublic ListfindByName(String name) \{returnsongDao.findByName(name);

@Overridepublic ListfindBylanguage(String language) \{returnsongDao.findBylanguage(language);

@Overridepublic ListfindBySinger(String singer) \{returnsongDao.findBySinger(singer);

@Overridepublic ListfindByCategory(String category) \{returnsongDao.findByCategory(category);

@Overridepublic booleandeletSong(String id) \{returnsongDao.deletSong(id);

@Overridepublic booleanaddSong(Song song) \{returnsongDao.addSong(song);

@Overridepublic booleanupdateSong(Song song) \{returnsongDao.updateSong(song);

歌曲管理界面的完整代码

![8f900a89c6347c561fdf2122f13be562.png][]

![961ddebeb323a10fe0623af514929fc1.png][]

packageshiyan6.view;importjava.awt.BorderLayout;importjava.awt.Color;importjava.awt.Dimension;importjava.awt.GridLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.awt.event.FocusAdapter;importjava.awt.event.FocusEvent;importjava.awt.event.MouseAdapter;importjava.awt.event.MouseEvent;importjava.util.List;importjavax.swing.BorderFactory;importjavax.swing.ButtonGroup;importjavax.swing.JButton;importjavax.swing.JInternalFrame;importjavax.swing.JLabel;importjavax.swing.JOptionPane;importjavax.swing.JPanel;importjavax.swing.JRadioButton;importjavax.swing.JScrollPane;importjavax.swing.JTable;importjavax.swing.JTextField;importjavax.swing.ListSelectionModel;importjavax.swing.table.DefaultTableModel;importshiyan6.entity.Song;importshiyan6.service.SongService;importshiyan6.service.SongServiceImpl;importshiyan6.util.Common;/\*\*\* 管理员--管理歌曲信息界面

\*\*/

public class AdminSongManageView extendsJInternalFrame \{/\*\*\*\*/

private static final long serialVersionUID = 1L;private JPanel panelMain; //主面板

private JPanel panelTop; //主面板的上部

private JPanel panelSearch; //搜索面板

private JLabel labKey; //关键字

private JTextField tfSearch; //搜索框

private JButton btnSearch; //查找按钮

private JPanel panelSearchType; //按什么查找

private ButtonGroup buttonGroup = newButtonGroup();private JRadioButton\[\] btnSearchTypes = new JRadioButton\[4\]; //条件，如歌名，语言，类别，歌手

privateJLabel labSearch;private JScrollPane panelTable; //表格面板

private myTableModel tableModel;//定义表格模型对象

private JTable table;//定义表格对象

private JPanel panelBottom; //底部面板，包括输入框，添加、删除、修改

privateJLabel labName;privateJLabel labLanguage;privateJLabel labCategory;privateJLabel labSinger;private JTextField tfName; //输入歌曲名字

private JTextField tfLanguage; //输入语言

private JTextField tfCategory; //输入类别

private JTextField tfSinger; //歌手

private JButton btnAdd; //添加按钮

private JButton btnEdit; //修改按钮

private JButton btnDelete; //删除按钮

privateSongService songService;publicAdminSongManageView() \{

songService= newSongServiceImpl();

init();

getTableSelectedRow();

addTableRow();

editTableRow();

deleteTableRow();

getSearchTypeValue();

displayMessage();

find();

System.out.println("songmanagerView");

\}/\*\*\* 初始化各组件\*/

private voidinit() \{this.setTitle("歌曲管理");this.setSize(new Dimension(750, 550));this.setIconifiable(true); //窗体最小化

this.setClosable(true); //可被关闭

this.setDefaultCloseOperation(DISPOSE\_ON\_CLOSE); //退出

panelMain = new JPanel(newBorderLayout());

panelTop= new JPanel(new GridLayout(2, 1, 0, 0));

panelTop.setLocation(0, 20);

panelSearch= newJPanel();

panelSearch.setPreferredSize(new Dimension(750, 30));

labKey= new JLabel("关键字");

tfSearch= new JTextField("请输入歌名",20);

tfSearch.setPreferredSize(new Dimension(100, 20));

btnSearch= new JButton("查找");

btnSearch.setPreferredSize(new Dimension(60, 20));

panelSearch.add(newJLabel());

panelSearch.add(labKey);

panelSearch.add(tfSearch);

panelSearch.add(newJLabel());

panelSearch.add(btnSearch);

panelSearch.add(newJLabel());

panelTop.add(panelSearch);

panelSearchType= newJPanel();

panelSearchType.setPreferredSize(new Dimension(750, 30));

labSearch= new JLabel("查询");

panelSearchType.add(labSearch);

btnSearchTypes\[0\] = new JRadioButton("歌名", true);

btnSearchTypes\[1\] = new JRadioButton("语言");

btnSearchTypes\[2\] = new JRadioButton("类别");

btnSearchTypes\[3\] = new JRadioButton("歌手");//System.out.println("名字"+btnSearchTypes\[1\].getText());

for(JRadioButton jRadioButton : btnSearchTypes) \{

buttonGroup.add(jRadioButton);

panelSearchType.add(jRadioButton);

panelTop.add(panelSearchType);

panelMain.add(panelTop, BorderLayout.NORTH);

String\[\] columnNames= \{ "id", "歌名", "语言", "类别", "歌手"\};//从数据库中查询所有数据

List songs =songService.findAll();

System.out.println(songs);

String\[\]\[\] tableValues= new String\[songs.size()\]\[5\];for (int i = 0; i < songs.size(); i++) \{

tableValues\[i\]\[0\] =songs.get(i).getId();

tableValues\[i\]\[1\] =songs.get(i).getName();

tableValues\[i\]\[2\] =songs.get(i).getLanguage();

tableValues\[i\]\[3\] =songs.get(i).getCategory();

tableValues\[i\]\[4\] =songs.get(i).getSinger();//System.out.println(tableValues\[i\]\[0\]);

\}//String\[\]\[\] tableValues = \{ \{"1", "1", "1", "1", "1"\},//\{"2", "2", "2", "2", "2"\},//\{"3", "3", "3", "3", "3"\},//\{"3", "1", "1", "1", "1"\},//\{"3", "1", "1", "1", "1"\},//\{"3", "1", "1", "1", "1"\},//\{"3", "1", "1", "1", "1"\},//\{"3", "1", "1", "1", "1"\},//\{"3", "1", "1", "1", "1"\},//\{"3", "1", "1", "1", "1"\},//\{"3", "1", "1", "1", "1"\},//\{"3", "1", "1", "1", "1"\},//\{"3", "1", "1", "1", "1"\},//\{"3", "1", "1", "1", "1"\},//\{"3", "1", "1", "1", "1"\},//\{"3", "1", "1", "1", "1"\},//\{"3", "1", "1", "1", "1"\},//\{"3", "1", "1", "1", "1"\},//\{"3", "1", "1", "1", "1"\},//\{"3", "1", "1", "1", "1"\},//\{"4", "1", "1", "1", "1"\},//\{"4", "1", "1", "1", "1"\},//\{"4", "1", "1", "1", "1"\},//\{"4", "1", "1", "1", "1"\},//\{"4", "1", "1", "1", "1"\},//\{"4", "1", "1", "1", "1"\},//\{"4", "1", "1", "1", "1"\},//\{"4", "1", "1", "1", "1"\},//\{"4", "1", "1", "1", "1"\}//\};

tableModel = newmyTableModel(tableValues, columnNames);

tableModel.isCellEditable(0, 0);

table= newJTable(tableModel);//table.setRowSorter(new TableRowSorter<>(tableModel));//不可排序

table.setRowHeight(20); //设置行高

table.getTableHeader().setBackground(Color.GRAY); //表头颜色

table.setLocation(20, 80);

table.setSelectionMode(ListSelectionModel.SINGLE\_SELECTION);//只能选中单行//table.setEnabled(false);//设置表格为不可编辑

panelTable = newJScrollPane(table);

panelTable.setBorder(BorderFactory.createTitledBorder("歌曲信息"));

panelMain.add(panelTable, BorderLayout.CENTER);

panelBottom= newJPanel();

labName= new JLabel("歌名");

tfName= new JTextField(8);

labLanguage= new JLabel("语言");

tfLanguage= new JTextField(8);

labCategory= new JLabel("类别");

tfCategory= new JTextField(8);

labSinger= new JLabel("歌手");

tfSinger= new JTextField(8);

panelBottom.add(labName);

panelBottom.add(tfName);

panelBottom.add(labLanguage);

panelBottom.add(tfLanguage);

panelBottom.add(labCategory);

panelBottom.add(tfCategory);

panelBottom.add(labSinger);

panelBottom.add(tfSinger);

btnAdd= new JButton("增加");

btnEdit= new JButton("修改");

btnDelete= new JButton("删除");

panelBottom.add(btnAdd);

panelBottom.add(btnEdit);

panelBottom.add(btnDelete);

panelMain.add(panelBottom, BorderLayout.SOUTH);this.getContentPane().add(panelMain);this.setVisible(true);//System.out.println("1234");

\}/\*\*\* 获取选中的表格的一行\*/

private voidgetTableSelectedRow() \{

table.addMouseListener(newMouseAdapter() \{//发生了点击事件

public voidmouseClicked(MouseEvent e) \{//获得被选中行的索引

int selectedRow =table.getSelectedRow();//从表格模型中获得指定单元格的值//Object id = tableModel.getValueAt(selectedRow, 0);

Object name = tableModel.getValueAt(selectedRow, 1);

Object language= tableModel.getValueAt(selectedRow, 2);

Object category= tableModel.getValueAt(selectedRow, 3);

Object singer= tableModel.getValueAt(selectedRow, 4);

tfName.setText(name.toString());

tfLanguage.setText(language.toString());

tfCategory.setText(category.toString());

tfSinger.setText(singer.toString());

\});

\}/\*\*\* 添加一行\*/

private voidaddTableRow() \{

String name =tfName.getText().trim();

String language=tfLanguage.getText().trim();

String category=tfCategory.getText();

String singer=tfSinger.getText();if (name.equals("") || name == null

|| language.equals("") || language == null

|| category.equals("") || category == null

|| singer.equals("") || singer == null) \{

JOptionPane.showMessageDialog(panelTable,"不能为空", "信息提示框", JOptionPane.INFORMATION\_MESSAGE);return;

Song song= newSong(Common.getUuid(),name,language, category, singer);

String\[\] rowValues= new String\[5\];if(songService.addSong(song)) \{

JOptionPane.showMessageDialog(panelMain,"添加成功", "信息提示框", JOptionPane.INFORMATION\_MESSAGE);

rowValues\[0\] =song.getId();

rowValues\[1\] =song.getName();

rowValues\[2\] =song.getLanguage();

rowValues\[3\] =song.getCategory();

rowValues\[4\] =song.getSinger();//将输入框清空

tfName.setText("");

tfCategory.setText("");

tfSearch.setText("");

tfLanguage.setText("");//将新增的行加入表格中

tableModel.addRow(rowValues);

\}else\{

JOptionPane.showMessageDialog(panelTable,"添加失败", "信息提示框", JOptionPane.INFORMATION\_MESSAGE);

\}//int preCount = table.getRowCount();//System.out.println(preCount);//tableModel.addRow(rowValues);//int rowCount = table.getRowCount();//System.out.println(rowCount);//try \{//if (rowCount > preCount) \{// //String id = tableModel.getValueAt(rowCount, 0).toString();//String name = tableModel.getValueAt(rowCount, 1).toString();//String language = tableModel.getValueAt(rowCount, 2).toString();//String category = tableModel.getValueAt(rowCount, 3).toString();//String singer = tableModel.getValueAt(rowCount, 4).toString();//

//tfName.setText(name);//tfLanguage.setText(language);//tfCategory.setText(category);//tfSinger.setText(singer);//\}//\} catch (Exception e2) \{// //TODO: handle exception//\}

\});

\}/\*\*\* 修改信息\*/

private voideditTableRow() \{

btnEdit.addActionListener(newActionListener() \{public voidactionPerformed(ActionEvent e) \{int selectedRow = table.getSelectedRow(); //获取被选中行的索引

Song song = newSong();if (selectedRow != -1) \{ //判断是否存在被选中行//System.out.println(tableModel.getValueAt(selectedRow, 0));

song.setId(tableModel.getValueAt(selectedRow, 0).toString());

song.setName(tfName.getText());

song.setLanguage(tfLanguage.getText());

song.setCategory(tfCategory.getText());

song.setSinger(tfSinger.getText());if(songService.updateSong(song)) \{

song=songService.findById(song.getId());

JOptionPane.showMessageDialog(panelMain,"修改成功", "信息提示框", JOptionPane.INFORMATION\_MESSAGE);

tableModel.setValueAt(song.getId(), selectedRow,0);

tableModel.setValueAt(song.getName(), selectedRow,1);

tableModel.setValueAt(song.getLanguage(), selectedRow,2);

tableModel.setValueAt(song.getCategory(), selectedRow,3);

tableModel.setValueAt(song.getSinger(), selectedRow,4);

\}else\{

JOptionPane.showMessageDialog(panelTable,"修改失败", "信息提示框", JOptionPane.INFORMATION\_MESSAGE);

\});

\}/\*\*\* 删除一条信息\*/

private voiddeleteTableRow() \{

btnDelete.addActionListener(newActionListener() \{public voidactionPerformed(ActionEvent e) \{int selectedRow = table.getSelectedRow(); //获取被选中行的索引

if (selectedRow != -1) \{

String id= tableModel.getValueAt(selectedRow, 0).toString();if(songService.deletSong(id)) \{

JOptionPane.showMessageDialog(panelMain,"删除成功", "信息提示框", JOptionPane.INFORMATION\_MESSAGE);//将输入框清空

tfName.setText("");

tfCategory.setText("");

tfSearch.setText("");

tfLanguage.setText("");

tableModel.removeRow(selectedRow);

\}else\{

JOptionPane.showMessageDialog(panelTable,"删除失败", "信息提示框", JOptionPane.INFORMATION\_MESSAGE);

\});

\}/\*\*\* 获取勾选框中的值，将该值的信息给放入到tfsearch中，用作提示信息\*/

private voidgetSearchTypeValue() \{for(JRadioButton jRadioButton : btnSearchTypes) \{

jRadioButton.addActionListener(newActionListener() \{public voidactionPerformed(ActionEvent e) \{

jRadioButton.setSelected(true); //将该jRadioButton设置为选中状态

String type =jRadioButton.getText();

tfSearch.setText("请输入" +type);//System.out.println(type);

\});

\}/\*\*\* 查询\*/

private voidfind() \{

btnSearch.addActionListener(newActionListener() \{public voidactionPerformed(ActionEvent e) \{

List songs = null;

String type= "歌名";for (int i = 0; i < btnSearchTypes.length; i++) \{if(btnSearchTypes\[i\].isSelected()) \{

type=btnSearchTypes\[i\].getText();

\}if ("歌名".equals(type)) \{

String name=tfSearch.getText();

System.out.println("name:" +name);

songs=songService.findByName(name);//System.out.println("查询出来的"+songs);

\} else if ("歌手".equals(type)) \{

String singer=tfSearch.getText();

songs=songService.findBySinger(singer);//System.out.println("查询出来的"+songs);

\} else if ("语言".equals(type)) \{

String language=tfSearch.getText();

songs=songService.findBylanguage(language);//System.out.println("查询出来的"+songs);

\} else if ("类别".equals(type)) \{

String category=tfSearch.getText();

songs=songService.findByCategory(category);//System.out.println("查询出来的"+songs);

\} else\{

JOptionPane.showMessageDialog(panelMain,"请选择查询类型", "信息提示框", JOptionPane.INFORMATION\_MESSAGE);

fillSonginfoToTable(songs);

\});

\}//查询时使用，清空表格数据，再重新添加行

private void fillSonginfoToTable(Listsongs) \{if(songs.isEmpty()) \{

JOptionPane.showMessageDialog(panelMain,"Sorry, 未查询到数据，请从新输入", "信息提示框", JOptionPane.INFORMATION\_MESSAGE);

tableModel.setRowCount(0); //将表格清空

String\[\]\[\] tableValues = new String\[songs.size()\]\[5\];//重新装填数据

for (int j = 0; j < songs.size(); j++) \{

tableValues\[j\]\[0\] =songs.get(j).getId();

tableValues\[j\]\[1\] =songs.get(j).getName();

tableValues\[j\]\[2\] =songs.get(j).getLanguage();

tableValues\[j\]\[3\] =songs.get(j).getCategory();

tableValues\[j\]\[4\] =songs.get(j).getSinger();//System.out.println(tableValues\[j\]\[0\]);

tableModel.addRow(tableValues\[j\]);

\}/\*\*\* 处理输入框的提示消息处理，当光标进入search输入框时，将输入框清空\*/

private voiddisplayMessage() \{

tfSearch.addFocusListener(newFocusAdapter() \{public voidfocusGained(FocusEvent e) \{

tfSearch.setText("");

\});

\}/\*\*\* myTableModel，继承DefaultTableModel，

\* 只重写了isCellEditable，让其不可编辑

\*\*/

private class myTableModel extendsDefaultTableModel \{/\*\*\*\*/

private static final long serialVersionUID = 1L;publicmyTableModel(Object\[\]\[\] data, Object\[\] columnNames) \{super(data, columnNames);//TODO Auto-generated constructor stub

\}//让表格不可编辑，重写了DefaultTableModel中的方法

public boolean isCellEditable(int row, intcolumn) \{return false;

推荐一个好的论坛--科帮网，里面有很多的项目源码、干货帖子和大神，希望能帮到大家。

[8f900a89c6347c561fdf2122f13be562.png]: /images/20221024/c8f32b258f844d7482dc3950d492731a.png
[961ddebeb323a10fe0623af514929fc1.png]: /images/20221024/d18a7d280330436f81812c850d992445.png
[792f1a3ad4452761b3e36f68b18c5db7.png]: /images/20221024/88ba14f6b10b4c25a4b413b440eef3c1.png
[84802ec2b5259aaf78a31d221201d83c.png]: /images/20221024/c6ef28e8154b44bb86fc612bac28ba03.png
[6c1e5dd5e03b39efbb3c11ce4a2e2e4b.png]: /images/20221024/38e007b7522446f3a724e39a52f3a8a0.png
[b46f6813bc8721a00035a948d5ab52c3.png]: /images/20221024/8745fea426184209bc68c34a5ab1f4a6.png