Spring框架学习[JdbcTemplate封装Jdbc] - JAVA

ss() }; int[] types=new int[]{ Types.VARCHAR, Types.VARCHAR, Types.VARCHAR }; return this.getJdbcTemplate().update(sql,params,types); } public int[] updatePersonUseBatchUpdate( final List persons){ String sql="insert into login values( , , )"; BatchPreparedStatementSetter setter=null; //使用匿名内部类，实现BatchPreparedStatementSetter接口，实现批量更新 setter=new BatchPreparedStatementSetter(){ public int getBatchSize(){ return persons.size(); } public void setValues(PreparedStatement ps,int index) throws SQLException{ Person person=(Person)persons.get(index); ps.setString(1,person.getName()); ps.setString(2,person.getPassword()); ps.setString(3,person.getAddress()); } }; return this.getJdbcTemplate().batchUpdate(sql,setter); } public Person getPersonByRowCallbackHandler(String username){ String sql="select * from login where username= "; final Person person=new Person(); final Object params[]=new Object[]{username}; //使用匿名内部类，实现RowCallbackHandler接口，即实现查询结果集的RowMapping this.getJdbcTemplate().query(sql,params,new RowCallbackHandler(){ public void processRow(ResultSet rs)throws SQLException{ person.setName(rs.getString("username")); person.setPassword(rs.getString("passwd")); person.setAddress(rs.getString("address")); } }); return person; } }

package SpringJDBCSupport.ReadData; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Types; import java.util.List; import org.springframework.jdbc.core.BatchPreparedStatementSetter; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowCallbackHandler; public class PersonDAO {   private JdbcTemplate jdbcTemplate; public JdbcTemplate getJdbcTemplate() {     return jdbcTemplate; } public void set<div class="article-middle-ad" style="margin: 30px 0; padding: 20px 0; text-align: center; clear: both;">
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-3873923678443673" crossorigin="anonymous"></script>

<ins class="adsbygoogle"
     style="display:block"
     data-ad-client="ca-pub-3873923678443673"
     data-ad-slot="5723320063"
     data-ad-format="auto"
     data-full-width-responsive="true"></ins>
<script>
     (adsbygoogle = window.adsbygoogle || []).push({});
</script>
</div>JdbcTemplate(JdbcTemplate jdbcTemplate) {     this.jdbcTemplate = jdbcTemplate; } public int insertPersonUseUpdate(Person person){     String sql="insert into login values( , , )";     Object[] params=new Object[]{             person.getName(),             person.getPassword(),             person.getAddress()     };     return this.getJdbcTemplate().update(sql,params); } public int insertPersonUseExecute(Person person){     String sql="insert into login values( , , )";     Object[] params=new Object[]{             person.getName(),             person.getPassword(),             person.getAddress()     };     int[] types=new int[]{             Types.VARCHAR,             Types.VARCHAR,             Types.VARCHAR     };     return this.getJdbcTemplate().update(sql,params,types); } public int[] updatePersonUseBatchUpdate( final List persons){     String sql="insert into login values( , , )";     BatchPreparedStatementSetter setter=null; //使用匿名内部类，实现BatchPreparedStatementSetter接口，实现批量更新    setter=new BatchPreparedStatementSetter(){         public int getBatchSize(){             return persons.size();         }         public void setValues(PreparedStatement ps,int index) throws SQLException{             Person person=(Person)persons.get(index);             ps.setString(1,person.getName());             ps.setString(2,person.getPassword());             ps.setString(3,person.getAddress());         }     };     return this.getJdbcTemplate().batchUpdate(sql,setter); } public Person getPersonByRowCallbackHandler(String username){     String sql="select * from login where username= ";     final Person person=new Person();     final Object params[]=new Object[]{username}; //使用匿名内部类，实现RowCallbackHandler接口，即实现查询结果集的RowMapping    this.getJdbcTemplate().query(sql,para</span>
            </div>

<div class="article-footer mt-60 pt-40">
                
                <div class="share-box">
                    
                        <div class="bdsharebuttonbox"><a href="#" class="bds_more" data-cmd="more"></a><a href="#" class="bds_qzone" data-cmd="qzone" title="分享到QQ空间"></a><a href="#" class="bds_tsina" data-cmd="tsina" title="分享到新浪微博"></a><a href="#" class="bds_tqq" data-cmd="tqq" title="分享到腾讯微博"></a><a href="#" class="bds_renren" data-cmd="renren" title="分享到人人网"></a><a href="#" class="bds_weixin" data-cmd="weixin" title="分享到微信"></a></div>
                    <script>window._bd_share_config={"common":{"bdSnsKey":{},"bdText":"","bdMini":"2","bdMiniList":false,"bdPic":"","bdStyle":"0","bdSize":"24"},"share":{}};with(document)0[(getElementsByTagName('head')[0]||body).appendChild(createElement('script')).src='http://bdimg.share.baidu.com/static/api/js/share.js?v=89860593.js?cdnversion='+~(-new Date()/36e5)];</script>
                </div>

<div class="prev-next mt-20">
                    <div class="prev">
                        <span class="label">上一篇</span>
                        <a href="bencandy.php?fid=76&id=39894" onclick="" class="link">Spring框架学习[创建AOP代理对象..</a>
                    </div>
                    <div class="next">
                        <span class="label">下一篇</span>
                        <a href="bencandy.php?fid=76&id=39892" onclick="" class="link">建造者模式――Head First Design..</a>
                    </div>
                </div>
            </div>
        </div>

</div>
</div>
</div>

<footer class="container mt-20 site-footer">
    <div id="copyright">
        Copyright © https://www.cppentry.com all rights reserved 
        <a href="http://www.miibeian.gov.cn" target="_blank">粤ICP备13067022号-3</a><br>
            </div>
</footer>

Spring框架学习[JdbcTemplate封装Jdbc](二)