<dependencies>
<dependency>
<groupId>com.j256.ormlite</groupId>
<artifactId>ormlite-core</artifactId>
<version>5.5</version>
</dependency>
</dependencies>
import com.j256.ormlite.jdbc.JdbcConnectionSource;
import com.j256.ormlite.support.ConnectionSource;
import com.j256.ormlite.table.TableUtils;
import java.sql.SQLException;
public class DatabaseConfig {
private static final String DATABASE_URL = "jdbc:mysql://localhost:3306/sample_db";
private static final String DATABASE_USERNAME = "root";
private static final String DATABASE_PASSWORD = "password";
public static ConnectionSource getConnectionSource() throws SQLException {
return new JdbcConnectionSource(DATABASE_URL, DATABASE_USERNAME, DATABASE_PASSWORD);
}
public static void createTables() throws SQLException {
ConnectionSource connectionSource = getConnectionSource();
TableUtils.createTableIfNotExists(connectionSource, Student.class);
connectionSource.close();
}
}
import com.j256.ormlite.field.DatabaseField;
import com.j256.ormlite.table.DatabaseTable;
@DatabaseTable(tableName = "students")
public class Student {
@DatabaseField(generatedId = true)
private int id;
@DatabaseField(canBeNull = false)
private String name;
@DatabaseField
private int age;
public Student() {
}
public Student(String name, int age) {
this.name = name;
this.age = age;
}
public int getId() {
return id;
}
public String getName() {
return name;
}
public int getAge() {
return age;
}
}
import com.j256.ormlite.dao.Dao;
import com.j256.ormlite.dao.DaoManager;
import com.j256.ormlite.support.ConnectionSource;
import java.sql.SQLException;
import java.util.List;
public class Main {
public static void main(String[] args) {
try {
ConnectionSource connectionSource = DatabaseConfig.getConnectionSource();
DatabaseConfig.createTables();
Dao<Student, Integer> studentDao = DaoManager.createDao(connectionSource, Student.class);
studentDao.create(student);
List<Student> students = studentDao.queryForAll();
for (Student s : students) {
}
connectionSource.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
