Spring数据访问策略_使用JdbcTemplate

最新推荐文章于 2025-07-21 21:49:34 发布

最新推荐文章于 2025-07-21 21:49:34 发布 · 66 阅读

文章标签：

本文介绍了一个使用Spring框架的JdbcTemplate进行数据库操作的具体示例。包括配置文件定义DataSource及JdbcTemplate，通过UserDao接口实现查询所有用户的功能，并展示了如何在demo类中调用这些组件来获取并打印用户列表。

Spring数据访问策略_使用JdbcTemplate

2007年12月12日星期三 15:37

-------------------------------------------------------------------------------------------
Spring数据访问策略_使用JdbcTemplate
-------------------------------------------------------------------------------------------
五个文件
config.xml
User.java
UserDao.java
JdbcTemplateUserDao.java
demo.java
-------------------------------------------------------------------------------------------
config.xml
-------------------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">

</beans>

-------------------------------------------------------------------------------------------
User.java
-------------------------------------------------------------------------------------------
package dao;
public class User
{
private String name;
private String department;
public String getDepartment()
{
return department;
}
public void setDepartment(String department)
{
this.department = department;
}
public String getName()
{
return name;
}
public void setName(String name)
{
this.name = name;
}
}

-------------------------------------------------------------------------------------------
UserDao.java

-------------------------------------------------------------------------------------------
package dao;
import java.util.List;
public interface UserDao
{
List<User> queryAll();
}

-------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------
JdbcTemplateUserDao.java

-------------------------------------------------------------------------------------------
package dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.support.JdbcDaoSupport;
public class JdbcTemplateUserDao extends JdbcDaoSupport implements UserDao
{
class UserRowMapper implements RowMapper
{
public Object mapRow(ResultSet rs, int rowNum) throws SQLException
{
User user = new User();
user.setDepartment(rs.getString("department"));
user.setName(rs.getString("name"));
return user;
}
}
public List<User> queryAll()
{
return getJdbcTemplate().query("select * from User",
new UserRowMapper());
}
}

-------------------------------------------------------------------------------------------
demo.java
-------------------------------------------------------------------------------------------
import java.util.Iterator;
import java.util.List;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import dao.User;
import dao.UserDao;
public class demo
{
public static void main(String[] args)
{
ApplicationContext context = new ClassPathXmlApplicationContext(
"config.xml");
UserDao userDao = (UserDao) context.getBean("jdbcTemplateUserDao");
List list = userDao.queryAll();
Iterator iter = list.iterator();
while (iter.hasNext())
{
User user = (User) iter.next();
System.out.println(user.getName());
}
System.out.println("===END===");
}
}