各种sql技术的优缺点

<p>从Manning.Ibatis.In.Action转载：</p>

<p>1，从Stored procedures继承来的优势：iBATIS encapsulates and externalizes SQL such that it is outside of your application code. It describes an API similar to that of a stored procedure,but the iBATIS API is object oriented.iBATIS also fully supports calling stored procedures directly.</p>
<p> 可以解决的问题：Business logic is kept out of the database, and the application is easier to deploy and test, and is more portable.</p>
<p>2，从Inline SQL 继承来的优势： iBATIS allows SQL to be written the way it was intended to be written.There’s no string concatenation, “setting” of parameters, or “getting” of results.<br>可以解决的问题：iBATIS doesn’t impose on your application code. No precompiler is needed, and you have full access to all of the features of SQL—not a subset.</p>

<p>3，从Dynamic SQL iBATIS继承的优势：building queries based on parameters. No “query builder” APIs are required.<br>可以解决的问题：iBATIS doesn’t force SQL to be written in blocks of concatenated strings interlaced with application code.</p>
<p>4，从Object/relational mapping继承的优势：iBATIS supports many of the same features as an O/RM tool, such as lazy loading, join fetching, caching, runtime code generation, and inheritance。可以解决的问题：iBATIS will work with any combination of data model and object model. There are nearly no restrictions or rules to how either is designed.</p>

<p>靠，美国人也爱吹牛啊。不过这个总结倒是不错，至少可以从侧面对各种sql处理技术的优缺点有个大致的了解。</p>