java无法插入mysql_java-无法将行插入MySQL数据库

我有一个带表lyricss1的基于日期的歌词,以及下面的代码,我想在lyrics1中插入一行.

但是,当我回到mysql客户端并描述lyrics1时,它尚未更新.

我没有错误,它可以很好地连接到数据库.至少我没有收到错误的消息,说它无法执行.

connectToDB();

ok.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

try {

String query = "INSERT INTO lyrics1(name, artist) values(?, ?)";

PreparedStatement statement = connection.prepareStatement(query);

statement.setString(1, nameOfSong.getText()); // set input parameter 2

statement.setString(2, artist.getText());

ResultSet rs = statement.executeQuery("SELECT * FROM lyrics1");

while (rs.next()){

System.out.println(rs.getString(1));

}

rs.close();

statement.close();

connection.close();

} catch (SQLException insertException) {

displaySQLError(insertException);

}

internalFrame.dispose();

}

});