JarCastingjade-all
Jade,是Java应用程序访问Mysql数据库的一个小框架.
数据库访问流程图
,---------------. ,---. ,----. ,----------.
|JavaApplication| |DAO| |Jade| |DataServer|
`-------+-------' `-+-' `-+--' `----+-----'
| | | |
|<------------------>| | |
| | | |
| | 1.Implement jdade specification | |
| |-----------------------------------------------> |
| | | |
| | | 2.Commit sql request|
| | | -------------------->
| | | |
| | | 3.Return result |
| | | <- - - - - - - - - -
| | | |
| |4.To convert a database object to a Java object| |
| | according to the DAO specification | |
| |<- - - - - - - - - - - - - - - - - - - - - - - - |
,-------+-------. ,-+-. ,-+--. ,----+-----.
|JavaApplication| |DAO| |Jade| |DataServer|
`---------------' `---' `----' `----------'
工程依赖
- JDK1.7或更高版本
- Maven3.x
- MySql数据库服务器
简单调用示例
- 添加如下依赖:
<dependency> <groupId>com.github.leixuan6</groupId> <artifactId>jade-all</artifactId> <version>1.0.3</version> </dependency>
- 设置src/main/resource/db.properties文件
driverClassName=com.mysql.jdbc.Driver url=jdbc:mysql://127.0.0.1/jade?characterEncoding=UTF-8 username=root password=123456 maxTotal=1 maxIdle=1 maxWait=-1 - 应用层实现DAO规范
- 调用JadeBootstrap.start方法，传入的路径参数。Jade扫描这个路径下的DAO，Jade会注册这些DAO服务
- 具体参考org.jade.example目录下的例子
实现Jade的DAO规范
@DAO
public interface AccountDAO {
@SQL(val = "Select * from Account ", type = SQLType.SELECT)
Account query();
@SQL(val = "Select * from Account ", type = SQLType.SELECT)
List queryList();
@SQL(val="Select * from Account Where id = ?",type = SQLType.SELECT)
Account queryById(int id);
@SQL(val="Select * from Account Where id =? and name =?",type = SQLType.SELECT)
Account queryById2(int id, String name);
@SQL(val="Delete From Account where id = ?",type=SQLType.INSERT)
int deleteById(int id);
@SQL(val="Update Account set name = ? where id = ?",type = SQLType.UPDATE)
int updateById(int id,String name);
@SQL(val="Insert into Account()Values(?,?)",type = SQLType.INSERT)
int insert(int id, String name);
}
Java对象，实现getset方法
public class Account {
private int id;
private String name;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
@Override
public String toString() {
return "Account [id=" + id + ", name=" + name + "]";
}
}
测试增删改查
public class JadeTest {
public static void main(String[] args) {
JadeBootstrap.start("org.jade");
AccountDAO dao = JadeDAOService.getDao(AccountDAO.class);
dao.deleteById(1);
dao.insert(1, "test");
dao.query();
dao.queryById(1);
dao.queryById2(1, "test");
dao.updateById(1, "test2");
}
}