morcble的blog

11.2. Using the JDBC Core classes to control basic JDBC
processing and error handling

11.2.1.
創建數據源（數據源里隱藏了數據連接池）
DriverManagerDataSource dataSource = new DriverManagerDataSource();
dataSource.setDriverClassName( "org.hsqldb.jdbcDriver");
dataSource.setUrl( "jdbc:hsqldb:hsql://localhost:");
dataSource.setUsername( "sa");
dataSource.setPassword( "");

11.2.3. SQLExceptionTranslator
      配置JdbcTemplate及異常處理
 // create a JdbcTemplate and set data source
 JdbcTemplate jt = new JdbcTemplate();
 jt.setDataSource(dataSource);
 // create a custom translator and set the datasource for the default translation lookup
 MySQLErrorCodesTransalator tr = new MySQLErrorCodesTransalator();
 tr.setDataSource(dataSource);
 jt.setExceptionTranslator(tr);
 // use the JdbcTemplate for this SqlUpdate
 SqlUpdate su = new SqlUpdate();
 su.setJdbcTemplate(jt);
 su.setSql("update orders set shipping_charge = shipping_charge * 1.05");
 su.compile();
 su.update();

11.2.4 簡單的調用配置好了的JdbcTemplate就可以執行SQL語句 如下

 import javax.sql.DataSource;
 import org.springframework.jdbc.core.JdbcTemplate;
 public class ExecuteAStatement {
  private JdbcTemplate jt;
  private DataSource dataSource;
  public void doExecute() {
   jt = new JdbcTemplate(dataSource);
   jt.execute("create table mytable (id integer, name varchar(100))");
  }
  public void setDataSource(DataSource dataSource) {
   this.dataSource = dataSource;
  }
 }

11.2.5. 執行查詢語句
import javax.sql.DataSource;
import org.springframework.jdbc.core.JdbcTemplate;
 public class RunAQuery {
   private JdbcTemplate jt;
   private DataSource dataSource;
   public int getCount() {
  jt = new JdbcTemplate(dataSource);
  int count = jt.queryForInt("select count(*) from mytable");
  return count;
  }
 
 public String getName() {
   jt = new JdbcTemplate(dataSource);
   String name = (String) jt.queryForObject("select name from mytable", String.class);
   （注：如果更新語句就書寫jt.update("update mytable set name = ? where id = ?", new Object[] {name, new Integer(id)});）
   return name;
  }①

        public List getList() {
   jt = new JdbcTemplate(dataSource);
   List rows = jt.queryForList("select * from mytable");
   return rows;
 }②   （①②取其一）
 
 public void setDataSource(DataSource dataSource) {
  this.dataSource = dataSource;
  }
}