sql-connectionStrings

<connectionStrings>
  <add name="ClassReservatConnectionString" connectionString="server=localhost;user id=root;password=123456;database=classreservat;" providerName="System.Data.SqlClient" />
</connectionStrings>

   dbhelper

  "Dbs": {
    //"DbType": "Oracle",
    //"Connection": "Data Source=192.168.1.10/orcl;User ID=c##v3_base;Password=c##v3_base"
    "DbType": "MySql",
    "Connection": "server=www.wskxy.xyz;port=3306;user=hdf;password=123;database=hoteldb;"
    //"DbType": "SqlServer",
    //"Connection": "server =148.70.176.58;uid=kxy;pwd=Aa1234567;database=dbHelper"
  }

分页:

  Oracle:rownum

  Mysql:limit

  SqlServer:top

posted @ 2018-06-20 22:09  wskxy  阅读(126)  评论(0编辑  收藏  举报