1、包结构:
2、源代码:
Book.java
package domain;
public class Book {
private long id;
private String name;
private double price;
public Book(){
}
public Book(String name,double price){
this.name=name;
this.price=price;
}
public Book(long id,String name,double price){
this(name,price);
this.id=id;
}
public long getId() {
return id;
}
public void setId(long id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public double getPrice() {
return price;
}
public void setPrice(double price) {
this.price = price;
}
public String toString(){
return "id:"+id+"-name:"+name+"-price:"+price;
}
}
BookDao.java
package dao;
import java.util.List;
import domain.Book;
public interface BookDao {
void save(Book b);
void update(Book b);
void delete(long id);
Book findById(long id);
List<Book> findByPrice(double from,double to);
}
BookDaoImpl.java
package dao.jdbc;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.ResultSetExtractor;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.support.JdbcDaoSupport;
import dao.BookDao;
import domain.Book;
public class BookDaoImpl extends JdbcDaoSupport implements BookDao {
public void delete(long id) {
String sql="delete from book where id = ?";
this.getJdbcTemplate().update(sql, new Object[]{id});
}
public Book findById(long id) {
String sql = "select * from book where id =?";
ResultSetExtractor rse = null;
rse = new ResultSetExtractor() {
public Object extractData(ResultSet rs) throws SQLException,
DataAccessException {
if (rs.next()) {
return new Book(rs.getLong(1), rs.getString(2), rs
.getDouble(3));
} else {
return null;
}
}
};
return (Book) this.getJdbcTemplate().query(sql, new Object[] { id },
rse);
}
public List findByPrice(double from, double to) {
String sql="select * from book where price between ? and ?";
return this.getJdbcTemplate().query(sql, new Object[]{from,to},new RowMapper(){
public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
return new Book(rs.getLong(1),rs.getString(2),rs.getDouble(3));
}
});
}
public void save(Book b) {
String sql = "insert into book(id,name,price) values(?,?,?) ";
this.getJdbcTemplate().update(sql,
new Object[] { b.getId(), b.getName(), b.getPrice() });
}
public void update(Book b) {
String sql="update book set name = ? , price = ? where id = ?";
this.getJdbcTemplate().update(sql,new Object[]{b.getName(),b.getPrice(),b.getId()});
}
}
applicationContext_jdbc.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"
xmlns:p="http://www.springframework.org/schema/p"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>
<property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:myorcl"></property>
<property name="username" value="myorcl"></property>
<property name="password" value="embed"></property>
</bean>
<bean id="bookDao" class="dao.jdbc.BookDaoImpl">
<property name="dataSource" ref="dataSource"></property>
</bean>
</beans>
BookDaoTest.java
package test;
import java.util.List;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import dao.BookDao;
import domain.Book;
public class BookDaoTest {
public static void main(String[]args){
ApplicationContext ac=new ClassPathXmlApplicationContext("applicationContext_jdbc.xml");
BookDao dao=(BookDao)ac.getBean("bookDao");
dao.save(new Book(10,"三个火枪手",44.9));
List<Book> books=dao.findByPrice(30, 60);
for(Book book:books){
System.out.println(book);
}
}
}
- 大小: 9.9 KB
分享到:
相关推荐
Spring mvc、 Spring、 Spring jdbc 整合实例源码
Spring+JDBC实例 ,参考博客:http://blog.csdn.net/Peng_Hong_fu/article/details/53366989
springMvc-spring+jdbc实例
Spring mvc + Spring + Spring jdbc 整合实例源码
spring jdbc 实例源码 用的是epet宠物做的项目,完整项目,数据库都是完好!适合你的学习!
spring-jdbcTemplate实例工程
使用spring jdbc template简化jdbc数据库操作实例代码,简化操作,包括详细测试例子。
Spring JDBC应用实例讲解 ,具体效果和过程看博文 http://blog.csdn.net/evankaka/article/details/45477185
spring的经典实例 spring事物配置 spring Aop 数据库mysql+jdbc····
关于spring JDbc 的一个实例希望有所帮助 谢谢大家
Spring + jdbc连接 例子,入门级别,很有用的 ,新手可看
实例详解Spring JDBC事务管理.doc 实例详解Spring JDBC事务管理.doc
Spring spring mvc MVC jdbc JDBC 例子 项目 springMVC+jdbc完全事例,不含其他框架。 增删改差齐全,数据库oracle。表结构等没有上传,根据bean自己写很简单的
主要介绍了spring对JDBC和orm的支持实例详解,需要的朋友可以参考下
16 <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> 17 18 19 --> 20 21 <!-- 22 23 24 25 --> 26 27 它配置了以下功能(不过,已经注释掉了): ...
Struts2+Spring2.5+jdbc+Ext+json实例用到的lib包。
一个简单的spring+springjdbc的登陆模块
使用Spring的JdbcTemplate和BeanPropertyRowMapper完成的JDBC我的实例 博文链接:https://zmx.iteye.com/blog/373454
spring jdbc java mysql实例