wonderer's program

   1: package dataSourceDemo;

   2:  

   3: public interface IUserDAO {

   4:     public void insert(User user);

   5:     public User find(Integer id);

   6:  

   7: }

   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: }

   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>

   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(

  14:                 "dataSourceDemo/dataSource-config.xml");

  15:     }

  16:  

  17:     public void testInsert() {

  18:         User user = new User();

  19:         user.setName("老丘");

  20:         user.setAge(new Integer(21));

  21:         

  22:         IUserDAO userDAO = (IUserDAO) context.getBean("userDAO");

  23:         userDAO.insert(user);

  24:     }

  25:     

  26: }