Spring与数据库的连接

1.配置DataSource

 

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"

  destroy-method="close">

  <!-- results in a setDriverClassName(String) call -->

  <property name="driverClassName">
   <value>com.mysql.jdbc.Driver</value>
  </property>
  <property name="url">
   <value>jdbc:mysql://localhost:3306/spring</value>
  </property>
  <property name="username">
   <value>root</value>
  </property>
  <property name="password">
   <value>root</value>
  </property>

UserDaoImpl.java

 

private DataSource dataSource;

 public DataSource getDataSource() {

  return dataSource;
 }
 @Resource
 public void setDataSource(DataSource dataSource) {
  this.dataSource = dataSource;
 }

 @Override

 public void save(User u) {
  try {
   Connection conn = dataSource.getConnection();
   conn.createStatement().execute("insert into user values(null,'zhangsan')");
   conn.close();
   
   
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  
  System.out.println("user save");
 }