@DB(url="jdbc:mysql://127.0.0.1:3306/test" ,username="root", password="root")	public interface TestDB{		public static DBConfig DB=DBConfig.fromClass(TestDB.class);  				public static class NewsModelGenerator{			public static void main(String[] args) {				DBModelGenerateMain.generateModelClass(TestDB.class);			}		}	}

	new User().setName("zzg.zhou").setStatus(1).save();

	public class UserBlogDao {		@Select(name="test.result.UserBlogs")      // <--- Auto create/update: test.result.UserBlogs		public List  selectUserBlogs(int user_id){ // <--- Auto replace List to List<UserBlogs>			Query q=TestDB.DB.createQuery();			            			q.add(""/**~{				SELECT a.id, a.name, b.title, b.content, b.create_time					FROM user a, blog b   					WHERE a.id=b.user_id AND a.id=?					}*/, user_id);			 			return q.getList();               // <--- Auto replace getList() to getList<UserBlogs>		} 	}

  curl http://localhost:8080/your_web_app/dbs/testdb/your_table_name

	//insert	new User().setName("zzg.zhou").setStatus(1).save();		//parse data from type: Map, json/xml string, JsonObject(Gson), HttpServletRequest, JavaBean	new User().parse("{'name':'oschina','status':0}").save();	new User().parse("<data> <name>china01</name><status>1</status> </data>").save();	new User().parse(request).save();		//Object field	Address address=new Address("guangdong","shenzhen");	user.setAddress(address).save();		//File field	String detail_save_path="path/001.txt";	String content="This is a big text.";	user.setDetail(path,content.getBytes()).save(); 	user.getDetailAsString();

	//delete user by primary key or unique key	user.delete();		//SQL: DELETE FROM `user` WHERE `name`='china01'	User.WHERE().name.eq("china01").delete();		User.DELETE().deleteAll();	User.DELETE().truncate();     

	//update by primary key	User user=User.SELECT().selectOne("name=?", "zzg.zhou");	user.setStatus(3).update();				//SQL: UPDATE user SET name='tsc9526' WHERE name like 'zzg%'		User updateTo=new User().setName("tsc9526");	User.WHERE().name.like("zzg%").update(updateTo);

	//select by primary key	User.SELECT().selectByPrimaryKey(1);		//SQL: SELECT * FROM `user` WHERE `name` = 'zzg.zhou'	User.SELECT().selectOne("name=?", "zzg.zhou");		//SQL: SELECT `name`, `status` FROM `user`	User.SELECT().include("name","status").select();  	//SQL: SELECT * FROM `user` WHERE (`name` like 'zzg%' AND `status` >= 0) 	//                             OR (`name` = 'zzg' AND `status` > 1) ORDER BY `status` ASC 	for(User x:User.WHERE()			.name.like("zzg%").status.ge(0)			.OR()			.name.eq("zzg").status.gt(1)			.status.asc()			.SELECT().select()){ //SELECT / delete / update		System.out.println(x);	}	 	//Page	Page<User> page=User.WHERE()		.name.like("zzg%")		.status.in(1,2,3)		.SELECT().selectPage(10,0);		

	TestDB.DB.select("SELECT * FROM user WHERE name like ?","zzg%");		TestDB.DB.createQuery()		.add("SELECT * FROM user WHERE name like ?","zzg%")		.getList(User.class);	 

	Query q=new Query(TestDB.DB);	DataTable<DataMap> rs=q.add("SELECT * FROM user WHERE name like ?","zzg%")	 .add(" AND status ").in(1,2,3)	 .getList();	 	//Query inside DataTable	//SQL: SELECT name, count(*) as cnt FROM _THIS_TABLE WHERE status>=0 GROUP BY name ORDER BY name ASC	DataTable<DataMap> newTable=rs.select("name, count(*) as cnt","status>=0","name ASC","GROUP BY name");	

	//transaction	Tx.execute(new Tx.Atom() {		public int execute() {			new User().setName("name001").setStatus(1).save();			new User().setName("name002").setStatus(2).save();			//... other database operation			return 0;		}	});

	//Dynamic model: Record	Record r=new Record("user").use(TestDB.DB);	r.set("name", "jjyy").set("status",1)	 .save();			//SQL: SELECT * FROM `user` WHERE (`name` like 'jjyy%' AND `status` >= 0)	//                             OR (`name` = 'zzg' AND `status` > 1) ORDER BY `status` ASC 	for(Record x:r.WHERE()			.field("name").like("jjyy%").field("status").ge(0)			.OR()			.field("name").eq("zzg").field("status").gt(1)			.field("status").asc()			.SELECT().select()){		System.out.println(x);	} 			//SQL: DELETE FROM `user` WHERE `name` like 'jjyy%' AND `status` >= 0	r.WHERE()	 .field("name").like("jjyy%").field("status").ge(0)	 .delete();

	public class ShardingUser extends User{		//Override		public Table table(){			String tableName= "user_"+( getId()%10 );			return ModelMeta.createTable(tableName);		}				//Override		public DBConfig db(){			return getId()<10 ? TestDB.DB1 : TestDB.DB2;		}	}		ShardingUser user1=new ShardingUser(1);	user1.save(); //Will be saved to table: user_1, database: TestDB.DB1		ShardingUser user2=new ShardingUser(15);	user2.save(); //Will be saved to table: user_5, database: TestDB.DB2

	public static void main(String[] args) {		String name="zzg";				String lines = ""/**~!{			SELECT * 				FROM user				WHERE name="$name"		}*/;				System.out.println(lines);	}

	SELECT * 		FROM user		WHERE name="zzg"

	<dependency>		<groupId>com.tsc9526</groupId>		<artifactId>monalisa-orm</artifactId>		<version>2.1.0</version>	</dependency>