rdiframework.net━9.14 Database connection Management ━web section

Rdiframework.net━. NET rapid Information System development framework

9.14 Database connection Management-web section　

　　We can often see a lot of software directly put the database connection string in the software execution directory in the configuration file, which directly put the database connection string (whether encrypted or not) on the client is very insecure. In our framework, we can hook up countless different types of databases, by unifying these connection strings through special processing to the database, the front-end developers only need to call the appropriate database access interface, change the database server address, etc. are very convenient, the database connection management main interface as shown. All database connections are determined uniformly through the connection name.

　　In the database connection management main interface, we can add a new database connection to meet our business needs, if the database changes, we can also modify the existing connection definition, the unused connection can also be deleted.

9.14.1, New database connection

Add a new database connection as shown, the database "connection type" can be set in the data dictionary by default to SQL Server, and the modification and delete operations are similar to others.

9.14.2, modifying database connections

　　The most important benefit of database connection management is that all the databases required by the business system can be managed and defined here, and then the interface calls provided by the framework are applied, and the unified management of the database connection of the business system is achieved. If the database name changes,IP address changes, and so on, the business code does not need to make any changes. As long as the connection name defined in database connection management is not changed. For existing database connections, if there are any changes, you can modify them. Modify the Reiki Library connection interface as follows:

9.14.3, deleting a database connection

　　For database connections that are no longer in use, you can delete them.

Related articles:

Rdiframework.net-based on. NET rapid Information System development Framework-Series catalogue

rdiframework.net━9.14 Database connection Management ━web section