public static int updateOneUser(User user) {
int uid = user.getUid();
String userName = user.getUserName();
String email = user.getEmail();
String password = user.getPassword();
try {
conn = RDSManagement.getConnection();
st = (Statement) conn.createStatement();
String sql =
"update User set email ='"
+ email
+ "', password ='******' where uid = "
+ uid
+ ";";
System.out.println(sql);
st.executeUpdate(sql);
System.out.println("Update user: " + uid);
} catch (SQLException e) {
System.out.println(e.getMessage());
} catch (Exception e) {
System.out.println(e.getMessage());
} finally {
try {
st.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return uid;
}
public UserTree(User user) {
this.setUid(user.getUid());
this.setUsername(user.getUsername());
this.setPassword(user.getPassword());
this.setIsadmin(user.isIsadmin());
this.setEmployeename(user.getEmployeename());
this.setUsertype(user.getUsertype());
this.setUsertypename(user.getUsertypename());
this.setEmail(user.getEmail());
this.setComment(user.getComment());
this.setCreateby(user.getCreateby());
this.setCreatetime(user.getCreatetime());
this.setEditby(user.getEditby());
this.setEdittime(user.getEdittime());
this.setLastlogin(user.getLastlogin());
this.setSex(user.getSex());
this.setBirthday(user.getBirthday());
this.setIdcard(user.getIdcard());
this.setAddress(user.getAddress());
this.setMobile(user.getMobile());
this.setTelephone(user.getTelephone());
this.setEmergencycontact(user.getEmergencycontact());
this.setAvatarurl(user.getAvatarurl());
this.setPostuid(user.getPostuid());
this.setPostname(user.getPostname());
this.setParentuid(user.getParentuid());
}
/** @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
HttpSession session = request.getSession();
User curuser = (User) session.getAttribute("curuser");
String uemail = curuser.getEmail();
double price = (Double) session.getAttribute("cprice");
String name = (String) session.getAttribute("cname");
String temp_quant = request.getParameter("quantity");
int quant = Integer.parseInt(temp_quant);
Cart cartentry = new Cart();
cartentry.setName(name);
cartentry.setPrice(price);
cartentry.setQuant(quant);
cartentry.setUemail(uemail);
cartentry.setBought(0);
Utils<Cart> db = new Utils<Cart>();
db.insert(cartentry);
// Prod prod = new Prod();
// prod.setName(name);
// prod.setPrice(price);
// prod.setQuant(quant);
// List<Prod> items = (List<Prod>) session.getAttribute("items");
// items.add(prod);
response.setContentType("text/html");
getServletContext().getRequestDispatcher("/ProductList").forward(request, response);
}
/**
* Update the list of managed parks of a Park Manager.
*
* @author Taylor Gorman
*/
public void updateParkList(String theEmail, List<String> theManagedParks) {
List<User> myManagerList = myUserList.getParkManagerListCopy();
for (User manager : myManagerList) {
if (manager.getEmail().equals(theEmail)) {
((ParkManager) manager).setManagedParks(theManagedParks);
}
}
}
public static int insertOneUser(User user) {
int uid = getMaxUserID() + 1;
String userName = user.getUserName();
String email = user.getEmail();
String password = user.getPassword();
try {
conn = RDSManagement.getConnection();
st = (Statement) conn.createStatement();
String sql =
"insert into User values("
+ uid
+ ",'"
+ userName
+ "', '"
+ email
+ "','"
+ password
+ "');";
System.out.println(sql);
int count = st.executeUpdate(sql);
System.out.println("Inserted " + count + " items into Event");
} catch (SQLException e) {
System.out.println(e.getMessage());
} catch (Exception e) {
System.out.println(e.getMessage());
} finally {
try {
st.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return uid;
}
public void updateUserBd(User user, String id) {
Session session = HibernateUtil.openSession();
Transaction transaction = null;
try {
transaction = session.getTransaction();
transaction.begin();
SQLQuery query =
session.createSQLQuery(
"UPDATE user SET surname=?, name=?, middleName=?, login=?, password=?, mobileTelephone=?, email=? WHERE id=?;");
query.setParameter(0, user.getSurname());
query.setParameter(1, user.getName());
query.setParameter(2, user.getMiddleName());
query.setParameter(3, user.getLogin());
query.setParameter(4, user.getPassword());
query.setParameter(5, user.getMobileTelephone());
query.setParameter(6, user.getEmail());
query.setParameter(7, id);
int resultUpdate =
query.executeUpdate(); // возвращает количество субъектов которые были изменены
System.out.println("Update отчет " + resultUpdate);
// session.saveOrUpdate(user);
transaction.commit(); // применяем транзакцию
} catch (Exception e) {
// отменяем транзакцию
transaction.rollback();
e.printStackTrace();
} finally {
session.close();
}
}