1.按條件查詢數(shù)據(jù)
1.1已知參數(shù)查詢法
/**
* @desc query user list
* @return List<User> list
*/
public List<User> queryUserList(){
//查詢用戶id大于8的用戶
List<User> list = me.find("select * from user where id > 8");
return list;
}
1.1傳參數(shù)查詢法
需要傳遞的參數(shù)用占位符表示“昧识?”钠四,具體的參數(shù)用“,”隔開繼續(xù)跟在方法后面跪楞。代碼如下:
/**
* @desc query user list
* @return List<User> list
*/
public List<User> queryUserList(){
List<User> list = me.find("select * from user where id > ?",9);
return list;
}
2.分頁查詢
分頁查詢是開發(fā)系統(tǒng)中比較重要的操作缀去,jfinal分頁可以說是非常的簡單。只需要編寫sql查詢語句甸祭,按約定傳遞分頁參數(shù)即可缕碎。示例如下:
2.1 Model層的代碼:
/**
* @desc query user list
* @return List<User> list
*/
public Page<User> queryUserList(){
//List<User> list = me.find("select * from user where id > ?",9);
//第一個(gè)參數(shù)表示:當(dāng)前頁;第二個(gè)參數(shù)表示每頁顯示多少條數(shù)據(jù)池户;
Page<User> list = me.paginate(1,4,"select * ","from user where id > ?",9);
return list;
}
2.2 html代碼:
為了展示效果美觀咏雌,這里使用了bootstrap這樣一個(gè)前端框架。
<!DOCTYPE html>
<html lang="zh-cn">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>用戶列表</title>
<!-- Bootstrap -->
<!--link href="css/bootstrap.min.css" rel="stylesheet"-->
<link rel="stylesheet">
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="http://cdn.bootcss.com/html5shiv/3.7.2/html5shiv.min.js"></script>
<script src="http://cdn.bootcss.com/respond.js/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<body>
<table class="table table-bordered table-hover">
<thead>
<tr>
<th>序號(hào)</th>
<th>姓名</th>
<th>密碼</th>
</tr>
</thead>
<!--循壞輸出列表數(shù)據(jù)-->
<#list userList.getList() as user>
<tr>
<td>${user.id}</td>
<td>${user.name}</td>
<td>${user.pwd}</td>
</tr>
</#list>
</table>
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="http://cdn.bootcss.com/jquery/1.11.1/jquery.min.js"></script>
<!-- Include all compiled plugins (below), or include individual files as needed -->
<!--script src="js/bootstrap.min.js"></script>-->
<script src="http://cdn.bootcss.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
</body>
</html>