Java Db.findFirst方法代码示例

import com.jfinal.plugin.activerecord.Db; //导入方法依赖的package包/类
@Override
protected void validate(Controller c) {
	validateRequiredString("user.username", "category_error", "用户名不能为空");
	int userId = 0;

	String email = c.getPara("user.email");
	String username = c.getPara("user.username");
	Integer[] is = c.getParaValuesToInt("user_role");
	int id = 0;
	if (email.length() != 0) {
		validateEmail("user.email", "text_error", "email格式不正确");
	}
	if (is == null) {
		addError("role_error", "必须选择一个角色");
	}
	if (userId == 0) {
		validateRequiredString("user.password", "text_error", "密码不能为空");
		validateEqualField("user.password", "vpassword", "text_error", "密码与确认密码不匹配");
	}

	if (username.length() != 0) {
		Record count = null;
		count = Db
				.findFirst("select count(id) as count from user where username='"
						+ username + "' and id<>" + id);
		if (count.getLong("count") != 0) {
			addError("codeRepeat_error", "已存在此用户");
		}
		;
	}
}
 

import com.jfinal.plugin.activerecord.Db; //导入方法依赖的package包/类
/**
 * 判断是否count 是否为0
 * 
 * @param tableName
 * @param whereSql
 * @param Object
 *            ...parameter
 */
protected boolean CheckCount(String tableName, String whereSql,
		Object... parameter) {
	boolean counts = false;
	String sql = "select count(id) as count from " + tableName + " where "
			+ whereSql;
	Record count = Db.findFirst(sql, parameter);
	if (count.getLong("count") == 0) {
		counts = true;
	}
	return counts;
}
 

import com.jfinal.plugin.activerecord.Db; //导入方法依赖的package包/类
/**
 * 检查用户账号是否被注册*
 */
@ClearInterceptor
public void checkUser() {
    String loginName = getPara("loginName");
    if (StringUtils.isEmpty(loginName)) {
        renderArgumentError("loginName can not be null");
        return;
    }
    //检查手机号码是否被注册
    boolean exists = Db.findFirst("SELECT * FROM t_user WHERE loginName=?", loginName) != null;
    renderJson(new BaseResponse(exists ? Code.SUCCESS:Code.FAIL, exists ? "registered" : "unregistered"));
}
 

import com.jfinal.plugin.activerecord.Db; //导入方法依赖的package包/类
public static Record getNews(int id){
//修改消息状态为已读
Db.update("update news set status=1 where id="+id);
Record news = Db.findFirst("select p.name as projectName,n.* from project p join news n on p.identifier = n.identifier where n.id="+id);
return news;
}
 

import com.jfinal.plugin.activerecord.Db; //导入方法依赖的package包/类
public Record findFirst(String sql, Object... params)
{
	return Db.findFirst(asterisk(sql, params), unpack(params));
}
 

import com.jfinal.plugin.activerecord.Db; //导入方法依赖的package包/类
/**
 * 1. 检查是否被注册*
 * 2. 发送短信验证码*
 */
@ClearInterceptor
public void sendCode() {
    String loginName = getPara("loginName");
    if (StringUtils.isEmpty(loginName)) {
        renderArgumentError("loginName can not be null");
        return;
    }

    //检查手机号码有效性
    if (!SMSUtils.isMobileNo(loginName)) {
        renderArgumentError("mobile number is invalid");
        return;
    }

    //检查手机号码是否被注册
    if (Db.findFirst("SELECT * FROM t_user WHERE loginName=?", loginName) != null) {
        renderJson(new BaseResponse(Code.ACCOUNT_EXISTS,"mobile already registered"));
        return;
    }

    String smsCode = SMSUtils.randomSMSCode(4);
    //发送短信验证码
    if (!SMSUtils.sendCode(loginName, smsCode)) {
        renderFailed("sms send failed");
        return;
    }
    
    //保存验证码数据
    RegisterCode registerCode = new RegisterCode()
            .set(RegisterCode.MOBILE, loginName)
            .set(RegisterCode.CODE, smsCode);

    //保存数据
    if (Db.findFirst("SELECT * FROM t_register_code WHERE mobile=?", loginName) == null) {
        registerCode.save();
    } else {
        registerCode.update();
    }
    
    renderJson(new BaseResponse("sms sended"));
    
}
 

import com.jfinal.plugin.activerecord.Db; //导入方法依赖的package包/类
/**
 * 用户注册
 */
   @ClearInterceptor()
public void register(){
	//必填信息
	String loginName = getPara("loginName");//登录帐号
       int code = getParaToInt("code", 0);//手机验证码
       int sex = getParaToInt("sex", 0);//性别
       String password = getPara("password");//密码
	String nickName = getPara("nickName");//昵称
   	//头像信息，为空则使用默认头像地址
   	String avatar = getPara("avatar", AppProperty.me().defaultUserAvatar());

       //校验必填项参数
	if(!notNull(Require.me()
               .put(loginName, "loginName can not be null")
               .put(code, "code can not be null")//根据业务需求决定是否使用此字段
               .put(password, "password can not be null")
               .put(nickName, "nickName can not be null"))){
		return;
	}

       //检查账户是否已被注册
       if (Db.findFirst("SELECT * FROM t_user WHERE loginName=?", loginName) != null) {
           renderJson(new BaseResponse(Code.ACCOUNT_EXISTS, "mobile already registered"));
           return;
       }
       
       //检查验证码是否有效, 如果业务不需要，则无需保存此段代码
       if (Db.findFirst("SELECT * FROM t_register_code WHERE mobile=? AND code = ?", loginName, code) == null) {
           renderJson(new BaseResponse(Code.CODE_ERROR,"code is invalid"));
           return;
       }
       
	//保存用户数据
	String userId = RandomUtils.randomCustomUUID();

	new User()
               .set("userId", userId)
               .set(User.LOGIN_NAME, loginName)
	        .set(User.PASSWORD, StringUtils.encodePassword(password, "md5"))
               .set(User.NICK_NAME, nickName)
	        .set(User.CREATION_DATE, DateUtils.getNowTimeStamp())
	        .set(User.SEX, sex)
               .set(User.AVATAR, avatar)
               .save();
	
       //删除验证码记录
       Db.update("DELETE FROM t_register_code WHERE mobile=? AND code = ?", loginName, code);
       
	//返回数据
	renderJson(new BaseResponse("success"));
}
 

import com.jfinal.plugin.activerecord.Db; //导入方法依赖的package包/类
/**
 * Query a data record.
 *
 * @param sqlSelect SqlNode Select
 * @return query result.
 * @see SqlSelect
 * @see FindBy
 */
public static Record findOne(SqlSelect sqlSelect) {
    Preconditions.checkNotNull(sqlSelect, "The Query SqlNode is must be not null.");
    return Db.findFirst(sqlSelect.toString(), sqlSelect.getParams().toArray());
}