database.url=jdbc:mysql://localhost:3306/mydatabase
database.username=root
database.password=123456
database.driver=com.mysql.jdbc.Driver
@DatabaseTable(tableName = "user")
public class User {
@DatabaseField(id = true)
private int id;
@DatabaseField(columnName = "name")
private String name;
@DatabaseField(columnName = "age")
private int age;
}
ConnectionSource connectionSource = new JdbcConnectionSource(databaseUrl, username, password);
Dao<User, Integer> userDao = DaoManager.createDao(connectionSource, User.class);
TableUtils.createTableIfNotExists(connectionSource, User.class);
User user = new User();
user.setId(1);
user.setName("John");
user.setAge(25);
userDao.create(user);
User queriedUser = userDao.queryForId(1);
connectionSource.close();
