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

清疚 2022-06-15 05:15 152阅读 0赞

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

jdbc.driverClassName=com.mysql.jdbc.Driver
    jdbc.url=jdbc\:mysql\://localhost\:3306/spring
    jdbc.username=root
    jdbc.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;
    	}
    
    	@Override
    	public 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();
    		}
    	}
    
    }