com.blade.jdbc.AR Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of blade-jdbc Show documentation

blade aop

There is a newer version: 0.2.2-RELEASE

package com.blade.jdbc;

import java.io.Serializable;

import org.sql2o.Connection;

public final class AR {

	private AR() {
	}
	
	public static ARC executeSQL(String sql) {
		Connection connection = DB.sql2o.beginTransaction();
		ARC brc = new ARC(connection, sql);
		return brc;
	}
	
	public static ARC executeSQL(String sql, Object...args) {
		Connection connection = DB.sql2o.beginTransaction();
		ARC brc = new ARC(connection, sql, args);
		return brc;
	}
	
	public static ARC executeSQL(Connection connection, String sql) {
		ARC brc = new ARC(connection, sql);
		return brc;
	}
	
	public static ARC executeSQL(Connection connection, String sql, Object...args) {
		ARC brc = new ARC(connection, sql, args);
		return brc;
	}
	
	public static ARC find(String sql) {
		return executeSQL(DB.sql2o.open(), sql);
	}
	
	public static ARC find(String sql, Object ... args) {
		return executeSQL(DB.sql2o.open(), sql, args);
	}
	
	public static Object[] in(Object... args) {
		return args;
	}
	
	public static  T findById(Class type, Serializable pk) {
		String sql = "select * from " + ARKit.tableName(type) + " where " + ARKit.pkName(type) +" = ?";
		return find(sql, pk).first(type);
	}
	
	public static ARC update(String sql) {
		return executeSQL(DB.sql2o.beginTransaction(), sql);
	}
	
	public static ARC update(String sql, Object ... args) {
		return executeSQL(DB.sql2o.beginTransaction(), sql, args);
	}
	
}