struts框架下JDBC数据源实现增删改查.docVIP

配置文件信息： ?xml version=1.0 encoding=UTF-8? beans xmlns=/schema/beans xmlns:xsi=/2001/XMLSchema-instance xsi:schemaLocation=/schema/beans /schema/beans/spring-beans-3.0.xsd bean id=dataSource class=mons.dbcp.BasicDataSource property name=driverClassName valuecom.mysql.jdbc.Driver/value /property property name=url valuejdbc:mysql://localhost:3306/test/value /property property name=username valueroot/value /property property name=password valueroot/value /property /bean bean id=jdbcTemplate class=org.springframework.jdbc.core.JdbcTemplate property name=dataSource ref local=dataSource/ /property /bean bean id=user class=com.shuju.entity.User/bean bean id=userdao2 class=com.shuju.dao.impl.UserDaoImpl property name=jdbcTemplate ref bean=jdbcTemplate/ /property /bean /beans 代码如下： package com.shuju.entity; public class User { private int id; private String name; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { = name; } } package com.shuju.dao; import java.util.List; import com.shuju.entity.User; public interface UserDao { public int add(User user); public int delete(User user); public int update(User user); public User findById(User user); public ListUser findAll(); } package com.shuju.dao.impl; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowCallbackHandler; import org.springframework.