dao package test.dao; import java.util.List; import java.util.Map; import org.springframework.jdbc.core.JdbcTemplate; import test.bean.User; import test.mapper.UserRowMapper; public class UserDao { private JdbcTemplate jdbcTemplate = null; public void setJdbcTemplate(JdbcTemplate jdbcTemplate) { this.jdbcTemplate = jdbcTemplate; } // create table public void createTable() { String sql = "create table test(name varchar(50))"; this.jdbcTemplate.execute(sql); } // update insert delete public void update() { String sql = "update user set name = ? where id = ?"; String name = "张胜鸿"; int id = 100; this.jdbcTemplate.update(sql, new Object[] { name, id }); } // count(*) public void count() { String sql = "select count(1) from user"; int count = this.jdbcTemplate.queryForInt(sql); System.out.println(count); } // select String public void selectByString() { String sql = "select name from user where id = ?"; int id = 100; String name = this.jdbcTemplate.queryForObject(sql, new Object[] { id }, java.lang.String.class); System.out.println(name); } // select object public void selectByObject() { String sql = "select * from user where id = ?"; int id = 100; User user = this.jdbcTemplate.queryForObject(sql, new Object[] { id }, new UserRowMapper()); System.out.println(user.getName()); } // select list public void selectByList() { String sql = "select * from user"; List<User> list = this.jdbcTemplate.query(sql, new UserRowMapper()); for (User user : list) { System.out.println(user.getId() + ";" + user.getName()); } } // select row @SuppressWarnings("unchecked") public void selectByRows() { String sql = "select * from user"; List rows = this.jdbcTemplate.queryForList(sql); for (int i = 0; i < rows.size(); i++) { Map map = (Map) rows.get(i); System.out.println(map.get("name")); } } } mapper package test.mapper; import java.sql.ResultSet; import java.sql.SQLException; import org.springframework.jdbc.core.RowMapper; import test.bean.User; public class UserRowMapper implements RowMapper<User> { public User mapRow(ResultSet rs, int index) throws SQLException { User user = new User(); user.setId(rs.getInt("id")); user.setName(rs.getString("name")); return user; } } javabean package test.bean; 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) { this.name = name; } } test import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import test.dao.UserDao; public class T { public static void main(String[] args) { ApplicationContext context = new ClassPathXmlApplicationContext( "classpath*:applicationContext.xml"); UserDao userDao = (UserDao) context.getBean("userDao"); userDao.selectByObject(); } } spring配置 <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://127.0.0.1:3306/mybatis"/> <property name="username" value="root"/> <property name="password" value="root"/> </bean> <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"> <property name="dataSource" ref="dataSource"/> </bean> <bean id="userDao" class="test.dao.UserDao"> <property name="jdbcTemplate" ref="jdbcTemplate"/> </bean>