java - 我正在尝试将 mysql 查询结果打印到 jLabel 中

Question

因此，当我单击另一个“显示提示”标签时，查询语句本身将被打印到 jLabel 中，而不是将查询结果打印到 Jlabel 中

private void jLabel7MouseClicked(java.awt.event.MouseEvent evt) {

try
    {            
    Class.forName("com.mysql.jdbc.Driver");            
    Connection CC = DriverManager.getConnection(
           "jdbc:mysql://localhost:3306/pulsedb", "root", "passtheword");
    String query = "SELECT hint FROM mstufflogin WHERE username = 'tapiwa'";            
    PreparedStatement PS = CC.prepareStatement(query);            
    PS.executeQuery(query);            
    jLabel6.setText("HINT: " + query);
}

标签上的输出将是...从 mstufflogin WHERE username = 'tapiwa' 中选择提示

Answer 1

用查询结果替换查询

ResultSet result = PS.executeQuery();
result.next();
jLabel6.setText("HINT: " + result.getString(1));