Spring DAO入门

Tony_Qiu

浏览: 61951 次
性别:
来自: 广州

最近访客更多访客>>

关于夏洛克福尔摩斯

小小酥ol

caoxin_03

skying苏

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

Java

DAO Spring Bean MySQL SQL

写了个Spring的DAO入门例子。

DAO的接口

   1: package dataSourceDemo;

2:

   3: public interface IUserDAO {

   4:     public void insert(User user);

   5:     public User find(Integer id);

6:

   7: }

DAO的实现，必须要有一个setDataSource()的方法，这样才能出入DataSource。

   1: package dataSourceDemo;

2:

   3: import java.sql.*;

4:

   5: import javax.sql.DataSource;

6:

   7: public class UserDAO implements IUserDAO {

8:

   9:     private DataSource dataSource;

10:

  11:     public User find(Integer id) {

  12:         // TODO 自动生成方法存根

  13:         return null;

  14:     }

15:

  16:     public void insert(User user) {

  17:         // TODO 自动生成方法存根

  18:         String name = user.getName();

  19:         int age = user.getAge().intValue();

20:

  21:         Connection conn = null;

  22:         Statement stmt =null;

23:

  24:         try {

  25:             conn = dataSource.getConnection();

  26:             stmt = conn.createStatement();

  27:             String sql = "insert into user (name, age)"+"values('"+name+"',"+age+")";

  28:             stmt.execute(sql);

  29:         }catch(Exception e) {

  30:             e.printStackTrace();

  31:         } finally {

  32:             if(stmt != null) {

  33:                 try {

  34:                 stmt.close();

  35:                 }catch(Exception e) {

  36:                     e.printStackTrace();

  37:                 }

  38:             }

  39:             if(conn != null) {

  40:                 try {

  41:                     conn.close();

  42:                 } catch(Exception e) {

  43:                     e.printStackTrace();

  44:                 }

  45:             }

  46:         }

  47:     }

48:

  49:     public DataSource getDataSource() {

  50:         return dataSource;

  51:     }

52:

  53:     public void setDataSource(DataSource dataSource) {

  54:         this.dataSource = dataSource;

  55:     }

56:

  57: }

USER BEAN

   1: package dataSourceDemo;

2:

   3: public class User {

   4:     private Integer id;

   5:     private String name;

   6:     private Integer age;

   7:     public Integer getAge() {

   8:         return age;

   9:     }

  10:     public void setAge(Integer age) {

  11:         this.age = age;

  12:     }

  13:     public Integer getId() {

  14:         return id;

  15:     }

  16:     public void setId(Integer id) {

  17:         this.id = id;

  18:     }

  19:     public String getName() {

  20:         return name;

  21:     }

  22:     public void setName(String name) {

  23:         this.name = name;

  24:     }

25:

26:

  27: }

配置文件，可以很容易的改变dataSource的属性，就可以轻易改变数据库的配置：

   1: <?xml version="1.0" encoding="UTF-8"?>

   2: <!DOCTYPE beans PUBLIC "-//SPRING/DTD BEAN/EN" "../resources/spring-beans-2.0.dtd" >

   3: <beans>

   4:     <bean id="dataSource"

   5:         class="org.springframework.jdbc.datasource.DriverManagerDataSource">

   6:         <property name="driverClassName">

   7:             <value>com.mysql.jdbc.Driver</value>

   8:         </property>

   9:         <property name="url">

  10:             <value>jdbc:mysql://localhost:3306/test</value>

  11:         </property>

  12:         <property name="username">

  13:             <value>root</value>

  14:         </property>

  15:         <property name="password">

  16:             <value>123</value>

  17:         </property>

  18:     </bean>

19:

  20:     <bean id="userDAO" class="dataSourceDemo.UserDAO">

  21:         <property name="dataSource" ref="dataSource"></property>

  22:     </bean>

  23: </beans>

JUNIT测试类

   1: package dataSourceDemo;

2:

   3: import org.springframework.context.ApplicationContext;

   4: import org.springframework.context.support.ClassPathXmlApplicationContext;

5:

   6: import junit.framework.TestCase;

7:

   8: public class DataSourceTest extends TestCase {

9:

  10:     private ApplicationContext context;

11:

  12:     public void setUp() {

  13:         context = new ClassPathXmlApplicationContext(

padding-right: 0px; padding-left: 0px; font-size: 8pt; padding-bottom: 0px; margin: 0em; overflow: visible; width: 100%; color: b

  


  
    
    分享到：
      
      
    
  

  
    
      html中TD标签的一个小问题
      |
      JUnit+Spring入门
    
  
  
    
      2007-07-18 14:04
      浏览 797
      评论(0)
      
      
            
      查看更多
        
  
    
  
    评论
    
    
    
    
  

  
    发表评论
               您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论

Spring DAO入门

评论

发表评论

相关推荐

最近访客 更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论

Spring DAO入门

评论

发表评论

相关推荐

基于Spring Security的动态加载节点树的粗图

翻译：Derby 开始之旅

翻译：Exceclsior JET for windows

JUnit+Spring入门

JSP中request.getParameter()乱码问题

Buffola的编码问题

转：什么是IOC

JEE上传文件的IO流

Java中的全角和半角

《Java学习笔记》--对象容器之ArrayList和LinkedList

最近访客更多访客>>