com.mysql.cj.jdbc.exceptions.通信异常：通信链路故障

Question

我试图连接我的java应用程序与SQL数据库和当我点击保存按钮它给我以下错误

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

这是我的密码

        name = full_name_input.getText();
        Fname = father_name_input.getText();
        cnic = father_cnic_input.getText();
        DOB = Integer.parseInt(DOB_input.getText());
        Class_V = Integer.parseInt(class_input.getText()); 
        prsnt_add = present_add_input.getText();
        city = city_input.getText();
        province = radio_text;
        Connection conn = null;
        PreparedStatement pst = null;

        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql:///UserDetails", "root", "sahanj");
            pst = conn.prepareStatement("insert into UserDetails values (?,?,?,?,?,?,?,?)");

            pst.setString(1, name);
            pst.setString(2, Fname);
            pst.setString(3, cnic);`enter code here`
            pst.setInt(4, DOB);
            pst.setInt(5, Class_V);
            pst.setString(6, prsnt_add);
            pst.setString(7, city);
            pst.setString(8, province);

            int x = pst.executeUpdate();

            if (x>0)
            {
                JOptionPane.showMessageDialog(null, "Record Saved !\n");
            }
            else
            {
                JOptionPane.showMessageDialog(null, "Data Not Saved !\n");
            }
        }

        catch(Exception e)
        {
            JOptionPane.showMessageDialog(null, e);
        }
}                                  

Answer 1

这个错误通常是由于以下原因而发生的。JDBC网址中的1.hostname不正确。2.port号不正确。3.db服务器没有启动。对于这些，请执行以下步骤1。给出完整的JDBC网址或用ping测试。2。签入mysql的my.cnf。3。启动数据库。