demo for jetbrick-webmvc + orm

DAOHelper.java

@IocBean("jetbrick.dao.orm.JdbcHelper")
public class DAOHelperFactory implements IocFactory<JdbcHelper> {
    @Inject
    private DataSource dataSource;
  
    public JdbcHelper getObject() {
        return new JdbcHelper(dataSource);
    }
}

DruidDataSource.java

@IocBean("javax.sql.DataSource")
public class DruidDataSourceFactory implements IocFactory<DataSource> {

    @Config("jdbc.url")
    private String url;

    @Config("jdbc.username")
    private String username;

    @Config("jdbc.password")
    private String password;

    @Override
    public DataSource getObject() {
        DruidDataSource ds = new DruidDataSource();
        ds.setUrl(url);
        ds.setUsername(username);
        ds.setPassword(password);
        return ds;
    }
}

jdbc.properties

jdbc.url = jdbc:mysql://127.0.0.1:3306/XXX
jdbc.username = root
jdbc.password = root

$dataSource = com.alibaba.druid.pool.DruidDataSource
$dataSource.url = jdbc:mysql://127.0.0.1:3306/XXX
$dataSource.username = root
$dataSource.password = root

PassportController.java

@Controller
public class PassportController {
    @Inject
    private PassportDAO passportDAO;
    
    @Action("/passport/check")
    public JSONAware checkUserPassword(
        @RequestParam("name") String name,
        @RequestParam("pass") String pass
    ) {
        boolean succ = passportDAO.checkUserPassword(name, pass);
        return JSON.wrap(succ);
    }

}

PassportDAO.java

@IocBean
public class PassportDAO {
    @Inject
    private JdbcHelper jdbc;
  
    public boolean checkUserPassword(String name, String pass) {
        User user = jdbc.queryAsObject(User.class, "select * from User where name=?", name);
        if (user != null) {
            return pass.equals(user.getPassword());
        }
        return false;
    }
}