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

配置文件信息： com.mysql.jdbc.Driver jdbc:mysql:/localhost:3306/test root root 代码如下：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 List 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.jdbc.core.RowMapper;import com.shuju.dao.UserDao;import com.shuju.entity.User;public class UserDaoImpl implements UserDaoprivate JdbcTemplate jdbcTemplate;public void setJdbcTemplate(JdbcTemplate jdbcTemplate) this.jdbcTemplate = jdbcTemplate;public int add(User user) String sql=insert into user values(?,?);String arg =user.getId()+,user.getName();int i=jdbcTemplate.update(sql, arg);return i;public int delete(User user) String sql=delete user from user where id=?;String arg =user.getId()+;int i=jdbcTemplate.update(sql, arg);return i;public User findById(User user) final User user1=new User();String sql=select * from user where id=?;String arg =user.getId()+;jdbcTemplate.query(sql, arg, new RowCallbackHandler()public void processRow(ResultSet rs) throws SQLException if(!rs.isAfterLast()user1.setId(rs.getInt(id);user1.setName(rs.getString(name););return user1;public List findAll() List list=new ArrayList();String sql=select * from user;list=jdbcTemplate.query(sql, new RowMapper()public Object mapRow(ResultSet rs, int i) throws SQLException User user2=new User();user2.setId(rs.getInt(id);user2.setName(rs.getString(name);return user2;);for(int i=0;ilist.size();i+)User u1=list.get(i);System.out.println(u1.getId();System.out.println(u1.getName();return list;public int update(User user) String sql=update user set name=? where id=?;String arg =user.getName(),user.getId()+;int i=jdbcTemplate.update(sql, arg);return i;public static void main(String args) ApplicationContex ac=new ClassPathXmlApplicationContext(App