【Spring Boot 27，springboot技术架构图

最新推荐文章于 2024-10-14 11:15:56 发布

docker从基础到进阶

最新推荐文章于 2024-10-14 11:15:56 发布

阅读量2.1k

点赞数

分类专栏：程序员文章标签： spring postgresql 后端

本文链接：https://blog.csdn.net/m0_61439907/article/details/120141949

版权

本文介绍了如何在Spring Boot应用中配置PostgreSQL和SQL Server两个数据源，展示了SqlSessionFactoryBean和DataSourceTransactionManager的使用，并通过Mapper接口进行数据库操作。此外，文章强调了在面试中高并发、高可用技术以及基础的重要性，提醒求职者要全面考虑工作机会，而不仅仅是薪资。

摘要由CSDN通过智能技术生成

                rs = stmt.executeQuery(sql);

                return rse.extractData(rs);

            }

            finally {

                JdbcUtils.closeResultSet(rs);

            }

        }

        @Override

        public String getSql() {

            return sql;

        }

    }



    return execute(new QueryStatementCallback());

}



@Override

@Nullable

public <T> T execute(StatementCallback<T> action) throws DataAccessException {

    Assert.notNull(action, "Callback object must not be null");



    Connection con = DataSourceUtils.getConnection(obtainDataSource());

    Statement stmt = null;

    try {

        stmt = con.createStatement();

        applyStatementSettings(stmt);

        T result = action.doInStatement(stmt);

        handleWarnings(stmt);

        return result;

    }

    catch (SQLException ex) {

        // Release Connection early, to avoid potential connection pool deadlock

        // in the case when the exception translator hasn't been initialized yet.

        String sql = getSql(action);

        JdbcUtils.closeStatement(stmt);

        stmt = null;

        DataSourceUtils.releaseConnection(con, getDataSource());

        con = null;

        throw translateException("StatementCallback", sql, ex);

    }

    finally {

        JdbcUtils.closeStatement(stmt);

        DataSourceUtils.releaseConnection(con, getDataSource());

    }

}

...

}


public interface Statement extends Wrapper, AutoCloseable {

    ResultSet executeQuery(String sql) throws SQLException;

    ...

}



public abstract class JdbcAccessor implements InitializingBean {

    @Nullable

    private DataSource dataSource;

    

    public void setDataSource(@Nullable DataSource dataSource) {

        this.dataSource = dataSource;

    }

} 

```



三、更优雅的方式 -> 通过配置类方式实现

---------------------



### 1、application.yml



```

server:

  port: 8080



spring:

  application:

    name: test

  datasource:

    sqlserver:

      jdbc-url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=test

      driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver

      username: sa

      password: sa

    postgres:

      jdbc-url: jdbc:postgresql://127.0.0.1:5432/test

      driverClassName: org.postgresql.Driver

      username: postgres

      password: 123456

```



### 2、配置类



```

package com.guor.config;



import org.apache.ibatis.session.SqlSessionFactory;

import org.mybatis.spring.SqlSessionFactoryBean;

import org.mybatis.spring.SqlSessionTemplate;

import org.mybatis.spring.annotation.MapperScan;

import org.springframework.beans.factory.annotation.Qualifier;

import org.springframework.boot.context.properties.ConfigurationProp