@Entity("user")
public class User {
@Id
private int id;
private String name;
// ...
}
public class UserDao {
public List<User> findAllUsers() {
return OrmContext.getInstance().findAll(User.class);
}
public User findUserById(int id) {
return OrmContext.getInstance().findById(User.class, id);
}
public void saveUser(User user) {
Transaction transaction = OrmContext.getInstance().beginTransaction();
try {
OrmContext.getInstance().save(user);
transaction.commit();
} catch (Exception e) {
transaction.rollback();
throw e;
}
}
public void deleteUser(User user) {
Transaction transaction = OrmContext.getInstance().beginTransaction();
try {
OrmContext.getInstance().delete(user);
transaction.commit();
} catch (Exception e) {
transaction.rollback();
throw e;
}
}
}
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/mydb" />
<property name="username" value="root" />
<property name="password" value="password" />
</bean>
<config>
<mapping class="com.example.User" table="user" />
</config>
