<dependency>
<groupId>com.j256.ormlite</groupId>
<artifactId>ormlite-core</artifactId>
<version>5.5</version>
</dependency>
<dependency>
<groupId>com.j256.ormlite</groupId>
<artifactId>ormlite-jdbc</artifactId>
<version>5.5</version>
</dependency>
properties
database.url=jdbc:mysql://localhost:3306/mydatabase
database.username=root
database.password=secret
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(canBeNull = false)
private String name;
@DatabaseField
private int age;
}
public class DatabaseManager {
private static final String DATABASE_CONFIG_FILE = "config.properties";
private static final String DATABASE_URL_PROPERTY = "database.url";
private static final String DATABASE_USERNAME_PROPERTY = "database.username";
private static final String DATABASE_PASSWORD_PROPERTY = "database.password";
private static ConnectionSource connectionSource;
public static void setupDatabase() throws SQLException, IOException {
Properties properties = loadProperties();
String databaseUrl = properties.getProperty(DATABASE_URL_PROPERTY);
String username = properties.getProperty(DATABASE_USERNAME_PROPERTY);
String password = properties.getProperty(DATABASE_PASSWORD_PROPERTY);
connectionSource = new JdbcConnectionSource(databaseUrl, username, password);
TableUtils.createTableIfNotExists(connectionSource, User.class);
}
private static Properties loadProperties() throws IOException {
Properties properties = new Properties();
FileInputStream input = new FileInputStream(DATABASE_CONFIG_FILE);
properties.load(input);
input.close();
return properties;
}
}
public class UserDao {
private static Dao<User, Integer> userDao;
public static void insertUser(User user) throws SQLException {
userDao.create(user);
}
}
public class Main {
public static void main(String[] args) {
try {
DatabaseManager.setupDatabase();
User newUser = new User();
newUser.setName("John");
newUser.setAge(25);
UserDao.insertUser(newUser);
e.printStackTrace();
}
}
}
