import com.j256.ormlite.dao.Dao;
import com.j256.ormlite.dao.DaoManager;
import com.j256.ormlite.jdbc.JdbcConnectionSource;
import com.j256.ormlite.table.TableUtils;
import java.sql.SQLException;
import java.util.List;
public class Main {
public static void main(String[] args) {
try {
JdbcConnectionSource connectionSource = new JdbcConnectionSource("jdbc:mysql://localhost:3306/test", "root", "password");
Dao<User, Integer> userDao = DaoManager.createDao(connectionSource, User.class);
TableUtils.createTableIfNotExists(connectionSource, User.class);
User user = new User("John", "Doe", 25);
userDao.create(user);
List<User> users = userDao.queryForAll();
for (User u : users) {
System.out.println(u);
}
connectionSource.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
import com.j256.ormlite.field.DatabaseField;
import com.j256.ormlite.table.DatabaseTable;
@DatabaseTable(tableName = "users")
public class User {
@DatabaseField(generatedId = true)
private int id;
@DatabaseField
private String firstName;
@DatabaseField
private String lastName;
@DatabaseField
private int age;
// Getters and setters
@Override
public String toString() {
return "User{" +
"id=" + id +
", firstName='" + firstName + '\'' +
", lastName='" + lastName + '\'' +
", age=" + age +
'}';
}
}
