Author: cbegin
Date: Sat Mar 28 21:34:19 2009
New Revision: 759597
URL: http://svn.apache.org/viewvc?rev=759597&view=rev
Log:
refactored sql source
Added:
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/mapping/BoundSql.java
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/parser/DynamicSqlSource.java
Removed:
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/mapping/BasicSqlSource.java
Modified:
ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/main/java/com/ibatis/sqlmap/engine/builder/DynamicSqlSource.java
ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/main/java/com/ibatis/sqlmap/engine/builder/SimpleSqlSource.java
ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/main/java/com/ibatis/sqlmap/engine/builder/XmlSqlStatementParser.java
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/mapping/MappedStatement.java
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/mapping/SqlSource.java
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/parser/ProviderSqlSource.java
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/parser/StaticSqlSource.java
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/test/java/org/apache/ibatis/executor/ExecutorTestHelper.java
Modified:
ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/main/java/com/ibatis/sqlmap/engine/builder/DynamicSqlSource.java
URL:
http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/main/java/com/ibatis/sqlmap/engine/builder/DynamicSqlSource.java?rev=759597&r1=759596&r2=759597&view=diff
==============================================================================
---
ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/main/java/com/ibatis/sqlmap/engine/builder/DynamicSqlSource.java
(original)
+++
ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/main/java/com/ibatis/sqlmap/engine/builder/DynamicSqlSource.java
Sat Mar 28 21:34:19 2009
@@ -6,6 +6,7 @@
import org.apache.ibatis.mapping.Configuration;
import org.apache.ibatis.mapping.ParameterMapping;
import org.apache.ibatis.mapping.SqlSource;
+import org.apache.ibatis.mapping.BoundSql;
import org.apache.ibatis.xml.NodeletContext;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;
@@ -25,13 +26,17 @@
this.mapParser = mapParser;
}
- public List<ParameterMapping> getParameterMappings(Object parameterObject) {
+ public BoundSql getBoundSql(Object parameterObject) {
+ return new
BoundSql(getSql(parameterObject),getParameterMappings(parameterObject));
+ }
+
+ private List<ParameterMapping> getParameterMappings(Object parameterObject) {
DynamicSql dynamic = new DynamicSql(configuration);
parseDynamicTags(context, dynamic, true);
return dynamic.getParameterMappings(parameterObject);
}
- public String getSql(Object parameterObject) {
+ private String getSql(Object parameterObject) {
DynamicSql dynamic = new DynamicSql(configuration);
parseDynamicTags(context, dynamic, true);
return dynamic.getSql(parameterObject);
Modified:
ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/main/java/com/ibatis/sqlmap/engine/builder/SimpleSqlSource.java
URL:
http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/main/java/com/ibatis/sqlmap/engine/builder/SimpleSqlSource.java?rev=759597&r1=759596&r2=759597&view=diff
==============================================================================
---
ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/main/java/com/ibatis/sqlmap/engine/builder/SimpleSqlSource.java
(original)
+++
ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/main/java/com/ibatis/sqlmap/engine/builder/SimpleSqlSource.java
Sat Mar 28 21:34:19 2009
@@ -6,6 +6,7 @@
import org.apache.ibatis.mapping.Configuration;
import org.apache.ibatis.mapping.ParameterMapping;
import org.apache.ibatis.mapping.SqlSource;
+import org.apache.ibatis.mapping.BoundSql;
import org.apache.ibatis.xml.NodeletContext;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;
@@ -29,14 +30,18 @@
this.parseNodes(context);
}
- public String getSql(Object parameterObject) {
+ public BoundSql getBoundSql(Object parameterObject) {
+ return new BoundSql(getSql(parameterObject),
getParameterMappings(parameterObject));
+ }
+
+ private String getSql(Object parameterObject) {
if (SimpleDynamicSql.isSimpleDynamicSql(sql)) {
return new SimpleDynamicSql(sql, parameterMappings,
configuration.getTypeHandlerRegistry()).getSql(parameterObject);
}
return new StaticSql(sql).getSql(parameterObject);
}
- public List<ParameterMapping> getParameterMappings(Object parameterObject) {
+ private List<ParameterMapping> getParameterMappings(Object parameterObject) {
return parameterMappings;
}
Modified:
ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/main/java/com/ibatis/sqlmap/engine/builder/XmlSqlStatementParser.java
URL:
http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/main/java/com/ibatis/sqlmap/engine/builder/XmlSqlStatementParser.java?rev=759597&r1=759596&r2=759597&view=diff
==============================================================================
---
ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/main/java/com/ibatis/sqlmap/engine/builder/XmlSqlStatementParser.java
(original)
+++
ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/main/java/com/ibatis/sqlmap/engine/builder/XmlSqlStatementParser.java
Sat Mar 28 21:34:19 2009
@@ -92,7 +92,7 @@
Class parameterClass = resolveClass(parameterClassName);
List<ParameterMapping> parameterMappings = new
ArrayList<ParameterMapping>();
if (sqlSource instanceof SimpleSqlSource) {
- parameterMappings = sqlSource.getParameterMappings(null);
+ parameterMappings = sqlSource.getBoundSql(null).getParameterMappings();
}
ParameterMap.Builder parameterMapBuilder = new
ParameterMap.Builder(configuration, id + "-ParameterMap", parameterClass,
parameterMappings);
builder.parameterMap(parameterMapBuilder.build());
Added:
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/mapping/BoundSql.java
URL:
http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/mapping/BoundSql.java?rev=759597&view=auto
==============================================================================
---
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/mapping/BoundSql.java
(added)
+++
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/mapping/BoundSql.java
Sat Mar 28 21:34:19 2009
@@ -0,0 +1,23 @@
+package org.apache.ibatis.mapping;
+
+import java.util.List;
+
+public class BoundSql {
+
+ private String sql;
+ private List<ParameterMapping> parameterMappings;
+
+ public BoundSql(String sql, List<ParameterMapping> parameterMappings) {
+ this.sql = sql;
+ this.parameterMappings = parameterMappings;
+ }
+
+ public String getSql() {
+ return sql;
+ }
+
+ public List<ParameterMapping> getParameterMappings() {
+ return parameterMappings;
+ }
+
+}
Modified:
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/mapping/MappedStatement.java
URL:
http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/mapping/MappedStatement.java?rev=759597&r1=759596&r2=759597&view=diff
==============================================================================
---
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/mapping/MappedStatement.java
(original)
+++
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/mapping/MappedStatement.java
Sat Mar 28 21:34:19 2009
@@ -155,11 +155,13 @@
}
public String getSql(Object parameterObject) {
- return sqlSource.getSql(parameterObject);
+ BoundSql boundSql = sqlSource.getBoundSql(parameterObject);
+ return boundSql.getSql();
}
public List<ParameterMapping> getDynamicParameterMappings(Object
parameterObject) {
- List<ParameterMapping> parameterMappings =
sqlSource.getParameterMappings(parameterObject);
+ BoundSql boundSql = sqlSource.getBoundSql(parameterObject);
+ List<ParameterMapping> parameterMappings = boundSql.getParameterMappings();
if (parameterMappings == null || parameterMappings.size() <= 0) {
parameterMappings = parameterMap.getParameterMappings();
}
Modified:
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/mapping/SqlSource.java
URL:
http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/mapping/SqlSource.java?rev=759597&r1=759596&r2=759597&view=diff
==============================================================================
---
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/mapping/SqlSource.java
(original)
+++
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/mapping/SqlSource.java
Sat Mar 28 21:34:19 2009
@@ -1,11 +1,7 @@
package org.apache.ibatis.mapping;
-import java.util.List;
-
public interface SqlSource {
- String getSql(Object parameterObject);
-
- List<ParameterMapping> getParameterMappings(Object parameterObject);
+ BoundSql getBoundSql(Object parameterObject);
}
Added:
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/parser/DynamicSqlSource.java
URL:
http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/parser/DynamicSqlSource.java?rev=759597&view=auto
==============================================================================
---
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/parser/DynamicSqlSource.java
(added)
+++
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/parser/DynamicSqlSource.java
Sat Mar 28 21:34:19 2009
@@ -0,0 +1,14 @@
+package org.apache.ibatis.parser;
+
+import org.apache.ibatis.mapping.SqlSource;
+import org.apache.ibatis.mapping.ParameterMapping;
+import org.apache.ibatis.mapping.BoundSql;
+
+import java.util.List;
+
+public class DynamicSqlSource implements SqlSource {
+
+ public BoundSql getBoundSql(Object parameterObject) {
+ return null;
+ }
+}
Modified:
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/parser/ProviderSqlSource.java
URL:
http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/parser/ProviderSqlSource.java?rev=759597&r1=759596&r2=759597&view=diff
==============================================================================
---
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/parser/ProviderSqlSource.java
(original)
+++
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/parser/ProviderSqlSource.java
Sat Mar 28 21:34:19 2009
@@ -1,8 +1,8 @@
package org.apache.ibatis.parser;
import org.apache.ibatis.mapping.Configuration;
-import org.apache.ibatis.mapping.ParameterMapping;
import org.apache.ibatis.mapping.SqlSource;
+import org.apache.ibatis.mapping.BoundSql;
import java.lang.reflect.Method;
import java.util.List;
@@ -33,14 +33,9 @@
}
}
- public String getSql(Object parameterObject) {
+ public BoundSql getBoundSql(Object parameterObject) {
SqlSource sqlSource = createSqlSource(parameterObject);
- return sqlSource.getSql(parameterObject);
- }
-
- public List<ParameterMapping> getParameterMappings(Object parameterObject) {
- SqlSource sqlSource = createSqlSource(parameterObject);
- return sqlSource.getParameterMappings(parameterObject);
+ return sqlSource.getBoundSql(parameterObject);
}
private SqlSource createSqlSource(Object parameterObject) {
Modified:
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/parser/StaticSqlSource.java
URL:
http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/parser/StaticSqlSource.java?rev=759597&r1=759596&r2=759597&view=diff
==============================================================================
---
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/parser/StaticSqlSource.java
(original)
+++
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/main/java/org/apache/ibatis/parser/StaticSqlSource.java
Sat Mar 28 21:34:19 2009
@@ -2,24 +2,25 @@
import org.apache.ibatis.mapping.ParameterMapping;
import org.apache.ibatis.mapping.SqlSource;
+import org.apache.ibatis.mapping.BoundSql;
import java.util.List;
public class StaticSqlSource implements SqlSource {
- private String sql;
- private List<ParameterMapping> parameterMappings;
- public StaticSqlSource(String sql, List<ParameterMapping> parameterMappings)
{
- this.sql = sql;
- this.parameterMappings = parameterMappings;
+ private BoundSql boundSql;
+
+ public StaticSqlSource(String sql) {
+ this.boundSql = new BoundSql(sql, null);
}
- public String getSql(Object parameterObject) {
- return sql;
+ public StaticSqlSource(String sql, List<ParameterMapping> parameterMappings)
{
+ this.boundSql = new BoundSql(sql, parameterMappings);
}
- public List<ParameterMapping> getParameterMappings(Object parameterObject) {
- return parameterMappings;
+ public BoundSql getBoundSql(Object parameterObject) {
+ return boundSql;
}
+
}
Modified:
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/test/java/org/apache/ibatis/executor/ExecutorTestHelper.java
URL:
http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-core/src/test/java/org/apache/ibatis/executor/ExecutorTestHelper.java?rev=759597&r1=759596&r2=759597&view=diff
==============================================================================
---
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/test/java/org/apache/ibatis/executor/ExecutorTestHelper.java
(original)
+++
ibatis/trunk/java/ibatis-3/ibatis-3-core/src/test/java/org/apache/ibatis/executor/ExecutorTestHelper.java
Sat Mar 28 21:34:19 2009
@@ -10,6 +10,7 @@
import org.apache.ibatis.mapping.*;
import org.apache.ibatis.type.JdbcType;
import org.apache.ibatis.type.TypeHandlerRegistry;
+import org.apache.ibatis.parser.StaticSqlSource;
import java.util.*;
@@ -29,7 +30,7 @@
public static MappedStatement prepareInsertAuthorMappedStatement(final
Configuration config) {
final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
- MappedStatement ms = new MappedStatement.Builder(config, "insertAuthor",
new BasicSqlSource("INSERT INTO author
(id,username,password,email,bio,favourite_section) values(?,?,?,?,?,?)"))
+ MappedStatement ms = new MappedStatement.Builder(config, "insertAuthor",
new StaticSqlSource("INSERT INTO author
(id,username,password,email,bio,favourite_section) values(?,?,?,?,?,?)"))
.parameterMap(
new ParameterMap.Builder(
config, "defaultParameterMap", Author.class,
@@ -49,7 +50,7 @@
public static MappedStatement
prepareInsertAuthorMappedStatementWithAutoKey(final Configuration config) {
final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
- MappedStatement ms = new MappedStatement.Builder(config, "insertAuthor",
new BasicSqlSource("INSERT INTO author
(username,password,email,bio,favourite_section) values(?,?,?,?,?)"))
+ MappedStatement ms = new MappedStatement.Builder(config, "insertAuthor",
new StaticSqlSource("INSERT INTO author
(username,password,email,bio,favourite_section) values(?,?,?,?,?)"))
.parameterMap(
new ParameterMap.Builder(config, "defaultParameterMap",
Author.class, new ArrayList<ParameterMapping>() {
{
@@ -67,7 +68,7 @@
public static MappedStatement prepareInsertAuthorProc(final Configuration
config) {
final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
- MappedStatement ms = new MappedStatement.Builder(config,
"insertAuthorProc", new BasicSqlSource("{call insertAuthor(?,?,?,?)}"))
+ MappedStatement ms = new MappedStatement.Builder(config,
"insertAuthorProc", new StaticSqlSource("{call insertAuthor(?,?,?,?)}"))
.parameterMap(new ParameterMap.Builder(config, "defaultParameterMap",
Author.class,
new ArrayList<ParameterMapping>() {
{
@@ -83,7 +84,7 @@
public static MappedStatement prepareUpdateAuthorMappedStatement(final
Configuration config) {
final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
- MappedStatement ms = new MappedStatement.Builder(config, "updateAuthor",
new BasicSqlSource("UPDATE author SET username = ?, password = ?, email = ?,
bio = ? WHERE id = ?"))
+ MappedStatement ms = new MappedStatement.Builder(config, "updateAuthor",
new StaticSqlSource("UPDATE author SET username = ?, password = ?, email = ?,
bio = ? WHERE id = ?"))
.parameterMap(new ParameterMap.Builder(config, "defaultParameterMap",
Author.class,
new ArrayList<ParameterMapping>() {
{
@@ -100,7 +101,7 @@
public static MappedStatement prepareDeleteAuthorMappedStatement(final
Configuration config) {
final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
- MappedStatement ms = new MappedStatement.Builder(config, "deleteAuthor",
new BasicSqlSource("DELETE FROM author WHERE id = ?"))
+ MappedStatement ms = new MappedStatement.Builder(config, "deleteAuthor",
new StaticSqlSource("DELETE FROM author WHERE id = ?"))
.parameterMap(new ParameterMap.Builder(config, "defaultParameterMap",
Author.class,
new ArrayList<ParameterMapping>() {
{
@@ -127,7 +128,7 @@
}
}).build();
- MappedStatement ms = new MappedStatement.Builder(config, "selectAuthor",
new BasicSqlSource("SELECT * FROM author WHERE id = ?"))
+ MappedStatement ms = new MappedStatement.Builder(config, "selectAuthor",
new StaticSqlSource("SELECT * FROM author WHERE id = ?"))
.parameterMap(new ParameterMap.Builder(config, "defaultParameterMap",
Author.class,
new ArrayList<ParameterMapping>() {
{
@@ -145,7 +146,7 @@
public static MappedStatement
prepareSelectAllAuthorsAutoMappedStatement(final Configuration config) {
final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
- return new MappedStatement.Builder(config, "selectAuthorAutoMap", new
BasicSqlSource("SELECT * FROM author ORDER BY id"))
+ return new MappedStatement.Builder(config, "selectAuthorAutoMap", new
StaticSqlSource("SELECT * FROM author ORDER BY id"))
.resultMaps(new ArrayList<ResultMap>() {
{
add(new ResultMap.Builder(config, "defaultResultMap",
Author.class, new ArrayList() {
@@ -160,7 +161,7 @@
public static MappedStatement
prepareSelectOneAuthorMappedStatementWithConstructorResults(final Configuration
config) {
final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
- MappedStatement ms = new MappedStatement.Builder(config, "selectAuthor",
new BasicSqlSource("SELECT * FROM author WHERE id = ?"))
+ MappedStatement ms = new MappedStatement.Builder(config, "selectAuthor",
new StaticSqlSource("SELECT * FROM author WHERE id = ?"))
.parameterMap(new ParameterMap.Builder(config, "defaultParameterMap",
Author.class,
new ArrayList<ParameterMapping>() {
{
@@ -192,7 +193,7 @@
public static MappedStatement prepareSelectTwoSetsOfAuthorsProc(final
Configuration config) {
final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
- MappedStatement ms = new MappedStatement.Builder(config,
"selectTwoSetsOfAuthors", new BasicSqlSource("{call
selectTwoSetsOfAuthors(?,?)}"))
+ MappedStatement ms = new MappedStatement.Builder(config,
"selectTwoSetsOfAuthors", new StaticSqlSource("{call
selectTwoSetsOfAuthors(?,?)}"))
.statementType(StatementType.CALLABLE)
.parameterMap(new ParameterMap.Builder(
config, "defaultParameterMap", Author.class,
@@ -222,7 +223,7 @@
public static MappedStatement prepareSelectAuthorViaOutParams(final
Configuration config) {
final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
- MappedStatement ms = new MappedStatement.Builder(config,
"selectAuthorViaOutParams", new BasicSqlSource("{call
selectAuthorViaOutParams(?,?,?,?,?)}"))
+ MappedStatement ms = new MappedStatement.Builder(config,
"selectAuthorViaOutParams", new StaticSqlSource("{call
selectAuthorViaOutParams(?,?,?,?,?)}"))
.statementType(StatementType.CALLABLE)
.parameterMap(new ParameterMap.Builder(config, "defaultParameterMap",
Author.class,
new ArrayList<ParameterMapping>() {
@@ -248,7 +249,7 @@
}
}).build();
config.addResultMap(discriminatorResultMap);
- MappedStatement ms = new MappedStatement.Builder(config, "selectProducts",
new BasicSqlSource("SELECT * FROM product"))
+ MappedStatement ms = new MappedStatement.Builder(config, "selectProducts",
new StaticSqlSource("SELECT * FROM product"))
.resultMaps(new ArrayList<ResultMap>() {
{
add(new ResultMap.Builder(config, "defaultResultMap",
HashMap.class, new ArrayList<ResultMapping>() {
@@ -276,7 +277,7 @@
public static MappedStatement
createInsertAuthorWithIDof99MappedStatement(final Configuration config) {
final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
- MappedStatement ms = new MappedStatement.Builder(config, "insertAuthor",
new BasicSqlSource("INSERT INTO author (id,username,password,email,bio)
values(99,'someone','******','[email protected]',null)"))
+ MappedStatement ms = new MappedStatement.Builder(config, "insertAuthor",
new StaticSqlSource("INSERT INTO author (id,username,password,email,bio)
values(99,'someone','******','[email protected]',null)"))
.statementType(StatementType.STATEMENT)
.parameterMap(new ParameterMap.Builder(config, "defaultParameterMap",
Author.class,
new ArrayList<ParameterMapping>()).build())
@@ -287,7 +288,7 @@
public static MappedStatement
createSelectAuthorWithIDof99MappedStatement(final Configuration config) {
final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
- MappedStatement ms = new MappedStatement.Builder(config, "selectAuthor",
new BasicSqlSource("SELECT * FROM author WHERE id = 99"))
+ MappedStatement ms = new MappedStatement.Builder(config, "selectAuthor",
new StaticSqlSource("SELECT * FROM author WHERE id = 99"))
.statementType(StatementType.STATEMENT)
.parameterMap(new ParameterMap.Builder(config, "defaultParameterMap",
Author.class, new ArrayList<ParameterMapping>()).build())
.resultMaps(new ArrayList<ResultMap>() {
@@ -308,7 +309,7 @@
public static MappedStatement prepareComplexSelectBlogMappedStatement(final
Configuration config) {
final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
- final SqlSource sqlSource = new BasicSqlSource("SELECT b.id, b.author_id,
b.title, a.username, a.password, a.email, a.bio" +
+ final SqlSource sqlSource = new StaticSqlSource("SELECT b.id, b.author_id,
b.title, a.username, a.password, a.email, a.bio" +
" FROM blog b" +
" INNER JOIN author a ON b.author_id = a.id" +
" WHERE b.id = ?");
@@ -347,7 +348,7 @@
public static MappedStatement prepareSelectBlogByIdAndAuthor(final
Configuration config) {
final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
- final SqlSource sqlSource = new BasicSqlSource("SELECT b.id, b.author_id,
b.title, a.username, a.password, a.email, a.bio" +
+ final SqlSource sqlSource = new StaticSqlSource("SELECT b.id, b.author_id,
b.title, a.username, a.password, a.email, a.bio" +
" FROM blog b" +
" INNER JOIN author a ON b.author_id = a.id" +
" WHERE b.id = ? and a.id = ?");
@@ -388,7 +389,7 @@
public static MappedStatement prepareSelectPostsForBlogMappedStatement(final
Configuration config) {
final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
- final SqlSource sqlSource = new BasicSqlSource("SELECT p.id, p.created_on,
p.blog_id, p.section, p.subject, p.body, pt.tag_id," +
+ final SqlSource sqlSource = new StaticSqlSource("SELECT p.id,
p.created_on, p.blog_id, p.section, p.subject, p.body, pt.tag_id," +
" t.name as tag_name, c.id as comment_id, c.name as comment_name,
c.comment" +
" FROM post p" +
" INNER JOIN post_tag pt ON pt.post_id = p.id" +
@@ -454,7 +455,7 @@
public static MappedStatement prepareSelectPostMappedStatement(final
Configuration config) {
final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
- final SqlSource sqlSource = new BasicSqlSource("SELECT p.id, p.created_on,
p.blog_id, p.section, p.subject, p.body, pt.tag_id," +
+ final SqlSource sqlSource = new StaticSqlSource("SELECT p.id,
p.created_on, p.blog_id, p.section, p.subject, p.body, pt.tag_id," +
" t.name as tag_name, c.id as comment_id, c.name as comment_name,
c.comment" +
" FROM post p" +
" LEFT OUTER JOIN post_tag pt ON pt.post_id = p.id" +
@@ -523,7 +524,7 @@
public static MappedStatement
prepareSelectPostWithBlogByAuthorMappedStatement(final Configuration config) {
final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
- final SqlSource sqlSource = new BasicSqlSource("SELECT p.id, p.created_on,
p.blog_id, p.author_id, p.section, p.subject, p.body, pt.tag_id," +
+ final SqlSource sqlSource = new StaticSqlSource("SELECT p.id,
p.created_on, p.blog_id, p.author_id, p.section, p.subject, p.body, pt.tag_id,"
+
" t.name as tag_name, c.id as comment_id, c.name as comment_name,
c.comment" +
" FROM post p" +
" LEFT OUTER JOIN post_tag pt ON pt.post_id = p.id" +
