# development Database Address #jdbcurl = Jdbc:oracle:thin: @localhost: 1521:testsajdbcurl = jdbc:srdbsql://127.0.0.1:1975/ Srdbdb.default.driver=org.srdbsql.driverdb.default.url= Jdbc:srdbsql://127.0.0.1:1975/srdb
Above is the configuration in Project.txt.
Focus:
Db.default.driver=org.srdbsql.driver
In the code:
Druidplugin druidplugin = new Druidplugin (GetProperty ("Jdbcurl"), GetProperty ("user"), GetProperty ("password"), GetProperty ("Db.default.driver"));d ruidplugin.setvalidationquery ("SELECT 1");d Ruidplugin.settestonborrow (True) ;//druidplugin.setfilters ("stat");d Ruidplugin.addfilter (New Statfilter ()); Me.add (Druidplugin); Autotablebindplugin arp = new Autotablebindplugin (Druidplugin, simplenamestyles.up_underline);//Arp.setDialect (new Mysqldialect ()); MySQL dialect configuration arp.setdialect (new ansisqldialect ()); Arp.setcontainerfactory (new Caseinsensitivecontainerfactory ()); Arp.setshowsql (true); Output SQL statement me.add (ARP);
Focus:
Arp.setdialect (New Ansisqldialect ());
Jfinal a data source that connects to a self-service database