jdbcTemplate的使用方法

1、1、使用JdbcTemplate的execute0方法执行SQL语句Java代码jdbcTemplate. execute(*CREATE TABLE USER (user_id integer, name varchar (100)w);2、如果是UPDATE或INSERT,可以用update()方法。Java代码1. jdbcTemplate. update(MINSERT INTO USER VALUES(r2.+3.+1.+5.user, get Id ()+ 八.user getName() + user .getSexO +user. getAgeO +*)*)；3、带参数的更新J

2、ava代码 1. jdbcTemplate. update(UPDATE USER SET name = ? WHERE user_id 二? new Obj ect namet id)；Java代码1. jdbcTemplate. update(MINSERT INTO USER VALUES(?.?.?) new Object uscr. get Id (). user getNeuneO . user getSexO usei* getAgeO);4、使用JdbcTemplate进行查询时，使用queryForXXX()等方法Java代码1. int count = jdbcTempla

3、te. queryEorlnt(SELECT COUNT() FROM USER”)；Java代码1. String name 二(String) jdbcTemplate. queryEorObject(SELECT name FROM USER WHERE user id - ? new Object id. java.1ang.String.class);Java代码】.List rows = jdbcTemplate. queryForList(HSELECT FROM ISER*)；Java代码 1. List rows 二 jdbcTemplate. queryForList(SE

4、LECT I;ROM ISER)；2. Iterator it = rowsiterator()；3. wh订e (it. hasNext () 1.Map userMap = (Map) i t.next ()；5.System. out print(userMap. get(Muser id”)+ ntjdbcTemplate.update(MINSERT INTO USER VALUES (?.?.?) new PreparedStatementSetter() public void setVa1ues(PreparedSt atemcnt ps) throws SQLExceptio

5、n );6.System out print (userMap. get(name*) +ntn)；7.System. out print(userMap. get(sex”)+*&9.System. out print ln(user(ap. get (age)+JdbcTemplate将我们使用的JDBC的流程封装起来，包括了异常的捕捉、SQL的执行、 查询结果的转换等等。spring大量使用Template Method模式来封装固定流程的动作， XXXTemplate等类别都是基于这种方式的实现。除了大量使用Template Method来封装一些底层的操作细节，spring也大量使用

6、 callback方式类回调相关类别的方法以提供JDBC相关类别的功能，使传统的JDBC的使用 者也能淸楚了解spring所提供的相关封装类别方法的使用。JDBC 的 PreparedStatement9.10.ps. setStri ng(1 ps. setString(2nam11.12.e);ps.setString(3ps. set 1 nt (1. age)；sex)；Java代码finalString id =-user getld()；finalString name=user. getNameO ；finalString sex= user getSex() +”;finali

7、nt age =user get Age ():13.Java代码1.final User user = new User()；2.jdbcTemplate. query C*SELECT * FROMUSER WHERE user_id = ?3.new Object id.4.new Roual Ibackllandler ()(5.public void processRow(Resu1tSet rs) throws SQLException 6.r_id”)；7.amew)；&x”). charAt (0):9.w);10.】1user. setld(rs getString(wuse

8、user. setName(rs getString(nuser.setSex(rs getString(Mse user. set/ge(rs get IJava代码1.class2.UserRowMapper implements RowMapper public Object mapRow(ResuItSet rs. int index) throws SQLExcept io3.User user 二 new User ():5.6.7.user setld(rs getString(user id”):user. setName (rs. getStringCrnamcw):user

9、. setSex(rs getString(，sexr) charAt (0)； user.setAge(rs getInt(*age*)；9.10.return user；11.12. 13.);11. public15.】6.er()；17. List f ind.Al lByRowMapperResul tReader ()String sql = ”SELECT * FROM USER:return jdbcTemplate. query(sq1. new RowilapperResultReader(new UserRowMapp在 getUser (id)里面使用 UserRowM

10、apperJava代码public User getUser(final String id) throws DataAccessExcept i on 2. String sql = ” SELECT FROM USER WHERE userJd=?M；3. final Object params = new Object id ；List list = jdbcTemplate .query(sql. params, new RowMapperResultReader(new UserRowMapper()；5.6. return (User) 1ist. get(0)；7. 网上收集or

11、g. springframework, jdbc. core. PreparedStatementCreator 返回预编译 SQL 不能 于Object】一起用Java代码public PreparedStatement createPreparedStatement(Connect ion con) throws SQLExce ption 2 return con prepareStatement(sql)；| 3.1. 增删改org. springframework. jdbc. core. JdbcTemplate 类(必须指定数据源 dataSource)Java 代码1. tem

12、plate update(Minsert into web_person valucs(?)wtObject)；或Java代码template .update(insert into web_person values(?)new PreparedStatementSett er()匿名部类 只能访问外部最终局部变量2.3. public void setValues(PreparedStatement ps) throws SQLException 1.ps. setInt(index+.3)；5.);org. springframework, jdbc. core. PreparedSta

13、tementSetter 接口 处理预编译 SQLJava代码1. public void setValues(PreparedStatement ps) throws SQLException 2. ps. setlnt(index+t3):3. )2. 查询JdbcTemplate query(String,Object/PreparedStatementSetter,RowMapper/Roua1 lb ackHandler)org. springframework. jdbc. core. RowMapper 记录映射接口 处理结果集Java代码 public Object mapRow(Resu1tSet rs int argl) throws SQLException int表当前行数2. person set Id(rs getlnt(id)；3. )1. List template.qucry(”select * from web person where id-?0bjectRowikipper);otg springframework, jdbe. core. RowCalIback