public static void updateUser(Context context, UserBean userBean) {
ArrayList<UserBean> userGroupArrayList = getUserGroup(context);
for (int i = 0; i < userGroupArrayList.size(); i++) {
if (userGroupArrayList.get(i).getUserName().equals(userBean.getUserName())) {
userGroupArrayList.set(i, userBean);
}
}
JSONArray contentArray = new JSONArray();
for (int i = 0; i < userGroupArrayList.size(); i++) {
contentArray.put(userGroupArrayList.get(i).getContentObject());
}
putUserGroupString(context, contentArray.toString());
}
public boolean getResult() {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
boolean flag = false;
try {
conn = pool.getConnection();
String strQuery = "select * from usertable where Email = '" + param.getEmail() + "'";
stmt = conn.createStatement();
rs = stmt.executeQuery(strQuery);
if (rs.next()) {
System.out.println("Alreay Exist");
flag = false;
return flag;
}
System.out.println("AAA");
// DB에 삽입할 쿼리문 생성
strQuery =
"insert into usertable (UserName,Email,PassWord) "
+ "VALUES('"
+ param.getUserName()
+ "', '"
+ param.getEmail()
+ "', '"
+ param.getPassWord()
+ "')";
//
System.out.println(strQuery);
stmt = conn.createStatement();
stmt.executeUpdate(strQuery);
flag = true;
} catch (Exception ex) {
System.out.println("Exception" + ex);
} finally {
pool.freeConnection(conn);
}
return flag;
}
