User.java實體類：

package com.liu.jdbc.update;public class User {private Integer id;private String username;private String password;public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getUsername() {return username;}public void setUsername(String username) {this.username = username;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}@Overridepublic String toString() {return "User [id=" + id + ", username=" + username + ", password=" + password + "]";}}

UserDao.java接口：

package com.liu.jdbc.update;import java.util.List;public interface UserDao {//根據id查詢數據public User selectById(int id);//查詢所有數據public List<User> selectAll();}

UserDaoImpl.java實現類：

package com.liu.jdbc.update;import java.util.List;import org.springframework.jdbc.core.BeanPropertyRowMapper; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowMapper;public class UserDaoImpl implements UserDao {//聲明JdbcTemplate屬性及其setter方法private JdbcTemplate jdbcTemplate;public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {this.jdbcTemplate = jdbcTemplate;}//根據id查詢數據@Overridepublic User selectById(int id) {// TODO Auto-generated method stub//定于SQL語句String sql = "select * from user where id = ?";//創建一個新的BeanPropertyRowMapper對象RowMapper<User> rowMapper = new BeanPropertyRowMapper<User>(User.class);//將id綁定到SQL語句中，通過rowMapper返回一個Object類型的單行記錄User user = this.jdbcTemplate.queryForObject(sql, rowMapper, 1);return user;}//查詢所有數據@Overridepublic List<User> selectAll() {// TODO Auto-generated method stub//定義SQL語句String sql = "select * from user";//創建一個新的BeanPropertyRowMapper對象RowMapper<User> rowMapper = new BeanPropertyRowMapper<User>(User.class);//通過rowMapper返回結果List<User> list = this.jdbcTemplate.query(sql, rowMapper);return list;}}

ApplicationContext.xml配置文件：

<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-4.3.xsd"><!-- 配置數據源 --><bean id = "dataSource" class = "org.springframework.jdbc.datasource.DriverManagerDataSource"><!-- 數據庫驅動 --><property name="driverClassName" value = "com.mysql.jdbc.Driver"></property><!-- 數據庫url --><property name="url" value = "jdbc:mysql://localhost:3306/test"></property><!-- 數據庫用戶名 --><property name="username" value = "root"></property><!-- 數據庫密碼 --><property name="password" value = "root"></property></bean><!-- 配置jdbc模板類 --><bean id = "jdbcTemplate" class = "org.springframework.jdbc.core.JdbcTemplate"><!-- 默認必須使用數據源 --><property name="dataSource" ref = "dataSource"></property></bean><!-- 定義ID為userDdao的bean --><bean id = "userDao" class = "com.liu.jdbc.update.UserDaoImpl"><property name="jdbcTemplate" ref ="jdbcTemplate"></property></bean></beans>

Test.java測試類：

package com.liu.jdbc.update;import java.util.List;import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext;public class Test {public static void main(String args[]) {Test test = new Test();test.selectById();//test.selectAll();}//通過id查詢public void selectById() {String xmlpath = "com/liu/jdbc/update/ApplicationContext.xml";ApplicationContext applicationContext = new ClassPathXmlApplicationContext(xmlpath);UserDao userDao = (UserDao) applicationContext.getBean("userDao");User user = userDao.selectById(1);System.out.println(user);}//查詢全部數據public void selectAll() {String xmlpath = "com/liu/jdbc/update/ApplicationContext.xml";ApplicationContext applicationContext = new ClassPathXmlApplicationContext(xmlpath);UserDao userDao = (UserDao) applicationContext.getBean("userDao");List<User> list = userDao.selectAll();for(User li : list) {System.out.println(li);}} }

總結

以上是生活随笔為你收集整理的JdbcTemplate中的query方法(代码)的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。