PrintWriter out = resp.getWriter();
String hash = req.getParameter("hash");
String type = req.getParameter("type");
String id = req.getParameter("id");
if ("email".equals(type)) {
try {
PrintWriter out = resp.getWriter();
String hash = req.getParameter("hash");
String type = req.getParameter("type");
String id = req.getParameter("id");
if ("email".equals(type)) {
try {
- PreparedStatement ps = DatabaseConnection
- .getInstance()
- .prepare(
- "select email, memid from `email` where `id`=? and `hash`=? and `hash` != '' and `deleted` = 0");
+ PreparedStatement ps = DatabaseConnection.getInstance().prepare(
+ "select email, memid from `email` where `id`=? and `hash`=? and `hash` != '' and `deleted` = 0");
- PreparedStatement ps1 = DatabaseConnection
- .getInstance()
- .prepare(
- "update `email` set `hash`='', `modified`=NOW() where `id`=?");
+ PreparedStatement ps1 = DatabaseConnection.getInstance().prepare(
+ "update `email` set `hash`='', `modified`=NOW() where `id`=?");
- PreparedStatement ps2 = DatabaseConnection
- .getInstance()
- .prepare(
- "update `users` set `verified`='1' where `id`=? and `email`=? and `verified`='0'");
+ PreparedStatement ps2 = DatabaseConnection.getInstance().prepare(
+ "update `users` set `verified`='1' where `id`=? and `email`=? and `verified`='0'");
ps2.setString(1, rs.getString(2));
ps2.setString(2, rs.getString(1));
ps2.execute();
ps2.setString(1, rs.getString(2));
ps2.setString(2, rs.getString(1));
ps2.execute();
String hash = req.getParameter("hash");
String type = req.getParameter("type");
if ("email".equals(type)) {
String hash = req.getParameter("hash");
String type = req.getParameter("type");
if ("email".equals(type)) {