Posted on 2005-12-30 19:52
morcble的blog 閱讀(241)
評(píng)論(0) 編輯 收藏 所屬分類(lèi):
Spring
11.2. Using the JDBC Core classes to control basic JDBC
processing and error handling
11.2.1.
創(chuàng)建數(shù)據(jù)源（數(shù)據(jù)源里隱藏了數(shù)據(jù)連接池）
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 簡(jiǎn)單的調(diào)用配置好了的JdbcTemplate就可以執(zhí)行SQL語(yǔ)句 如下
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. 執(zhí)行查詢(xún)語(yǔ)句
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);
（注：如果更新語(yǔ)句就書(shū)寫(xiě)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;
}
}