package com.liuliu.test.db;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.simple.SimpleJdbcTemplate;
import oracle.jdbc.pool.OracleDataSource;
public class OracleTest {
/**
* @param args
* @throws SQLException
*/
public static void main(String[] args) throws SQLException {
// TODO Auto-generated method stub
OracleDataSource ds = new OracleDataSource();
ds.setDriverType("thin");
ds.setServerName("11111111");
ds.setPortNumber(1521);
ds.setDatabaseName("1111111111");
ds.setUser("1111111111");
ds.setPassword("11111111111");
SimpleJdbcTemplate simpleJdbcTemplate = new SimpleJdbcTemplate(ds);
String sql = "select tb from tbool";
RowMapper<Tbool> rm = new RowMapper<Tbool>() {
public Tbool mapRow(ResultSet rs, int i) throws SQLException {
Tbool tb = new Tbool();
tb.setTb(rs.getBoolean("tb"));
return tb;
}
};
List<Tbool> result = simpleJdbcTemplate.query(sql, rm);
for (Tbool tb : result) {
System.out.println(tb.isTb());
}
List<Tbool> result2 = simpleJdbcTemplate.query(sql,
new BeanPropertyRowMapper<Tbool>(Tbool.class));
for (Tbool tb : result2) {
System.out.println(tb.isTb());
}
sql = "update TBOOL set tb = :tb";
simpleJdbcTemplate.update(sql, true);
}
}
OracleDataSource java spring jdbctemplate demo
最新推荐文章于 2021-11-17 00:12:37 发布