spring_使用占位符连接数据库_PropertyPlaceholderConfigurer_DataSource配置创建获取

来源：互联网发布：js将对象添加到数组中编辑：程序博客网时间：2024/05/16 17:13

<beanclass="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"><property name="locations" value="classpath:jdbc.properties" /></bean><bean id="myDataSource" destroy-method="close"class="org.apache.commons.dbcp.BasicDataSource"><property name="driverClassName" value="${jdbc.driverClassName}" /><property name="url" value="${jdbc.url}" /><property name="username" value="${jdbc.username}" /><property name="password" value="${jdbc.password}" /></bean>

创建一个jdbc.properties文件里面写入连接属性

jdbc.driverClassName=com.mysql.jdbc.Driverjdbc.url=jdbc\:mysql\://localhost\:3306/springjdbc.username=rootjdbc.password=root

package com.bjsxt.dao.impl;import java.sql.Connection;import java.sql.SQLException;import javax.annotation.Resource;import javax.sql.DataSource;import org.springframework.stereotype.Component;import com.bjsxt.dao.UserDao;import com.bjsxt.model.User;@Component("userDaoImpl")public class UserDaoImpl implements UserDao {private DataSource dataSource;public DataSource getDataSource() {return dataSource;}@Resource(name = "myDataSource")public void setDataSource(DataSource dataSource) {this.dataSource = dataSource;}@Overridepublic void save(User user) {try {Connection cnn = dataSource.getConnection();cnn.createStatement().executeUpdate("insert into user values (null,'zhangsan')");System.out.println("a save");} catch (SQLException e) {e.printStackTrace();}}}

阅读全文

0 0