05_Spring2.3_JdbcSupport

JdbcConnection.java（继承jdbcDaosupport）

public class JdbcConnection extends JdbcDaoSupport {

	public void getEmployee() {
		
		String sql = "select * from employee";

		/*Connection conn = this.getConnection();
		PreparedStatement ps;
		try {
			ps = conn.prepareStatement(sql);
			ResultSet rs = ps.executeQuery();
			while (rs.next()) {
				System.out.println(rs.getString("name"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}*/

		List<Map<String, Object>> list = getJdbcTemplate().queryForList(sql);

		for (Map<String, Object> map : list) {
			Set<Entry<String, Object>> entrys = map.entrySet();
			for (Entry<String, Object> entyr : entrys) {
				System.out.println(entyr.getKey() + "\t" + entyr.getValue());
			}
		}
	}

 

applicationContext.xml

<bean id="jdbc" class="cn.lichen.dao.JdbcConnection">
		<property name="dataSource" ref="dataSource"></property>
	</bean>

	<bean id="dataSource"
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
		<property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl" />
		<property name="username" value="jboa" />
		<property name="password" value="bdqn" />
	</bean>

 

lib包：