JAVA CRUD WITH ACCESS code example
Example 1: CRUD JAVA
String sql = "SELECT * FROM Users";
Statement statement = conn.createStatement();
ResultSet result = statement.executeQuery(sql);
int count = 0;
while (result.next()){
String name = result.getString(2);
String pass = result.getString(3);
String fullname = result.getString("fullname");
String email = result.getString("email");
String output = "User #%d: %s - %s - %s - %s";
System.out.println(String.format(output, ++count, name, pass, fullname, email));
}
Example 2: CRUD JAVA
String sql = "DELETE FROM Users WHERE username=?";
PreparedStatement statement = conn.prepareStatement(sql);
statement.setString(1, "bill");
int rowsDeleted = statement.executeUpdate();
if (rowsDeleted > 0) {
System.out.println("A user was deleted successfully!");
}