String databaseUrl = "jdbc:mysql://localhost:3306/mydatabase";
String username = "root";
String password = "password";
ConnectionSource connectionSource = new JdbcConnectionSource(databaseUrl, username, password);
createTable(connectionSource);
connectionSource.close();
@DatabaseTable(tableName = "users")
public class User {
@DatabaseField(id = true)
private int id;
@DatabaseField
private String name;
@DatabaseField
private int age;
}
private static void createTable(ConnectionSource connectionSource) {
try {
TableUtils.createTable(connectionSource, User.class);
} catch (SQLException e) {
e.printStackTrace();
}
}
private static void updateTable(ConnectionSource connectionSource) {
try {
TableUtils.updateTable(connectionSource, User.class);
} catch (SQLException e) {
e.printStackTrace();
}
}
