CREATE TABLE user (
id INT PRIMARY KEY,
name VARCHAR(50),
age INT
);
import lombok.Data;
@Data
public class User {
private int id;
private String name;
private int age;
}
<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<database>
<driver>com.mysql.jdbc.Driver</driver>
<url>jdbc:mysql://localhost:3306/mydatabase</url>
<username>root</username>
<password>password</password>
</database>
<mappings>
<mapping class="com.example.User" table="user">
<property column="id" name="id" type="INT"/>
<property column="name" name="name" type="VARCHAR"/>
<property column="age" name="age" type="INT"/>
</mapping>
</mappings>
</configuration>
import com.enklib.sql.SQLSessionManager;
public class UserDao {
private SQLSessionManager manager;
public UserDao() {
manager = new SQLSessionManager("enklib-sql.xml");
}
public void saveUser(User user) {
manager.save(user);
}
public User getUserById(int id) {
return manager.get(User.class, id);
}
public void close() {
manager.close();
}
}
public class Main {
public static void main(String[] args) {
UserDao userDao = new UserDao();
User user = new User();
user.setId(1);
user.setAge(25);
userDao.saveUser(user);
User storedUser = userDao.getUserById(1);
System.out.println(storedUser);
userDao.close();
}
}
