|
1 package forum;
2
3 import java.io.*;
4 import javax.servlet.*;
5 import javax.servlet.http.*;
6 import java.util.*;
7 import java.sql.*;
8 import java.sql.Connection  ;
9 import java.sql.Statement ;
10 import java.sql.ResultSet ;
11
12
13 public class ChangeProfile extends HttpServlet {
14
15 DBConnectie db = new DBConnectie(Variable.getDb(),Variable.getDbLogin(),Variable.getDbPassword());
16
17 public void doPost (HttpServletRequest request, HttpServletResponse response)
18 throws ServletException, IOException{
19 PrintWriter out = response.getWriter();
20 try{
21
22 HttpSession session = request.getSession(true);
23 String sessionUsername = (String )session.getAttribute("username");
24 String sessionType = (String )session.getAttribute("type");
25
26 String avatar_list = request.getParameter("avatar_list");
27 String link_avatar = request.getParameter("link_avatar");
28 String member_title = request.getParameter("member_title");
29 String signature = request.getParameter("signature");
30
31 member_title = Filter.filterAll(member_title);
32 signature = Filter.filterAll(signature);
33
34 String avatar = null;
35 if(link_avatar.equals("http://")){
36 avatar = avatar_list;
37 }else{
38 avatar = link_avatar;
39 }
40
41 db.connect();
42
43 db.query("INSERT INTO forum_users(user_name) VALUES(\"" + sessionUsername + "\"");
44 db.query("UPDATE forum_users SET type = \"" + sessionType + "\" WHERE user_name =\"" + sessionUsername + "\"");
45 db.query("UPDATE forum_users SET avatar = \"" + avatar + "\" WHERE user_name =\"" + sessionUsername + "\"");
46 db.query("UPDATE forum_users SET member_title = \"" + member_title + "\" WHERE user_name =\"" + sessionUsername + "\"");
47 db.query("UPDATE forum_users SET signature = \"" + signature + "\" WHERE user_name =\"" + sessionUsername + "\"");
48
49 response.sendRedirect(Variable.getForumPath() + "index.jsp?page=profile");
50 db.close();
51
52 }catch(Exception e){out.println(e);}
53
54
55 }
56 public void doGet (HttpServletRequest request, HttpServletResponse response)
57 throws ServletException, IOException{
58 doPost(request, response);
59 }
60
61 } |
Popular Tags |
Java API By Example, From Geeks To Geeks.