public class DbConnectionImpl extends Object implements DbConnection
Constructor and Description |
---|
DbConnectionImpl(Connection con,
com.mysema.query.sql.SQLTemplates dialect,
org.ofbiz.core.entity.DelegatorInterface genericDelegator) |
Modifier and Type | Method and Description |
---|---|
void |
commit() |
com.mysema.query.sql.dml.SQLDeleteClause |
delete(com.mysema.query.sql.RelationalPath<?> entity)
Starts an delete statement on the given DB Table.
|
Connection |
getJdbcConnection()
Returns the JDBC connection wrapped by this object.
|
IdGeneratingSQLInsertClause |
insert(JiraRelationalPathBase<?> entity)
Starts an insert statement on the given DB Table.
|
com.mysema.query.sql.SQLQuery |
newSqlQuery()
Starts a SELECT statement on this connection.
|
void |
rollback() |
void |
setAutoCommit(boolean autoCommit) |
com.mysema.query.sql.dml.SQLUpdateClause |
update(com.mysema.query.sql.RelationalPath<?> entity)
Starts an update statement on the given DB Table.
|
public DbConnectionImpl(Connection con, com.mysema.query.sql.SQLTemplates dialect, org.ofbiz.core.entity.DelegatorInterface genericDelegator)
public Connection getJdbcConnection()
DbConnection
getJdbcConnection
in interface DbConnection
public com.mysema.query.sql.SQLQuery newSqlQuery()
DbConnection
Example usage:
QVersion v = new QVersion("v"); final Listversions = dbConnection.newSqlQuery() .from(v) .where(v.project.eq(projectId)) .orderBy(v.sequence.asc()) .list(v);
newSqlQuery
in interface DbConnection
public com.mysema.query.sql.dml.SQLUpdateClause update(com.mysema.query.sql.RelationalPath<?> entity)
DbConnection
Example usage:
dbConnection.update(QIssueLink.ISSUE_LINK) .set(QIssueLink.ISSUE_LINK.linktype, newIssueLinkTypeId) .where(QIssueLink.ISSUE_LINK.id.eq(issueLink.getId())) .execute();
update
in interface DbConnection
entity
- The DB entity you want to update eg QIssue.ISSUE
public IdGeneratingSQLInsertClause insert(JiraRelationalPathBase<?> entity)
DbConnection
Example 1 usage:
dbConnection.insert(QIssueLink.ISSUE_LINK) .set(QIssueLink.ISSUE_LINK.linktype, newIssueLinkTypeId) .set(QIssueLink.ISSUE_LINK.sequence, sequence) .execute();
Example 2 usage:
dbConnection.insert(QIssueLink.ISSUE_LINK) .populate(issueLinkDTO) .execute();
insert
in interface DbConnection
entity
- The DB entity you want to insert into eg QIssue.ISSUE
public com.mysema.query.sql.dml.SQLDeleteClause delete(com.mysema.query.sql.RelationalPath<?> entity)
DbConnection
Example usage:
dbConnection.delete(QIssueLink.ISSUE_LINK) .where(QIssueLink.ISSUE_LINK.id.eq(issueLink.getId())) .execute();
delete
in interface DbConnection
entity
- The DB entity you want to delete from eg QIssue.ISSUE
public void setAutoCommit(boolean autoCommit)
setAutoCommit
in interface DbConnection
public void commit()
commit
in interface DbConnection
public void rollback()
rollback
in interface DbConnection
Copyright © 2002-2015 Atlassian. All Rights Reserved.