import com.j256.ormlite.field.DatabaseField;
import com.j256.ormlite.table.DatabaseTable;
@DatabaseTable(tableName = "persons")
public class Person {
@DatabaseField(generatedId = true)
private int id;
@DatabaseField(columnName = "name")
private String name;
@DatabaseField(columnName = "age")
private int age;
}
import com.j256.ormlite.dao.Dao;
import com.j256.ormlite.jdbc.JdbcConnectionSource;
import com.j256.ormlite.support.ConnectionSource;
import com.j256.ormlite.table.TableUtils;
import java.sql.SQLException;
public class DatabaseHelper {
private static final String DATABASE_URL = "jdbc:mysql://localhost:3306/test";
private static final String DATABASE_USERNAME = "root";
private static final String DATABASE_PASSWORD = "password";
private Dao<Person, Integer> personDao;
public DatabaseHelper() {
try {
ConnectionSource connectionSource = new JdbcConnectionSource(DATABASE_URL, DATABASE_USERNAME, DATABASE_PASSWORD);
TableUtils.createTableIfNotExists(connectionSource, Person.class);
personDao = DaoManager.createDao(connectionSource, Person.class);
} catch (SQLException e) {
e.printStackTrace();
}
}
public Dao<Person, Integer> getPersonDao() {
return personDao;
}
}
public class Main {
public static void main(String[] args) {
DatabaseHelper databaseHelper = new DatabaseHelper();
Person person = new Person();
person.setAge(25);
databaseHelper.getPersonDao().create(person);
List<Person> personList = databaseHelper.getPersonDao().queryForAll();
for (Person p : personList) {
}
Person personToUpdate = personList.get(0);
databaseHelper.getPersonDao().update(personToUpdate);
Person personToDelete = personList.get(0);
databaseHelper.getPersonDao().delete(personToDelete);
}
}
