String databaseUrl = "jdbc:mysql://localhost:3306/mydatabase"; String username = "root"; String password = "password"; ConnectionSource connectionSource = new JdbcConnectionSource(databaseUrl, username, password); @DatabaseTable(tableName = "users") public class User { @DatabaseField(generatedId = true) private int id; @DatabaseField(columnName = "name") private String name; @DatabaseField(columnName = "age") private int age; } User user = new User(); user.setName("John"); user.setAge(25); Dao<User, Integer> userDao = DaoManager.createDao(connectionSource, User.class); userDao.create(user); Dao<User, Integer> userDao = DaoManager.createDao(connectionSource, User.class); List<User> users = userDao.queryForAll(); Dao<User, Integer> userDao = DaoManager.createDao(connectionSource, User.class); User user = userDao.queryForId(1); user.setAge(26); userDao.update(user); Dao<User, Integer> userDao = DaoManager.createDao(connectionSource, User.class); userDao.deleteById(1); connectionSource.close();


上一篇:
下一篇:
切换中文