?? findpassutil.java
字號:
/**
*
*/
package com.air.backend.util;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import com.air.constants.AppConstants;
import com.air.exceptions.AirException;
import com.air.model.LoginUser;
import com.air.persistence.DataSrcUtil;
import com.air.persistence.IsqlDataSource;
import com.air.util.ValHelper;
/**
* @author jelly_yang
*
*/
public class FindPassUtil {
/**
*
*/
private static Log log = LogFactory.getLog(FindPassUtil.class);
public FindPassUtil() {
// TODO Auto-generated constructor stub
}
public static class FindPassUtilHolder{
static FindPassUtil findPassUtil = new FindPassUtil();
}
public static FindPassUtil getInstance(){
return FindPassUtilHolder.findPassUtil;
}
public LoginUser searchUserByUserName(String uname)throws AirException{
LoginUser user = null;
Map<String, String> result = new HashMap<String, String>();
String sSql = "select username,question,answer from users where username='"+uname+"'";
IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
Connection conn = null;
try
{
conn = src.getConnection();
result = src.retrieveSingleRow(conn, sSql);
}
catch(SQLException se)
{
se.printStackTrace();
log.error("searchUserByUserName() caught SQLException: " + se);
}
catch(Exception ex)
{
ex.printStackTrace();
log.error("searchUserByUserName() caught Exception: " + ex);
}
finally
{
src.closeConn(conn);
}
if(!result.isEmpty())
{
String username = ValHelper.getInstance().getValue(result, "username");
String question = ValHelper.getInstance().getValue(result, "question");
String answer = ValHelper.getInstance().getValue(result, "answer");
user = new LoginUser(username,question,answer);
}
return user;
}
public String getAnswerByUserAndAnswer(String username,String answer)throws AirException{
Map<String, String> result = new HashMap<String, String>();
String sSql = "select pwd from users where username='"+username+"' and answer='"+answer+"'";
System.out.println("haha"+username+","+answer);
IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
Connection conn = null;
try
{
conn = src.getConnection();
result = src.retrieveSingleRow(conn, sSql);
}
catch(SQLException se)
{
se.printStackTrace();
log.error("getAnswerByUser() caught SQLException: " + se);
}
catch(Exception ex)
{
ex.printStackTrace();
log.error("getAnswerByUser() caught Exception: " + ex);
}
finally
{
src.closeConn(conn);
}
String password = AppConstants.EMPTY_STR;
if(!result.isEmpty())
{
password = ValHelper.getInstance().getValue(result, "pwd");
}
return password;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -