|
楼主 |
发表于 2018-3-12 09:46:28
|
显示全部楼层
您帮我看看这段代码有没有错误,try方法里面的不太明白,我感觉那里有错误,您帮我看一下
// 获取输入用户名并判断是否存在
public static JSONObject getInput(JSONObject params, ActionContext context) throws ServletException, IOException, AddressException, MessagingException {
String userCode = params.getString("strUserCod"); //获取用户名ID
String password = params.getString("strPassWord");//获取密码
password = getPassWordEncrypt(password);
System.out.println(userCode + "~~~~~~~~~~" + password);
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = "";
JSONObject result = new JSONObject();
try {
conn = context.getConnection("txxt");
if (userCode != null) {
sql = "SELECT * FROM YH_INFO WHERE YHID='" + userCode + "' AND PSWD='" + password + "'";
System.out.println(sql);
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
int count = Integer.parseInt(DataUtils.getValueBySQL(conn, sql,null).toString());
result.put("count", count);
System.out.println(count);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (Exception e2) {
e2.printStackTrace();
}
}
return null;
} |
|