<dependency>
<groupId>com.j256.ormlite</groupId>
<artifactId>ormlite-core</artifactId>
<version>5.5</version>
</dependency>
import com.j256.ormlite.field.DatabaseField;
import com.j256.ormlite.table.DatabaseTable;
@DatabaseTable(tableName = "user")
public class User {
@DatabaseField(generatedId = true)
private int id;
@DatabaseField
private String name;
public User() {
}
public User(String name) {
this.name = name;
}
}
properties
database.url=jdbc:mysql://localhost:3306/testdb
database.username=root
database.password=password
import java.sql.SQLException;
import com.j256.ormlite.dao.Dao;
import com.j256.ormlite.dao.DaoManager;
import com.j256.ormlite.jdbc.JdbcPooledConnectionSource;
public class Main {
public static void main(String[] args) throws SQLException {
JdbcPooledConnectionSource connectionSource = new JdbcPooledConnectionSource("jdbc:mysql://localhost:3306/testdb", "root", "password");
Dao<User, Integer> userDao = DaoManager.createDao(connectionSource, User.class);
try {
TableUtils.createTableIfNotExists(connectionSource, User.class);
} catch (SQLException e) {
e.printStackTrace();
}
User user = new User("John");
try {
userDao.create(user);
} catch (SQLException e) {
e.printStackTrace();
}
try {
List<User> userList = userDao.queryForAll();
for (User u : userList) {
System.out.println(u.getName());
}
} catch (SQLException e) {
e.printStackTrace();
}
connectionSource.closeQuietly();
}
}
