BFWSOA多种数据库的连接方式
BFWSOA框架中Model层主要负责对数据库进行持久化,每个model层可以单独连接一个数据库或一张表,相互独立,支持分布式事务处理,读写分离设置
下面我们来演示一下常用的model层连接方式
1、mysql连接方式
$_config_arr['Db']['logicconfig'] = [
"dbtype" => "DbMysql",
"dbport" => 3306,
"dbuser" => "root",
"dbpwd" => "root",
"dbname"=>"bfwdbname",
"dbhost"=>"127.0.0.1"
];
2、sqllite;连接方式
$_config_arr['Db']['sqlconfig'] = [
"dbtype" => "DbSqlite",
"dbuser" => "root",
"dbpwd" => "root",
"dbname" => "bfwdbname",
"dbhost" => DATA_DIR,
"createsql" => "CREATE TABLE IF NOT EXISTS bfw_test (
id INTEGER PRIMARY KEY,
username TEXT,
userpwd TEXT,
token TEXT,
regtime TEXT)"
];
3、mssql连接方式
$_config_arr['Db']['mssqlconfig'] = [
"dbtype" => "DbMssql",
"dbport" => 1433,
"dbuser" => "root",
"dbpwd" => "test",
"dbname" => "dbname",
"dbhost" => "127.0.0.1"
];点击查看剩余70%
网友评论0