b3log的query方法

最新推荐文章于 2021-10-19 11:01:53 发布

刘利新西安

最新推荐文章于 2021-10-19 11:01:53 发布

阅读量1.2k

点赞数

分类专栏： JDBC

本文链接：https://blog.csdn.net/weiyanghuadi/article/details/9957873

版权

JDBC 专栏收录该内容

46 篇文章 0 订阅

订阅专栏

mysqldump -u root -p b3log b3_solo_user>kuazi.txt

insert into b3_solo_user values('8','liulixin63@163.com','刘利新','188029.net','123','admin',0,0);

DROP TABLE IF EXISTS `b3_solo_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `b3_solo_user` (
  `oId` varchar(255) NOT NULL,
  `userEmail` varchar(255) NOT NULL,
  `userName` varchar(255) NOT NULL,
  `userURL` varchar(255) NOT NULL,
  `userPassword` varchar(255) NOT NULL,
  `userRole` varchar(255) NOT NULL,
  `userArticleCount` int(11) NOT NULL,
  `userPublishedArticleCount` int(11) NOT NULL,
  PRIMARY KEY (`oId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

import org.b3log.latke.Keys;
import org.b3log.latke.Latkes;
import org.b3log.latke.model.User;
import org.b3log.latke.repository.AbstractRepository;
import org.b3log.latke.repository.FilterOperator;
import org.b3log.latke.repository.PropertyFilter;
import org.b3log.latke.repository.Query;
import org.json.JSONArray;
import org.json.JSONObject;


public class test_Query extends AbstractRepository {

	public test_Query(String name) {
		super(name);
		// TODO Auto-generated constructor stub
	}
	
	public void zouYiGe(){
		PropertyFilter pia=new PropertyFilter(User.USER_EMAIL, FilterOperator.EQUAL,"liulixin63@163.com".toLowerCase().trim());
		final Query query = new Query();
		query.setFilter(pia);
		try {
            final JSONObject result = get(query);
            final JSONArray array = result.getJSONArray(Keys.RESULTS);
            System.out.println(array.getJSONObject(0));
		}catch (final Exception e) {
		
		}
	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		Latkes.initRuntimeEnv();
		test_Query haha=new test_Query("user");
		haha.zouYiGe();
		
		

	}

}

输出：

{"userArticleCount":0,"userPassword":"123","userName":"刘利新","userEmail":"liulixin63@163.com","userPublishedArticleCount":0,"userRole":"admin","oId":"8","userURL":"188029.net"}