# activejdbc

**Repository Path**: uyghurjava/activejdbc

## Basic Information

- **Project Name**: activejdbc
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2017-02-14
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

ActiveJDBC — ActiveRecord for Java
==========


ActiveJDBC is a Java implementation of Active Record design pattern. 
It was inspired by [ActiveRecord ORM](https://github.com/rails/rails/tree/master/activerecord) from Ruby on Rails.

## Design principles
* Should infer metadata from DB (like ActiveRecord)
* Should be very easy to work with
* Should reduce amount of code to a minimum
* No configuration, just conventions
* Some conventions are overridable in code
* No need to learn another language
* No need to learn another QL — SQL is sufficient
* Code must be lightweight and intuitive, should read like English
* No sessions, no "attaching, re-attaching"
* No persistence managers
* No classes outside your own models
* Models are lightweight, no transient fields
* No proxying. What you write is what you get (WYSIWYG:))
* Should have the least possible resistance to startup a project
* No useless getters and setters (they just pollute code). You can still write them if you like.
* No DAOs and DTOs — this is mostly junk code anyway

## Simple example

For a simple example we will use a table called `people` created with this MySQL DDL:

<pre>
CREATE TABLE people (
  id  int(11) NOT NULL auto_increment PRIMARY KEY, 
  name VARCHAR(56) NOT NULL, 
  last_name VARCHAR(56), 
  dob DATE, 
  graduation_date DATE, 
  created_at DATETIME, 
  updated_at DATETIME
);
</pre>

ActiveJDBC infers DB schema parameters from a database. This means you do not have to provide it in code, the simplest example model looks like this:

```java
public class Person extends Model {}
```

Despite the fact that there is no code in it, it is fully functional and will map to a table called `people` automatically.

Here is a simple query how to use the `Person` model:
 
```Java
List<Person> people = Person.where("name = 'John'");
Person aJohn =  people.get(0);
String johnsLastName = aJohn.get("last_name");
```

As you can see, the amount of code is reduced to a level when it is actually readable. Finder methods can also be parametrized like this:

```Java
List<Person> people = Person.where("name = ?", "John");
Person aJohn =  people.get(0);
String johnsLastName = aJohn.get("last_name");
```

## Documentation

For more information, follow here: http://javalite.io


## Acknowledgement

Special thanks to folks at [IntelliJ](http://www.jetbrains.com/) for granting a license to this project