Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Java GUI inserting to a DB

  • 17-10-2017 2:37pm
    #1
    chocolate boy123
    Closed Accounts Posts: 191 ✭✭


    Hi can someone please help me with this. When the user clicks the add button the package details add too the arrayList but not my DB.
     //Add package
        String time = new SimpleDateFormat("DD.MM.YYYY.HH.mm.ss").format(new java.util.Date());
        String name = nameInputTF.getText();
        String address = addressInputTF.getText();
        String city = cityInput.getText();
        String county = (String) countyCombo.getSelectedItem();
        String contact = contactInput.getText();
        String description = descriptionInput.getText();
        double price = Double.parseDouble(priceInput.getText());
        boolean prepaid = true || false;
        id++;

        //Adding packages to the list
        packages.add(new Package(id, time, name, address, city, county, contact, description, price, prepaid));

        //Method to display packages in the text JList
        displayList();

        try {

            String sql = "INSERT INTO packtable VALUES (?,?,?,?,?,?,?)";

            statement = conn.prepareStatement(sql);

            statement.setString(1, name);
            statement.setString(2, address);
            statement.setString(3, contact);
            statement.setDouble(4, price);
            statement.setInt(5, id);
            statement.setString(6, county);
            statement.setString(7, city);

            statement.executeUpdate();

        } catch (SQLException ex) {
            Logger.getLogger(A2ZTransit.class.getName()).log(Level.SEVERE, null, ex);
        }
       }

    And below is my connection class
    public class PackageJDBC {

    String user = "root";
    String password = "";
    String dbURL = "jdbc:mysql://localhost:3306/packages";

    Connection conn;
    PreparedStatement stmt;
    ResultSet rs;

    public PackageJDBC() {

    }

    public void connection() {
        try {
            conn = DriverManager.getConnection(dbURL, user, password);
        } catch (SQLException ex) {
            Logger.getLogger(PackageJDBC.class.getName()).log(Level.SEVERE, null, ex);
        }

        JOptionPane.showMessageDialog(null, "Connected to the database!");
    }
}

    My database is made in netbeans with each entry as char except id which is int, contact which is varchar and price which is float. Help would be massively appreciated.


Advertisement