Example usage for org.springframework.jdbc.core PreparedStatementCreator PreparedStatementCreator

Introduction

In this page you can find the example usage for org.springframework.jdbc.core PreparedStatementCreator PreparedStatementCreator.

Prototype

PreparedStatementCreator

Source Link

Usage

From source file:org.perconsys.dao.implement.PostDb.java

@Override
public Post create(final Post post) {
    KeyHolder keyh = new GeneratedKeyHolder();
    final String sql = "insert into `posts` (`title`, `content`, `blog_id`, `date`) value (?, ?, ?, now()) ;";

    getJdbcTemplate().update(new PreparedStatementCreator() {

        @Override/*  w  w  w  .  j av a  2 s . com*/
        public PreparedStatement createPreparedStatement(Connection conn) throws SQLException {
            PreparedStatement pstat = conn.prepareStatement(sql, new String[] { "id" });
            pstat.setString(1, post.getTitle());
            pstat.setString(2, post.getContent());
            pstat.setLong(3, post.getBlog().getId());
            return pstat;
        }
    }, keyh);
    Long id = (Long) keyh.getKey();
    post.setId(id);
    return post;
}

From source file:zerogame.info.javapay.dao.PayOrderDao.java

@Override
public PayOrder add(final PayOrder payorder) {
    try {//  w w  w  . j  av  a  2  s  .c  om
        KeyHolder keyHolder = new GeneratedKeyHolder();
        getTemplate().update(new PreparedStatementCreator() {
            public PreparedStatement createPreparedStatement(Connection con) throws SQLException {
                PreparedStatement ps = con.prepareStatement("insert into pay_order"
                        + "(uin,account_id,order_id,product_id,product_name,product_desc,money,channel,serverId,status,order_type,create_time,user_level,vip_level) "
                        + "values(?,?,?,?,?,?,?,?,?,?,?,now(),?,?)", Statement.RETURN_GENERATED_KEYS);
                ps.setLong(1, payorder.getUin());
                ps.setString(2, payorder.getAccountId());
                ps.setString(3, payorder.getOrderId());
                ps.setString(4, payorder.getProductId());
                ps.setString(5, payorder.getProductName());
                ps.setString(6, payorder.getProductDesc());
                ps.setInt(7, payorder.getMoney());
                ps.setInt(8, payorder.getChannel());
                ps.setInt(9, payorder.getServerId());
                ps.setInt(10, payorder.getStatus());
                ps.setInt(11, payorder.getOrderType());
                ps.setInt(12, payorder.getUserLevel());
                ps.setInt(13, payorder.getUserVipLevel());
                return ps;
            }
        }, keyHolder);
        return payorder;
    } catch (Exception e) {
        logger.warn("add pay order failed", e);
        return null;
    }
}

From source file:net.freechoice.model.orm.Map_Tag.java

@Override
public PreparedStatementCreator createUpdate(final FC_Tag entity) {

    return new PreparedStatementCreator() {
        @Override//from ww w .j av a  2s. c o  m
        public PreparedStatement createPreparedStatement(Connection con) throws SQLException {

            PreparedStatement ps = con
                    .prepareStatement("update  FC_Tag" + " set content = ? " + "where id = ? ");
            ps.setString(1, entity.content);
            ps.setInt(2, entity.id);
            return ps;
        }
    };
}

From source file:com.onclave.testbench.jdbcTemplate.DAOSupport.StudentDAOImplementation.java

@Override
public boolean createNewStudent(final StudentPOJO student) {
    this.jdbcTemplate.update(new PreparedStatementCreator() {
        @Override//from  w  w  w .ja  v a2 s . c  om
        public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {
            PreparedStatement preparedStatement = connection
                    .prepareStatement(QueryStatements.INSERT_STUDENT_SQL);
            preparedStatement.setString(1, student.getName());
            preparedStatement.setString(2, student.getRollNo());
            preparedStatement.setString(3, student.getEmail());
            preparedStatement.setBoolean(4, student.isActive());
            preparedStatement.setInt(5, student.getAge());

            return preparedStatement;
        }
    });

    return true;
}

From source file:com.javacreed.examples.spring.ExampleDao.java

public long addNew(final String name) {
    final PreparedStatementCreator psc = new PreparedStatementCreator() {
        @Override//from w  w  w .  j a va 2  s  .co m
        public PreparedStatement createPreparedStatement(final Connection connection) throws SQLException {
            final PreparedStatement ps = connection.prepareStatement("INSERT INTO `names` (`name`) VALUES (?)",
                    Statement.RETURN_GENERATED_KEYS);
            ps.setString(1, name);
            return ps;
        }
    };

    // The newly generated key will be saved in this object
    final KeyHolder holder = new GeneratedKeyHolder();

    jdbcTemplate.update(psc, holder);

    final long newNameId = holder.getKey().longValue();
    return newNameId;
}

From source file:net.freechoice.model.orm.Map_Account.java

@Override
public PreparedStatementCreator createInsert(final FC_Account account) {

    return new PreparedStatementCreator() {
        @Override/*from   www.j a  v  a  2 s  .  c om*/
        public PreparedStatement createPreparedStatement(Connection con) throws SQLException {
            PreparedStatement ps = con.prepareStatement(
                    "insert into FC_Account(" + "id_user_, balance)" + " values(?, ?)", RET_ID);
            ps.setInt(1, account.id_user_);
            ps.setBigDecimal(2, account.balance);
            return ps;
        }
    };
}

From source file:eu.ibacz.swsc.spring.di.testdependencyinjection.dao.impl.JdbcTemplateCustomerDaoImpl.java

public void save(final Customer customer) {
    KeyHolder keyHolder = new GeneratedKeyHolder();
    jdbcTemplate.update(new PreparedStatementCreator() {

        public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {
            PreparedStatement stmt = connection.prepareStatement(
                    "insert into customer (firstname, lastname) values (?,?)", Statement.RETURN_GENERATED_KEYS);
            stmt.setString(1, customer.getFirstname());
            stmt.setString(2, customer.getLastname());
            return stmt;
        }//from  www  . ja  v  a  2s . co m
    }, keyHolder);
    customer.setId(keyHolder.getKey().longValue());
}

From source file:com.ewcms.component.online.dao.AdvisorDAO.java

public int add(final Advisor vo) {
    final String sql = "Insert Into plugin_online_advisory "
            + "(username,name,title,content,organ_id,matter_id,ip) Values " + "(?,?,?,?,?,?,?)";

    jdbcTemplate.update(new PreparedStatementCreator() {

        @Override/*from   w  ww.  ja  va 2 s  . co  m*/
        public PreparedStatement createPreparedStatement(Connection con) throws SQLException {
            PreparedStatement ps = con.prepareStatement(sql);
            ps.setString(1, vo.getUsername());
            ps.setString(2, vo.getName());
            ps.setString(3, vo.getTitle());
            ps.setString(4, vo.getContent());
            ps.setInt(5, vo.getOrganId());
            ps.setInt(6, vo.getMatterId());
            ps.setString(7, vo.getIp());

            return ps;
        }
    });
    return jdbcTemplate.queryForInt("select currval('seq_plugin_online_advisory_id')");
}

From source file:zerogame.info.javapay.dao.UserDao.java

public Player add(final long uin, final int channel, final String accountId, final String accountName) {
    Player user = new Player();
    try {/*from  w ww .j  av  a2s. com*/
        KeyHolder keyHolder = new GeneratedKeyHolder();
        getTemplate().update(new PreparedStatementCreator() {
            public PreparedStatement createPreparedStatement(Connection con) throws SQLException {
                PreparedStatement ps = con.prepareStatement(
                        "insert into player(uin,channel,serverid,accountId,accountName) values(?,?,?,?,?)",
                        Statement.RETURN_GENERATED_KEYS);
                ps.setString(1, String.valueOf(uin));
                ps.setString(2, String.valueOf(channel));
                ps.setString(3, accountId);
                ps.setString(4, accountName);
                return ps;
            }
        }, keyHolder);
        user.setUin(keyHolder.getKey().intValue());
        return user;
    } catch (Exception e) {
        logger.warn("add account failed", e);
        return null;
    }
}

From source file:net.freechoice.model.orm.Map_Comment.java

@Override
public PreparedStatementCreator createInsert(final FC_Comment comment) {

    return new PreparedStatementCreator() {

        @Override//from   w w w  .  j  av a  2  s  .c o m
        public PreparedStatement createPreparedStatement(Connection con) throws SQLException {
            PreparedStatement ps = con.prepareStatement(
                    "insert into FC_Comment(" + "id_post_, email, name, comment)" + " values(?, ?, ?, ?)",
                    RET_ID);
            ps.setInt(1, comment.id_post_);
            ps.setString(2, comment.email);
            ps.setString(3, comment.name);
            ps.setString(4, comment.comment);
            return ps;
        }
    };
}