使用freemarker创建动态SQL
使用Spring的JdbcTempl时为了让SQL文便于管理,一般采用的将SQL文写在静态的字符串常量中。形式如下:
public class UserDao {
private static final String QUERY_USER_BY_ID = "select id, email, login_name from LOGIN_USER where id=?";
private static final String QUERY_USER_BY_IDS = "select id, email, login_name from LOGIN_USER where id in(:ids)";
private static final String QUERY_USER = "select id, email, login_name from LOGIN_USER order by id";
private static final String QUERY_USER_BY_LOGINNAME = "select id,email,login_name from LOGIN_USER where login_name=:login_name";
private static final String INSERT_USER = "insert into LOGIN_USER(id, login_name, email) values(:id, :loginName, :email)";
private SimpleJdbcTemplate jdbcTemplate;
private UserMapper userMapper = new UserMapper();
private class UserMapper implements RowMapper<User> {
public User