A simple ORM(Object Relational Mapping) for Java.
Add this text to your pom.xml
<dependency>
<groupId>com.wangtingzheng</groupId>
<artifactId>myorm</artifactId>
<version>1.0.6</version>
</dependency>The latest version can be check here.
This code will create a table named MyTable which has two item: username and password. The username is a 100 length varchar and it is primary key, the password is same but it is not primary key.
@OrmTable
public class MyTable {
@OrmItem(type = ItemTypeEnum.VARCHAR, length = 100, isPrimaryKey = true)
private String username;
@OrmItem(type = ItemTypeEnum.VARCHAR, length = 100)
private String password;
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}This code will define a database which includes one table named MyTable. MyOrm can use SQLITE Driver to connect database in 123.456.789.123:3306 use a account called "myuser". When connect established, MyOrm will use database called test, the server timezone is +8:00.
@OrmDatabase(type = DatabaseTypeEnum.SQLITE,host = "123.456.789.123:3306",username = "myuser",password = "mypassword",openDatabase = "test",serverTimezone = "+8:00")
public class MyDatabase {
@OrmTable()
public MyTable myTable;
}This code will add a record to table named "MyTable" in database "Mydatabse".
DatabaseApt myDatabase = new DatabaseApt(MyDatabase.class); //new database annotation process tool
TableApt myTable = new myDatabase.newInstance(MyTable.class ); //get table annotation process tool
MyTable record = new MyTable("wangtingzheng","iloveMyOrm"); //new a record obejct
myDatabase.create(); //create database if not existed
myTable.create(); //create table if not existed
if(myTable.add(record)){ //if add record successfully
System.out.println("Record has been add to MyTable in Mydatabase.");
}
else{
System.out.println("Add failed.");
}More detail can be saw in wiki:
- Install MyORM to your project
- Define database and table with class
- Execute table operation
- Write extend to make MyORM support more databases
- Support more databases
- Support sql language DIY
- Improve performance
- Support more sql data type
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent